Johan just purchased an apartment. He purchased the apartment with a loan of RM $250,000$ at an interest rate of $4\mathrm{.}22\%,$ compounded monthly, for tenure of $20$ years. He assumes the market value of the apartment to be RM$300,000$ in $5$ years' time.

He wishes to purchase a semi$-$detached house in the state of Selangor in $5$ years' time.

A$.$ From Current Information

Obtain the monthly payment.

Construct an amortization table $($by using excel$)$

B$.$ From Other Sources

How much must be paid to the bank if the apartment is sold in $5$ years' time?

What is the difference between the market value and the payment to be made to the bank in question B$\mathrm{.}1?$