Microsoft Excel Templates For Net Present Value and IRR

Product Rank:

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 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:
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.

Also 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. 

 

Our complete collection of Investment Cash Flow workbooks for NPV & IRR Solutions includes:

30 page Guide fully explaining all the calculations and equations required for time based value of investing. Includes Quick IRR –NPV spreadsheets and Future Values.

Libor interest rate curve to predict long term interest rates to establish the correct discount rate to use. To evaluate projects correctly.

Investment Appraisal simulations. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

The library of investment analysis spreadsheets incorporate present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.

Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.

Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.

Synergy Value schedule calculates the economic and net present value an acquisition or merger.

Insurance buy out schedules value any bond to its terminal value.

This workbook includes lots of Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.

Quick NPV and IRR spreadsheets provide present values and IRR of any project for up to 40 years.

Libor Futures Curve in Excel. The LIBOR Eurodollar curve predicts longer-term interest rates providing a crucial guide for investment decisions and discount rates. Daily updates available.

Additional Information

See the Free My Loans Manager 2011 bonus notice at the end of this page:

Our complete collection of Investment Cash Flow workbooks for NPV & IRR.

Investment Appraisal simulators. This spreadsheet will run 3,000 forecasts combining up to 80 variables of any investment project to predict the most probable 10 year pre-tax profits, cash flows, NPV, IRR and ROIC.

Large library of investment analysis spreadsheets provide present value beyond the cash flow forecasting horizon. With our quick and easy to use spreadsheets terminal values are automatically added to project net worth and included in the real return on capital values.

Quick calculation of your firms cost of capital using beta risk look up values from the database included within the workbook. Your firms or your project cost of capital is the real discount rate to apply to all net present value spreadsheets.

Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.

Calculates the economic and net present value of the financial benefits of an acquisition or merger.

This workbook includes Present values calculators, and internal rate of returns of investment project cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, and present value of periodic investments.

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 Collection' - large collection of financial programs - as it contains this product.

30-day Money Back Guarantee!

Additional Information: Excel Templates

Investment-Calc Solutions for IRR & NPV

$139.95  $69.95
Financial Excel Collection for 2013

$1754.20 $169.95


System Requirements

Order

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

30 day money back guarantee!

Additional Information: Excel Templates

Investment-Calc Solutions for IRR & NPV

$169.95  $69.95

Financial Excel Collection for 2013

$1754.20 $169.95

Please see also:

Financial Excel Templates