1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan...

1A) Construct a loan amortization schedule for a 15 year, 7.75% loan of $10,000,000. The loan requires equal, end-of-year paymens, and interest compounded monthly.

b) what is the total amount of interest paid over the life of the loan?

c) Assume that there is a balloon payment requirment after 10 years. What is the balloon payment in section a?

Solutions

Expert Solution

Interest rate = 7.75% Compounded monthly.

So, Effective annual rate = [(1 + 7.75% / 12) ^ 12] - 1

= 1.0803 - 1

= 8.03%

Effective annual rate is 8.03%.

Now Loan amortization scedule is calculated in excel and screen shot provided below:

Annual Payment on Loan is $1,170,529.20.

total amount of interest paid over the life of the loan is $7,557,937.99.

Outstanding balance at end of year 10 is $4,669,730.78. So, if there is a balloon payment requirment after 10 years then value of balloon payment is $4,669,730.78.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

A- 1. Construct a loan amortization schedule for a 15-year, 7.75% loan of $10,000,000. The loan...

A- 1. Construct a loan amortization schedule for a 15-year, 7.75% loan of $10,000,000. The loan requires equal, end-of-year payments, and interest is compounded monthly. - What is the total amount of interest paid over the life of the loan? 2. Re-construct this amortization schedule assuming that interest is compounded annually. - What total amount of interest is paid over the life of the loan? - What is the difference between those total interest amounts? 3. Assume that in sections...

1. Construct a loan amortization schedule for a 15-year, 7.25% loan of $7,000,000. The loan requires...

1. Construct a loan amortization schedule for a 15-year, 7.25% loan of $7,000,000. The loan requires equal, end-of-year payments, and interest is compounded monthly. - What is the total amount of interest paid over the life of the loan? 2. Re-construct this amortization schedule assuming that interest is compounded annually. - What total amount of interest is paid over the life of the loan? - What is the difference between those total interest amounts? 3. Assume that in...

Construct a loan amortization schedule for a 30-year, 8.65% loan of $15,000,000. The loan requires equal,...

Construct a loan amortization schedule for a 30-year, 8.65% loan of $15,000,000. The loan requires equal, end-of-year payments, and interest is compounded monthly. What is the total amount of interest paid over the life of the loan?

1. Construct a loan amortization schedule for a 30-year, 8.65% loan of $15,000,000. The loan requires...

1. Construct a loan amortization schedule for a 30-year, 8.65% loan of $15,000,000. The loan requires equal, end-of-year payments, and interest is compounded daily (use 360-day year). What is the total amount of interest paid over the life of the loan?

Construct a detailed Fixed Loan Amortization schedule for a 2 year corporate equipment loan of $750,000.00,...

Construct a detailed Fixed Loan Amortization schedule for a 2 year corporate equipment loan of $750,000.00, payable at a 7 1/2% annual interest rate, with payments scheduled to be made on a quarterly basis. This loan calls for the payback of $187,500.00 toward the principal with each scheduled payment. Note that the schedule may be off by several dollars due to rounding. The schedule should include the following parts, which you should put in the form of a table: A)...

7. Construct a LOAN AMORTIZATION schedule for a 3 year 5% loan of $100, 000. Please...

7. Construct a LOAN AMORTIZATION schedule for a 3 year 5% loan of $100, 000. Please show your calculations clearly and include calculated answers in the table below. (Please only do this question if you are certain how to do it) Amortization Schedule for a Loan of $100 000 Repaid Over 3 Years at 5% Year Payment amount Interest Paid Principal repaid Outstanding loan balance 0 1 2 3

3) Construct a detailed Fixed Loan Amortization schedule for a 2 year corporate equipment loan of...

3) Construct a detailed Fixed Loan Amortization schedule for a 2 year corporate equipment loan of $750,000.00, payable at a 7 1/2% annual interest rate, with payments scheduled to be made on a quarterly basis. This loan calls for the payback of $187,500.00 toward the principal with each scheduled payment. Note that the schedule may be off by several dollars due to rounding. The schedule should include the following parts, which you should put in the form of a table:...

Question