Directions: Complete the requirements listed on the "Assignment" tab using the installment spreadsheet on the "Schedule" tab. Do not work in groups, each person is to answer the following questions on his or her own. Save your answers and submit through CANVAS. Schedule may be extended by copying or deleting rows to accommodate varying years and periods.
Requirements-
1 Assume you borrowed $25,000 to buy a new car at 3.9% interest to be paid back in monthly installment over the next 5 years.
a) How much would your monthly payment be?
b) How much interest expense would be included in your first payment?
c) How much interest expense would be included in your last payment?
d) How much would your payment be if your interest rate was 9.9%?
2 Assume you borrowed $200,000 for a home, at 6.5% interest for 30 years, to be paid back in monthly installments over the next 30 years?
a) How much would your monthly payment be?
b) How much interest would you pay over the 30 years in total?
c) If you pay back the loan in equal installments over the next 15 years instead of 30 years how much would your monthly payment be?
d) If you pay back the loan in equal installments over the next 15 years instead of 30 years how much interest you pay over the 15 years?
3 Select a loan amount, interest rate, and number of months to pay back and answer the following questions.
Loan:
a) What is the monthly payment amount?
b) How much interest expense would be included in your first payment?
c) How much interest expense would be included in your last payment?
d) How much interest would you pay in total over the term of the loan?