Hello everyone,

I need help with written case analysis please.

I attached the case, excel worksheet, and please follow the suggest format written case analysis.

If there is any questions please let me know.

\fThis spreadsheet supports STUDENT analysis of the case, "HORNIMAN HORTICULTURE Revised, August 18, 2006 Copyright (C) 2006, by the University of Virginia Darden School Foundation. Exhibit 1 HORNIMAN HORTICULTURE Projected Horniman Horticulture Financial Summary (in thousands of dollars) 2002 2003 2004 2005 788.5 402.9 385.6 301.2 34.2 50.2 17.6 32.6 807.6 428.8 378.8 302.0 38.4 38.4 13.1 25.3 908.2 437.7 470.5 356.0 36.3 78.2 26.2 52.0 1048.8 503.4 545.4 404.5 40.9 100.0 39.2 60.8 120.1 90.6 468.3 20.9 699.9 332.1 1032.0 105.2 99.5 507.6 19.3 731.6 332.5 1064.1 66.8 119.5 523.4 22.6 732.3 384.3 1116.6 9.4 146.4 656.9 20.9 833.6 347.9 1181.5 Accounts payable Wages payable Other payables Current liabilities Net worth 6.0 19.7 10.2 35.9 996.1 5.3 22.0 15.4 42.7 1021.4 4.5 22.1 16.6 43.2 1073.4 5.0 24.4 17.9 47.3 1134.2 Capital expenditure Purchases 22.0 140.8 38.8 145.2 88.1 161.2 4.5 185.1 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 Exhibit 2 HORNIMAN HORTICULTURE Financial Ratio Analysis and Benchmarking 2002 Revenue growth Gross margin (Gross profit / Revenue) Operating margin (Op. profit / Revenue) Net profit margin (Net profit / Revenue) 2003 2004 2005 2.9% 2.4% 12.5% 15.5% 48.9% 46.9% 51.8% 52.0% 6.4% 4.8% 8.6% 9.5% 4.1% 3.1% 5.7% 5.8% Benchmark1 -1.8% 48.9% 7.6% 2.8% Return on assets (Net profit / Total assets) Return on capital (Net profit / Total capital 3.2% 3.3% 2.4% 2.5% 4.7% 4.8% 5.1% 5.4% 2.9% 4.0% Receivable days (AR / Revenue * 365) Inventory days (Inventory / COGS * 365) Payable days (AP / Purchases * 365) NFA turnover (Revenue / NFA) 41.9 424.2 15.6 2.4 45.0 432.1 13.3 2.4 48.0 436.5 10.2 2.4 50.9 476.3 9.9 3.0 21.8 386.3 26.9 2.7 1 Benchmark figures are based on 2004 financial ratios of publicly traded horticulture producers. Suggested Format for Written Case Analysis * This is a suggestednot requiredformat. You can find rich information on desirable formats for WCA by searching for, for example, \"how to write a case analysis.\" No matter what format you choose, your WCA should have sufficient contents with an organized structure. In other words, WCA is a \"formal\" write-up. [Objectives] The purpose of the written case analysis of a case situation is: 1. To test your ability to view a financial management situation in terms of the concepts we have studied. 2. To test your ability to apply the knowledge you have acquired to specific situation. 3. To test your ability to present your ideas and opinions in a well thought out, organized, and readable form. 4. To test your ability to identify managerial approaches and analytical tools that are most appropriate for a given situation. [Format] Many organizations specify a format for reports and memos. Your written case analysis is encouraged to follow the following format: Part 1. Statement of the problem(s) This section should present a brief statement of the major problem(s) in the case you have identified written in a sentence form and not a question. Some questions to ask when formulating your statement of the problem(s) are: 1. Have you identified the basic problem(s) or am I dealing with the symptoms? 2. If I have identified more than one problem, are they separated or related? 3. Am I putting myself in the manager's shoes and looking forward to future actions? You provide relevant facts about the situation, related industry, or economy and establish reasonable assumptions in order for your analytical tools to be justified if necessary. Part 2. Analysis You provide analysis using your knowledge from previous courses taken in order to support your recommendations and conclusions. Do sufficient analysis to reach and support your conclusions and recommendations. Do not use case-end questions item by item for your analysis (Keep relevance and consistency). Do not restrict your analysis to these case-end questions. Do analysis relevant to Part 1. Be clear and concise (organize your writing well; It would be not fun for me to read just lengthy, sloppy. Part 3. Concluding Remarks and Recommendations You briefly summarize Parts 1 and 2 and conclude with suggested remedies. # If you are deemed to go the extra mile on any assignment in this class, you will be rewarded extra points #