solve using excel formulas

Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the end of each payment period. The interest rate and the payment period information are given in the following table. How much will the company have after 5 years in the bank account? Assume each year contains 52 weeks. Students can use the Template provided in Canvas to complete this problem. $1500 will be paid... (PP) Rate is 12 % per year with the compounding period below (CP) Future Value At the end of year 5 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Yearly Yearly Yearly Yearly Simi Annually Simi Annually Simi Annually Simi Annually Quarterly Quarterly Quarterly Quarterly Quarterly Monthly Monthly Monthly Monthly Weekly Weekly Weekly Yearly Monthly Quarterly Continuously Yearly Simi Annually Monthly Continuously Yearly Simi Annually Quarterly Monthly Continuously Yearly Simi Annually Monthly Continuously Weekly Daily Continuously 8 19 20 Company A deposit $10,000 now in the bank. Company A will keep deposits $1500 at the end of each payment period. The interest rate and the payment period information are given in the following table. How much will the company have after 5 years in the bank account? Assume each year contains 52 weeks. Students can use the Template provided in Canvas to complete this problem. $1500 will be paid... (PP) Rate is 12 % per year with the compounding period below (CP) Future Value At the end of year 5 1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Yearly Yearly Yearly Yearly Simi Annually Simi Annually Simi Annually Simi Annually Quarterly Quarterly Quarterly Quarterly Quarterly Monthly Monthly Monthly Monthly Weekly Weekly Weekly Yearly Monthly Quarterly Continuously Yearly Simi Annually Monthly Continuously Yearly Simi Annually Quarterly Monthly Continuously Yearly Simi Annually Monthly Continuously Weekly Daily Continuously 8 19 20