SHOW THE FORUMLAS IN EXCEL PLEASE "3. Loan Amortization (25 points) When you go buy a car you know the full value of the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

SHOW THE FORUMLAS IN EXCEL PLEASE "3. Loan Amortization (25 points) When you go buy a car you know the full value of the

Post by answerhappygod »

SHOW THE FORUMLAS IN EXCEL PLEASE
"3. Loan Amortization (25 points) When you go buy a car you knowthe full value of the car. Most of us need a loan to buy the car.The typical length of a car loan is 6 years. (1) If the bankapproves you for an annual interest rate of 7% on your loan, howmuch would you pay each month for a $25,000 car, given you put$5,000 as the down payment? Assume that the first payment is 1month from now. (10 points) (2) Set up a data table that examinesthe sensitivity of monthly payment with respect to the annualdiscount rate varying from 4% to 10% (in 2% increments) and thelength of the loans varying from 3 years to 9 years (in 2 yearincrements). (15 points) "
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”