Amortization. Loan Consolidated Incorporated (LCI) is offering a special one-time package to reduce Custom Autos' outstanding bills to one easy-to-handle payment plan. LCI will pay off the current outstanding bills of $242 comma 000 for Custom Autos if Custom Autos will make an annual payment to LCI at an interest rtae of 9 % over the next 5 years. a. What are the annual payments of the loan? b. What is the amortization schedule for this loan if Custom Autos wants to pay off the loan before the loan maturity in 5 years? c. When will the balance be half paid off? d. What is the total interest expense on the loan over the 5 years?

Question

02-07-2021
Business

Answered

Looking for answers? Westonci.ca is your go-to Q&A platform, offering quick, trustworthy responses from a community of experts. Connect with professionals ready to provide precise answers to your questions on our comprehensive Q&A platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

Amortization. Loan Consolidated Incorporated (LCI) is offering a special one-time package to reduce Custom Autos' outstanding bills to one easy-to-handle payment plan. LCI will pay off the current outstanding bills of $242 comma 000 for Custom Autos if Custom Autos will make an annual payment to LCI at an interest rtae of 9 % over the next 5 years. a. What are the annual payments of the loan? b. What is the amortization schedule for this loan if Custom Autos wants to pay off the loan before the loan maturity in 5 years? c. When will the balance be half paid off? d. What is the total interest expense on the loan over the 5 years?

Sagot :

We appreciate your time. Please come back anytime for the latest information and answers to your questions. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Westonci.ca is your trusted source for answers. Visit us again to find more information on diverse topics.

how big is a ziggurat?

Adam Smiths Wealth of Nations stressed the importance of?

In which situation is the object experiencing balanced forces? A) A girl swings on a swing at the playground. B) A car brakes as it approaches a traffic light.

Which of these sentences contains a coordinate conjunction? A. Astronauts bounce about from wall to wall, flying! B. Weightlessness can sometimes be downright u

beth has made 12 cupcakes.This is 30% of the cupcakes she must make.How many cupcakes must she make?

What are some ways that propaganda posters were used to influence americans behavior during world war 1

Which of these is true for both photosynthesis and cellular respiration? Both occur in all organisms. Both occur in most producers. Both produce carbon dioxide.

John is a farmer who wants to keep his soil as productive as possible. Which of these actions would help him achieve this goal? excessive irrigation crop rotati

if you wanted to learn more about the genetic material of plant and animal cells, were would you look ? a. in the lysosomes b. in the nucleus c. inside the chlo

which of the following is a complex sentence A. of started to make pasta, but I changed my mind and made rice instead. B. I enjoy reading because it's a solit

codiepienagoya codiepienagoya · Answer 1 · 2021-07-07T09:20:56-04:00

Answer:

Please find the complete question in the attached file.

Explanation:

Use PMT for the interest amount computation

[tex]PMT(12\%, 55, 232000, 0 , 0) = \$27,894.77[/tex]

At first, the bulk of an initial premium is paid at the rate of interest, and that only the remainder of the small part is used for amortization. The very first three years schedule is shown below:

[tex]Loan\ \ \ \ \ \ \ \ \ \ Annual\ \ \ \ \ \ \ \ \ \ Interest\ \ \ \ \ \ \ \ \ \ Principal\\\\[/tex]

[tex]1\ \ \ \ \ \ \ \ \$232,000.00\ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,840.00\ \ \ \ \ \ \ \ \$54.77\\\\2\ \ \ \ \ \ \ \ \$231,945.23\ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,833.43\ \ \ \ \ \ \ \ \$61.34\\\\3\ \ \ \ \ \ \ \ \$231,883.89 \ \ \ \ \ \ \ \ \$27,894.77\ \ \ \ \ \ \ \ \$27,826.07\ \ \ \ \ \ \ \ \$68.70\\\\[/tex]

By the 49th payment, upwards of half of the initial amount borrowed would be the total principal paid. Using the formula CUMPRINC in excel, the entire principal payment is calculated twice.

Total Interest Expense [tex]= 27,894.77 \times 55 - 232,000 = \$1,302,212.27[/tex]

Sagot :

Other Questions