Please show all work

1. Construct an amortization schedule for a 15-year, $300,000 loan with a 2.5% interest rate compounded monthly. The loan will be paid back in 15 years making monthly payments. You need to calculate the principal payment and interest payment, respectively, of each month. Hint: Please refer to the excel file of Loan Amortization posted in Unit 4 Lecture. Specifically, you need to update the model from yearly payment to monthly mortgage payment. 15 years *12 = 180 months. Therefore, you should demonstrate 180 principal payments and interest payments for each month.

2. Construct an amortization schedule for a 30-year, $300,000 loan with a 3.2% interest rate compounded monthly. The loan will be paid back in 30 years making monthly payments. You need to calculate the principal payment and interest payment, respectively, of each month. Hint: Please refer to the excel file of Loan Amortization posted in Unit 4 Lecture. Specifically, you need to update the model from yearly payment to monthly mortgage payment. 30 years *12 = 360 payments. Therefore, you should demonstrate 360 principal payments and interest payments for each month.