Saturday, October 3, 2009

FinExcelSoft FinStat Excel Templates

FinExcelSoft FinStat Excel Templates -

5, 10 and 15 Year Project 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.

Plus 137 Excel templates for almost any 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. To receive a correlation matrix you just click one button. Moreover,
you will receive the partial correlation matrix too.

Please note also that some complex Excel functions are simplified by 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.

The 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 in 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, Excel templates may be very useful as for professionals, as for students!

This unique collection of Excel templates (supplied in conjunction with examples and full instructions) allows you easily learn all financial and statistic Excel functions and easily use them for your needs.