You are planning to buy a bicycle shop from Mr. John with 60% of your own money and 40% of bank loan. Your bank has offered the required loan at 15% rate of interest with the condition that you will have to repay the loan in equal semiannual instalments in 2 years. Mr. John wants a price for the bicycle shop equal to the present value of his expected future cash flows from the shop. If not sold now, he expects to get $10,000, $14,000, and $28,000 cash flows respectively in the years 1, 2, and 3, from the shop, and $10,000 in year 3 from selling the shop to someone else. For calculating the present value, John uses the discount rate of 16%. You have to prepare the loan amortisation schedule for the loan you will take from the bank to buy the bicycle shop from Mr. John