IN EXCEL, CREATE AN AMORTIZATION SCHEDULE FOR THE FOLLOWING MORTGAGE LOAN LOAN AMOUNT: $350,000 INTEREST (COMPOUNDED MONTHLY): 4% TERM 30 YEARS YOUR SCHEDULE SHOULD INCLUDE THE FOLLOWING COLUMNS BEGINNING TERM BALANCE PRINCIPAL END PAYMENT INTEREST REDUCTION BALALANCE ADDITIONAL PAYMENT YOU WILL NEED TO SUBMIT A COPY OF YOUR ORIGINAL SPREADSHEET, A COPY DEPICTING EACH SITUATION LISTED BELOW ALONG WITH THE ANSWERS TO THE QUESTIONS, PLEASE NOTE NO CREDIT WILL BE GIVEN UNLESS ALL FORMULAS ARE INCLUDED IN YOUR SPREADSHEET SITUATION 1: YOU WILL SEND THE BANK AN EXTRA $SO A MONTH. HOW MUCH SOONER WILL THE LOAN BE PAID OF? HOW MUCH WILL YOU SAVE IN INTEREST? PLEASE CREATE AN EXTRA COLUMN AFTER ENDING BALANCE COLUMN. DO NOT ADD THE $50 TO PAYMENT. PLEASE MAKE AN ADOMIONAL PAYMENT COLLIMN.) SITUATION 2: YOU WILL SEND THE BANK AN EXTRA PAYMENT AT THE END OF THE SIXTH YEAR IN THE AMOUNT OF $30,000. HOW MUCH SOONER WILL THE LOAN BE PAID OF? HOW MUCH WILL YOU SAVE IN INTERES? (THIS MEANS MONTH 289. PACE PUTIN THE ADDITIONAL PAYMENT COLUMN SITUATION 3: YOU WILL SEND THE BANK ONE EXTRA PAYMENT PER YEAR UNTIL THE LOAN IS PAID IN FULL HOW MUCH SOONER WILL THE LOAN BE PAID OF? HOW MUCH WILL YOU SAVE IN INTEREST? (PLACE THE EXTRA PAYMENT STARTING IN MONTH 349 THEN EVERY 12 MONTHS IN THE ADDITIONAL PAYMENT COLUMN)