If Using excel please show formula.

Consider the following fixed-rate, level-payment mortgage: maturity 360 months, amount borrowed = $10,000,000, annual mortgage rate = 7% (APR). Assuming there is no prepayment, construct the following amortization table for months 36 to 40. Balance at beginning of month Balance at end of month Mortgage Interest Payment Payment Month Principal Payment 36 37 38 39 40