Financial Accounting: Please answer all questions. Please do in EXCEL where appropriate. Thank you very much.

Part I. The owner of Alpine Golf Course Ltd., a local golf course, has just approached a bank for financing for its new business venture, the development of another course. On April 1, 2023, the bank lent the company $200,000 at an interest rate of 8%. The bank loan is payable over four years with annual payments of $60,384, principal and interest. The first payment is due March 31, 2024. The golf course's year end is March 31. Instructions a. Prepare an instalment payment schedule for the four-year loan period. Round all amounts to the nearest dollar. b. Record the receipt of the bank loan on April 1, 2023. c. Record the first two instalment payments, on March 31, 2024, and March 31, 2025. d. Show the statement of financial position presentation of the bank loan payable as at March 31, 2024. e. Show the statement of financial position presentation for all accounts relating to the bank loan assuming that the company's year end was on April 30, 2024, instead of March 31, 2024. Part II. The following transactions are for Iqaluit Ltd., which has an April 30 year end. 1. In late April, Iqaluit received $12,000 in advance (on deposit) from a customer for inventory that the company will produce and ship to that customer next year. 2. Purchased equipment for $35,000 on April 1 by making a $5,000 down payment and borrowing the remainder from the bank for a six-month period; 6% interest is payable on maturity. 3. Purchased inventory for $7,000 on April 27 on account, n/30. 4. Sold inventory on April 28 for $15,000, plus 5\% GST. (There is no PST in Nunavut, where Iqaluit Ltd. is based.) The cost of the goods sold was $10,500. The company uses a perpetual inventory system. 5. Received $25,000 from customers on April 29 for services to be performed in May. 6. Weekly salaries of $40,000 are paid every Friday for a five-day workweek (Monday to Friday). This year, April 30 is a Monday. Payroll deductions for the one day of this period that falls before the end of the year include CPP of $426, EI of $126, and employee income tax of $2,208. Employee benefits to be paid by the employer include CPP of \$426 and EI of \$176. Payroll deductions will be paid on May 15. 7. Iqaluit is defending a lawsuit alleging negligence for an oil spill that leaked into the neighbouring company's water system. Iqaluit's legal counsel estimates that it is probable that the company will lose the suit but the amount of the loss cannot be determined yet. 8. Iqaluit paid income tax instalments of $80,000 throughout the year. After the preparation of its year-end corporate income tax return, it was determined that the total corporate income tax payable for the year was $95,000. 10. Iqaluit has a $50,000 operating line of credit available, and the company borrowed $5,000 of this line at 6% interest on April 1. The bank will calculate interest due each month on the amount drawn from the line of credit and take that amount out of the company's chequing account on the last day of each month. Instructions a. Identify which of the above transactions give rise to amounts that should be reported in the current liabilities section or the non-current liabilities section of Iqaluit's statement of financial position as at April 30. Identify the account title(s) and amount(s) for each reported liability. b. Indicate any information that should be disclosed in the notes to Iqaluit's financial statements. Part III. The following summary of the payout, dividend yield, and basic earnings per share ratios is available for a three-year period for Acadian Timber Corp.: Instructions a. Using the information provided above, determine the dividends declared and paid per common share in each year (assume there were no preferred share dividends). (Hint: You can determine dividends per share by using basic earnings per share and the payout ratio.) b. Do you think most companies would reduce dividends declared on common shares when basic earnings per share declines? Why or why not? c. Derive the company's market share price at the end of each of the three years shown above by using the common dividends per share calculated in part (a) above and the dividend yield provided. Why do you think that the company's dividend yield decreased in 2021 ? d. If you were an investor looking for dividend income, would you be happy with Acadian's dividend policy? Explain