finexcelsoft-npv-irr-excel-template-for-periodic-cash-flows-logo.gif

NPV & IRR Excel Template for Periodic Cash Flows

NPV & IRR Excel Template for Periodic Cash Flows

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.

30-day money back guarantee!

67 financial Excel templates!

FinExcelSoft

Get NPV & IRR Excel Template for Periodic Cash Flows now:


Purchase the full version for unlimited use

Latest posts by FinExcelSoft (see all)

You may also be interested in:

  • Investment-Calc Solutions IRR & NPV Capital improvement investment analysis - quick and easy way to evaluate improvement projects - cash flows - rate of returns- net present […]
  • FES 10 years FinForecast Ready to use Excel templates for NPV, IRR, ROIC, EBIT, debt fixed/balloon payments (interest and principal) calculations. Also calculates […]
  • FinExcelSoft FinStat Excel Templates NPV, IRR, ROIC, EBIT calculation, fixed/balloon payments (interest and principal), cost of equity, cost of debt, cost of capital, income […]
  • FinExcelSoft NPV & IRR Excel templates Ready to use 67 Excel templates for NPV/EVA ,IRR/MIRR, EVA, ROIC, EBIT calculation and more. NPV and EVA Excel templates for 2 to 15 […]
  • FinExcelSoft FinStat Templates for 3, 5, 10 years Ready to use Excel templates for NPV, IRR, ROIC, EBIT, debt fixed/balloon payments (interest and principal) calculations. Also […]
  • FinExcelSoft FinStat Ready to use Excel templates: Loan and mortgage calculations including debt payment schedule, business valuation using NPV and EVA […]
  • INVESTMENT-CALC PRO IRR/ NPV Solutions Capital improvement investment analysis - quick and easy way to evaluate improvement projects - cash flows - rate of returns- net present […]
  • Investment and Business Valuation The Excel Investment and Business Valuation template is suitable for evaluating a variety of simple to complex investment, financial […]
  • FinExcelSoft Securities Excel templates Contains 26 securities Excel templates: templates for coupons (6 templates), templates for price calculation (6 templates), templates for […]
  • FinExcelSoft Annuities Excel Templates Contains 10 annuities Excel templates: price per $100 face value of security that pays periodic interest, yield on a security that pays […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>