Can you please write the functions for how to calculate Mortage amount, Effective rate, Payment, Amortization for the first period and the sensitivity analysis for 3%

Amortization Schedule Sensitivity Analysis $ 540,000.00 Period Principle House Price Down payment (min 20%) Mortgage Amount Loan Balance 4.0% s.14% Effecthe Rate 5,0% 5.9% 6.5% 7.9 Payments peryear 8.0% 9.5% First calculate your Canadian mortgage payment and then use itto buld your mortgage amortization schedulc. After completing those tasks use the two-way data table to do a sensitivity analysis on your mortgage payments where you vary both the years and interest rates Amortization Schedule Sensitivity Analysis $ 540,000.00 Period Principle House Price Down payment (min 20%) Mortgage Amount Loan Balance 4.0% s.14% Effecthe Rate 5,0% 5.9% 6.5% 7.9 Payments peryear 8.0% 9.5% First calculate your Canadian mortgage payment and then use itto buld your mortgage amortization schedulc. After completing those tasks use the two-way data table to do a sensitivity analysis on your mortgage payments where you vary both the years and interest rates