Find future value of annuity in excel
pv is the initial principal or the present value; fv refers to future value. type is whether the annuity is a regular or an annuity due. Use 0 for regular annuities, and 1 29 Apr 2018 The formula for calculating the future value of an ordinary annuity (where a series of equal payments are Excel Formulas and Functions 29 May 2019 You can calculate the future value of ordinary annuity using the following direct formula: Alternatively, you can use Excel FV function.