please show the excel reference

Problem #3: Create a table showing the payment of a mortgage of $252,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment always the same value) - Payment against principal - Remaining Principal The mortgage is to last 32 years, and the nominal interest rate is 7.81% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th month? (c) How much of the principal is paid down by the payment made at the end of the 22nd month? (d) The first time that the portion of a monthly payment that is paying down the principal will be larger than the portion paying interest will occur at the end of month number_ ? Problem #3(a): 1788.20 Answer correct to 2 decimals Problem #3(b): 1632.21 Answer correct to 2 decimals Problem #3(c): Answer correct to 2 decimals Problem #3(d): 279 Just Save Your work has been saved! (Back to Admin Page) Submit Problem #3 for Grading