Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer Parts 4-5 Please and thank you. Use excel to show the answer thank you will upvote if correct. - Prof. Business decides to buy

Answer Parts 4-5 Please and thank you. Use excel to show the answer thank you will upvote if correct.

image text in transcribed

- Prof. Business decides to buy a 2022 Honda CR-V Touring edition. After paying a down payment and taxes, Prof. Business can finance the rest of the purchase price with a loan of $22,000 for 48 months at a special finance rate offered by Honda of 2.9% APR compounded monthly. - Prof. Business finds out that Honda has a second offer of $1000 cash back (which will be used as an additional down payment) in place of the special 2.9% finance rate offered. Prof. Business can get 4.29% APR financing online for 48 months with the $1000 cash back offer. Answer the following questions. 1. What is the effective annual rate for each loan? 2. What would be the monthly car loan payment under the Honda's 2.9% APR financing offer (assume a 48-month loan term)? 3. What would be the monthly car loan payment under the $1000 cash back offer and the 4.29% APR pre-approved financing (assume a 48-month loan term)? 4. At what APR would Prof. Business be indifferent between the two offers? In other words, what APR (assuming a 48month loan term) for the $1000 cash back offer would have the same monthly payment with the 2.9% APR financing offer? 5. Let's assume you go with the offer in question #3. Construct an amortization schedule for the loan for all 48 monthly payments (see section 5-18 of the textbook). What is your loan balance after 36 months? 6. The local Honda dealer has found a special 3.19\% APR loan rate for 48 months from Citibank that Prof. Business qualifies for if he elects the $1000 cash back option. Finance says that's great! What would be the monthly payment under this loan? 7. Prof. Business is more than happy with the 3.19% APR and $1000 cash back offer but wants a monthly payment of $425 (assume a 48-month loan term) and realizes he will have to put more money down. How much additional money will Prof. Finance have to put down in order to achieve his target monthly payment? Note: original loan amount with cash back was $21,000. - Prof. Business decides to buy a 2022 Honda CR-V Touring edition. After paying a down payment and taxes, Prof. Business can finance the rest of the purchase price with a loan of $22,000 for 48 months at a special finance rate offered by Honda of 2.9% APR compounded monthly. - Prof. Business finds out that Honda has a second offer of $1000 cash back (which will be used as an additional down payment) in place of the special 2.9% finance rate offered. Prof. Business can get 4.29% APR financing online for 48 months with the $1000 cash back offer. Answer the following questions. 1. What is the effective annual rate for each loan? 2. What would be the monthly car loan payment under the Honda's 2.9% APR financing offer (assume a 48-month loan term)? 3. What would be the monthly car loan payment under the $1000 cash back offer and the 4.29% APR pre-approved financing (assume a 48-month loan term)? 4. At what APR would Prof. Business be indifferent between the two offers? In other words, what APR (assuming a 48month loan term) for the $1000 cash back offer would have the same monthly payment with the 2.9% APR financing offer? 5. Let's assume you go with the offer in question #3. Construct an amortization schedule for the loan for all 48 monthly payments (see section 5-18 of the textbook). What is your loan balance after 36 months? 6. The local Honda dealer has found a special 3.19\% APR loan rate for 48 months from Citibank that Prof. Business qualifies for if he elects the $1000 cash back option. Finance says that's great! What would be the monthly payment under this loan? 7. Prof. Business is more than happy with the 3.19% APR and $1000 cash back offer but wants a monthly payment of $425 (assume a 48-month loan term) and realizes he will have to put more money down. How much additional money will Prof. Finance have to put down in order to achieve his target monthly payment? Note: original loan amount with cash back was $21,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

World Finance Since 1914

Authors: Paul Einzig

1st Edition

0415539471, 978-0415539470

More Books

Students also viewed these Finance questions

Question

Example. Evaluate 5n+7 lim 7-00 3n-5

Answered: 1 week ago

Question

Consistently develop management talent.

Answered: 1 week ago

Question

Create a refreshed and common vision and values across Europe.

Answered: 1 week ago

Question

Provide the best employee relations environment.

Answered: 1 week ago