Prepare an amortization schedule for the mortgage of a house of 500,000 with 20% down payment. Interest rate is 5% compounded semiannually. The payments are done on monthly basis for 2 years (A) (B) = Find PMT (C) ' - Previous (E) Xi Interest paid i= (D) (B) - (C) Principal Repaid (E) = previous (E) - (D) Outstanding Principal Balance Amount Paid Payment number 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 TOTALS PV N I/Y CPT PMT