Please show all excel formulas

The months payment interest principle balance and cash flows table goes down to 72. Please complete the table and fill in all pink and green tabs.

3. Calculate the lender's yield on constant amortization mortgage loan for $950,000 with monthly payments over 15 years at 6% interest with 1.75 points assuming the borrower prepays the loan at the end of year 6. Using IRR Function Yield to Lender Loan Amount Annual Interest Rate Discount Points Maturity (in years) Periods per year Prepayment Month Monthly Amortization Balance at EOY 6 $950,000.00 6.00% 1.75% 6 12 72 CAM Loan Amortization Schedule Interest Principal Balance Month Payment Cash Flows 0 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 3. Calculate the lender's yield on constant amortization mortgage loan for $950,000 with monthly payments over 15 years at 6% interest with 1.75 points assuming the borrower prepays the loan at the end of year 6. Using IRR Function Yield to Lender Loan Amount Annual Interest Rate Discount Points Maturity (in years) Periods per year Prepayment Month Monthly Amortization Balance at EOY 6 $950,000.00 6.00% 1.75% 6 12 72 CAM Loan Amortization Schedule Interest Principal Balance Month Payment Cash Flows 0 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23