Can you do it in EXCEL ( Spreadsheet) and write the formula please

1. Assume that you deposit $1,000 at the beginning of each year into an account earning 2% interest. [ 1.25 points] a. How much will you have at the end of 5 years? [0.25 points] b. If you instead deposit the money at the end of each year, how much will you have at the end of 5 years? [0.25 points] ***For questions C through E, assume beginning of year deposits (as in Part A). c. Using a vertical data table, explore how your results vary when the interest rate changes from 1% to 10%. Intuitively explain why the variation makes sense. [Note: you can just write your answer in a cell and highlight the answer). [0.25 points] d. Using a horizontal data table, explore how your results vary when your investment horizon changes from 1 to 10 years. Intuitively explain why the variation makes sense. [0.25 points] e. Create a two-dimensional table showing how results change when the interest rate changes from 1% to 10% and the investment horizon changes from 1 to 10 years. [0.25 points]