Excel Built-in Functions Calculates present value given interest rate, num ber of years, uniform payment, =PV(i,n,pmt,fv) future value =FV(i,n,pmt,pv) =PMT(i,n,pv,fv) NPER(i,pmt,pv,fv) =RATE(n,pmt,pv,fv) Calculates future value Calculates uniform payment Calculates number of periods Calculates the interest rate (or compund growth rate) The arguments in the functions refer to cell locations (e.g., the first entry in the PV function will be the cell location of the interest rate). See the formula in the cell with the first anwwer as an example. Compound Growth: Present and Future Amounts (Enter PV or FV as negative number) i (int rate) n(years) Uniform Pmt FV(n) $1,967 PV -1,234 0.06 0 1,234 0.09 -1,234 0.06 14 0 -1,234 8 -0.06 0 FV(n) i (int rate) n (years) Uniform Pmt PV -20,000 0.05 15 0 -20,000 0.10 15 8 -20,000 0.05 0 -0.05 -20,000 20 0 FV(n) n(years) i (int rate) PV Uniform Pmt -10,000 20,000 20 0 0 -1.00 1.60 20 -10,000 20,000 10 -20,000 10,000 20 0 FV(n) i (int rate) Uniform Pmt n(years) PV -10,000 20,000 0.10 0 0.06 0 -1.00 1.50 -10,000 0 25,000 0.10 -20,000 10,000 -0.09 0