please post in excel

Consider the following Excel project. Make sure your responses to the questions are clearly written on an Excel document. Lastly, upload this word document to word by the due date of Friday, 11:59 P.M., June 21, 2019 Victor Connors work at Home Trust Mortgage (HTM) company. One of his duties at work is to prepare informative tables, charts and graphs showing monthly payments to clients for various loan amounts. You are Victor's assistant. You should help him with the following: Consider a $300,000 loan to be repaid in equal end of month install ments for the next 30 years at an interest rate of 4.25 percent (compounded monthly) Now answer the following based on the loan above: Calculate monthly payments to pay off the mortgage. 1 2. Set up an amortization schedule. What is the remaining balance after 6 years (72 payments)? 3. Create a graph showing how the monthly payments are shared between interest and principal. How much is paid towards interest payments over these 30 years. 4. What would be your overall savings if the interest rate were to decline to 4.125 percent instead of 4.25 percent original rate if you made an initial payment of $2,000? Is it worth making this payment. Make sure to answer questions 1, 2, and 3 in Sheet 1 and question 4 in Sheet 2