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.
by FRANZ AG
Technical Analysis in Microsoft Excel. 146 indicators and experts. Free download real and historical stock quotes from USA, Europe, and Canada into...
by Bogemic Software
Create your business forms and professional document templates in a few minutes! The program is supplied with a document templates that can be easi...
by Bogemic Software
Bogemic Docs is a useful tool that accelerates and simplifies the documentation process in a small business office with a minimal investment. The p...
by Plantilla excel
Empleados y control de vacaciones en Excel
Gesti?n de contratos de personal, busqueda facil de aspirantes, calendario de vacaciones de varios a...
by Plantilla excel
Pensado para que pueda llevar el control de vehiculos con gastos , reparaciones y mantenimientos hasta 50 vehiculos
Puede dar de alta sus vehicu...
by Business Spreadsheets
The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least ...
by Business Spreadsheets
The Customer Invoicing Template is an invoice template with the ability to store invoices, products and customers and perform advanced invoice sale...
by Business Spreadsheets
The Real Option Valuation model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of investment scen...
by Business Spreadsheets
The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The m...
by Business Spreadsheets
The Multiple Regression Forecasting template provides a solid basis for identifying value drivers and forecasting data. While it utilises a range ...
by jklnsoft
XLS Converter can easily convert the excel file to txt, html, csv, mdb, dbf,etc. The processing is as quickly as possible. MS Excel is doesnt requi...
by Addintools
Convert data format between Date, Numeric, Text.
Recognize more than ten formats of date: 12/31/2006, 2006-12-31, 2006.12.31...
Recognize more t...
by Plantilla excel
Productos con codigo de barras tipo codebar 3 de 9
Imprime varios modelos de etiquetas de codigos de barras tipo Apli en papel DIN A4
Las entra...
by Plantilla excel
Deja archivadas las facturas de clientes y los pedidos a proveedores de manera que se pueden volver a modificar o imprimir
Archivos de : clientes...
by Business Spreadsheets
The Investment Valuation template is ideal for evaluating a wide range of investment and business case scenarios. While it is based on the traditi...
by ConvertZone
CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, ...
by Plantilla excel
Inventory control, inbound and outbound
Control inbound and outbound providers monthly
Inventory Control by product, keeps track of units and...
by Ovsannikov S.A
Advanced XLS Converter converts XLS to other formats for use in other database software, word processing tools, or for posting the database to the ...
by Plantilla excel
Calculo del salario mensual , quincenal o semanal basado en las horas de trabajo y en el precio de las horas normales y extras
Calculo del impor...
by Addintools
Retrieve and show classic menus and toolbars again in Microsoft Excel 2007, look like the Excel 2003. You could not see the classic main menu and t...
FOLLOW US ON TWITTER
