N

NPV & IRR Excel Template for Periodic Cash Flows

FinExcelSoft – Shareware

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

Vue d'ensemble

NPV & IRR Excel Template for Periodic Cash Flows est un logiciel de Shareware dans la catégorie Entreprise développé par FinExcelSoft.

La dernière version de NPV & IRR Excel Template for Periodic Cash Flows est actuellement inconnue. Au départ, il a été ajouté à notre base de données sur 31/08/2018.

NPV & IRR Excel Template for Periodic Cash Flows s’exécute sur les systèmes d’exploitation suivants : Windows.

NPV & IRR Excel Template for Periodic Cash Flows n'a pas encore été évalué par nos utilisateurs.

Captures d'écran (Cliquez pour agrandir)

Télécharger ne sont pas encore disponibles. S'il vous plaît ajoutez-en un.

Restez à jour
avec UpdateStar freeware.

Derniers avis

DC Image Button DC Image Button
DC Image Button - L’outil ultime pour des boutons d’interface utilisateur personnalisables
Remote Process Explorer Remote Process Explorer
Rationalisez votre surveillance à distance avec Remote Process Explorer
3000 CHANNELS 3000 CHANNELS
Des divertissements illimités vous attendent avec 3000 CHAÎNES !
Stellar Phoenix Photo Recovery Stellar Phoenix Photo Recovery
Récupération de photos sans effort avec Stellar Phoenix Photo Recovery
Screen Protractor Screen Protractor
Mesure de précision simplifiée avec le rapporteur d’écran
NIUBI Partition Editor Free Edition NIUBI Partition Editor Free Edition
Simplifiez la gestion de vos disques avec NIUBI Partition Editor Free Edition
Current Newsletter