Hosted by FinExcelSoft
For complete list of our products please click on the link above.
This collection of Excel templates includes:
This spreadsheet allows 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 the 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 duratinn for a security. Full instructions.
Calculates straigh-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.
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 are 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 uses 56 financial Excel Templates and 81 statistic Excel templates
Excel workbooks supplied with this product:
1. npv.xls - NPV & IRR for periodic cash flows templates
2. npvirrdate.xls - NPV & IRR for any cash flows templates
3. mirr.xls - MIRR template
4. sec.xls - 26 securities templates
5. amort.xls - 5 amortization templates
6. datetime.xls - 4 date templates
7. finexcelsoft.xls - additional 16 financial templates
8. ann.xls - Excel templates for annuities
9. corr.xls - correlation coefficients, partial correlation coefficients, regression
coefficients
10. test.xls - testing Excel templates
11. var.xls - variation calculation Excel templates
12. serial.xls - serial statistics
13. mean.xls - mean values calculation
14. extrem.xls - extreme values calculation
15. dist.xls - distribution calculation
16. invdist.xls - inverse distribution calculation
17. geo.xls - geometric characteristics calculation
18. add.xls - probability calculation
19. math.xls - mathematics for statistic analysis
20. even.xls - calculation of venly distributed numbers.
56 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 |  |
|
Our Bonus: if you order this product you may order Excel add-in for Extended Accounting with hierarchies for free. For more information about this Excel add-in please visit: Extended Accounting page. This offer is just temporary. To order this Excel add-in, email to info@busysoftorder.com. Please include: your first and last name and your order number.
Busysoftorder.com Excel Templates
IovSoft Financial Excel Templates
Please review also our POP3 anti-SPAM, mass email, and more FES emailer
Copyright © FinExcelSoft 2007 All Rights Reserved
