Business Analysis of a Sawmill for Employee Purchase

Income Statement for the Past 3 Years

lgoma University – CESD 2996 Assignment #1 Due: February 8, 2021 *Please submit the assignment electronically to the folder location on the course site by the due date. Include your name and student number on the submission. The assignment #1 is based on the course information from week 1 and 2. The First Nation Band operates an industrial park, an area of land developed as a site for factories and other industrial businesses. One of the tenants operates a sawmill that process wood to be used in furniture. 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, and the single owner has fallen behind on payments and unfortunately filed for bankruptcy. The business employs 40 people from the First Nation Community. The employees have approached the Band office through their economic development department as they wish to purchase the sawmill and operate the mill as an employee owned business. To make this happen, the economic development department of the First Nation Band would need to provide a $1 million loan that would be repayable. The financial data of the sawmill is as follows: 1) Sales for last three years from previous to recent were; $5 million, $4.5 million and $4 million 2) Cost of goods sold for each year was 60%. All other overhead expenses were 30%. 3) The company had depreciation of $200,000 for each of the last 3 years. 4) The company purchased fixed assets of $250,000 during each of the last 3 years. 5) The previous owner typically declared a dividend of 10% of sales each year. Note, the dividend is in addition to the cost of goods sold and operating expenses. 6) Total assets of the business have an original cost of $2 million. Other important data to consider: 1) The previous owner was absent quite often and not fully committed to the business. 2) There is real growth opportunity for the business as there are only a few number of sawmills that can process this type of wood product. 3) There is only $2 Million dollars in the economic development fund. 4) The expectation is that it would be difficult for the 40 employees to find other employment. Required a) Prepare an Income Statement for the past 3 years. b) Identify some of the expenses that a sawmill would have in cost of goods sold and in operating expenses. c) Identify and explain the benefits and risks if the Band provided the $1 million loan for the employee purchase of the mill. d) If you were a member of the economic development committee, how would you vote and explain why.