Module Mastery Exercise 3

.xlsx

School

Eastern Gateway Community College *

*We aren’t endorsed by this school

Course

201

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

2

Uploaded by AdmiralStraw4916

Report
You are interested in purchasing a $17,999 new car. You are weighing your options regarding down payment and payment schedule. Your credit score indicates that you can secure a loan with a 5.9% interest rate for a 5-year loan. The facts are summarized below. Car Price $ 17,999 Down Payment 10% Annual Interest Rate: 5.90% Loan years 5 Answer the questions below. 1. If you pay 10% as a down payment (so only need to borrow 90% of the car price), use an EXCEL formulas and functions to complete the following table assuming you make ANNUAL payments. Payment amount: $3,621.48 Format with $, and as a positive num Total repayment: $18,107.42 # of payments X Payment amount Total interest: $1,908.32 Total repayments - amount borrowe 2. If you pay 10% as a down payment (so only need to borrow 90% of the car price), use an EXCEL formulas and functions to complete the following table assuming you make MONTHLY payments. Payment amount: $310.89 Total repayment: $18,653.56 Total interest: $2,454.46 3. Use an Excel formula to calculate the difference (subtraction) between the total interest paid between the two options. Difference: $546.14
mber ed
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help