If you extend the financial statements, and performance, what do you expect to be the financial position of Horniman in 2016? Explain.

Please show a excel forecasting for 2016 Income statement, Balance sheet, Cash flow statement to support your answer.

Transcribed Image Text:

Exhibit 1 HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) Profit and loss statement Revenue Cost of goods sold Gross profit SG&A expense Depreciation Operating profit Taxes Net profit Balance sheet Cash Accounts receivable Inventory Other current assets Current assets Net fixed assets Total assets Accounts payable Wages payable Other payables Current liabilities Net worth Capital expenditure Purchases 2012 788.5 402.9 385.6 301.2 34.2 50.2 17.6 32.6 120.1 90.6 468.3 20.9 699.9 332.1 1032.0 6.0 19.7 10.2 35.9 996.1 22.0 140.8 2013 807.6 428.8 378.8 302.0 38.4 38.4 13.1 25.3 105.2 99.5 507.6 19.3 731.6 332.5 1064.1 2014 2015 38.8 145.2 908.2 1048.8 437.7 503.4 470.5 545.4 356.0 404.5 36.3 40.9 78.2 100.0 26.2 39.2 52.0 60.8 66.8 119.5 523.4 22.6 9.4 146.4 656.9 20.9 833.6 347.9 1116.6 1181.5 732.3 384.3 5.3 4.5 5.0 22.0 22.1 24.4 15.4 16.6 17.9 42.7 43.2 47.3 1021.4 1073.4 1134.2 88.1 161.2 4.5 185.1 Exhibit 1 HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) Profit and loss statement Revenue Cost of goods sold Gross profit SG&A expense Depreciation Operating profit Taxes Net profit Balance sheet Cash Accounts receivable Inventory Other current assets Current assets Net fixed assets Total assets Accounts payable Wages payable Other payables Current liabilities Net worth Capital expenditure Purchases 2012 788.5 402.9 385.6 301.2 34.2 50.2 17.6 32.6 120.1 90.6 468.3 20.9 699.9 332.1 1032.0 6.0 19.7 10.2 35.9 996.1 22.0 140.8 2013 807.6 428.8 378.8 302.0 38.4 38.4 13.1 25.3 105.2 99.5 507.6 19.3 731.6 332.5 1064.1 2014 2015 38.8 145.2 908.2 1048.8 437.7 503.4 470.5 545.4 356.0 404.5 36.3 40.9 78.2 100.0 26.2 39.2 52.0 60.8 66.8 119.5 523.4 22.6 9.4 146.4 656.9 20.9 833.6 347.9 1116.6 1181.5 732.3 384.3 5.3 4.5 5.0 22.0 22.1 24.4 15.4 16.6 17.9 42.7 43.2 47.3 1021.4 1073.4 1134.2 88.1 161.2 4.5 185.1