QUESTION 1

(In part 1b and 1d, The formula is given and the values, kindly give correct answers for all parts now.)

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. a) Illustrate all the cash flows associated with this loan as a fully labelled timeline diagram. b) Determine the size of the monthly payments. Enter this value to the nearest cent. (The formula to use in this question is: PV = R(1-(1 + i)) / i. Values are calculated like this: PV = 250,000 , n = 15 x 12 = 180 , j12 = i = 0.0042) c) Describe and carry out two sanity checks on your answer to part b). d) Determine the size of the outstanding principal immediately after Lee and Kims 20th payment. Enter this value to the nearest cent. (The formula to use in this question is: PV = R(1-(1 + i)) / i. Values are: R = R will be the monthly payment calculated in part 1b , i = 0.0042 , n = 160.) e) If the interest rate charged by the Eastside Bank increases to j12 = 5.52% p.a. immediately after Lee and Kims 20th payment, determine how many more payments it will take to pay off the loan, assuming that Lee and Kim dont change their payment size. f) Determine the size of the partial payment. g) Describe and carry out a strong sanity check on your answer to f). h) 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. i) 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. j) 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).