rom Benninga and Mofkadi, 2018, 2011, 2006 Ruth and Moab have just purchased ther dream apartment/condo. They have financed the purchase wth a term 'equal payment) loan of $150,000 (mortgage). The loan is for 10 years, with 6% stated annua interest (0.50% monthly interest payments). All payments and compounding are from month end. Part A: Show an amortization table for the loan, and till in the missing information below. Principal at the Beginning of the Month Part of the Payment that is Repayment of Part of the Payment that is Loan Principal Belance at Year Payment at the End of the Month Loan Principal Loan Term (years) Loan Term (monrhs) Quoted Interest Rate Monthly Repayment 150,000,00 10 6.00% #N/A Calculating the EAIR Monthly Interest Rate Effective Annual Interest Rate #N/A #N/A Part B: Break down the 10th payment to the principal and interest. You may only usc the IPMT an PPMT Functions 10th Period Interest Payment: 10th Period Principal Payment: NA N/A 12 13 14 15 16 17 18 19 20 21 Part C Four years after taking out the loan, Ruth and Moab want to repay the loan. What is the outstanding balance of the loan? Outstanding principal balance: Use the CUMPRINC tuntion to verty #N/A extra credit (2 pcints) 24 25 26