Formula only needed to calculate the balance. Interest not required

1 2 5. You are wanting to purchase a house in 5 years, needing $30,000 down payment. How much must you deposit each month (starting today) in an account that pays a quoted annual interest rate 3 4 5 1. Future value amount(s) 30000 ($363.70) calc annuity 6 2. Present value amount 0 7 3. Time and number of periods (including compounding timing) 60 monthly 5 years 12 84. Interest rate 0.01 mo rate 0.12 annual interest rate 9 10 starting the deposits TODAY - annuity due (1) 1 11 " 12 TIMELINE 13 191 months balance annity interest balance 14 0 0 $363.70 3.636965 $367.33 15 1 $363.70 7.310299 $738.34 16 2 $363.70 11.02037 $1,113.06 17 3 $363.70 14.76753 $1,491.52 18 4 $363.70 18.55217 $1,873.77