Horniman Horticulture

First, the projected cash flows range from $21.2 million in 2007 to $29.5 million in 2011 as shown in the data exhibit ‘DCF model.’ To generate these numbers Liedtke’s base case performance projections are used for the projected 2007 – 2011 net revenue numbers and the estimated depreciation and then his projections for Balance sheet accounts were used to determine the current net working capital and capital expenditure as in the exhibit ‘Financial statements.’ These projections were based by Liedtke under the following assumptions, women’s casual footwear would be wound down within one year and the historical corporate overhead-revenue ratio would conform to historical averages. These annual cash flows give us a PV (Cash flows) of $96.15 million over the next 5 years.

The company’s increase in inventory (illustrated on the statement of cash flows) rose after 1970 and culminated by a drastic increase in 1973. This increase in inventory (especially in 1973) appears to be heavily financed by short-term and long-term borrowing rather than the typical accounts payable. This is a bit unusual and in 1973 (when they acquired the greatest amount of debt equity, their accounts payable decreased. Their sales were not sufficient to offset the large outflows of inventory related costs. Furthermore, Grant’s decentralization was also a cause of their financial woes because rather than corporately controlling credit extension and credit terms, they allowed each store manager to set their own policies (and manipulate them as they desired). This disastrous policy imploded in 1975 when the company had to make a $155.7 million provision for bad debt expense. So not only did the company have substantial debt and bad debt to equity ratios, they were forced to write off about 8.8% of their total sales from 1975.

The company have generated very low operating cash flows, which is caused by a negative net income(16, 55) in 94,95, again with sales going down and cost of goods sold increasing. The company current ratio (2.3, 2.1, 2.5) in 93, 94, 95 are indicating satisfactory but when analyze quick ratio (1.1, 1.1, 1.3), and we also know that sales are down which mean more inventories. Now the account payable days has been increasing (49, 62, and 66). They have been delaying there payment which mean more cash on

One of the main reasons for this negative cash balance may be that Hampton is experiencing liquidity problems, that is, they are not generating enough cash to pay for their current expenses. Another factor that may contribute to such phenomenon is the delays in production that Hampton has had because suppliers have not delivered the raw materials. The inventory conversion period is greater than what Hampton can finance because the cash conversion cycle is even greater than collections from customers.

In addition, as we are comparing the profit margin and operating profit margin, we notice that interest expense, from 2006 to 2010, consumed a relative small portion of sales proceeds comparing to 2011. In 2011, the profit margin for HH is -1.46% and the operating profit margin for HH is -0.74%. Since profit margin includes interest expense in the calculation while operating profit margin does not, we can conclude that HH has about the same amount in interest expense as the amount of operating loss before interest. This finally doubles the amount of company’s loss at the end of the cycle. This big amount of interest expense leads us to study HH’s leverage ratios.

Although the company seems to be profitable, it has faced shortage of cash. It happened due to increase in Accounts Receivable as well as Inventories. On the other hand, Accounts Payable does not increase that rapidly and difficulties regarding cash collection become evident. Furthermore, the cash collection cycle becomes larger (59 days in year 2003, while more than 70 in year 2006).

Because they have faced cash shortage trouble. Their profitability has grown for 1993 ~ 1995 period, as we can see from their I/S (e.g. Sales and Net Income, etc.). However, as its business size grows, their A/R increased, which means that it is getting difficult to collect cash. On the other hand, A/P decreased for the same period, which means that the company paid cash for A/P, resulting in critical cash shortage. Furthermore, the A/P payment period is shorter than A/R collection periods, the company’s cash problem happens to be accelerated.

First of which, is the current ratio. It has been rapidly declining since 2000. To me this indicates that there is a liquidity issue. Each year their trade debt increase exceeds the increase of net income for the company. As a result, the working capital has taken a nosedive from $58,650 in 2002 to only $5,466 in 2003.

However, in 2009 revenues declined to $4.5 million along with net cash flows from all activities declining in 2009 as well. Overall capital expenditures for the company have been continually increasing by 26% each year. Milton had planned on borrowing $20 million in the fourth quarter of 2010 from

As shown in the ratios chart, working capital has increased by $13M. Maturities of short-term investments and cash flow from operations are projected to be sufficient to sustain the company’s overall financing needs, including capital expenditures. The following corporate strategic plan identifies a project that needs financial backing.

Moving onto the income statement portion of the common-size financial statements, an increase in cash and equivalents (3.20% of total assets in 1997 to 5.97% in 2001) and receivables (2.69% of total assets in 1997 to 3.22% in 2001) coupled with a decrease in inventory signify Costco’s improving efficiency over this five year period. It is important to mention two points. First, the decrease in inventory as a percentage of total assets from 30.8% in 1997 to 27.14% in 2001 signifies an increase in the turnover rate, perhaps due to

The statement of cash flows outlines some of the changes to the capital structure. The company added $164.5 million in a consolidated loan facility, and it paid out $138.1 million in dividends. There were no share buybacks during the year. The company states in the annual report (p.4) that it intends to maintain a conservative gearing ratio. The company in this section attributes its increased borrowings to projects and opportunities on which it has embarked. These investments lie within the integrated retail, franchise and property system. One of the

Jones over forecasts his inventory and has a low inventory turnover ratio. This drastically increases his accounts payable, as he isn’t able to pay due to low cash inflow. His account’s payable increased by nearly 9 percent in 2006. Nearly half of his current assets are in inventory. Also Jones isn’t able to take advantage of the cash discounts offered by his suppliers due to his slow cash collection process. In order to perform well, the company must improve its inventory system and its cash collection policies.

The company’s day-to-day operations did not change significantly over the last few years. Average collection period, inventory turnover, accounts payable, accounts receivable as well as cash conversion cycle all went up and down over the last four years but mainly stayed in the same range. So, there is no any significant change in operations. Mr. Cartwright has a very sound control over operations of the firm. Therefore, I believe, the company needs few more years to recover from the debts

Information gathered from Costco’s balance sheet show that it has steadily grew a larger cash reserve. It has a higher rate of outstanding receivables and has sharply increased the rate of inventory kept in stock from 16% in 1997 to 27% in 2001. Another interesting fact to notice is the high increase in property, plants, and equipment increase in proportion to assets, from 31% in 1997 to 58% in 2001. Costco has a much higher ratio of accounts payable in 2001 compared to 1997, which can be explained by the many investments and purchases of property, land, and plans. The amount of short-term liabilities to assets has more than doubled, from 20% to 41%. This may be a troublesome trend if it continues since they