FinExcelSoft Logo

Please see below financial Excel templates designed for Excel 2000 or later.

Financial Software for Excel - Add-ins, Spreadsheets, Templates

Hosted by FinExcelSoft

FinExcelSoft Excel Templates

For complete list of our products please click on the link above.

FES 10 years FinForecast

This collection of Excel templates includes:

1. NPV & IRR & ROIC Excel Templates for your 10 year business plan.

This workbook allows you to calculate NPV, IRR, ROIC, EBIT, fixed/balloon payments (interest and principal), cost of equity, cost of debt, cost of capital, income taxes payments, depreciation, capital gain, and more for your 10-year plan.

Please see the screenshots of worksheets below.

npv introduction

npv irr 10 years source

npv irr ebit 10 years forecast

loan schedule for 10 years

NPV IRR 10 years results

2. NPV and IRR Excel Templates

1. NPV & IRR Excel Template for periodic cash flows

Buy Online

$62.00 $52.00

This spreadsheet allows you to calculate the NPV & IRR values for a schedule with periodic cash flows (for example annual). If you need an Excel template for a schedule that is not necessarily periodic, please see below.

NPV SOURCE DATA

NPV, IRR Results

Please note that you can enter the values for up to 65533 cash flow periods.

When you enter "Calculate" button, you will see the screen below.

NPV SOURCE DATA

NPV, IRR RESULTS

You can find the results in G3 and H3 cells.

2. NPV & IRR Excel Template for a schedule that is non-periodic.

NPV, IRR Source Data

Please note that in this case the template has the column "Date". When you enter your data and click on "Calculate" button, you will see the screen below.

NPV, IRR Results

You can find the results in H3 and I3 cells.

3. MIRR

NPV, IRR Source Data

The modified internal rate of return (MIRR) is the internal rate of return when payments and receipts are financed at different rates. To calculate a MIRR value please enter finance rate in cell D2, Reinvest Rate - in cell E2, then enter your cash flow in column C (payments - with '-', receipts - with '+'). Select all cash flow values. Please do not select empty cells. Then click on the "Calculate" button.

NPV, IRR Results

You can find the result in the cell F2.

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

5. Securities Excel templates

Contains 26 securities Excel templates: templates for coupons (6 templates), templates for price calculation (6 templates), templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duration for a security. Full instructions.

6. Amortization Excel Templates, Fixed and Balloon Loans and Mortgages

Calculates straight-light depreciation of an asset for a single period, sum-of-years' digits depreciation of an asset for a specified period, depreciation of an asset for a specified period using the fixed-declining balance method, depreciation of an asset for a specified period using the double-declining balance method or some other method you specify, depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify.

Contains also the template to calculate the payments for fixed and balloon loan / mortgage with adding amortization schedule for up to 30-year loans/mortgages. Balloon mortgage may be useful as allows you to pay off lower interest rates. You can also try to sell your home before large balloon payment or refinance your mortgage.

7.Correlation, Partial Correlation, and Regression Excel Templates

You enter several columns of your data, and VBA code calculates correlation matrix (correlation coefficients) and partial correlation matrix (partial correlation coefficients). These Excel templates use Excel functions: correl, fisher, covariance, rsq, linest, forecast, trend, logest, growth.

8. Excel functions for statistic criteria tests

These Excel templates use Excel functions: ztest, ttest, ftest, chitest.

9.  Excel functions for variance calculations

These Excel templates use Excel functions: var, vara, varp, varpa, devsq, stdev, stdeva, stdevp, stdevpa, avedev.

10. Excel functions for serial statistics

These Excel templates use Excel functions: quartile, percentile, median, percentrank, rank.

11. Excel functions for mean calculations

These Excel templates use Excel functions: harmean, geomin, average, averagea, trimmean.

12. Excel functions for extreme values calculation

These Excel templates use Excel functions: max, maxa, min, mina, large, small.

13. Excel functions for a distribution calculations

These Excel templates use Excel functions: fdist, betadist, binomdist, weibull, hypgeomdist, gammadist, lognormdist, normsdist, negbinomdist, poisson, tdist, chidist, expondist.

14. Excel functions for an inverse distribution calculation

These Excel templates use Excel functions: finv, betainv, gammaint, loginv, norminv, normsinv, tinv, chiinv, critbinom.

15. Excel functions for calculation of geometric characteristics of a distribution

These Excel templates use Excel functions: skew, kurt.

16. Excel functions for probability calculation (used for statistic analysis)

These Excel templates use Excel functions: prob, confidense, mode, frequency.

17. Excel mathematical functions used in statistical analysis

These Excel templates use Excel functions: gammaln, standardise, permut, count, counta.

18. Excel functions to generate evenly distributed random numbers (used in statistic analysis)

These Excel templates use Excel functions: rand, randbetween.

This collection contains Excel templates for almost all financial & statistic calculations: NPV, IRR, MIRR, amortization templates, securities templates, 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, and more. Also contains all statistic functions. finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in all workbooks. Use of some complex financial functions is simplified by VBA procedures.

Benefit: With these Excel templates you can now do financial & statistic calculations more easily. For example, you enter your source data and the work is done! Now you can see, for example, NPV and IRR results. Or you can see, for example, the results of 6 Excel extreme functions: max, maxa, min, mina, large, small. To receive a correlation matrix you just click one button. Moreover, you will receive the partial correlation matrix too. Please note that Excel has no the tools to calculate a partial correlation matrix. Please note also that some complex Excel functions are simplified by our VBA code. Please note also that Excel contains hundreds functions and you may have problems with a search of the function you need for your given task. Our finexcelsoft.xls workbook contains the links to all financial and statistic functions. And these links to financial functions are grouped in 6 groups (investment interest, annuities, securities, rates, amortization, date functions); the statistic functions are grouped in 14 groups. Now you can review only functions from one group rather all list! Moreover, finexcelsoft.xls contains additional grouping of financial functions: interest rate, income, payment, price, number of periods. To open the template you simply double click its name, and the work in done! Therefore, our Excel templates may be very useful as for professional financiers, as for students! This unique collection of Excel templates (supplied in conjunction with examples and full instructions) allow you easily learn all financial and statistic Excel functions and easily use them for your needs.

Installation

Just unpack zip archive. NPV & IRR Excel Template for a schedule that is not necessarily periodic and MIRR Excel template require the Excel add-in "Analysis Toolpak - VBA". This add-in is supplied with Excel by Microsoft. To install this add-in, run the Setup program. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu. If you use Excel 2007 then you will not need to install this add-in as Excel 2007 contains it.

System Requirements

Platform:

Windows XP / 2000 / 2003 or later. Or NT4 Server,  Windows 9x, Me, NT or Mac. Please note that IS Financial Calculator is not available for Mac.

Requires Excel 2000 or later.

FES 10 years FinForecast Order

This product contains all Excel templates placed above: 60 financial Excel Templates and 81 statistic Excel templates

Excel workbooks supplied with this product:

1. npvirrroic.xls -  NPV, IRR, ROIC, EBIT, fixed/balloon payments
(interest and principal), cost of equity, cost of debt, cost of capital, income taxes payments,
depreciation, capital gain, and more for your 10-year project. These templates are ready to enter source data for your 10-year project. See the spreadsheets above.

2. evacalc.xls - NPV & EVA Excel Templates for 5, 10 and 15 year period.
Source data: depreciated rate, tax rate, discount rate, fixed and current
assets, sales of products, WACC, and more. What advantages of EVA concept?
If the traditional NPV-analysis demands calculation of necessary size of investments with exact scooping and time of cash flows on the periods, calculation EVA can be spent on each separate period of functioning of the enterprise without the additional account of the past events and a future prediction, and is simple proceeding from the size of the involved capital estimated on the basis of the accounting data.

3. npv.xls - NPV & IRR for periodic cash flows templates
4. npvirrdate.xls - NPV & IRR for any cash flows templates
5. mirr.xls - MIRR template
6. sec.xls - 26 securities templates
7. amort.xls - 5 amortization templates
8. datetime.xls - 4 date templates
9. finexcelsoft.xls - additional 16 financial templates
10. ann.xls - Excel templates for annuities
11. corr.xls - correlation coefficients, partial correlation coefficients, regression coefficients
12. test.xls - testing Excel templates
13. var.xls - variation calculation Excel templates
14. serial.xls - serial statistics
15. mean.xls - mean values calculation
16. extrem.xls - extreme values calculation
17. dist.xls - distribution calculation
18. invdist.xls - inverse distribution calculation
19. geo.xls - geometric characteristics calculation
20. add.xls - probability calculation
21. math.xls - mathematics for statistic analysis
22. even.xls - calculation of evenly distributed numbers
23. forecast.xls - NPV, IRR, EBIT, cost of equity, cost of debt, cost of capital, income taxes payments, depreciation, capital gain, and more for your 3 to 100-year project

Order 

60 Excel Financial Templates and 81 Statistic Excel templates. The download also contains the example data for all Excel templates and full instructions.

30-day money-back guarantee!

Additional Information: FES 10 years FinForecast

$99.95  $62.00 Buy Online Buy FES 10 years FinForecast

Copyright (c) FinExcelSoft

For more NPV & IRR and other financial Excel Templates please visit:

NPV Excel templates, IRR, EVA, Investment Valuation, Cash Flow, Budget Forecasting, and more for financial calculations

Microsoft Excel Templates For Net Present Value and IRR

Busysoftorder.com Excel Templates

IovSoft Financial Excel Templates

How to calculate NPV and IRR with Excel

Loan Payment Calculation with Excel

Please review also our POP3 anti-SPAM, mass email, and more FES emailer

You also may want to review our following Excel add-ins: Excel add-ins Part 1, Excel add-ins Part 2Excel add-ins Part 3, Excel add-ins Part 4, Excel add-ins Part 5, Excel add-ins Part 6,

We have also Accounting Excel Templates: Accounting Excel Templates Part 1, Accounting Excel Templates Part 2

We have Budgeting Excel templates: Budgeting Excel Templates Part 1

We have the calendars for Excel: Calendars for Excel Part 1, Calendars for Excel Part 2, Calendars for Excel Part 2

We have financial Excel templates: Financial Excel Templates Part 1

We have inventory management Excel templates: Inventory Management Excel Templates Part 1

We have planning Excel templates: Planning Excel Templates Part 1, Planning Excel Templates Part 2

We have scheduling Excel templates: Scheduling Excel Templates Part 1

We have financial Analysus Excel templates: Financial Analysis Excel Templates Part 1

Standalone Business Support Software

We have video software: Video Software Part 1, Video Software Part 2

We have accounting software: Accounting Software Part 1, Accounting Software Part 2, Accounting Software Part 3

We have barcode software: Barcode Software Part 1, Barcode Software Part 2

We have financial software: Financial Software Part 1, Financial Software Part 2, Financial Software Part 3, Financial Software Part 4, Financial Software Part 5

We have planning software: Planning Software Part 1

Copyright FinExcelSoft All Rights Reserved