Collection of Statistical and Financial Excel Templates - NPV, IRR, and much more

FinExcelSoft Logo

Please see below financial Excel templates designed for Excel 2000 or later. If you find financial software for Windows, please see below IS Financial Calculator. It does not require Microsoft Excel.

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

Hosted by FinExcelSoft

FinExcelSoft Products

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

Financial Excel Templates

This collection of Excel templates includes:

1. NPV & IRR Excel Workbooks for Periodic Cash Flows

Contains workbooks:

1. NPV & IRR & ROIC Excel Templates for your 3 up to 100 year business plan.

Buy Online

$62.00 $52.00

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 3 to 100-year project.

Please see the screenshots of worksheets below.

npv introduction

npv irr roic source

npv irr roic sales

npv irr roic loan

npv irr roic results

Please see similar workbooks below:

NPV, IRR, EBIT Excel templates for 10-year business plan

NPV, IRR, EBIT Excel templates for 3, 5 and 10-year business plan

2. 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 periodic or non-periodic.

3. NPV & IRR Excel templates for a schedule that is not necessarily periodic - contains all Excel templates for a schedule that is not necessarily periodic listed below.

Buy Online

$67.95 $57.00

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.

These Excel templates also contain the workbook:

NPV & IRR & ROIC Excel Templates for your 3 up to 100 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 3 to 100-year project.

Please see the screenshots of worksheets below.

npv introduction

npv irr roic source

npv irr roic sales

npv irr roic loan

npv irr roic results

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 (except IS Financial Calculator).

FinStat Excel Templates 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. sales-gen.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: FinExcelSoft FinStat Excel templates

$99.95  $67.95 Buy Online Buy FinStat Templates

FinExcelSoft Safe Office

This our collection of programs contains all Excel templates placed above plus some security tools for your safe work in Internet at your home or office (safe e-mail POP3 client and more).

This product contains all FinExcelSoft Excel products listed above plus FinExcelSoft Defense plus FES EA Inventory Manager for Excel (for accounting with car parts) plus FES Browser for Excel. It contains:

1. NPV & EVA Excel Templates for 5, 10 and 15 year periods (evacalc.xls workbook - please see above).

2. Financial Excel templates - business valuation, forecast, securities, amortization, loans, annuities, investment.

3. Statistic Excel templates - regression and correlation analysis, partial correlation.

4. FES emailer - safe POP3 email client with many features including: SPAM blocker, re-sender from one email account to another one, safe saving of emails - with 2048 bit encoding, multiple passwords, and much more. Allows you to remove emails without downloading them.

5. FES Notes - text editor with 2048 bit encoding, multiple passwords. allows you to safely save financial documents, passwords and so on.

6. FES alarm - Allows you to set a month, day, year, hours, and minutes and track the time.

7. Safe Web Browser - Allows you to download web pages, remove any dangerous content (scripts and more) from them, save them and pass them to default web browser.

8. FES Encoder - allows you to encode the files with 2048-bit key.

9. FES EA Inventory Manager for Excel - Excel add-in for accounting with for example car's parts and other inventory items that require multi-level BOMs. You may define several levels of hierarchy within your Excel list. For example: assemblies, units, packs, details, sub details, and so on. This add-in contains about 250 VBA macros. Allows you to set up additional hierarchic and other dependencies between columns of your list(s). And when you enter your data, this add-in will track these dependencies and instantly offer you to correct your data if your entry is wrong. Also, allows easy pivot table and subtotals creation, has a timer and more.

Special requirements: MS Excel 2000 or later
Platform: Windows 98 or later.

10. FES Browser for Excel

IE, Firefox or Opera often loose their cache and you need to download the pages and images again. Alternatively, you can use FES Browser for Excel. It can automatically save all pages and images in your file system. Additionally, it also can save all URLs you visited during every session in xls file.
FES Browser works faster then usual browser as it does not save information in cache. It uses IE engine.

Requires Excel 2000 or later.

11. FES Financial Calculator.

Calculates Net Present Value (NPV) of investment with regular cash payments, Internal Rate of Return (IRR) of investment with regular cash payments, Net Present Value (XNPV) of investment with irregular cash payments, and Internal Rate of Return (XIRR) of investment with irregular cash payments.

12. VBA Defencer.

Protects MS Excel or Word VBA projects by renaming procedures and declared variables and making VBA code unreadable to the human eye. Main Features:
- renames procedure, function and property names.
- renames almost all variables declared in dim, public and private statements.
- removes all comments.
- removes blank lines.
- removes all additional spaces.

Platform: Windows 98 or later. Requires Excel 2003 or later.

Order

30-day money back guarantee for all products!

Additional Information: FinExcelSoft Safe Office

FES FinStat Excel Templates 141 finstat Excel templates $99.95

$67.95

Buy Online
FES Emailer POP3 E-mail client, office safe tools and more $39.95 Buy Online
FES Browser for Excel Excel workbook $46.00 Buy Online
FES EA Inventory Manager for Excel Accounting with, for example, car's parts and others that require multi-level BOMs support. $67.95 Buy Online
IS Financial Calculator Windows Application $67.95 Buy Online
FES Safe Office (all above) $254.00 $99.95 Buy Online
FES Inventory Manager Excel Templates $87.95 Buy Online
Balance Sheet Excel Templates
VBA Defencer Excel add-in $67.00 Buy Online

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 IovSoft All Rights Reserved