Please show work for each part A, B, and C. It's only 1 problem with multiple parts, thank you!

Your local bank has offered you a 20-year, $100,000 mortgag. The bank is charging 1.5 points when the loan is given. Payments on the mortgage are semi-annual and are based on a 10% annual interest rate on the full amount of the mortgage. 1 2 3 Part A. Calculate the semi-annual mortgage payment 4 Mortgage principal 100,000 5 "Points" 1.50% 6 Quoted interest 10% 7 Mortgate term (years) 20 8 semi-annual payment 9 10 Part B. Compute the EAIR (if you need intermediate steps to calculate EAIR, use the space in this worksheet to show all your work 11 semi-annual rate 12 Effective annual interest rate 13 Payment at end of the period Part of payment which is interest Part of payment which is repayment of principal 15 Part C. Show the mortgage amortization table Mortgage principal at 16 Semi-annual period beginning of the period 17 1 18 2 19 3 20 4 21 5 22 6 23 7 24 8 25 9 26 10 27 11 28 12 29 13 30 14 31 15 32 16 33 17 34 18 35 19 36 20 37 21 38 39 40 41 42 43 44 45 46 47 48 49 50 51 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Your local bank has offered you a 20-year, $100,000 mortgag. The bank is charging 1.5 points when the loan is given. Payments on the mortgage are semi-annual and are based on a 10% annual interest rate on the full amount of the mortgage. 1 2 3 Part A. Calculate the semi-annual mortgage payment 4 Mortgage principal 100,000 5 "Points" 1.50% 6 Quoted interest 10% 7 Mortgate term (years) 20 8 semi-annual payment 9 10 Part B. Compute the EAIR (if you need intermediate steps to calculate EAIR, use the space in this worksheet to show all your work 11 semi-annual rate 12 Effective annual interest rate 13 Payment at end of the period Part of payment which is interest Part of payment which is repayment of principal 15 Part C. Show the mortgage amortization table Mortgage principal at 16 Semi-annual period beginning of the period 17 1 18 2 19 3 20 4 21 5 22 6 23 7 24 8 25 9 26 10 27 11 28 12 29 13 30 14 31 15 32 16 33 17 34 18 35 19 36 20 37 21 38 39 40 41 42 43 44 45 46 47 48 49 50 51 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38