Investment-Calc PRO Excel Templates For Cash Flow Analysis

With Investment-Calc PRO you can create and manipulate ready to use cash flow Excel worksheets to analyse business, capital, share, lease purchase cash flow forecasts for internal use, for acquisitions, and for calculating best valuation for sale. The program calculates Net Present Values, Internal Rates of Return, Accounting Rate of Return, Share Valuation & Economic Valuations over any forecast period to 15, 20, 30 or 50 years. Investment-Calc incorporates self generating tables, that calculate yearly asset depreciation values for any yearly capital purchase program, prepares tax calculations, calculates annual lease and loan finance costs and repayments, compounds money values and transfers all values automatically into user's spreadsheets to help save time.

The Cash Flow Forecasting template below will help you prepare a 1-15 year cash flow forecast quickly based on annual sales, gross margin, expenses and capital budget forecasts for rapid calculation of Net Present Value, Internal Rate of Return, Accounting Rate of Return & Economic Valuation. With Investment-Calc PRO you can create and manipulate cash flow worksheets to analyse company acquisitions, capital investments, lease purchases, with combinations of term loan/capital lease financing, and calculate daily compound deposit interest, optimise capital budgets and value business cash flows.

Investment-Calc 7.3 provides:

  1. Excel calculators for: Present values, cost of capital, rate of return required, discount rates, continuous adjustments, Continuing Value, Share Valuation.
  2. Linked spreadsheets for creation of business investment evaluation models using discounted cash flow with quick and easy adjusters to review alternative assumptions and resulting returns.
  3. Imported financial data from useful web sites, converted to Excel databases for easy referencing.

Below are a selection of 8 screen graphics out of 65 calculators, spreadsheets, help guides, explanations and templates provided:

Present Value & Compounding calculators for Excel from/to any future date. T-Bill rate values are imported via Web Query.

Present Value & Compounding calculators for Excel from/to any future date. T-Bill rate values are imported via Web Query
Click to enlarge

back 2(15) next



Download Excel Spreadsheets(file size = 1.7 MB)

Additional Information

Page 1.Excel Cash Flow Analysis - prepare a 1-15 year cash flow forecast

Page 2.Automatic Excel calculations of annual repayments of loan & lease principal

Page 3.Sensitivity Excel Analysis calculations - maximum rate of return position

Page 4.NPV-IRR analysis Excel spreadsheet - values for any capital investment

Page 5.Excel Templates: accelerated depreciation tax calculations

Page 6.Excel Templates : NPV-IRR worksheet annual cash flows and Net Present Values

Page 7.Capital investment projections Recalculations Excel Spreadsheet

Page 8.Two Economic Value Added Excel worksheets - EVA Excel Templates

Page 9.Forecast cash flows Excel Templates over 1-30 years by automating calculations using constant ratios

Page 10.Excel Spreadsheet - compounded interest totals for an investment deposit

Page 11.Excel Templates to value company shares using current free cash flows

Page 12.PV Table 1 calculates PV of annual recurring amount for Cash Flow Analysis

Page 13.PV Excel Table 2 calculates the PV of any future amount received until 30 years

Page 14.Excel Tools to handle the rate of return and present value of any forecast pattern of cash flow income and expenses

New In Version 7.3

Imported financial data transposed to easy lookup combo boxes

Start calculating NPV & IRR using Goal Seek as well as Excel IRR

Preparing Base Case Investment Appraisal and risk adjustment figures using these instructions and templates

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels

Use Continuing Value calculations to include project value beyond the forecast period

Quick NPV/IRR forecasting schedules for annual projections (to 60 years) and monthly (to 120 months)

Share Valuation: Value on earnings or cash flow projections

Basic accounting returns & EBIT forecasting, and IRR of a profit forecast

Capital Project analysis with detailed expense and income itemizations

Valuing a lease purchase

System Requirements

Requires MS Excel Excel97/Excel 2000/Excel XP or later or MS Office 97 or later.

Platform : Windows XP/ Me/ 9x/ NT/ 2000 or Mac

Web data requires Excel 2000 and above and MS Windows XP/2000/2003 or later.

Order

30 day money back guarantee!

Additional Information: Additional Information: Investment-Calc Solutions IRR & NPV

Require Excel 97 or greater.

Os : Windows or Apple Mac        

Buy Online

buy.gif (540 bytes)

Please see also:

All Programs Gold Edition of Business Support Programs for Excel - contains Investment-Calc Pro and many other programs (just $149.95)

System Requirements

Platform : Windows or Mac  &  MS Excel 95/Excel97/Excel 2000/Excel XP/Excel 2002/Excel 2003 or MS Office 7(95) or later.

Order

Platform : Windows 95, 98, ME, NT/2000 or XP

Excel 97 or later. Web data requires Excel 2000 or above and Windows XP/2000/2003 or later.

Additional Information: All Programs Gold Edition
30 day money back guarantee!

Buy Online

buy.gif (540 bytes)

Regular Price : 299.95

buy.gif (540 bytes)  -

More International Company Services Software

MS Excel Add-ins, Spreadsheets, Templates

Copyright © International Company Services Software All Rights Reserved