1. This assignment contains ONE Problems. -50 points

2. All the problem must be completed with MS Excel (not using MS Excel will result Zero grade).

3. Show your work for full credit.

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.

The final table made in excel should look like this:

$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 2 3 4 5 6 7 8 9 Yearly Yearly Yearly Yearly Simi Annually Simi Annually Simi Annually Simi Annually Quarterly Quarterly Quarterly Quarterly Quarterly Monthly Monthly Monthly Monthly Yearly Monthly Quarterly Continuously Yearly Simi Annually Monthly Continuously Yearly Simi Annually Quarterly Monthly Continuously Yearly Simi Annually Monthly Continuously 10 11 12 13 14 15 16 17 Home Assignment 3 Working Template Entering the values in the fields, the answer will automatically calculated. $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 Year 12% 5 -$10,000.00 -$1,500.00 1 2 3 4 5 6 7 8 9 Yearly Yearly Yearly Yearly Simi Annually Simi Annually Simi Annually Simi Annually Quarterly Quarterly Quarterly Quarterly Quarterly Monthly Monthly Monthly Monthly Yearly Monthly Quarterly Continuously Yearly Simi Annually Monthly Continuously Yearly Simi Annually Quarterly Monthly Continuously Yearly Simi Annually Monthly Continuously $27,152.69 S0.00 $0.00 S0.00 S0.00 S0.00 S0.00 50.00 S0.00 S0.00 50.00 $0.00 50.00 S0.00 $0.00 S0.00 S0.00 10 11 12 13 14 15 16 17