There are no financial functions in Excel to find the net future value of an investment. The good news however is the option of using tadXL add-in, a large library of financial functions including one to find net future worth. Here, me Abraham A. will take you on a guided tour to find the net future value using the tadNFV function.
All tad Finance products are available for download at this link.
NFV is an acronym that stands for net future value of an investment and it is one of the tools used by an analyst to help find an investor's ROI - return on investment. The net future value is nothing more than the sum of compounded cash flows that results in a terminal value of an investment such as periodic deposits in uneven amounts. The Excel spreadsheet program has no NFV function of its own yet third party tools such as tadXL add-in for Excel 2007, 2010, and 2013 offer tadNFV function along with host of other financial functions. This function offers a bunch of features that are desired in NFV calculation such as use of different compounding frequencies, specification of periods of different lengths, and the mid-year discounting convention as opposed to the full-year discounting convention.
Before we proceed to find net future worth in Excel, you would need the tadXL add-in which is available for download here. There are different versions of this add-in i.e. v0.5, v1.0, v2.0 and v2.5 and you would have to select one of them for installation.
The net future value Excel function requires the following values as input:
=tadNFV ( discount_rate, cash_flows, type, compounding, period, distribution )
|Net future value||23.0272||26.103||29.5321||29.7441||22.8088|
You can download a copy of net future value template here.
Finance tutorials on a variety of topics ranging from finding ROI using IRR, NPV, Payback period, etc. TVM calculations i.e. present value & future value of loans and bank deposits. Valuation & yield on stocks and bonds i.e. cost of equity, & debt. Rates of return on investments i.e. ARR, GRR, holding period return & yield.
Excel 4 finance to perform DCF analysis NPV, xNPV, IRR, xIRR, MIRR, xMIRR etc. Time value of money calculations i.e GRADIENT, INTEREST RATE, NPER, PMT, etc, yields and prices of bonds and stocks. Rates of return i.e. HPR, HPY, AHPR, and AHPY, etc.
TI BA II plus guide to analyze investments using capital budgeting methods i.e IRR, NPV, MIRR etc. TVM calculations i.e. RATE, NPER, PMT, PV, FV. Interest rate factors i.e. PVIFA, PVIF, FVIFA, FVIF, etc .
Finance tables to find interest factors for present value and future value of $1 and of annuities with start of period and end of period payments in amount of $1. Interest rates for growing and shrinking annuities are available as well.