Please show the work.. that how you get the value..

Thses are the information what i have in question pleas help

a) You have recently purchased a 5-room resale HDB flat in Bishan at a transaction price of $700.000. The combined balance of CPF Ordinany Account for both you and your spouse is $200,000. You intend to use this CPF balance for the uptront payment, and use a bank loan for the remaining $500,000 with monthly installment for the next 20 years of tenureship. With so many loan packages oftered by different banks in the market, you prefer to adopt a more conservative' approach in your future assessment and decided to take up a fixed-rate package of 2.0% pa. compounded monthly Construct a loan amortization schedule, showing first and last 6 months of payment schedule. (7 marks) b) You have an existing housing loan with an outstanding amount of $500,000. You would like to refinance this loan for a term of 20 years. Make a study of the offers from DBS and OCBC (consider both fixed and floating rates). Show clearly how you would compare the offers and decide on the best package. (8 marks)