In: Finance
4. Make an amortization table for a plain vanilla CPM fully amortizing with the following terms. 30 year monthly payments 4.5% Interest rate $1,000,000 initial loan amount. a. How much interest is paid on the loan over the first 2 years? b. How much interest is paid on the loan over the last 2 years? c. If 25 years from now interest rates drop to 2%, would the borrower be likely to refinance? Why or why not? ****NEED THIS IN EXCEL*** PLS