On the first of May 2015 Lee and Kim borrowed $250,000 from the Eastside Bank in order to buy an apartment. The loan was to be repaid through 180 monthly payments over a period of 15 years, with the first payment due on the first of June 2015, and each payment being the same size. The interest rate charged by the Eastside Bank was j12=5.04% p.a.

1. Illustrate all the cash flows associated with this loan as a fully labelled timeline diagram.

2. ANSWER IN THE FORMAT "$X,XXX.XX". The size of each monthly payment to the nearest cent is:

3. Describe and carry out two sanity checks on your answer to part b).

4. The outstanding principal immediately after the 20th payment is.

5. If the interest rate charged by the Eastside Bank increases to j12 = 5.52% p.a. immediately after Lee and Kims 20^th payment, determine how many more payments it will take to pay off the loan, assuming that Lee and Kim dont change their payment size.

6. Determine the size of the partial payment.

7. Describe and carry out a strong sanity check on your answer to f).

8. Construct an amortization schedule, showing the last 3 payments (i.e. two full payments and a partial payment). Ensure that you include example calculations for one line of the schedule, and that you show how you got the starting OP for the table.

9. Lee and Lim decide that rather than making a partial payment the month after the full payments finished, they would rather make the last full payment large enough to retire the loan then. Determine the size that this larger payment would need to be. Ensure that you explain the logic of the approach.

10. Referring back to question e), determine what the new payment size would need to be if Lee and Kim wanted to retire the debt by May 2030. (i.e. in 160 more months).

Can u help me to solve the above questions in Excel, thanks