Question
In late 2012, Bob Brown and his wife Maggie bought Horniman Horticulture from Maggies father, who was retiring. Browns purchased the business for $999,000. Horniman
In late 2012, Bob Brown and his wife Maggie bought Horniman Horticulture from Maggies father, who was retiring. Browns purchased the business for $999,000.
Horniman Horticulture was a well-established wholesale nursery serving retailers up and down the east coast. The nurserys operations filled 52 greenhouse and 40 acres of productive fields and employed 12 full-time and 15 seasonal employees. Bob was a people person and had expanded Hornimans customer base with his style. Over the last year, Horniman had experienced a noticeable increase in business from small nurseries. Since taking over, Bob had increased the number of plant species grown at the. Nursery by more than 40%. Because the cost of carrying inventory was particularly burdensome for those customers, Bob had made loosened the companys credit terms. This had been accompanied by substantial increases in sales. Bob was confident that the nurserys overall prospects were robust.
Maggie kept a tight rein on costs. The effect on the businesss profits was obvious, as its profit margin had increased since the couple took over. She was pleased with the rising sales and increasing margins but was concerned about the recent decline in the firms cash balance to below $10,000. Such a cash level was well under her operating target of 8% of annual revenue.
Maggie had shown determination to maintain financial responsibility by avoiding bank borrowing and by paying suppliers early enough to obtain any trade discounts. (Most of Hornimans suppliers provided 30-day terms with a 2% discount for payments received within 10 days.). Maggie had been raised to be financially conservative and was very averse to debt. Her aversion stemmed from her concerned about inventory risk. She believed that interest payments might be impossible to meet if adverse weather wiped out their inventory.
Bob and Maggie were happy with the improvements the business had experienced. Some of thee gains were due to Bobs response to a growing demand for more mature plants. Nurseries were willing to pay premium prices for plants that delivered instant landscape, and Bob was increasingly shifting the product mix to that line. Because much of the inventory took two to five years to mature to sell, his top-line expansion efforts had been in the works for some time but he expected this strategy to begin paying off as early as next year.
Given the ongoing strength of the economy,he expected 2016 to be a banner year with revenue hitting a record 30% growth. In addition, he hoped to ensure long-term-growth opportunities by purchasing a neighboring 12-acre parcel of farmland.
If the company acquired the additional property, Maggie expected 2016 capital expenditures to be $75,000. She was hoping not to have to finance the purchase with debt but had checked and found prevailing mortgage rates were 6.5%. If the new parcel was acquired, she figured next years depreciation expense to be $46,000.
Your assignment is to use the financial information provided to perform a financial analysis on Horniman Horticulture since Bob and Maggie took over in 2012 with special attention to how management decisions they have made have affected liquidity, profitability, operating cycle and financial stability.You will also want to prepare pro forma projections based on the couples plans.
AutoSave Off Horniman - Saved to this PC Table Tools TRAN QUYNH Nga VIETNAM 7 File Home Insert Design Layout References Mailings Review View Help Design Layout O Search Share Comments E AL X Cut LG Copy & Format Painter Calibri (Body) 12 AA Aar to to every BI U ab x, x* A A = AaBbCD AaBbCD AaBbci AaBbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste Dictate Sensitivity Clipboard Font Paragraph Styles Projected Horniman Horticulture Financial Summary (in thousands of dollars) Editing Voice Sensitivity 2012 2013 2014 2015 788.5 402.9 1048.8 503.4 Profit and loss statement Revenue Cost of goods sold Gross profit SG&A expense Depreciation Operating profit Taxes Net profit 807.6 428.8 378.8 302.0 38.4 545.4 404.5 385.6 301.2 34.2 50.2 17.6 32.6 908.2 437.7 470.5 356.0 36.3 782 26.2 52.0 38.4 13.1 40.9 100.0 39.2 60.8 25.3 Balance sheet Cash 120.1 90.6 468.3 20.9 105.2 99.5 507.6 19.3 66.8 119.5 523.4 22.6 Accounts receivable Inventory Other current assets Current assets Net fixed assets Total assets 9.4 146.4 656.9 20.9 833.6 347.9 1181.5 699.9 332.1 1032.0 731.6 332.5 1064.1 732.3 384.3 1116.6 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 4.5 22.1 16.6 5.0 24.4 17.9 47.3 11342 42.7 43.2 1021.4 1073.4 4.5 Capital expenditure Purchases 22.0 140.8 38.8 145.2 88.1 161.2 185.1 Page 3 of 4 C Focus + 80% 1003 words DX English (United States) Type here to search Pi E e W I ENG 7:38 PM 8/23/2020 AutoSave Off Horniman - Saved to this PC Table Tools TRAN QUYNH Nga VIETNAM 7 File Home Insert Design Layout References Mailings Review View Help Design Layout Search Share Comments Calibri (Body) 12 AA Aa to E 21 X Cut L Copy & Format Painter 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste BIUab x, xADA SE I Dictate Sensitivity Clipboard Font Paragraph Styles Editing Voice Sensitivity Comparable Companies Financial Ratio Benchmarking Benchmark Revenue growth Gross margin (Gross profit / Revenue) Operating margin (Op. profit / Revenue) Net profit margin (Net profit / Revenue) (18% 48.9% 7.6% 2.8% etum on assets (Net profit / Total assets) Return on capital (Net profit / Total capital) 4.0% Receivable days (AR/ Revenue * 365) Inventory days (Inventory / COGS * 365) Payable days (AP/ Purchases + 365) NFA turnover (Revenue/NFA) 21.8 386.3 26.9 2.7 Page 3 of 4 1003 words English (United States) C Focus le 80% Type here to search I ENG 7:39 PM 8/23/2020 AutoSave Off Horniman - Saved to this PC Table Tools TRAN QUYNH Nga VIETNAM 7 File Home Insert Design Layout References Mailings Review View Help Design Layout O Search Share Comments E AL X Cut LG Copy & Format Painter Calibri (Body) 12 AA Aar to to every BI U ab x, x* A A = AaBbCD AaBbCD AaBbci AaBbccc AaB 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste Dictate Sensitivity Clipboard Font Paragraph Styles Projected Horniman Horticulture Financial Summary (in thousands of dollars) Editing Voice Sensitivity 2012 2013 2014 2015 788.5 402.9 1048.8 503.4 Profit and loss statement Revenue Cost of goods sold Gross profit SG&A expense Depreciation Operating profit Taxes Net profit 807.6 428.8 378.8 302.0 38.4 545.4 404.5 385.6 301.2 34.2 50.2 17.6 32.6 908.2 437.7 470.5 356.0 36.3 782 26.2 52.0 38.4 13.1 40.9 100.0 39.2 60.8 25.3 Balance sheet Cash 120.1 90.6 468.3 20.9 105.2 99.5 507.6 19.3 66.8 119.5 523.4 22.6 Accounts receivable Inventory Other current assets Current assets Net fixed assets Total assets 9.4 146.4 656.9 20.9 833.6 347.9 1181.5 699.9 332.1 1032.0 731.6 332.5 1064.1 732.3 384.3 1116.6 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 4.5 22.1 16.6 5.0 24.4 17.9 47.3 11342 42.7 43.2 1021.4 1073.4 4.5 Capital expenditure Purchases 22.0 140.8 38.8 145.2 88.1 161.2 185.1 Page 3 of 4 C Focus + 80% 1003 words DX English (United States) Type here to search Pi E e W I ENG 7:38 PM 8/23/2020 AutoSave Off Horniman - Saved to this PC Table Tools TRAN QUYNH Nga VIETNAM 7 File Home Insert Design Layout References Mailings Review View Help Design Layout Search Share Comments Calibri (Body) 12 AA Aa to E 21 X Cut L Copy & Format Painter 1 Normal 1 No Spac... Heading 1 Heading 2 Title Find Replace Select Paste BIUab x, xADA SE I Dictate Sensitivity Clipboard Font Paragraph Styles Editing Voice Sensitivity Comparable Companies Financial Ratio Benchmarking Benchmark Revenue growth Gross margin (Gross profit / Revenue) Operating margin (Op. profit / Revenue) Net profit margin (Net profit / Revenue) (18% 48.9% 7.6% 2.8% etum on assets (Net profit / Total assets) Return on capital (Net profit / Total capital) 4.0% Receivable days (AR/ Revenue * 365) Inventory days (Inventory / COGS * 365) Payable days (AP/ Purchases + 365) NFA turnover (Revenue/NFA) 21.8 386.3 26.9 2.7 Page 3 of 4 1003 words English (United States) C Focus le 80% Type here to search I ENG 7:39 PM 8/23/2020Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started