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

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 ŷ =...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a...

Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the: Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR

Please could you show full steps and no excel please Miss M had R100,000 to invest...

Please could you show full steps and no excel please Miss M had R100,000 to invest in the financial market. She chose to invest R10,000 in Asset A, which returned 12.0%; R40,000 in Asset B which returned 15.0%; R20,000 in Asset C which returned –5.0%, and the remaining in Asset D which returned 5%. The correlation between the assets are ρAB = 0.75, ρAC = 0.35, ρAD = 1, ρBC = –0.5, ρBD = 0.25, and ρCD = -1. The...

Question