Free Investment and Financial Calculator - TVM, NPV, IRR
The Time Value of Money and Discounted Cash Flow Analysis are two cornerstone concepts of investment and financial analysis. This free investment and financial calculator uses these two concepts to develop financial models for analyzing investments.
It is known that most financial analysts in the industry developed their own set of models during their course of work over the years. The models usually form the basis of their analysis work and become an extremely important toolkit to them. This financial calculator and tutorial aims to provide the basis of building this toolkit and serve as a stepping stone for financial analysts to building more complex models. The following Time Value of Money (TVM) calculations are supported :
Future Value of a Lump Sum
Future Value of a Lump Sum with more than 1 compounding period per year
Future Value of a Lump Sum with Continuous Compounding
Future Value of an Ordinary Annuity
Future Value of a series of unequal cash flow
Present Value of a Lump Sum to be received in the Future
Present Value of a Lump Sum with more than 1 compounding period per year
Present Value of an Ordinary Annuity
Present Value of a Perpetuity
Present Value of a series of unequal cash flow
The following Discounted Cash Flow Analysis (DCF) calculations are supported :
Net Present Value (NPV)
Internal Rate of Return (IRR)
Money Weighted Rate of Return
Time Weighted Rate of Return
Holding Period Return
Bank Discount Yield
Money Market Yield
All VBA Source Code and Excel Formulas are provided.
What's New: New Release

Free Investment and Financial Calculator 1.0 is 100% clean
This download (FreeInvestmentFinancialCalculator.zip) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. TinyGraphs 1.0 - Open source add-in that creates sparklines for Excel
2. Free Loan Amortization Schedule 1.0 - Free Loan Amortization Schedule
3. TraderCode Technical Indicators 5.0 - Stock Trading Technical Indicators and Backtesting for Excel
4. Discounted Cash Flow Analysis Calculator 2.1 - Discounted Cash Flow Analysis of 14 cash flow series with 5 discount rates.
5. Visual Options Analyzer 4.5.2 - Visual Stock Options Analyzer. Build options strategies, hedging.
6. AnalyzerXL 6.1.37 - Technical analysis, stock quotes, investment portfolio in Microsoft Excel
7. TraderXL Pro Package 6.1.39 - All-in-one investment solution for Microsoft Excel
8. Portfolio Performance Monitoring 3.0 - Monitoring and tracking the performance of a portfolio of financial assets.
9. Investment and Business Valuation 3.0 - Evaluating a wide range of investment proposal and business valuation scenarios.
10. GoldenGem 1.4 - Goldengem is one of the best neural net stock market programs.