Question

In: Finance

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) Beginning Balance B) Payment per Period C) Interest Paid D) Principal Paid E) Ending Balance

Solutions

Expert Solution

Even though it is 2 year corporate loan it gets paid off in year 1 because there will 4 quarterly payment of $187500 which matches to $750000 principal.

* Interest = Beginning Balance * 7.50%/4

* Payment Per Period = Interest + Principal repayment per payment

Please dont forget to upvote


Related Solutions

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:...
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?
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...
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?
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...
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
Construct an amortization schedule for a four-year, RM10,000 loan at 6% interest compounded annually.
Construct an amortization schedule for a four-year, RM10,000 loan at 6% interest compounded annually.
Construct an amortization schedule for a loan with the following characteristics. Loan amount = $10,000; term...
Construct an amortization schedule for a loan with the following characteristics. Loan amount = $10,000; term = 5 years; interest rate = 8 percent; annual payments.
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT