Question
See Wall Street Journal, Tuesday, September 30, 2003: Personal Journal, Section D: Read the article, A Car Loan That Outlasts Your Car. The article mentioned
See Wall Street Journal, Tuesday, September 30, 2003: Personal Journal, Section D: Read the article, "A Car Loan That Outlasts Your Car." The article mentioned that a $20,000 loan with an 8% interest rate over 8 years instead of a 5% loan over 5 years will slash payments by approximately $100, but will add $4,500 to interest cost.
Problem:Set up amortization schedules for
A $30.000 car loan at a 6.5% interest rate over 8 years
B. A $30.000 car loan at a 3.5% interest rate over 5 years.
C. Calculate the exact difference in payments.
D. Comment on the article using your knowledge of the time value of money
**Please do it in excel with formula** Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started