You borrowed an X amount of money from a local bank to be repaid over N months at an interestrate i (assume your own numbers for X, i, M). I need : (a) Create a table (using Excel) showing each...

You borrowed an X amount of money from a local bank to be repaid over N months at an interest rate i (assume your own numbers for X, i, M). I need : (a) Create a table (using Excel) showing each month's interest in $ (I), principal repayment, and amount of principal remaining at the end of each month. (b) Suppose that you decided to pay out the remaining principal all at once after few monthly payments (< n),="" how="" much="" will="" you="" pay?="" use="" the="" p="" a="" relationship="" to="" answer="" this="" part="" and="" compare="" to="" the="" numbers="" in="" the="">