The First Nation Band operates an industrial park, an area of land developed as a site location for factories and other industrial businesses. The businesses pay rent to the First Nation and to operate from their industrial park location. One of the tenants operates a will that process wood to be wed in future. The business has operated for 10 years, however, for the last 4 years, operations have failed to produce net income after all expenses and dividends. The single owner has fallen behind on rent payments to the Industrial Park and unfortunately las recently filed for bankruptcy. The business employs 30 people from the First Nation Community The employees have approached the Band office through their sconomic development department as they wish to purchase the sawmill and operate the mill as an employee owned business. To make this happen, the Comic development department of the First Nation and would need to provide a St million loan that would be fully repayable The financial data of the sawmill is as follows: 1) Sales for last three years from previous to recent wers, 56,25 million, 55.4 million and S4.5 million Cost of goods sold for each year was 60% of sales All other operating expenses were 30% of sales for each year The company had depreciation of $225,000 for each of the last 3 years The depreciation expense amount is included in the operating expenses 4 The company purchased fixed assets of $250,000 during each of the last 3 years The current owner and sole shancholder declared a dividend of 12% of sales for each of the last 3 years. Note the dividend is in addition to the cost of poods sold and operating expenses Total assets of the business have an original cost of 2.75 million Other important data to consider: The current owner was absent quite often, as the owner would go to his Vacation property that is in a different country for extended periods of time. >> There is real growth opportunity for this business as there are only a few sawmills that can process this type of wood product used in furniture and the demand is expected to increase by 10% for each for the next 5 years. The First Nation Band has an economie development fund with a mission to enerate and sustain employment. The Fundas S2 Million dollars for this year Historically, the Band approves 10 economic development fund proposals in a year with an average loan amount of 5200,000 The expectation is that it would be difficult for the existing 30 employees to 3The First Nation Band has an economic development fund with a mission to generate and sustain employment. The Fund has $2 Million dollars for this year. Historically, the Band approves 10 economic development fund proposals in a year with an average loan amount of $200,000 The expectation is that it would be difficult for the existing 30 employees to find other employment The 30 cmployees plan to set up a company and purchase the bankrupt business for S2 million, funded as follows: 1 million - First Nation Economic Development Fund, $700,000 Bank Loan, and $300,000 from employees (cach employee will invest $10,000). The funding from the Economic Development Fund and the Bank loan are repayable over 10 years. Required (Answer the following) a) Prepare an Income Statement for the past 3 years Explain the strengths and weaknesses with this Income Suatement. Calculate the Dividend Payout Ratio and explain how dividends impact the retained camnings equity of the company, Is there a problem if a sharcholder declared dividends that were excessive? b) Identify some of the expenses that a sawmill would have in cost of goods sold and in the operating expenses. Explain how you would determine if the expenses are in line or excessive above average. How would you monitor the expenses for this business during a typical fiscal year! c) Identify and explain the benefits and risks if the First Nation Band provided the SI million loan for the employee purchase of the sawmill. If you were a member of the economic development committee, how would you vote and explain why. d) If the employees are successful in their purchase of this sawmill, explain if the business currently has the ability to repay the debt. Calculate the total debt payment per month and for the year (assume 12 months of payments in the year) for the year. Explain how the long-term debt is shown in the balance sheet and income statement e) If the employees are successful in their purchase of this sawmill explain how the day-to-day financial affairs should be managed. Explain the difference between share capital and retained earnings