Please show steps, preferably no excel pls Loan Consolidated Incorporated (LCI) is offering a special one-time...

Please show steps, preferably no excel pls

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 $200,000 for Custom Autos if Custom Autos will make an annual payment to LCI at a 9% interest rate over the next 12 years.

21. What portion of the eighth payment is used to pay for interest?

22. What portion of the tenth payment is used to pay for principal?

23. What is the total interest expense on the loan over the 12 years?

Expert Solution

(21.) $ 9778.71

(22.) $ 21,563.92

(23.) $ 135,173.83

Present Value = Annual Payment * PVAF(9%, 12 years)

$ 200,000 = Annual Payment * PVAF(9%, 12 years)

Annual Payment = $ 200,000 / PVAF(9%, 12 years)

Annual Payment = $ 200,000 / 7.1611

Annual Payment = $ 27,928.6

Repayment Schedule

Year	Opening Blance	Annual Payment	Towards Interest	Towards Principal	Closing Balance
	A	B	*C = A9%**	D = B - C	E = A - D
1	$ 200,000.00	$ 27,928.63	$ 18,000.00	$ 9,928.63	$ 190,071.37
2	$ 190,071.37	$ 27,928.63	$ 17,106.42	$ 10,822.20	$ 179,249.17
3	$ 179,249.17	$ 27,928.63	$ 16,132.43	$ 11,796.20	$ 167,452.97
4	$ 167,452.97	$ 27,928.63	$ 15,070.77	$ 12,857.86	$ 154,595.11
5	$ 154,595.11	$ 27,928.63	$ 13,913.56	$ 14,015.07	$ 140,580.04
6	$ 140,580.04	$ 27,928.63	$ 12,652.20	$ 15,276.42	$ 125,303.62
7	$ 125,303.62	$ 27,928.63	$ 11,277.33	$ 16,651.30	$ 108,652.32
8	$ 108,652.32	$ 27,928.63	$ 9,778.71	$ 18,149.92	$ 90,502.40
9	$ 90,502.40	$ 27,928.63	$ 8,145.22	$ 19,783.41	$ 70,718.99
10	$ 70,718.99	$ 27,928.63	$ 6,364.71	$ 21,563.92	$ 49,155.07
11	$ 49,155.07	$ 27,928.63	$ 4,423.96	$ 23,504.67	$ 25,650.40
12	$ 25,650.40	$ 27,928.63	$ 2,308.54	$ 25,650.40	$ -
		Total Interest	$ 135,173.83

jeff jeffy answered 1 year ago

Amortization. loan consolidated incorporated (LCI) is offering a special one time package to reduce custom Auto's...

Amortization. loan consolidated incorporated (LCI) is offering a special one time package to reduce custom Auto's outstanding Bill's to easy to handle payment plan. LCI will pay off the current outstanding Bill's of $230,000 for custom Autos if custom Autos will make an annual payment to LCI at an interest rate of 7% 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...

loan Consolidated Incorporated (LCI) is offering a special one-time package to reduce Custom Autos' outstanding bills...

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 $248 comma 000 for Custom Autos if Custom Autos will make an annual payment to LCI at an interest rtae of 8% 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...

Loan Consolidated Incorporated (LCI) is offering a special one-time package to reduce Custom Autos’ outstanding bills...

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 $200,000 for Custom Autos if Custom Autos will make an annual payment to LCI at a 9% interest rate over the next 12 years. . What portion of the eighth payment is used to pay for interest? . What portion of the tenth payment is used to pay for principal?...

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

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 $244,000 for Custom Autos if Custom Autos will make an annual payment to LCI at a 9% interest rate over the next 5 years. First, what are the annual payments and the remaining balance of the loan at the end of each year (should Custom Autos want to pay...

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

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 $234,000 for Custom Autos if Custom Autos will make an annual payment to LCI at an interest rate of 12% 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...

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

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 $244,000 for Custom Autos if Custom Autos will make an annual payment to LCI at an interest rate of 11% 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...

Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will...

Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will cost $10 million. A bank is willing to lend you $7 million for the purchase with equity holders having to provide the remainder of the funds. the terms of the loan are: a 20-year loan with yearly payments at a fixed rate of 3%. You will sell the business after year 8. You estimate the business will have the following profits in years 1-8:...

Please show steps Madison Inc. was incorporated in the State of Delaware in May 2018 and...

Please show steps Madison Inc. was incorporated in the State of Delaware in May 2018 and received authorization to issue 200,000 shares of $3 Par Value Common Stock and 20,000 Preferred Stock, Par Value $50 per share. Prepare journal entries to record the following transactions. (a) On June 15, 2018 Madison Inc. issued 75,000 common shares with a Market price of $10 (b) On July 8, 2018 Madison Inc. issued 500 common shares to Mr. Maddox in settlement of Professional...

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical...

SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...

SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). Brand Price ($) Score A 180 76 B 150 71 C 95 61 D 70 58 E 70 40 F 35 24 (a) The estimated regression equation for this data is ŷ =...

Question