Question 4 - Create an amortization table for a 15-yr fully amortizing, 6% loan for $10...

 

Transcribed Image Text:

Question 4 - Create an amortization table for a 15-yr fully amortizing, 6% loan for $10 million. Assume annual payments. What is the loan balance after year 5? Inputs Loan Life Interest Rate Loan Amount Annual Payment Loan Balance After YR5 t 1 2 3 Year Beginning Balance 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 15 years 6.00% $ $ $ Question 5 - Calculate the present value of the following cash flows given the interest rate term structure below. Cash Flows Total Payment 5,000 6,000 7,000 Term Structure Total PV Interest Paid 3.50% 4.25% 6.01% Principal Payment PV of Cash Flows Ending Balance Question 4 - Create an amortization table for a 15-yr fully amortizing, 6% loan for $10 million. Assume annual payments. What is the loan balance after year 5? Inputs Loan Life Interest Rate Loan Amount Annual Payment Loan Balance After YR5 t 1 2 3 Year Beginning Balance 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 15 years 6.00% $ $ $ Question 5 - Calculate the present value of the following cash flows given the interest rate term structure below. Cash Flows Total Payment 5,000 6,000 7,000 Term Structure Total PV Interest Paid 3.50% 4.25% 6.01% Principal Payment PV of Cash Flows Ending Balance