+ Excel for Finance and Accounting: Learn how to optimize Excel formulas and functions for financial analysis by Suraj Kumar Lohani

Author:Suraj Kumar Lohani [Lohani, Suraj Kumar]
Language: eng
Format: epub, pdf
Publisher: BPB Publications
Published: 2023-04-15T00:00:00+00:00

Figure 5.1: Calculation of FV

So, after investing ₹1,00,000/- for 10 years @ 8% compounded annually, we will get ₹2,15,892.5.

If we calculate it year-wise, as shown in Figure 5.1 cell no. D19, we get the same figure as when we calculate it with the formula as shown in cell F3.

Excel has an inbuilt formula for FV = FV(rate,nper,pmt,[pv],[type])

Syntax

=FV (rate, nper, pmt, [pv], [type])

Arguments:

rate: The interest rate per period.

nper: The total number of payment periods.

pmt: The payment made each period (must be entered as a negative number)

pv: [optional] The present value of future payments (assumed to be zero. if omitted); PV must always be entered as a negative number

type: [optional] When payments are due: 0 = end of period, 1 = beginning of period; the default is 0.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.