Question

Given the following partial amortization table for a loan repaid in level payments. Fill in the rest of the table (keep addin

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Time Payment Interest Principal Reduction Outstanding Balance

0

-

-

-

25300

1

6504.44

2277.001

4227.441

21072.561

2 6504.44 1896.52 4607.92 16464.65

a)

Amount of level payment : 2277.001 + 4227.441 = 6504.44

b)

Initial amount of loan T0 : Principal o/s at year 1 end + opening balance = 21072.561 - 4227.441 = 25300.00

c)

Effective interest rate : Interest / opening outstanding: 2277.001 / 25300 = 0.09 or 9%

or 1896.53/ 21072.561 = 0.09 or 9%

d)

Annual level payment: Loan amount / PVAF @ 9%, for n years

6504.44 = 25300 / PVAF @ 9%, for n years

PVAF @ 9%, for n year = 25300/6504.44

PVAF @ 9%, for n year = 3.8896

PVAF @ 9% becomes 3.8896 after 5 years, hence, total 5 payments will be made until the loan is paid off.

Add a comment
Know the answer?
Add Answer to:
Given the following partial amortization table for a loan repaid in level payments. Fill in the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360...

    Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the loan are shown below): Correct Answers 1. What is your monthly payment? 2. What is the total $ amount of payments made over the life of the loan Enter Answers Here. 3. How many months will it take to pay off the loan if you pay an extra $465.71 per month? Note: Enter the...

  • A loan of 100,000 is to be repaid in 4 level annual payments starting one year...

    A loan of 100,000 is to be repaid in 4 level annual payments starting one year after the loan date. For the first 2 years, the annual interest rate is 8%; for the last 2 years, the annual interest rate is 4%. Find the annual payment and complete the loan amortization table. t Payment Interest Due Principal Repaid Outstanding Balance 0 100,000 1 2 3 4

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

    AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $34,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Interest ofPrincipal Balance Balance avment Interest Payment b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. 96 Interest %...

  • The purpose of this question is to give you experience creating an amortization schedule for a...

    The purpose of this question is to give you experience creating an amortization schedule for a loan. As noted by Investopedia: ‘An amortization schedule is a complete table of periodic loan payments, showing the amount of principal and the amount of interest that comprise each payment until the loan is paid off at the end of its term. While each periodic payment is the same amount early in the schedule, the majority of each payment is interest; later in the...

  • You took out a loan that must be repaid with level payments at the end of...

    You took out a loan that must be repaid with level payments at the end of each year. The loan has an annual effective rate of interest of 8%. The outstanding balance at the end of the ninth year was $22,000 and the outstanding balance at the end of the twelfth year was $15,000. What is your payment on the loan? Round your answers to two decimal places. 3914.6 X

  • b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal...

    b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. General Computers Inc. purchased a computer server for $58,500. It paid 35.00% of the value as a down payment and received a loan for the balance at 7.50% compounded semi-annually. It made payments of $2,050.27 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? o payments Round up to the next payment...

  • A company borrowed $14,000 paying interest at 6% compounded annually. If the loan is repaid by...

    A company borrowed $14,000 paying interest at 6% compounded annually. If the loan is repaid by payments of $2100 made at the end of each year, construct a partial amortization schedule showing the last three payments, the total paid, and the total interest paid. Complete the table below for the last three payments. (Do not round until the final answer. Then round to the nearest cent as needed.) Payment Outstanding Number Amount Paid Interest Paid Principal Repaid Principal $2100 $2100...

  • 3. A company borrowed $13,000 paying interest at 8% compounded quarterly. If the loan is repaid...

    3. A company borrowed $13,000 paying interest at 8% compounded quarterly. If the loan is repaid by payments of $1800 made at the end of each 3 months, construct a partial amortization schedule showing the last three payments, the total paid, and the total interest paid. Complete the table below for the last three payments. (Do not round until the final answer. Then round to the nearest cent as needed.) Payment Outstanding Number Amount Paid Interest Paid Principal Repaid Principal...

  • A company borrowed ​$15,000 paying interest at 3​% compounded quarterly. If the loan is repaid by...

    A company borrowed ​$15,000 paying interest at 3​% compounded quarterly. If the loan is repaid by payments of $1700 made at the end of each 3 months, construct a partial amortization schedule showing the last three​ payments, the total​ paid, and the total interest paid. Complete the table below for the last three payments. ​(Do not round until the final answer. Then round to the nearest cent as​ needed.) Payment Number Amount Paid Interest Paid Principal Repaid Outstanding Principal 8...

  • 8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal paym...

    8. Prepare the loan amortization schedule ($15) You borrow $1,000, and the loan is to be repaid in three equal payments at the end of each of the next three years. The lender charges a 6 percent interest rate on the loan balance that is outstanding at the beginning of each year. 1) Calculate the payment the firm must repay each year. 2) Prepare the loan amortization schedule (fill all the numbers in each cell). Repayment of Remaining Principal Beginning...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT