Assuming strong performance in 2006, will this improve the cash position? Use the information provided in your team's Excel workbook to calculate the estimated cash position for 2006. Maggie assumes 2006 Deprecation and Capital Expenditures of $46,000 and $75,000, respectively. Remaining variables will use 2005 estimates.

AutoSave On Ly ysueegroupproject_horniman_horticulture_workbookb - Saving... Parker Lake X File Home Insert Page Layout Formulas Data Review View Help Search Share Comments X Cut [G Copy Times New Roman ~ 12 AA B Wrap Text Number AutoSum Fill APO Paste Format Painter BIUTY MY A v = Merge & Center $ % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table Styles Clear Ideas Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas J23 X A 2 B HORNIMAN HORTICULTURE C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC Projected Horniman Horticulture Financial Summary (in thousands of dollars) 5 6 2002 2003 2004 2005 2006E 7 Profit and loss statement 8 Revenue 788.5 807.6 908.2 1048.8 31.0% 1373.9 9 Cost of goods sold 402.9 428.8 437.7 503.4 10 Gross profit 385.6 378.8 470.5 301.2 302.0 356. $45.4 11 SG&A expense 404.5 12 Depreciation 34.2 38.4 36.3 40.9 46.0 13 Operating profit 50 2 38.4 78.2 100.0 14 Taxes 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 FALSE 19 Accounts receivable 90.6 99.5 119.5 146.4 20 Inventory 468.3 6 523.4 656.9 21 Other current assets? 20 0 19.3 22.6 20.9 22 Current assets 699.9 731.6 732.3 833.6 23 Net fixed assets 332.1 332.5 384.3 347.9 24 Total assets 1032.0 1064.1 1116.6 1181.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 16.6 17.9 29 Current liabilities 35 9 42.7 43.2 47.3 30 Net worth 31 996.1 1021.4 1073.4 1134.2 32 Capital expenditure 22.0 38.8 88.1 4.5 75.0 33 Purchases 140.8 145.2 161.2 185.1 34 35 36 Inventory investment was valued at the lower of cost or market. The cost of inventory was determined by accumulating the costs 37 Other current assets included consigned inventory, prepaid expenses, and assets held for sale. 38 Net fixed assets included land, buildings and improvements, equipment, and software. 39 Purchases represented the annual amount paid to suppliers. Title Page | Exh 1 | Exh 2 Exh 3 + Ready 70% O Type here to search x E 8 1 0 6 7()) ENG 4:52 PM 9/21/2019