A realtor sold a house on 31 August 2016 for $150000 with a 20% down payment. The buyer took a 15-year loan on the property with an effective interest rate of 10% per annum. The buyer intends to pay off the loan owed in yearly payments starting on 31 August 2017. (a) How much of the loan will still be owed after the payment due on 31 August 2,019 has been made? (b) Solve the same problem by separating the interest and principal amounts for the next 15 years. (21 points) Please assume uniform series payments. Down payments typically come from the buyer's pocket, and are not a part of the loan. Do not make any additional assumptions; points will be deducted if you do. For (b), prepare a spreadsheet table with the following headings: - Payment number, - Principal owed (beginning of period), - Interest owed in each period, - Total owed (end of each period), - Principal paid in each payment, - Uniform annual payment amount