Need help with the attached finance assignment due in excel.

ACC 406 - FALL 2016 SEMESTER EXCEL - EXTRA CREDIT Please use Excel to answer the following questions. Answer each question in the space provided. 1 Calculate the present value of 120 monthly payments of $3,000 at an annual rate of 8%. The payments are made at the end of each month. ANSWER = -$247,264.44 2 You are financing a new car with a 3 year loan at 5% annual interest, compounded monthly. The amount you are borrowing is $16,000. What are your monthly payments? ANSWER = 3 What is the maximum you can finance if you can only afford a monthly payment of $200? The interest rate is 5%. The term is three years. ANSWER = 4 If you deposit $5,000 in a savings account that pays 8% annual interest compounded monthly, and make no other deposits to the account, how much will you have after 5 years? ANSWER = 5 In addition to the $5,000 as specified in the above problem, how much will you have at the end of 5 years if you also deposit an additional $200 at the end of each month for the entire 5 year period? ANSWER = 6 In addition to the $5,000 as specified in above problem #4, how much will you have at the end of 5 years if you also deposit an additional $200 at the beginning of each month for the entire 5 year period? ANSWER = 7 You will be making quarterly payments on your $10,000 loan. The interest rate is 8%. How much are your payments if you plan on paying off the loan in 5 years? ANSWER = 8 Calculate the present value of 120 monthly payments of $1,000 at an annual rate of 12%. The payments are made at the beginning of each month. ANSWER = 9 In five years we need $125,000. How much do we deposit today if the annual interest rate is 8%, compounded annually? ANSWER = 10 In five years we need $25,000. How much do we deposit today if the annual interest rate is 8%, compounded monthly? ANSWER = 11 Create a monthly loan amortization schedule for the following loan: The amount to borrow is: Term of the loan: Annual interest rate: Loan payments are made monthly. 15,000.00 3 years 6% Please start the loan amortization schedule here: Principal Interest Term Payment 15000 6% APR 3 $456.33 Pmt # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Beg Bal 15,000.00 Pmt Amt 456.33 Interest Principal Reduction 75.00 381.33 End Bal 14,618.67 31 32 33 34 35 36 0.00