Ready to use Excel Templates for NPV & IRR & EVA & ROIC for periodic cash flows in Excel 2000 or later. Also allows you to calculate: amortization schedule (debt interest and loan repayment). Allows you your business valuation.
The net present value of an investment is the current value of a future series of payments and receipts. The internal rate of return is the interest rate received for an investment consisting of payments and receipts that occur at regular intervals.
EVA is another method of business valuation.
Here the short description of NVP/IRR calculation. You define your planned cash flow values in Excel list, enter a rate of interest for NPV calculation, initial rate of interest for IRR calculation, and click on a button. NPV & IRR are calculated automatically and stored in special cells of this template.
For your convenience, we added Excel templates to calculate NPV, IRR, ROIC, EBIT for 3 up to 100 year project. Here the short description of NVP/IRR/ROIC/EBIT calculation. You enter your sales forecasts for your 3 to 100 year project, debt to capital ratio, pre-tax cost of debt, risk premium, sector beta value, capital, amortization period, balloon (optionally), your costs, operating expenses, depreciation, and more. The results: NPV, IRR, ROIC, amortization schedule, taxes, EBIT, tax scheduling for 10 periods, discounted cash flows, cost of equity, cost of capital, capital gain, and more.
The same for 10 year project is ready to use.
Also contains the bonus:
2 to 15 Year NPV and EVA Calculation. NPV and EVA Excel templates for 2 to 15 period projects. Source data: depreciated rate, tax rate, discount rate, fixed and current assets, sales of products, WACC, and more.
MIRR (Modified Rate of Return) calculation
NPV & IRR calculations for non-periodic cash flows.
Excel templates for the following more useful financial functions: NPV, IRR, MIRR, future value of initial principal, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule.