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.

Please answer using excel equations.

$1500 will be paid... (PP) Rate is 12 % per year with the compounding period below (CP) Future Value At the end of year 5 Time Window Rate Nper PV PMT 1 Year 12% 5 $10,000.00 -$1,500.00 2 3 4 5 6 7 8 9 10 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 $27,152.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 11 12 13 14 15 16 17 18 19 20 $1500 will be paid... (PP) Rate is 12 % per year with the compounding period below (CP) Future Value At the end of year 5 Time Window Rate Nper PV PMT 1 Year 12% 5 $10,000.00 -$1,500.00 2 3 4 5 6 7 8 9 10 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 $27,152.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 11 12 13 14 15 16 17 18 19 20