Question

In: Finance

Prepare the first row of a loan amortization schedule based on the following information; the loan...

Prepare the first row of a loan amortization schedule based on the following information; the loan amount is for $17,246 with an annual interest rate of 6%. the loan will be repaid over 38 years with monthly payments.

What is the loan payment?
What portion of this payment is Interest?
What portion of this payment is principal?
What is the loan balance after the first monthly payment?

Expert Solution

Loan Amount = $17,246

Calculating the monthly Loan Payment:-

Where, P = Loan amount = $17,246

r = Periodic Interest rate = 6%/12 = 0.5%

n= no of periods = 38 years*12 = 456

Monthly Payment = $96.12

- Preparing the Amortization table of the first month of Loan:-

Year	Beg bal.	Payment	Interest amount	Principal Amount	End Bal.
1	17,246.00	96.12	86.23	9.89	17,236.11

2) .Portion of this payment is Interest = $86.23

3). Portion of this payment is principal = $9.89

4). Loan balance after the first monthly payment = $17,236.11

Note- The following Columns are calculated based on:

- Interest amount = beg. Balnace*Monthly interest rate

- Principal maount = Payment - Interest amount

- End Bal. = Beg. Bal + Interest - Payment

If you need any clarification, you can ask in comments.

If you like my answer, then please up-vote as it will be motivating

jeff jeffy answered 2 years ago

Prepare an amortization schedule for a three-year loan of $24,000.

Prepare an amortization schedule for a three-year loan of $24,000. The interest rate is 16 percent per year, and the loan calls for equal principal payments.

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest...

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and...

a. Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. Month Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the third year. Check that this value is the same...

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...

AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...

Problem 6-55 Amortization with Equal Payments [LO3] Prepare an amortization schedule for a five-year loan of...

Problem 6-55 Amortization with Equal Payments [LO3] Prepare an amortization schedule for a five-year loan of $61,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ $ $ $ $ 2 ...

a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and...

a)Prepare an amortization schedule for a 10-year loan of $300,000. The interest rate is 12% and the loan calls for equal payments. How much interest is paid in the fifth year? How much interest is paid over the life of the loan? b)What is the present value of $2,625 per year at a discount rate of 8%, if the first payment is received six years from now and the last payment is received 20 years from now?

Prepare a schedule showing the amortization of a $12,000 loan to be repaid in 10 end-of-year...

Prepare a schedule showing the amortization of a $12,000 loan to be repaid in 10 end-of-year installments that include interest at a rate of 6%. Jared and Courtney Jill own a parcel of fertile farm land which a local farmer has offered to rent for a period of 10 years. He is willing to make a payment of $20,000 today or pay an ordinary annuity of $3,400 at the end of each of the next 10 years. Which payment method...

Amortization schedule Set up an amortization schedule for a $36,000 loan to be repaid in equal...

Amortization schedule Set up an amortization schedule for a $36,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 6% compounded annually. Round all answers to the nearest cent. Beginning Remaining Year Balance Payment Balance 1 $ $ $ 2 $ $ $ 3 $ $ $ What percentage of the payment represents interest and what percentage represents principal for each of the 3 years? Round all answers...

Prepare an amortization schedule for a three-year loan of $111,000. The interest rate is 10 percent...

Prepare an amortization schedule for a three-year loan of $111,000. The interest rate is 10 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance 1 $ 111000 $ $ $ $ 2...

Prepare an amortization schedule for a five-year loan of $84,000. The interest rate is 8% per...

Prepare an amortization schedule for a five-year loan of $84,000. The interest rate is 8% per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan? Provide another amortization schedule if you must pay $8,400 toward the principle each year instead of equal annual payments. How much interest is paid in the third year? Explain why the third year interest...