On January 1, 2018, XYZ Co. sold services to a customer in exchange for a four year $100,000 promissory note with an annual interest rate of 4%. Interest only payments are due SEMI-ANNUALLY, beginning on June 30, 2018. The market rate for an equivalent loan to this customer would have been 6%*. XYZ Co. uses IFRS, has a Dec 31 year end, and prepares adjusting entries annually. Required: a) Calculate the amount of revenue to be recorded on January 1st 2018 by XYZ Co for the sale of the equipment. i. Calculate using the present value tables in the textbook. ii. Calculate using EXCEL PV formula. Copy your Excel formula to another cell as text so it can be viewed (put in front of it for text.) (Remember that the payment and the future value must be negative.) b) Prepare the journal entries for XYZ Co. at Jan 1, 2018, June 30, 2018, and Dec 31, 2018. (Show all calculations.) c) Prepare the note amortization schedule. Be sure to show the semi-annual interest payments and the payment of the note on Jan 1, 2022. *HINT: semi-annual payments, therefore, there is a payment every 6 months. Interest rates are always quoted on an annual basis.