To be done in Microsoft Excel

2. APR vs EAR (5 points) Samantha plans to invest some money so that she has S5,500 at the end of three years. Option A 4.20% 365 Option B 4.90% 12 Option C 5.20% 4 Option D 5.40% APR m/per year 1. 2. 3. 4. How much should she invest today given the choices above? What is her best choice? What is the EAR for each account? Support your decision in question 2. Three years later: she has S5,500. She did not use this money as she intended, so she decided to reinvest this sum again. Calculate the final balance in each account at the end of year 1, year 5, and year 20