y bank gives me an interest rate of 3.35%. Fill out this into C10 C13 Scenario: I want to buy a house that is for sale for $154,500. I wouldke to take 1) Show my monthly payment in cell C13. 2) Show a table with all the info; at bottom total for columns Intere amortization - done in class.) 3) Fill out the small table on the right ting in row 15. (HINT: see the example of the 10 year mortgage Loan Total Interest Paid Total Payment Mortege Interest Rate Periods Monthly Payment Pay Period Mortgage Beginning Balance Payment Interest PENSARNAR Scenario: I want to buy a house that is for sale for $154,500. I would like to take a 30 year. My bank gives me an interest rate of 3.35%. Fill out this info Clo:C13. 1) Show my monthly payment in cell C13. 2) Show a table with all the info; at bottom total for columns Interest and Principal starting in row 15. (HINTI see the example of the 30 year mortgage amortization - done in class.) 3) Fill out the small table on the right Loan Total Interest Paid Total Payment Mortgage Interest Rate: Periods Monthly Payment: Pay Period Mortgage Beginning Balance Payment interest Principal Ending Balance