Safari File Edit View History Bookmarks Window Help G Q 8 Sun Jun 2 7:36 PM OOO AutoSave ... X Collalti Excel Assignment 1 - Case 8 (1) - Saved to my Mac v Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout Formulas Data Review View Automate Developer Comments Share Times New Roman v 12 AA = = ab v General Conditional Formatting Insert v ZY Ap- O. Format as Table v Delete v Paste BIUVE V V A v 5 v $ ~ % " Sort & Find & Sensitivity Add-ins Analyze Cell Styles v Format Filter Select Data L22 X V fx A B D E F G H I J K L M N 0 P Exhibit 1 HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) VOUAWN cent of Sales Assumptions Forecast Explanation of Assumptions 2012 2013 2014 2015 2012 2013 2014 2015 2016 2016 Profit and loss statement B Revenue 788.5 807.6 908.2 1048. 9 Cost of goods sold 402.9 428. 437.7 503.4 10 Gross profit 385.6 378.8 470.5 545.4 11 SG&A expense 301.2 302.0 356.0 404.5 12 Depreciation 34.2 38.4 36.3 40.9 13 Operating profit 50.2 38.4 78.2 100.0 14 Taxe 17.6 13.1 26.2 39.2 15 Net profit 32.6 25.3 52.0 60.8 16 17 Balance sheet 18 Cash 120.1 105.2 66.8 9.4 19 Accounts receivable 90.6 99.5 119.5 146.4 20 Inventory 468.3 507.6 523.4 656.9 21 Other current assets 20.9 19.3 22.6 20.9 22 Current assets 599.9 731.6 732.3 833.6 23 Net fixed assets3 332.1 332.5 384.3 347.9 24 Total assets 1032.0 1064.1 1116.6 1 181.5 25 26 Accounts payable 6.0 5.3 4.5 5.0 27 Wages payable 19.7 22.0 22.1 24.4 28 Other payables 10.2 15.4 6.6 7.9 29 Current liabilities 35.9 42.7 43.2 47.3 30 Net worth 996.1 1021.4 1073.4 1134.2 31 32 Capital expenditure 22.0 38.8 88.1 4.5 33 Purchases 140.8 145.2 161.2 185.1 34 Inventory investment was valued at the lower of cost or market. The cost of inventory was Title Page Exh 1-Forecast Exh 1-Common Sized Financials Exh 2 + Ready Accessibility: Good to go + 100% O 983 JUN 2 O tv AExcel File Edit View Insert Format Tools Data Window Help G Q Sun Jun 2 7:37 PM AutoSave O n A P . C ... *: Collalti Excel Assignment 1 - Case 8 (1) - Saved to my Mac v Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout Formulas Data Review View Automate Developer Comments Share Times New Roman v 12 VA A = = 207 ab v General Conditional Formatting Insert Format as Table X Delete v Paste BIUVV DVAv E E v $ ~ % " Sort & Find & Sensitivity Add-ins Analyze Cell Styles v Format v Filter Select Data J32 X V fx A B D E F G H I J K L M N P Q R S T U V W Exhibit 1 HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) VOUAWN Common Sized Financial Statements 2012 2013 2014 2015 2012 2013 2014 2015 Profit and loss statement 8 Revenue 788.5 807.6 908.2 1048. 9 Cost of goods sold 402.9 428. 437.7 503.4 10 Gross profit 385.6 378.8 470.5 545.4 11 SG&A expense 301.2 302.0 356.0 404.5 12 Depreciation 34.2 38.4 36.3 40.9 13 Operating profit 50.2 38.4 78.2 100.0 14 Taxe 17.6 13.1 26.2 39.2 15 Net profit 32.6 25.3 52.0 60.8 16 17 Balance sheet 18 Cash 120.1 105.2 66.8 9.4 19 Accounts receivable 90.6 99.5 119.5 146.4 20 Inventory 468.3 507.6 523.4 656.9 21 Other current assets 20.9 19.3 22.6 20.9 22 Current assets 599.9 731.6 732.3 833.6 23 Net fixed assets3 332.1 332.5 384.3 347.9 24 Total assets 1032.0 1064.1 1116.6 1 181.5 25 26 Accounts payable 6.0 5.3 4.5 5.0 27 Wages payable 19.7 22.0 22.1 24.4 28 Other payables 10.2 15.4 6.6 7.9 29 Current liabilities 35.9 42.7 43.2 47.3 30 Net worth 996.1 1021.4 1073.4 1134.2 31 32 Capital expenditure 22.0 38.8 88.1 4.5 33 Purchases* 140.8 45.2 161.2 185.1 34 Inventory investment was valued at the lower of cost or market. The cost of Title Page Exh 1-Forecast Exh 1-Common Sized Financials Exh 2 + Ready Accessibility: Good to go - + 100% O 983 JUN 2