6. 75,000 is borrowed. The loan is repaid with n end of month payments. For payments 1-12, the amount is 1000. For payments 13-24, the amount is 2000. For the rest of the payments, the amount is 3000 with the possible exception of the final payment. The nominal rate of interest is 3.6% convertible monthly. (a) Use the retrospective method to find the outstanding loan balance just after the 24th payment has been made. (b) Use the prospective method to find the outstanding loan balance just after the 24th payment has been made. (c) Create an amortization schedule of the loan in Microsoft Excel