Free Investment and Financial Calculator
|Last updated:||14 Sep. 2009|
|File size:||474 KB|
|Publisher:||ConnectCode Pte Ltd|
Publisher description for Free Investment and Financial Calculator
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.