Copy B Overline Merge Cell 3- Insert Row 2. Delete Row B Remove Conditional Format CK HERE TO SAVE YOUR WORK B E F G H 1 2 3 4 Sheri Dan has applied for a mortgage from a Canadian bank. The mortgage would be for $210,000. The nominal interest rate is *9% per year, compounded semi-annually. The mortgage will be paid off in 35 years. 5 6 7 8 9 10 11 12 13 14 Requirements: A. What is the effective annual rate? ]percent (Round your answer to two decimal places (0.9. 12.34). Do not enter the percent sign.) B. Calculate Sheri's payments if the mortgage is due: (Assume mortgage payments are due at the beginning of each time period) (Round your answers to two decimal places. (0.9. $123.45)) 1. Monthly 2. Weekly 3. Bi-weekly Mortgage New