9.1 A 20-year, $470,000 mortgage at 3.20% compounded semi-annually is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $275 at the end of year six(HOW MANY YEARS AND MONTHS?   Kindly explain with excel details Thank you

A $347,500 mortgage at 4.90% compounded semi-annually was settled with monthly payments of $2, 525. a. What is the amortization period for the mortgage? b. How much will the amortization period be shortened by if weekly payments of $1300 are made instead ca the monthly payments? a) 7 A▾ BI EE

The balance on a mortgage was $43,200 and an interest rate of 5.50% compounded semi-annually was charged for the remaining 3-year term. Monthly payments were made to settle the mortgage. a. Calculate the size of the monthly payments. SO Round up to the next whole number b. If the monthly payments were set at $1,454, how long would it take to pay off the mortgage? 0 years 0 months Express the answer in years and months, rounded to the next payment period c. If the monthly payments were set at $1,454, calculate the size of the final payment. $0.00 Round to the nearest cent