Final answer:
To save $40,100 for a down payment in five years with an interest rate of 4.5% compounded annually, you need to save approximately $597.21 at the end of each month.
Step-by-step explanation:
To calculate the amount of money needed to save at the end of each month, we can use the formula for future value of an ordinary annuity:
FV = PMT x ((1 + r)^n - 1) / r
Where:
- FV is the future value or the total amount needed to save ($40,100)
- PMT is the monthly savings amount that we need to find
- r is the interest rate per period (4.5% compounded annually divided by 12)
- n is the number of periods (5 years multiplied by 12 months)
Plugging in the values, we get:
FV = PMT x ((1 + (0.045/12))^(5*12) - 1) / (0.045/12)
Simplifying the equation:
40,100 = PMT x (1.00375^60 - 1) / (0.00375)
PMT = 40,100 x (0.00375) / (1.00375^60 - 1)
PMT ≈ $597.21