Question

You take out a 20-year loan in the amount of $450,000 at a 4 percent annual...

You take out a 20-year loan in the amount of $450,000 at a 4 percent annual rate. The loan is to be paid off by equal monthly installments over 20 years. Draw an amortization table showing the beginning balance, total payment, principal repayment, interest payment and ending balance for each month. How much is the total interest payment for the first four months? (show only four months on the table).

Homework Answers

Answer #1
amount 450000
interest 4.00%
periodicity monthly
time 20
effective rate of interest 0.003333333
total no. of payments 240
installment ₹ 2,717.85
no. of payments begining balance installments interest principal prepayment closing balance
1 450000 ₹ 2,717.85 1500 ₹ 1,217.85 ₹ 4,48,782.15
2 ₹ 4,48,782.15 ₹ 2,717.85 1495.910295 ₹ 1,221.94 ₹ 4,47,560.21
3 ₹ 4,47,560.21 ₹ 2,717.85 1491.806958 ₹ 1,226.05 ₹ 4,46,334.16
4 ₹ 4,46,334.16 ₹ 2,717.85 1487.689943 ₹ 1,230.16 ₹ 4,45,104.00

TOTAL INTERST PAYMENT = SUM OF FIRST 4 MONTHS = 1500 + 1495.91 + 1491.81 + 1487.69 =  5975.41

PLEASE APPRECIATE THE WORK

Know the answer?
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
Similar Questions
You take out a 15-year loan amount in the amount of $300,000 at a 7% rate...
You take out a 15-year loan amount in the amount of $300,000 at a 7% rate annually. The loan is to be paid off by equally monthly installments over 15 years. Draw an amortization table showing the beginning balance, total payment, principle repayment, interest payment, and ending balance for each month. How much is the total interest payment for the 5 months? (Show only 5 months on the table) ***Please show all work***
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home....
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home. The bank charges 5.5% annual interest compounded monthly. You are going to pay off this loan by fixed installments (fixed total payment) to be made at the end of each month for thirty years. How much is each installment payment? How much is the total principal repayment after four months? How much is the total interest payment after four months. Draw an amortization table...
You have just taken out an amortized loan for $404,000. Assume that the loan will be...
You have just taken out an amortized loan for $404,000. Assume that the loan will be paid in 24 equal monthly installments of ​$18,345.62​ and that the first payment will be due 1 month from today. How much of your third monthly payment will go toward the repayment of​ principal? Fill in the worksheet below.   Month Interest Owing at End of Month​ ($) Principal Repayment​ ($) Principal Owing at End of Month​ ($) 1 2 3
You are getting a six-month loan for new kitchen appliances, where the principal is $10,000 and...
You are getting a six-month loan for new kitchen appliances, where the principal is $10,000 and monthly interest is 1%. The first payment will be made in a month from today. Find the equal monthly payment and complete the following amortization table. [15 pts] Period Beginning, Balance Total Amount, Interest Payment, Principal Payment , Ending Balance 1, 2, 3, 4, 5, 6
Problem 4-20 Amortization Schedule Consider a $10,000 loan to be repaid in equal installments at the...
Problem 4-20 Amortization Schedule Consider a $10,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $  ...
a. Complete an amortization schedule for a $28,000 loan to be repaid in equal installments at...
a. Complete an amortization schedule for a $28,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2 $   $   $   $   $   3 $   $   $   $   $  
Prepare an amortization schedule for a three-year loan of $99,000. The interest rate is 10 percent...
Prepare an amortization schedule for a three-year loan of $99,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 $ $ $ $ $ 2 3...
An amortization table reports the amount of interest and principal contained within each regularly scheduled payment...
An amortization table reports the amount of interest and principal contained within each regularly scheduled payment used to repay an amortized loan. Example Amortization Schedule Year Beginning Amount Payment Interest Repayment of Principal Ending Balance 1 2 3 Consider the amount of the interest payments included in each of the payments of an amortized loan. Which of the following statements regarding the pattern of the interest payments is true? The portion of the payment going toward interest is smaller in...
Loan Amortization GIVEN: A $12,000 4-year loan at 5%. FIND for each year: a. Annual loan...
Loan Amortization GIVEN: A $12,000 4-year loan at 5%. FIND for each year: a. Annual loan payment b. Beginning-of-year balance .c. Annual interest d. Annual principal e. End-of-year balance
Part 2 (matlab) Functions Many of you will have some form of a loan during your...
Part 2 (matlab) Functions Many of you will have some form of a loan during your lifetime, either a student loan, mortgage, credit card debt, or other loan. If you never do have a loan, great! But you may have to calculate a payment for someone else, such as the company you work for. Such a loan will have a principal amount (called the present value), an interest rate, and a number of periods for the loan. The formula to...