Question: Today, you open a savings account and you plan to deposit $1,000 at the end of each year. (Your first deposit will be on December 31,2017) How much money will you have in the account at the end of 2021? The bank pays nominal rate of 7% compounded monthly.
Please work in excel and show each equation used.