1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ale4655 [162]
3 years ago
11

Amortization.  Loan Consolidated Incorporated​ (LCI) is offering a special​ one-time package to reduce Custom​ Autos' outstandin

g 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?
Business
1 answer:
vladimir2022 [97]3 years ago
7 0

Answer:

Please find the complete question in the attached file.

Explanation:

Use PMT for the interest amount computation

PMT(12\%, 55, 232000, 0 , 0) = \$27,894.77

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:

Loan\ \ \ \ \ \ \ \ \ \  Annual\ \ \ \ \ \ \ \ \ \   Interest\ \ \ \ \ \ \ \ \ \   Principal\\\\

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\\\\

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 = 27,894.77 \times 55 - 232,000 = \$1,302,212.27

You might be interested in
How do we find an interest rate?​
Murrr4er [49]

Answer:

i find de interst rate 10 %

6 0
3 years ago
How old can you be to get your license?<br>A) 16<br>B) 18<br>C) 19 ​
jekas [21]

Answer: 18

Explanation: Legal age to drive

7 0
3 years ago
Read 2 more answers
In economics, we define the "long run" as a. About ten years b. The amount of time it takes for a factory to need new paint c. T
kari74 [83]

Answer:The answer is c

Explanation:

3 0
3 years ago
A company issues a ten-year bond at par with a coupon rate of 6.5% paid semi-annually. The YTM at the beginning of the third yea
Montano1993 [528]

Answer:

$880.31

Explanation:

For computing the new price of the bond we need to apply the present value formula i.e to be shown in the attachment

Given that,  

Assuming Future value = $1,000

Rate of interest = 8.6%  ÷ 2 = 4.3%

NPER = 8 years  × 2 =

PMT = $1,000 × 6.5% ÷ 2  = $32.5

The formula is shown below:

= -PV(Rate;NPER;PMT;FV;type)

So, after applying the above formula, the present value is $880.31

5 0
3 years ago
On February 2, Flint Corp.'s board of directors voted to discontinue operations of its frozen food division and to sell the divi
ikadub [295]

Answer: $40,000

Explanation:

The gain from discounted operations assuming no income taxes, is the gain from the sale of the asset less the net operating losses in the period.

= Gain from Sales of Asset - Net losses in period

= 90,000 - ( 20,000 + 30,000)

= $40,000

8 0
3 years ago
Other questions:
  • Jermaine, a member of a student organization, supports the move to increase the membership fees for their organization in order
    14·1 answer
  • Agent Emily's listing was sold by another agent in her brokerage. Emily is entitled to a:______.a. selling side commission.
    14·1 answer
  • What uses a systematic approach in an attempt to improve business effectiveness and efficiency continuously? static process dyna
    7·1 answer
  • A service management tool has the ability to store templates for common incidents that define the steps to be taken to resolve t
    12·1 answer
  • Who Is The Creator Of The Apple Company And Pixar.Just Guess Don't Google
    8·1 answer
  • Lucia and Kenji need to decide which one of them will take time off from work to complete the rather urgent task of shearing the
    9·1 answer
  • Recent financial statement data for Harmony Health Foods (HHF) Inc. is shown below.
    12·1 answer
  • Accounts payable, end of year $ 5,643 $ 9,588 Accounts receivable, net, end of year 21,325 16,438 Inventory, end of year 7,944 7
    14·1 answer
  • Why was agricultural sector declared as critical industry and exempt from the hardest lockdown regulations
    5·1 answer
  • If Honduras wanted to trade goods with China, how would they negotiate the treaty? A. Through the WTO B. At a meeting of busines
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!