Microsoft Excel Templates For Net Present Value and IRR

Product Rank:

Developer: Millennium Software Inc.

Ready to use Excel Templates for your business valuation and more

Excel Templates For Net Present Value and IRR : 20 ready to use Excel spreadsheets for NPV, IRR, ROI, ROA, EVA, EBIT, ROIC calculations, capital investment analysis, lease purchase ROR, investment rate of return.

Description


Quick calculations of Net Present Values, Discounted Cash Flows, Internal Rate of Return (IRR), Accounting Rate of Return, Daily Loan Interest, Asset Replacement Investments, Capital Optimizations, Profit and Mark Up Forecasts, Project Valuations.
Investment-Calc PRO 7.3 latest version  of our tried and tested investment return analysis tool for Excel contains over 50 NPV/IRR ROI ROR EVA Beta Risk Analysis Project Evaluation LookUp Current Market Returns/Rates Cost of Capital Capital Budgets Options cash flow forecast templates, plus lots of help instructions & guides, financial databases and tables with current values for imported financial data.

Contains:

Menu of templates and information pages:

Menu of templates and information pages 1Menu of templates and information pages 2Menu of templates and information pages 3

The program calculates Internal Rates of Return, ROIC, Payback, after tax cash flows, present values, Accounting Rate of Return, Share Valuation & Economic Valuations with variable equity/debt financing ratios, and risk analysis over any forecast period. Investment-Calc incorporates self generating tables that calculate straight line and MACRS depreciation and tax calculations.

Includes new sensitivity analysis tables, which allow users to keep their original forecasts while varying their assumptions for instant recalculations of NPV and IRR forecasts under any combination of key variables.

Version 7.0 includes new additional workbooks for calculating the internal rate of return of any irregular cash outflows/inflows forecast over 60 months or 50 years. Version 6.0 incorporates a new simple list way of creating cash flow forecasts, which speeds up calculations and reduces work time. 

 

Plus Bond amortization and rate of return spreadsheets.

Screenshots

NPV, IRR Analysis Excel Templates

NPV, IRR Analysis Excel Templates

Our New Additions to this program: Better finances 2010

Better finances 2010 helps lenders and borrowers manage up to 50 loan accounts online. Better finances 2010 is a web based program with “under the hood” calculations to update loan payment schedules. Edit any payment row, miss payments, change interest rates and terms anytime. Use better finances 2010 at home or at work and with any computer. Includes present values of loan repayments – optimizes loan present values for better finances. Includes quick calc to insert new rates and repayments into any repayment period. Includes npv calc to insert present values into any repayment period. Incorporates negative present values (deflation) and positive present values (inflation). Provides instant loan status reports – balances – interest – principal between any two periods. Drag and drop reports and schedules into excel. Add a total of 50 members to share your better finances 2010 web program at no additional cost.

System Requirements

Windows XP/2000/2003 or later and Excel 2000 or later.

Order

Please note that you also may want to purchase our 'Financial Excel All Programs Edition' - large collection of financial programs - as it contains this product.

30-day Money Back Guarantee!

Additional Information: Excel Templates

Investment-Calc 2008 - NPV - IRR + Better Finances 2010 - Financial Excel Templates

Buy Online

Order $169.95  $69.95
Financial Excel All Programs Edition

Buy Online

Order $450.00 $129.95


Additional Information and Screenshots

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

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

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

Order

Please note that you also may want to purchase our 'Financial Excel All Programs Edition' - large collection of financial programs - as it contains this product.

30 day money back guarantee!

Additional Information: Excel Templates

Investment-Calc 2008 - NPV - IRR + Better Finances 2010 - Financial Excel Templates

Buy Online

Order $169.95  $69.95

Financial Excel All Programs Edition

Buy Online

Order $450.00 $129.95

More Millennium Software

Please see also other Millennium Excel Templates:

  Business Excel Spreadsheets & Templates (Accounting    Analysis     Budgeting     Calculators    Cars   Cash Flow      Charting     Checks      Converters      E-Books     Finance     Forecasting    Employment      Inventory        Investment      IRR   Management    Marketing    NPV   Planners       Project Management      Quality Control    Schedulers )

Business Software

MS Excel Add-ins, Spreadsheets, Templates

Copyright © Millennium Software All Rights Reserved