Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show the work on excel Youre given with an auto loan from your credit union. Suppose the total loan you have is $45,000 and the

Show the work on excel

Youre given with an auto loan from your credit union. Suppose the total loan you have is $45,000 and the current average market interest rate is 7.25% for the short-term loans. Answer the following questions:

a. Given that the stated interest as 7.25% per year on your loan, what is the monthly payment if youre intended to have the loan for 5 years?

b. Suppose the credit union says that if youd like to retire the loan earlier, say at the end of the 3rd year, you need to pay (say) $25,000 for the rest of the loan, would you take it given that you have no difficulty to generate the cash flow? Why or why not? (Hint: apply the amortization table to find out the balance of loan).

c. Suppose that the credit union also offers you another possible payment program that is they will give you a low 4% interest rate for the first two years and with a balloon payment at the end of the 2nd year as $28,000. (The balloon payment is a one-time payment that you have to pay it off or you have to re-finance by then.) What is your monthly payment for the first two years? Suppose the loan also carries a penalty charge that if you take the offer and can not pay off the loan with $28,000 at the end of 2nd year, youre subject to a 10% interest rate in refinancing the residual balance of the loan. What will be your monthly payment for the residual balance starting from the 3rd year supposed that you did not arrange the $28,000 lump-sum payment? What will be the overall payments you owe to the credit union if you did not have $28,000 at the end of 2nd year?

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

Complacency And Collusion A Critical Introduction To Business And Financial Journalism

Authors: Keith J. Butterick

1st Edition

074533203X,1849648379

More Books

Students also viewed these Finance questions