29 Jan 2010
Sample Essay: COMPASS GROUP PLC
Part A: Forecast the financial statements
a) Discuss issues to consider when preparing projected financial statements (10 marks)
One of the major issues that the Compass group has to deal with is the currency exchange rates they have to deal with when reporting their consolidated financial statements. The company is currently using a fixed rate to be used as basis for the computation of the whole fiscal year. In order to shield to company from devastating currency losses, they have already engaged in currency swaps to protect the company’s interests.
There were also the exceptional items that happened several times throughout the last five years that the company has experienced. They are going to affect the financial analysis we have of the company’s previous performance as well as future prospects. This is the reason why the exceptional items are not included as part of the figures found in the financial statement. The items considered to be of exceptional nature were the sale of company’s assets as well as investing in new facilities of considerable amounts.
There are also different account principles being used by the company’s numerous subsidiaries throughout the world. The differences in the accounting rules are nevertheless reflected in the consolidated financial statements.
b) Forecast the consolidated income statement and the consolidated balance sheet for the year to 30 sep 2009 (40 marks)
Here are the forecasted financial statements of the company. The sales growth revenue percentage was determine first to be used as the basis for the computation of the rest of the items in the balance sheet.
| Income Statement | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Sales | 11,633 | 22,485 | 10,073 | 10,267 | 5,589 | 4653.2 |
| COGS | -11,029 | -22,034 | -9,475 | -9,636 | -4,973 | -4,412 |
| Tax Expense | -112 | -100 | -101 | -121 | -152 | -112 |
| Net Income | 492 | 351 | 497 | 510 | 464 | 130 |
| In Percentage | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Sales | 100 | 193 | 87 | 88 | 48 | 40 |
| COGS | 100 | 200 | 86 | 87 | 45 | 40 |
| Tax Expense | 100 | 89 | 90 | 108 | 136 | 100 |
| Net Income | 100 | 71 | 101 | 104 | 94 | |
The base year used was the year 2004 for calculations. Instead of growth rate, the company is expected to actually post a reduction in their sales. This is realistic since the current economy is already a dire situation plus the fact that the company has already been showing a reduction in their growth rates in the previous years. The first table above expresses the figures in actual numbers while the one below is shown in terms of the percentage that they are expected to be in the year 2009.
Note: The net income was taken from the net operating cash flow. The tax expense was taken from the balance sheet. The COGS was calculated by deduction as well as the net income. All other individual expenses were summarized in the COGS figure for simplicity.
The following figures are also forecast figures in the year 2009. The most conservative figures were chosen in order to reflect reality best in the dire economic situation that the rest of the world is in right now.
| Forecast operating expenses | ||||||
| Sales | 11,633 | 22,485 | 10,073 | 10,267 | 5,589 | |
| Expense Margins | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 |
| Cost of Goods Sold | -94.8079 | -97.9942 | -94.0633 | -93.8541 | -88.9784 | -85 |
| R&D expense | 0 | 0 | 0 | 0 | 0 | 0 |
| Selling, admin expense | 1.203473 | 0.622637 | 1.508984 | 1.383072 | 3.667919 | 4 |
| Non-operating income(loss) | 0.171925 | 0.088948 | 0.198551 | 0.194799 | 0.357846 | 0.4 |
| Forecast Balance Sheet operating | ||||||
| Assets & Liabilities | ||||||
| Operating asset/liability | ||||||
| utilization (% of sales) | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 |
| operating cash/sales | 6.318233 | 1.561041 | 7.485357 | 7.334177 | 12.45303 | 10 |
| Accounts receivables/sales | 10.31548 | 7.560596 | 14.1368 | 13.08074 | 27.3752 | 20 |
| Inventory/sales | 0 | 0 | 2.104636 | 1.74345 | 3.524781 | 3 |
| Other current assets/sales | 0 | 10.22904 | 22.74397 | 21.36944 | 34.8005 | 32 |
| Property, gross/sales | 15.5162 | 6.893485 | 7.505212 | 5.610207 | 10.73537 | 10 |
| Other assets/sales | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts payable/sales | 0 | 0 | 19.75578 | 17.85332 | 3.023797 | 3 |
| Other current liabilities/sales | 0 | 0 | 0 | 0 | 0 | 0 |
| Other liabilities/sales | 0 | 0 | 0 | 0 | 0 | 0 |
| Forecast Depreciation | ||||||
| & Tax Expense | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Depreciation expense/cost | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 |
| Tax Expense/pre-tax Earnings | 33.3 | 34 | 34 | 34 | 34 | 34 |
| Forecast Company’s Financial | ||||||
| Structure | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Debt/assets | 0.077914 | 0.726307 | 0.682679 | 0.662624 | 0.69169 | 0.7 |
| current portion of | 0.049791 | 0 | 0.076198 | 0.07521 | 0.052482 | 0.05 |
| long-term debt/debt | ||||||
| Interest rate/begin’g debt | 12 | 14 | 14 | 14 | 14 | 14 |
| Dividends | 0 | 213 | 213 | 135 | 270 | 270 |
The following ratios were computed using the following set of data. They are derived from the balance sheet. The rest are assumed where needed.
| Total Liabilities | 472 | 10729 | 4974 | 4262 | 4478 |
| Total Assets | 6058 | 14772 | 7286 | 6432 | 6474 |
| Debt/assets | 0.077914 | 0.726307 | 0.682679 | 0.662624 | 0.69169 |
| Long term debt | 2,872 | 5,310 | 2,441 | 2,021 | 2,115 |
| Current portion | 143 | 0 | 186 | 152 | 111 |
| Long term debt/debt | 2872 | 5310 | 2441 | 2021 | 2115 |
| Ratio results | 0.049791 | 0 | 0.076198 | 0.07521 | 0.052482 |
The figures in pink are the ones that are forecasted to happen in the year 2009. The growth rate of the sales revenue was also used as the basis for the computation of the operating expenses. The rest of the items in the balance sheet are forecasted using the biggest possible expense or the lowest possible income. This is the manner by which the forecast is believed to be approximate to what the reality will hold since the economic situation is already dire. All percentages shown can then be used to derive the actual balance sheet items. They are not shown here as they are already part of the data computed in the cash flow analysis of the company to derive the amount needed for extra funding by other means.
Those figures that are expressed as percentage in relation to sales have been computed using a set of relevant data. There are some of them that are assumed to be the closest and most reasonable given the data by the company. The ratios expressed are naturally derived from the division of the indicated items directly.
| Retained Earnings | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | ||
| Beginning Retained earnings | 0 | 482 | 823 | 1310 | 1810 | 2264 | ||
| plus Net income | 492 | 351 | 497 | 510 | 464 | 130 | ||
| minus Dividends | -10 | -10 | -10 | -10 | -10 | -10 | ||
| equals ending retained | 482 | 823 | 1310 | 1810 | 2264 | 2384 | ||
| earnings | ||||||||
From the forecasted financial data above, the following computation is done to arrive at the retained earnings of the company up to the forecasted year. The needed funding can then be ascertained from the above information. The amount needed to be borrowed is also determined by this analysis. The cash flow of the company can now be derived from the previous data to determine the future amount needed. Here is the derivation of the projected cash flow statements.
| Cash Flow Statement | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Net Income | 492 | 351 | 497 | 510 | 464 | 129.6 |
| Accounts receivables | 1200 | 1700 | 1424 | 1343 | 1530 | 1117.8 |
| Depreciation | -756.145 | -1461.53 | -654.745 | -667.355 | -363.285 | -302.458 |
| Cash from operations | 935.855 | 589.475 | 1266.255 | 1185.645 | 1630.715 | 944.942 |
| Cash from investing | -330 | -4201 | 1109 | 1109 | -416 | 0 |
| activities | ||||||
| Cash from financing | 141 | 3850 | -1032 | -1032 | -946 | -936 |
| activities | ||||||
| Net increase (decrease) | 746.855 | 238.475 | 1343.255 | 1262.645 | 268.715 | 8.942 |
| in cash | ||||||
The cashflow derived is very simplified but it nevertheless includes all the essence in detailing the cash needed by the company in the year 2009 as derived from the data in the forecasted balance statements. The cash in the investing portion is assumed to be zero since it is not prudent for the company to continue making investments in these dire economic times. The cash from financing activities decreased by 10 since that is the amount of dividends paid regularly. There are no more cash raised through getting more debts as this might compromise the company’s positions. The projection however will tell us the amount of cash the company needs to raise through whatever means. The company will have an expected deficit of 8.942 million. This was derived by 944.942 from cash in operations minus 936 from cash needed in financing activities.
The company either needs to raise some stocks or negotiate a revolving credit line with their bank partner. This figure will be the basis on whether the public still has the appetite for buying bonds or stocks to this amount. This is also the amount that the bank has to consider whether the company still has the capability to pay despite the present economic conditions.
Part B: Write a report to the management of the compass group plc analyzing the predicted financial position and performance of the company and comment on the company’s financial strategy (50 marks)
The following financial statements are arranged to show the previous financial performance of the company as well as their future prospects. From the data displayed below, we can infer the right kind of strategy that the company needs to have in order to prosper in the future.
| Consolidated Income Statement | |||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Continuing operations: | |||||
| Revenue | 11,633 | 22,485 | 10,073 | 10,267 | 5,589 |
| Operating Costs | -11,276 | -21,955 | -9,685 | -9,812 | -5,269 |
| Operating profit | 357 | 530 | 388 | 455 | 320 |
| Share of profit of associates | 2 | 2 | |||
| Total operating profit | 357 | 530 | 388 | 457 | 322 |
| Finance income | 4 | 4 | 4 | 15 | 16 |
| Finance costs | -156 | -156 | -156 | -160 | -49 |
| Hedge accounting ineffectiveness | -3 | -3 | -3 | 11 | -8 |
| Profit before tax | 202 | 375 | 233 | 323 | 281 |
| Income tax expense | -97 | -97 | -97 | -61 | -81 |
| Profit for the year from continuing operations | 105 | 278 | 136 | 262 | 200 |
| Discontinued operations: | |||||
| Profit/(loss) for the yr from discontinued operations | 73 | 73 | 73 | 33 | 16 |
| Profit for the year | 178 | 351 | 209 | 295 | 216 |
| Attributable to: | |||||
| Equity shareholders of the Company | 195 | 195 | 195 | 285 | 213 |
| Minority interest | 14 | 14 | 14 | 10 | 3 |
| 209 | 209 | 209 | 295 | 216 | |
| Basic earnings per share | |||||
| From continuing operations | 5.7 | 5.7 | 5.7 | 11.7 | 10.4 |
| From discontinued operations | 3.3 | 3.3 | 3.3 | 1.6 | 0.9 |
| From continuing and discontinued operations | 9 | 9 | 9 | 13.3 | 11.3 |
| Diluted earnings per share | |||||
| From continuing operations | 5.7 | 5.7 | 5.7 | 11.7 | 10.4 |
| From discontinued operations | 3.3 | 3.3 | 3.3 | 1.6 | 0.8 |
| From continuing and discontinued operations | 9 | 9 | 9 | 13.3 | 11.2 |
| The year 2004, 2005 have no identical formats used in | |||||
| the reports for year 2006 and 2007 | |||||
| the year 2008 only has the interim report and not | |||||
| the full fiscal year report; figures are to be doubled if you want to make an analysis | |||||
| The year 2005 has only dollars for the figures | |||||
This is the income statement that will be used as basis for later analysis.
| Consolidated Balance Sheets | |||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Non Current Assets | |||||
| Goodwill | 3,451 | 2,985 | 3,147 | ||
| Other intangible assets | 4,223 | 7,024 | 152 | 142 | 205 |
| Property, plant equipment | 1,805 | 3,145 | 756 | 576 | 600 |
| Interests in associates | 30 | 90 | 39 | 25 | 25 |
| Other investments | 9 | 12 | 13 | ||
| Deferred tax assets | 237 | 240 | 79 | ||
| Trade and other receivables | 117 | 66 | 244 | ||
| Derivative financial instruments | 22 | 13 | 19 | ||
| Non-current assets | 6,058 | 10,259 | 4,783 | 4,059 | 4,332 |
| Current assets | |||||
| Inventories | 212 | 179 | 197 | ||
| Trade and other receivables | 3,484 | 1,424 | 1,343 | 1,530 | |
| Tax recoverable | 10 | 10 | 14 | ||
| Derivative financial instruments | 466 | 9 | 2 | 400 | |
| Cash and cash equivalents | 563 | 848 | 839 | 1 | |
| Current assets | 4513 | 2503 | 2373 | 2142 | |
| Total Assets | 6,058 | 14,772 | 7,286 | 6,432 | 6,474 |
| Current liabilities | |||||
| Short-term borrowings | 5,419 | -119 | -151 | -111 | |
| Derivative financial instruments | -2 | -8 | |||
| Current tax liabilities | -357 | -171 | -92 | ||
| Trade and other payables | -1,990 | -1,833 | -169 | ||
| Provisions | -65 | -86 | -1,983 | ||
| Current liabilities | 0 | 5419 | -2533 | -2241 | -2363 |
| Non-current liabilities | |||||
| Long-term borrowings | 2,872 | -5,310 | 1,835 | -1,452 | -1,509 |
| Derivative financial instruments | -18 | -15 | -2 | ||
| Post-employment benefit obligations | -282 | -162 | -177 | ||
| Provisions | -242 | -351 | -372 | ||
| Deferred tax liabilities | -18 | -5 | -23 | ||
| Other payables | -46 | -36 | -32 | ||
| Non-current liabilities | 2,872 | -5,310 | -2,441 | -2,021 | -2,115 |
| Total Liabilities | -472 | -10,729 | -4,974 | -4,262 | -4,478 |
| Net Assets | 5,586 | 4,043 | 2,312 | 2,170 | 1,996 |
| Equity | |||||
| Share capital | 9 | 382 | 210 | 193 | 185 |
| Share premium account | 93 | 166 | 96 | 122 | 144 |
| Capital redemption reserve | 216 | 16 | 15 | 33 | 42 |
| Less: own shares | -1 | -2 | 0 | -1 | -4 |
| Other reserves | 4,170 | 7,381 | 4,288 | 4,312 | 4,342 |
| Retained earnings | -2,005 | -3,900 | -2,303 | -2,511 | -2,729 |
| Total equity shareholder’s funds | 2482 | 4043 | 2306 | 2148 | 1980 |
| Minority interests | -54 | 6 | 22 | 16 | |
| Total Equity | 5,586 | 4,043 | 2,312 | 2,170 | 1,996 |
This is the balance sheet statement that will be used as the basis for later analysis.
| Consolidated Cash Flow | ||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2008 | |
| Cash generated from operations | 735 | 351 | 754 | 753 | 348 | 696 |
| Interest paid | -134 | -186 | -152 | -47 | -94 | |
| Interest element of finance lease rentals | -2 | -3 | -3 | -1 | -2 | |
| Tax received | 5 | 4 | 4 | 6 | 12 | |
| Tax paid | -112 | -101 | -121 | -76 | -152 | |
| Net cash optng/continued ops | 492 | 351 | 468 | 481 | 230 | 460 |
| Net cash optng/discontinued ops | 29 | 29 | 2 | 4 | ||
| Net cash from operating activities | 492 | 351 | 497 | 510 | 232 | 464 |
| Cash flow from investing activities | ||||||
| Purchase of subs/investments | -81 | -167 | -167 | -146 | -292 | |
| Proceeds from sale of investments | 1,807 | 1,807 | -10 | -20 | ||
| Contribution to pension plans | -280 | -280 | 0 | |||
| Purchase of physical assets | -4,201 | -206 | -206 | 0 | ||
| Proceeds of physical assets | 27 | 27 | -5 | -10 | ||
| Purchase of intangible assets | -249 | -30 | -30 | 0 | ||
| Dividends/assoctd undrtkngs | 2 | 2 | -65 | -130 | ||
| Interest received | 15 | 15 | 18 | 36 | ||
| Net cash from/continuin oprtns | -330 | -4201 | 1168 | 1168 | -208 | -416 |
| Net cash used in discontinued oprtns | -59 | -59 | 0 | |||
| Net cash from investing activities | -330 | -4,201 | 1,109 | 1,109 | -208 | -416 |
| Cash flow from financing activities | 0 | |||||
| Issue of ordinary share capital | 141 | 3,850 | 2 | 2 | 22 | 44 |
| Pruchase of own shares (net) | -148 | -148 | -290 | -580 | ||
| Net decrease in borrowings | -647 | -647 | -61 | -122 | ||
| Repayment of leases | -15 | -15 | -6 | -12 | ||
| Equity dividends paid | -213 | -213 | -135 | -270 | ||
| Dividends paid to minority interests | -11 | -11 | -3 | -6 | ||
| Net cash used continuing ops | 141 | 3850 | -1032 | -1032 | -473 | -946 |
| Net cash used discontinued ops | 0 | |||||
| Net cash/financing activities | 141 | 3850 | -1032 | -1032 | -473 | -946 |
| Net increase in cash and cash equivalents | 57 | 574 | 574 | -449 | -898 | |
| Cash/beginning of the year | 281 | 281 | 839 | 1678 | ||
| Exchange gains/losses on cash | -7 | -7 | 10 | 20 | ||
| Cash/ year’s end | 57 | 563 | 848 | 848 | 400 | 800 |
This is the consolidated Cash Flow to be used as basis for later analysis.
The second 2008 figures are simply multiplied by 2 from the previous one since the company’s reports only includes six months figures. It is presumed that this will be the closest approximation of the financial performance of the company for the whole 2008 itself.
The following are the common size trends and time trends of the company. They will indicate the past performance as well as give us a clue as how the company will be faring in the future.
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Non Current Assets | |||||
| Goodwill | 0 | 0 | 47.36481 | 46.40858 | 48.60982 |
| Other intangible assets | 69.70948 | 47.54942 | 2.086193 | 2.207711 | 3.166512 |
| Property, plant equipment | 29.79531 | 21.29028 | 10.37606 | 8.955224 | 9.267841 |
| Interests in associates | 0.495213 | 0.609261 | 0.535273 | 0.388682 | 0.38616 |
| Other investments | 0 | 0 | 0.123525 | 0.186567 | 0.200803 |
| Deferred tax assets | 0 | 0 | 3.252814 | 3.731343 | 1.220266 |
| Trade and other receivables | 0 | 0 | 1.605819 | 1.026119 | 3.768922 |
| Derivative financial instruments | 0 | 0 | 0.301949 | 0.202114 | 0.293482 |
| Non-current assets | 100 | 69.44896 | 65.64645 | 63.10634 | 66.91381 |
| Current assets | 0 | 0 | 0 | 0 | 0 |
| Inventories | 0 | 0 | 2.90969 | 2.78296 | 3.042941 |
| Trade and other receivables | 0 | 23.58516 | 19.54433 | 20.87998 | 23.63299 |
| Tax recoverable | 0 | 0 | 0.13725 | 0.155473 | 0.21625 |
| Derivative financial instruments | 0 | 3.154617 | 0.123525 | 0.031095 | 6.17856 |
| Cash and cash equivalents | 0 | 3.811265 | 11.63876 | 13.04415 | 0.015446 |
| Current assets | 0 | 30.55104 | 34.35355 | 36.89366 | 33.08619 |
| Total Assets | 100 | 100 | 100 | 100 | 100 |
This is the common size analysis of the balance sheet. It is focusing on the assets with total assets used as basis for 100%. The rest are reflected according to their relative size.
We can see immediately that the company had a lot of significant intangible assets in the years 2004-2005 but drastically reduced in the following years. The drop is very sharp as you can see ranging from 69% to a sudden 2% in 2006. This must have meant a lot of conservative financing for the company later. The most interesting part is the 2004 which does not have any cash in their account except for the value of their physical properties, plant and equipments. The cash holdings of the company increased to a more comfortable level at the range of 30-33% after the year 2004.The current assets basically did not change drastically for four consecutive years.
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Non Current Assets | |||||
| Goodwill | 100 | 86.49667 | 91.19096 | ||
| Other intangible assets | 100 | 166.3273 | 3.599337 | 3.362538 | 4.854369 |
| Property, plant equipment | 100 | 174.2382 | 41.88366 | 31.91136 | 33.241 |
| Interests in associates | 100 | 300 | 130 | 83.33333 | 83.33333 |
| Other investments | 100 | 133.3333 | 144.4444 | ||
| Deferred tax assets | 100 | 101.2658 | 33.33333 | ||
| Trade and other receivables | 100 | 56.41026 | 208.547 | ||
| Derivative financial instruments | 100 | 59.09091 | 86.36364 | ||
| Non-current assets | 100 | 169.3463 | 78.95345 | 67.00231 | 71.50875 |
| Current assets | |||||
| Inventories | 100 | 84.43396 | 92.92453 | ||
| Trade and other receivables | 100 | 40.87256 | 38.54765 | 43.91504 | |
| Tax recoverable | 100 | 100 | 140 | ||
| Derivative financial instruments | 100 | 1.93133 | 0.429185 | 85.83691 | |
| Cash and cash equivalents | 100 | 150.6217 | 149.0231 | 0.17762 | |
| Current assets | 100 | 55.462 | 52.58143 | 47.46288 | |
| Total Assets | 100 | 243.8429 | 120.2707 | 106.1737 | 106.867 |
This is the time trend analysis of the company’s assets. We can clearly see that the intangible assets of the company have dropped dramatically from the time of 2005. This can be seen already in the common size analysis but the time trend also confirms it. Aside from the year 2005, the year 2006 still has a considerable amount of assets as compared to the rest of the succeeding years after it. The asset size decreased from 120% to a sudden 106 % only in comparison relative to the year 2005 as basis. The years 2007 and 2008 have a fairly stable amount of assets indicating stable performances. On a more detailed analysis, the tangible investments of the company increased in 2007 and 2008. Their intangible investments are left alone as this does not have a marked effect on the company’s performance. The receivables of 2008 on the other suddenly went double that of the year 2006 indicating the increase of credit given to customers and an increase in sales.
| Common Size Trend Analysis For Liabilities and Equities | |||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Current liabilities | |||||
| Short-term borrowings | 0 | 134.0341 | 4.009434 | 6.696231 | 4.493927 |
| Derivative financial instruments | 0 | 0 | 0.067385 | 0 | 0.323887 |
| Current tax liabilities | 0 | 0 | 12.0283 | 7.583149 | 3.724696 |
| Trade and other payables | 0 | 0 | 67.04852 | 81.28603 | 6.842105 |
| Provisions | 0 | 0 | 2.190027 | 3.813747 | 80.2834 |
| Current liabilities | 0 | 134.0341 | 85.34367 | 99.37916 | 95.66802 |
| Non-current liabilities | |||||
| Long-term borrowings | 187.4674 | -131.338 | -61.8261 | 64.39024 | 61.09312 |
| Derivative financial instruments | 0 | 0 | 0.606469 | 0.665188 | 0.080972 |
| Post-employment benefit obligations | 0 | 0 | 9.501348 | 7.184035 | 7.165992 |
| Provisions | 0 | 0 | 8.153639 | 15.56541 | 15.06073 |
| Deferred tax liabilities | 0 | 0 | 0.606469 | 0.221729 | 0.931174 |
| Other payables | 0 | 0 | 1.549865 | 1.596452 | 1.295547 |
| Non-current liabilities | 187.4674 | -131.338 | 82.24394 | 89.62306 | 85.62753 |
| Total Liabilities | -30.8094 | -265.372 | 167.5876 | 189.0022 | 181.2955 |
| Net Assets | 100 | -215.78 | 100 | 100 | 100 |
| Equity | |||||
| Share capital | 0.587467 | 9.448429 | -7.07547 | -8.55876 | -7.48988 |
| Share premium account | 6.070496 | 4.105862 | -3.2345 | -5.4102 | -5.82996 |
| Capital redemption reserve | 14.09922 | 0.395746 | -0.50539 | -1.46341 | -1.7004 |
| Less: own shares | -0.06527 | -0.04947 | 0 | 0.044346 | 0.161943 |
| Other reserves | 272.1932 | 182.5625 | -144.474 | -191.22 | -175.789 |
| Retained earnings | -130.875 | -96.463 | 77.59434 | 111.3525 | 110.4858 |
| Total equity shareholder’s funds | 162.0104 | 100 | -77.6954 | -95.255 | -80.1619 |
| Minority interests | -3.5248 | 0 | -0.20216 | -0.97561 | -0.64777 |
| Total Equity | 100 | 100 | 100 | 100 | 100 |
This common size trend analysis was done using the equity as the basis for the computation.
The most obvious information you can get right away is the short term borrowings of the company in the year 2005. They are significantly huge since they have to practically start the company operating from scratch. It has since then dropped considerably to about 4-6 percent with the succeeding years. The same goes for long term borrowings. The company made a substantial borrowing in the year 2004 at the level of 187% compared to the 64% something that the company has since then maintained in the years 2007. This simply indicated that their previous investments have already been paid and that they have now stabilized the income for the company’s operations.
| Trend Analysis for Liabilities & Equities | |||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |
| Current liabilities | |||||
| Short-term borrowings | 0 | -4553.78 | 100 | 126.8908 | 93.27731 |
| Derivative financial instruments | 0 | 0 | 100 | 0 | 400 |
| Current tax liabilities | 0 | 0 | 100 | 47.89916 | 25.77031 |
| Trade and other payables | 0 | 0 | 100 | 92.11055 | 8.492462 |
| Provisions | 0 | 0 | 100 | 132.3077 | 3050.769 |
| Current liabilities | 0 | -213.936 | 100 | 88.47217 | 93.28859 |
| Non-current liabilities | |||||
| Long-term borrowings | 156.5123 | -289.373 | 100 | -79.1281 | -82.2343 |
| Derivative financial instruments | 0 | 0 | 100 | 83.33333 | 11.11111 |
| Post-employment benefit obligations | 0 | 0 | 100 | 57.44681 | 62.76596 |
| Provisions | 0 | 0 | 100 | 145.0413 | 153.719 |
| Deferred tax liabilities | 0 | 0 | 100 | 27.77778 | 127.7778 |
| Other payables | 0 | 0 | 100 | 78.26087 | 69.56522 |
| Non-current liabilities | -117.657 | 217.5338 | 100 | 82.79394 | 86.64482 |
| Total Liabilities | 9.489345 | 215.7016 | 100 | 85.68556 | 90.02815 |
| Net Assets | -51.6173 | 293.9353 | 100 | 75.97709 | 83.22102 |
| Equity | |||||
| Share capital | 4.285714 | 181.9048 | 100 | 91.90476 | 88.09524 |
| Share premium account | 96.875 | 172.9167 | 100 | 127.0833 | 150 |
| Capital redemption reserve | 1440 | 106.6667 | 100 | 220 | 280 |
| Less: own shares | |||||
| Other reserves | 97.24813 | 172.1315 | 100 | 100.5597 | 101.2593 |
| Retained earnings | 87.06036 | 169.3443 | 100 | 109.0317 | 118.4976 |
| Total equity shareholder’s funds | 107.6323 | 175.3252 | 100 | 93.14831 | 85.86297 |
| Minority interests | -900 | 0 | 100 | 366.6667 | 266.6667 |
| Total Equity | -51.6173 | -136.22 | 100 | 75.97709 | 83.22102 |
This time trend analysis used the year 2006 since it is the only one with a complete set of figures that are verifiable. The short term borrowings saw a small bump at the rate of 126% and then returned to state near that of 2006 in the form of 93%. This only meant that the company has encountered additional investment needs aside from the substantial amount that they have already borrowed in 2005. The operations have remained fairly stable after this. The equity of the company has also decreased noticeably from the year 2006 to around 75-83% only. This has either been because of stock issuance or the reduction in owner’s equity since the company has now shown to be fairly stable in its earnings.
The following financial ratios are computed and arranged by year to show the company’s financial position. This is also to gain an understanding of what will be the best strategy the company should take.
| Financial ratios | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | |
| Debt Ratio | 0.077914 | 0.726307 | 0.683365 | 0.662624 | 0.69169 | 0.660797 | |
| Debt to equity | 0.084497 | 2.653722 | 1.231511 | 1.964055 | 2.243487 | 2.143287 | |
| interest coverage | 52.5 | 2.34 | 2.309211 | 2.309211 | 2.468085 | 2.666667 | |
| Time interest earned | 5.485075 | 2.34 | 2.34 | 2.309211 | 2.468085 | 4.444444 | |
| Current ratio | 0.83281 | 1.781682 | 0.368937 | 0.906475 | 0.973636 | ||
| Quick Ratio | 0.83281 | 1.781682 | 0.368937 | 0.906475 | 0.973636 | ||
| Cash Ratio | 0.135634 | 0.29017 | 0.117071 | 0.318663 | 0.342273 | ||
| Receivables | |||||||
| Turn-over | |||||||
| fixed-assets | 0.401662 | 0.401662 | 0.401662 | 0.401662 | 0.401662 | 0.401662 | |
| Turn-over | |||||||
| Gross Profit | -14.2124 | -29.3917 | -12.069 | -12.291 | -5.85931 | -5.08552 | |
| Margin | |||||||
| Profit Margin | -14.5476 | -29.7269 | -12.4234 | -12.6262 | -6.17931 | -5.23724 | |
| Return on Assets | 0.081215 | 0.023761 | 0.033645 | 0.034525 | 0.071671 | 0.02 | |
| NOI | 492 | 351 | 497 | 510 | 464 | 128 | |
| CashFlow to | 0.081215 | 0.023761 | 0.033645 | 0.034525 | 0.071671 | 0.02 | |
| Total Assets | |||||||
| EPS | 0.260964 | 0.260964 | 0.445587 | 0.979968 | 1.225772 | 1.290742 | |
| P/E | 15 | 1191.737 | 697.955 | 317.3575 | 253.7178 | 240.9467 | |
| Dividends/Share | 0.005414 | 0.005414 | 0.005414 | 0.005414 | 0.005414 | 0.005414 | |
| Dividend Yield | 0.001741 | 0.001741 | 0.001741 | 0.001741 | 0.001741 | 0.001741 | |
| Dividend Pay-out | 0.020747 | 0.020747 | 0.012151 | 0.005525 | 0.004417 | 0.004195 | |
The most striking information that you can get in the financial ratios is the profit margin of the company. The company has already been in the negative zone when it comes to their profit margin. This was because of a substantial investment in the years 2004-2005. It did become gradually smaller as the years passed by but it is still negative in the year 2009. The company has to be careful with their finances if they want to survive the current depression affecting the whole world. Another indicator of poor performance is the return on assets by the company. They had never been able to post a rate of above 10%. The returns on the assets are all within 2-8% only. This is very small indeed considering that the company has to make substantial investments in order to run the operation. The small margin in the food industry leaves very little room for mistake. Even the net operating income of the company has a very sharp reduction in their figures in the year 2009. It is almost smaller by four times literally. Even if the company does not take into account the year 2009, the previous years are still showing a decrease in the NOI.
Another danger sing is the debt to equity ratio of the company. It has risen recently from an insignificant 08 to 2.0 level. This only means that the company is in dangerous grounds.
The rest of the other ratios like the current ratio and the cash ratios have remained more or less stable. These are only due to the varying conditions that a business can normally encounter. The rest of the details are better indicators of the company’s performance.
Naturally, there are no receivable ratios since the company sells the food on a cash basis. There are no items sold on credit. This is one thing that is advantageous for the company’s operation. It actually lessens the chances of being short on cash on their daily operation. In a long term sense, the company is also far away from danger since they don’t have to contend with the long waiting time needed to make use of the sale they had commenced. The company does not have to wait for the cash to be cleared in their names. The time trend and the commons size analysis confirm this also. The company has already made a substantial investment at the start. They are only slowly starting to regain their investments. This is no time to be extravagant.
The strategy that the company has to take this time is one of a very conservative and prudent type of actions. There should be no additional investments. The debt should be paid as little as possible to conserve cash. All expenses should be reduced. There should be no credit extended to customers as this might compromise the company’s own cash reserves. Considering there are numerous signs for danger to the company in combination with the adversarial economic conditions right now, the company should stay away from all kinds of speculative actions. There should be no expansion of the company’s operation whatsoever. If possible, the company should wait again until they have cleared all debts before thinking of expanding again. This is to ensure that the company will survive despite tough economic times.