Answer:
What is typed in the attached Excel file is =FV(B4,B5,-B3,0,0).
Step-by-step explanation:
Note: See the attached excel file for the calculation of future value of an ordinary annuity.
Since we want to find the balance after 30 years, the function in the Excel is the FV function which is used to calculate the future value (FV) of an ordinary annuity as follows:
=FV(rate,nper,-pmt,0,0) …………………… (1)
rate = Monthly interest rate = APR / 12 = 8.99% / 12 = 0.0899 / 12 = 0.00749166666666667. Note: This is typed in cell B4 in attached excel file.
nper = periods = number of months = 30 years * 12 months = 360. Note: This is typed in cell B5 in attached excel file.
pmt = monthly payment = $300. Note: This is typed in cell B3 in the attached excel file. And also typed as a negative value in cell B7, i.e. as -B3.
pv = present value = 0. Note: This is the first 0 typed in cell B7 in the attached excel file.
type 0 = 0 this is typed to indicate that deposit is made at end of period as a regular or ordinary annuity. This is the second 0 typed in cell B7 in the attached excel file.
Based on the above, the FV function in equation (1) above is converted to the following which is typed in the attached Excel file to find the balance after 30 years:
=FV(B4,B5,-B3,0,0)
The above then gives a future value of $548,080.11 which is the balance after 30 years.
