Please help with assumptions and forecast as well!!

HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) 2012 2013 2014 Profit and loss statement Revenue 788.5 807.6 908.2 1048.8 Cost of goods sold 402.9 428.8 437.7 503.4 Gross profit 385.6 378.8 470.5 545.4 301.2 302.0 356.0 404.5 SG&A expense Depreciation Operating profit 34.2 38.4 36.3 40.9 50.2 38.4 78.2 100.0 Taxes 17.6 13.1 26.2 39.2 Net profit 32.6 25.3 52.0 60.8 Balance sheet Cash 120.1 105.2 66.8 9.4 90.6 99.5 119.5 146.4 Accounts receivable Inventory 468.3 507.6 523.4 656.9 Other current assets 20.9 19.3 22.6 20.9 Current assets 699.9 731.6 732.3 833.6 Net fixed assets 332.1 332.5 384.3 347.9 Total assets 1032.0 1064.1 1116.6 1181.5 Accounts payable 6.0 5.3 4.5 5.0 Wages payable 19.7 22.0 22.1 24.4 Other payables 10.2 15.4 16.6 17.9 35.9 42.7 43.2 47.3 Current liabilities Net worth 996.1 1021.4 1073.4 1134.2 Capital expenditure 22.0 38.8 88.1 4.5 Purchases+ 140.8 145.2 161.2 185.1 Inventory investment was valued at the lower of cost or market. The cost of inventory was determined by accumulating the costs associated with preparing the plants for sale. Costs that were typically capitalized as inventory included direct labor, materials (soil, water, containers, stakes, labels, chemicals), scrap, and overhead. 2 Other current assets included consigned inventory, prepaid expenses, and assets held for sale. Net fixed assets included land, buildings and improvements, equipment, and software. Purchases represented the annual amount paid to suppliers. 2015 2012 100% 51% 49% 38% 4% 6% 2% 4% 15% 11% 59% 3% 89% 42% 131% 1% 2% 1% 5% 126% 3% 18% Percent of Sales 2013 2014 100% 53% 47% 37% 5% 5% 2% 3% 13% 12% 63% 2% 91% 41% 132% 1% 3% 2% 5% 126% 5% 18% 2015 100% 100% 48% 48% 52% 52% 39% 39% 4% 4% 9% 10% 3% 4% 6% 6% 7% 1% 13% 14% 58% 63% 2% 2% 81% 79% 42% 33% 123% 113% 0% 0% 2% 2% 2% 2% 5% 5% 118% 108% 10% 0% 18% 18% Assumptions Forecast 2016 2016 1363.4 654.5 709 525.9 46 129.5 50.4 79.1 -173.4 190.1 854 27.3 897.9 376.9 1274.8 6.5 31.7 23.3 61.5 1213.3 75 240.6 Explanation of Assumptions HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) 2012 2013 2014 Profit and loss statement Revenue 788.5 807.6 908.2 1048.8 Cost of goods sold 402.9 428.8 437.7 503.4 Gross profit 385.6 378.8 470.5 545.4 301.2 302.0 356.0 404.5 SG&A expense Depreciation Operating profit 34.2 38.4 36.3 40.9 50.2 38.4 78.2 100.0 Taxes 17.6 13.1 26.2 39.2 Net profit 32.6 25.3 52.0 60.8 Balance sheet Cash 120.1 105.2 66.8 9.4 90.6 99.5 119.5 146.4 Accounts receivable Inventory 468.3 507.6 523.4 656.9 Other current assets 20.9 19.3 22.6 20.9 Current assets 699.9 731.6 732.3 833.6 Net fixed assets 332.1 332.5 384.3 347.9 Total assets 1032.0 1064.1 1116.6 1181.5 Accounts payable 6.0 5.3 4.5 5.0 Wages payable 19.7 22.0 22.1 24.4 Other payables 10.2 15.4 16.6 17.9 35.9 42.7 43.2 47.3 Current liabilities Net worth 996.1 1021.4 1073.4 1134.2 Capital expenditure 22.0 38.8 88.1 4.5 Purchases+ 140.8 145.2 161.2 185.1 Inventory investment was valued at the lower of cost or market. The cost of inventory was determined by accumulating the costs associated with preparing the plants for sale. Costs that were typically capitalized as inventory included direct labor, materials (soil, water, containers, stakes, labels, chemicals), scrap, and overhead. 2 Other current assets included consigned inventory, prepaid expenses, and assets held for sale. Net fixed assets included land, buildings and improvements, equipment, and software. Purchases represented the annual amount paid to suppliers. 2015 2012 100% 51% 49% 38% 4% 6% 2% 4% 15% 11% 59% 3% 89% 42% 131% 1% 2% 1% 5% 126% 3% 18% Percent of Sales 2013 2014 100% 53% 47% 37% 5% 5% 2% 3% 13% 12% 63% 2% 91% 41% 132% 1% 3% 2% 5% 126% 5% 18% 2015 100% 100% 48% 48% 52% 52% 39% 39% 4% 4% 9% 10% 3% 4% 6% 6% 7% 1% 13% 14% 58% 63% 2% 2% 81% 79% 42% 33% 123% 113% 0% 0% 2% 2% 2% 2% 5% 5% 118% 108% 10% 0% 18% 18% Assumptions Forecast 2016 2016 1363.4 654.5 709 525.9 46 129.5 50.4 79.1 -173.4 190.1 854 27.3 897.9 376.9 1274.8 6.5 31.7 23.3 61.5 1213.3 75 240.6 Explanation of Assumptions