please answer on excel and show the functions

10) You have purchased of a $250,000 apartment with a down payment in cash of 10% of the purchase price. The remaining 90% is financed with a term loan. The loan term is for 15 years, with 4.5% stated annual interest ( 0.375% monthly interest payment). Please note that your payment is monthly payment, not annual payment. Thus, answer the following questions using monthly payment. ( 12 points) In addition, you are NOT allowed to use an amortization table of the loan to answer the following questions. You have to use Excel functions such as PV, PMT, IPMT, PPMT, CUMPRINC, etc, to directly get answers for the following questions. (Of course, you can always use the amortization table to verify your answers.) a. What is your monthly payment? b. Use IPMT and PPMT to break down the principal and interest portion of the 50th payment. c. After paying 72th payment, you want to repay the loan. What is the outstanding balance of the loan? d. While talking to one of the local banks about paying off the outstanding balance of the current loan after paying 72th payment, you realize that you can refinance your mortgage with a new loan carrying a 0.3125% monthly interest rate (3.75\% stated annual interest rate) for a one-time commission of $6,000. Should you refinance? If not, what is the maximal commission you would be willing to pay? e. If you decide to stay with the current loan meaning you are not going to pay off your loan now and you are not going to refinance with the new interest rate, you would like to know that after the loan is paid off, what are the total principal and the total interest repaid over the duration of the loan. Use CUMPRINC and CUMIPMT to get answers. Please note that the arguments used in =CUMIPMT are very much the same as =CUMPRINC. Please note that if a user is using your model for this mortgage problem, the user should be able to change the scenario by changing the certain values such as loan amount, interest rates, number of years of the loan, number of years or number of payments paid, and still be able to derive an answer in terms of whether he/she should refinance