Click to enlarge
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:
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.
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
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
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
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: Investment-Calc Pro For Cash Flow Analysis | ||
|
Require Excel 97 or greater. Os : Windows or Apple Mac |
|
|
|
$139.95 |
||
Please see also:
All Programs Gold Edition of Business Support Programs for Excel - contains Investment-Calc Pro and many other programs (just $189.00)
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 $189.95 |
|
|
Regular Price : 299.95 |
||
-
$299.95 $189.95
Business & Finance
Material Resources Planning Systems Accounting Amortization Business Business Plan Automation Finance
Info Managers Inventory Systems Bar Code Fonts Legal Planners/Schedulers Presentation Tools
Project Management Internet Marketing
Management Systems (
Contact Management Document Management Sales Management
Real Estate Vehicles Venture Capital
Business Using Mail, Phone, or Email
Publishing Gem Management Rental Repair Travel )
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates
Copyright © Millennium Software All Rights Reserved