Question

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

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

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

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

Part B
Your firm borrows $1m to buy a warehouse. The loan is a 30-year
mortgage at 6% per year with monthly repayments without any balloon
payment. Create an amortization table, but print out only the 30
rows of monthly payments for the anniversary months, i.e., 12, 24,
36, … , 348, and 360. The 6 needed columns are: No. of month,
Beginning balance, Monthly payment, Interest, Principal reduction,
Ending balance. Except for first column, all columns are to be...

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

Amortization Schedule
Consider a $50,000 loan to be repaid in equal installments at
the end of each of the next 5 years. The interest rate is 9%.
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
$
$
$
$
Total...

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

Assume that someone borrows $5,000 at an interest rate of 9
percent per year for five years and agrees to make interest and
principal payments in the amount of $1285.46 at the end of each
year. Prepare a loan amortization schedule for each of the five
years, showing the beginning principal balance, the total payment
of $1285.46, the interest component of the payment, the principal
component of the payment, and the ending balance. Fill in the blank
spaces in the...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 7 minutes ago

asked 8 minutes ago

asked 22 minutes ago

asked 24 minutes ago

asked 29 minutes ago

asked 32 minutes ago

asked 35 minutes ago

asked 42 minutes ago

asked 46 minutes ago

asked 51 minutes ago

asked 1 hour ago