:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
Latest version of NeuralCode(v1.3) for
Neural Networks Trading.



06/17/2013
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



02/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.


Add-ins and other tools


Free Investment and Financial Calculator (TVM, NPV, IRR) for Microsoft® Excel®

Microsoft Office Marketplace logo

The Time Value of Money and Discounted Cash Flow Analysis are two cornerstone concepts of investment and financial analysis. The aim of this free investment/financial calculator and tutorial is to introduce these two concepts and at the same time use Microsoft Excel to develop financial models that utilize these concepts 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 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 concepts listed will be supported by the calculator.



Download the complete financial templates and tutorials

Time Value of Money (TVM)

Discounted Cash Flow Analysis (DCF)

Background

If given a choice of $1000 to be received today or two years later, most people will no doubt choose to receive the money today. The reason is very simple, the $1000 received today can be put in the banks or in risk free instruments like the US Treasury Bills to earn interest. In two years’ time, the $1000 with interest will be worth more than the $1000 today. This simple concept forms the basis of the Time Value of Money.

If given a choice of receiving $1000 today or $1050 two years later, what would you choose? This is slightly more difficult. We will need to compare these two values on a fair and comparable basis. For example, what is $1000 worth two years later or what is the $1050 in two years’ time worth today? In other words, we are asking what the future value of the $1000 is in two years’ time or what the present value of the $1050 is now.

Download Investment and Financial Calculator - v1.3

Download the Investment and Financial Calculator for Excel

System Requirements

  • Microsoft® Windows XP®, Microsoft® Windows Vista®, Windows 7 or Windows 8
  • Windows Server 2003, 2008 or 2012
  • 512 MB RAM
  • 5 MB of Hard Disk space
  • Excel 2002, 2003, XP, Excel 2007, Excel 2010 or Excel 2013

FreeInvestmentFinancialCalculator.zip (Zip Format - 352 KB)


Back to Add-Ins and Templates for Excel main page.





 


Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners