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.