In: Finance
6. You are saving for a new house and you put $25,000 per year in an account paying 4.5%. The first payment is made today.
A.) How much will you have at the end of 3 years? (Show Work)
B. Also build a table/schedule to show your account each year (include beginning balance and ending balance each year, interest earned).
Given that I am saving $25,000 each year for 3 years
Rate of interest is 4.5%, lets us assume this rate is annual interest rate
A) Today, I make first payment $25,000
So, for 1st year, my interest amount = $25000 * 4.5% = $1125
Also, I deposit my payment at beginning of year 1 i.e., $25000
Therefore, at the beginning of year 1, my amount = $25000 + $1125 + $25000 = $51125
So, for 2nd year, my interest amount = $51125 * 4.5% = $2300.625
Also, I deposit my payment at beginning of year 2 i.e., $25000
Therefore, at the beginning of year 2, my amount = $51125+ $2300.625 + $25000 = $78425.625
So, for 3rd year, my interest amount = $78425.625 * 4.5% = $3529.153125
Also, I deposit my payment at beginning of year 3 i.e., $25000
Therefore, at the beginning of year 3 my amount = $78425.625+ $3529.153125+ $25000 = $106954.7781
Interest during the 3rd year = $106954.7781 * 4.5% = $4812.965016
Therefore total amount at end of 3 years = $106954.7781 + $4812.965016 = $111767.7431
So, amount at the end of 3 years is $111,767.74 (rounded off to two decimals)
B) The below table represents the account for 3 years
| 
 Amount deposited  | 
 Opening balance  | 
 Interest Per annum (4.5%)  | 
 Closing balance  | 
|
| 
 At present  | 
 $25000  | 
 $25000  | 
 $1125  | 
 $26125  | 
| 
 1st year  | 
 $25000  | 
 $51125  | 
 $2300.625  | 
 $53425.625  | 
| 
 2nd year  | 
 $25000  | 
 $78425.625  | 
 $3529.153125  | 
 $81954.77813  | 
| 
 3rd year  | 
 $25000  | 
 $106954.7781  | 
 $4812.965016  | 
 $111767.7431  |