Future Value of Periodic Payments Symbolic Formula in Excel Format Interpretation A(t) = P*((1+r/n)^(n*t)-1)/(r/n) If an amount P is contributed at the end of each of n periods per year and the balance earns interest at an annual percentage rate of r, the total amount A accrued after t years is given by the right-hand side of the formula. Sample problem: An amount of $250 is contributed at the end of each month, and the balance earns interest at an APR of 6.2%.What is the total amount accrued after 7 years? Inputs: Formatting instructions: p= r= n= t= Dollar amounts: format as Currency with 2 decimal places $250 6.20% 12 7 Rate: format as Percentage with 1 decimal place Application of the formula to the inputs: A(t) Periods/Years: format at Number with 0 decimal places