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.
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:
2. What is your monthly payment?
b. Use IPMT and PPMT to break down the principal and interest portion of the 40tl payment:
c. After paying 72th payment, you want to repay the lean. What is the outstanding balance of the tean?
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.
