Our best solution: NPV Excel templates, IRR, EVA, Investment Valuation, Cash Flow, Budget Forecasting, and more for financial calculations
Hosted by FinExcelSoft
For complete list of our products please click on the link above.
This collection of Excel templates includes:
Contains workbooks:
1. NPV & IRR & ROIC Excel Templates for 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 project.
Please see the screenshots of worksheets below.
2. NPV & IRR Excel Template for periodic cash flows
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.
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.
You can find the results in G3 and H3 cells.
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.
You can find the results in H3 and I3 cells.
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.
You can find the result in the cell F2.
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.
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.
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.
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.
These Excel templates use Excel functions: ztest, ttest, ftest, chitest.
These Excel templates use Excel functions: var, vara, varp, varpa, devsq, stdev, stdeva, stdevp, stdevpa, avedev.
These Excel templates use Excel functions: quartile, percentile, median, percentrank, rank.
These Excel templates use Excel functions: harmean, geomin, average, averagea, trimmean.
These Excel templates use Excel functions: max, maxa, min, mina, large, small.
These Excel templates use Excel functions: fdist, betadist, binomdist, weibull, hypgeomdist, gammadist, lognormdist, normsdist, negbinomdist, poisson, tdist, chidist, expondist.
These Excel templates use Excel functions: finv, betainv, gammaint, loginv, norminv, normsinv, tinv, chiinv, critbinom.
These Excel templates use Excel functions: skew, kurt.
These Excel templates use Excel functions: prob, confidense, mode, frequency.
These Excel templates use Excel functions: gammaln, standardise, permut, count, counta.
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.
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.
Platform:
Windows XP / 2000 / 2003 or later. Or NT4 Server, Windows 9x, Me, NT or Mac.
Requires Excel 2000 or later.
This product contains 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.
60 Excel Financial Templates and 81 Statistic Excel templates with $20 discount! 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 |
||
| Buy Online |  |
|
This product contains all FinExcelSoft Excel products listed above plus FinExcelSoft Defense plus Inventory Manager for Excel 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, resender 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 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.
30-day money back guarantee!
Additional Information: FinExcelSoft Safe Office |
|||
| FES FinStat Excel Templates | 141 finstat Excel templates | $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 |
| FES Safe Office (all above) | Buy Online | ||
Copyright (c) FinExcelSoft
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 2, Excel 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
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 2007 All Rights Reserved
