Table of contentsExecutive summary.....................................................................................................4Introduction..................................................................................................................51. Financial ratio analysis............................................................................................52. Financial projections................................................................................................63. Breakeven analysis.................................................................................................74. Evaluation of main sources of financing..................................................................85. YYY’s options for debt or equity financing...............................................................9Conclusion.................................................................................................................10List of references.......................................................................................................11Appendix 1. Financial ratios.......................................................................................14Appendix 2. Financial projections..............................................................................19Appendix 3. Financial ratios (calculations).................................................................20
Executive summary
YYY Drinks PLC (hereafter YYY) was founded in 2005 and is a fast-growing company showing graduate growth based on the analysis of key financial indicators during the observed period of time (2014-2018 years). In order to make comprehensive analysis company’s financial performance in this report I will examine annual reports and financial statements for the last five years and make comparison to its peer group. The purpose of financing planning is to optimize processes and to improve the business. Proper financing planning will allow company to enhance own financial and operational policies and strategies. This business financing plan will evaluate company’s current economic position and will predict theoretical future income, the amount of assets and liabilities. Based on published reports (latest available report is for 2018) the company was not facing any significant financial issues that required immediate attention. But at the same time it was still crucial for the management to pay extra attention to company’s inventory (taking into consideration 2018’s uncertainty around the United Kingdom leaving the European Union and all related predictions and preparations), to efficiently use their assets, to negotiate better deals with existing and
future suppliers.
Should YYY seek to raise additional funding to scale its business this report also suggests possible and the most appropriate sources of financing for the company. This takes into the account existing internal policies and aims for the company to become debt free. The most innovative way to get both new ideas and additional funds for company to grow is crowdfunding. YYY hadn’t used this method before, but according to the theory and proven practical use cases of other product companies it is both effective and efficient way.
Introduction
This report overviews YYY company which creates a range of soft drinks (e.g. tonics, lemonades, colas, ginger ales and many other). It covers current financial performance of the company (as of 2018) and previous four years, financial projection for the next five years. Report presents a breakeven point – a necessary level of sales to cover YYY’s total fixed costs. Several potential ways for YYY to attract additional finances are also provided in this report based on its current size and stage of growth.
1. Financial ratio analysis
In this section key financial indicators of YYY’s performance will be introduced and analysed (refer to appendices 1 and 3 to see detailed analysis and explanation to all ratios).
Profitability ratios are one of financial metrics that can be used to assess organisation's ability to generate profit, operating costs, assets and equity over period of time. Year 2016 was the most successful year for YYY in terms of profitability comparing to other years in observed period (2014-2018). Profitability is analysed with a help of gross margin, net profit margin, return on equity and operating profit margin, these ratios are then compared to the closest for YYY’s market competitor - Nichols PLC (hereafter Nichols).
Profitability ratios remained strong for the observed period. Period of 2016-2018 demonstrated a slight decline mostly due to:
· soft drinks’ new tax introduced in the UK (GOV UK 2018),
· rise of underlying costs (e. g. glass),
· company’s policy to stock more inventory as a measure to mitigate possible risks of Brexit (YYY 2018).
All YYY’s profitability ratios were above the average comparing to the competitor’s ratios. Performed cross-sectional analysis clearly demonstrated that YYY had a better profitability than Nichols for the period of 2014-2018.
As a potential recommendation, YYY may consider negotiating better deals with existing inventory suppliers, searching for cheaper deals on components or increasing products price.
Liquidity ratios allow to measure company’s ability to pay off short-term payments without raising external investment. For the observed period of 2014-2018 company had sufficient current assets to cover its current liabilities at a time. As of
2018, YYY’s had £3.6 of cash, cash equivalents and current receivables to cover each pound of current liabilities. Company’s cash amount grew much faster than its current liabilities. YYY’s ratios were not much higher than ratios of its competitor, so management still should have paid attention to the usage of assets efficiently.
Leverage ratios show the amount of capital coming in the form of loans. Alternatively, it can be used to assess company’s ability to meet its financial obligations. Companies have to balance between financing their operations of equity and debt. Stable decrease of debt/equity ratio can be observed starting from 2016. The main reason for this was a growth of retained earnings which was much stronger comparing to growth of total liabilities (2016 to 2018: 370% vs 145% respectively). In 2014-2016 YYY took more loans to finance its activities than in following years (2017- 2018). According to YYY’s accounting records, starting from the year 2016 company started using more of own funds to finance its activities and operations.
For the year 2018 YYY debt/equity ratios were lower than its direct competitor (Nichols), this indicated a low risk for potential YYY investors.
Operating ratios for Fever Tree show worse results in competitor analysis. The difference in ratios might be due to different sizes of companies, different production cycles, resource planning models.
Cash flow ratio. In 2018 it took around 291 days for YYY to convert its account receivables and inventory into cash. There was a stable decrease of this ratio starting from 2016, which was a positive dynamic for the company.
Valuation ratio. Investors were willing to pay £50 on average for every pound of YYY's earnings (2015-2018). In 2014 it was £42. Earnings per share for 2014 were significantly lower than for the year 2015 and onward due to the fact that in 2014 the calculation of ratio included amortization, shareholder loan note interest and exceptional items and the statutory tax rates. This was no longer a case in 2015 and following years. Due to amendments in IFRS in 2014, company was required to change the accounting framework in use (this was a new requirement of FRS 100 “Application of Financial Reporting Requirements” which superseded FRS 22).
2. Financial projections
Projecting or forecasting financial performance is main element of many companies for making further decisions (Alexander 2007: 70). Some companies use financial projections for measuring future performance and planning future activities and expenses. Based on this information companies will determine general approach
to run business in the future, vision, set objectives and goals, development plan (Tyran 1973, Klonowski 2015: 67). Klonowski (2015: 67) believes that financial projection is the best way for a company to assess its future financial condition. It is important to mention that it is difficult to make any predictions. These assumptions must be updated by management according to understanding of current situation and estimated further market dynamic (Alexander 2007:74).
Based on YYY’s financial performance for years 2014-2018 I will make shortcut projections for main financial indicators for the next five years (refer to appendix 2 for details).
The YYY shortcut projection suggests that total net revenues will rise from
£237.5m to £2740.6m for the period of next five years on the assumption that revenues’ annual growth rate would remain at 63.1%.
The shortcut projection for net income shows that it will go up to £582m by 2023 on the assumption that average profit margin would remain at 21.2%.
The YYY’s shortcut projection for total assets demonstrates the growth from
£225.4m to £886.2m over the five-year projection period on the assumption that assets’ annual growth rate remains at 31.5%.
The shortcut projection for total liabilities and shareholders’ equity indicates that liabilities will go up to £198.5m by 2023 on the assumption that average proportion liabilities/assets remains at 22.4% and shareholders’ equity will increase from £183.2m to £687.7m over the five-year projection period on the assumption that proportion remains at 77.6%.
The company is expected to show growth for the next five years according to analysis of shortcut projections.
3. Breakeven analysis
Breakeven analysis is a way for many companies to find a balance between profitability, volume and costs (Cafferky and Wentworth 2014: 1).
Some researchers as Paschal (2006) start conducting breakeven analysis by determining fixed and semi-fixed costs. Fixed expenses are those which happen each month during the entire year, for example salaries, rent, insurance and equipment loans. Bills for telephone, utilities, water, wages paid hourly are semi-fixed costs (Paschal 2006). Breakeven analysis allows to measure how much a company must generate monthly to cover fixed and semi-fixed expenses, in other words to break even.
In some cases, breakeven analysis can be used not only for calculating break- even point (and making further decisions based on these findings, e.g. changing pricing policy), but for defining a measure (benchmark) to identify upper or lower bound for services or products (especially by regulatory agencies) as well. For example, some companies use it to calculate a price for their services when they have to estimate how much life or health costs (Farber 2014).
For the purposes of this report a traditional formula will be used for the breakeven analysis. It determines the necessary level of sales to cover YYY’s total fixed costs (Cafferky and Wentworth 2014: 2). For the year 2018 breakeven point for YYY was £66.26m (refer to appendix 3). For fixed costs to be fully payed YYY needed to have at least £66.26m in sales in 2018, this is a point at which YYY would have reported zero net profit/loss.
4. Evaluation of main sources of financing
Theory defines two types of financing entrepreneurial firms (Govori 2014; Oliner and Rudebusch 1992; Klonowski 2015: 66):
· internal (savings from efficient management, retained earnings),
· external sources (equity and debt instruments).
Researchers say that internal funds are the cheapest source of funds and recommend using this type of source. Eventually when company scales up it need additional source of capital – external. Externally company can get resources from banks, government, venture capitalists, business angels, investors, public market and private partners (Klonowski 2015: 66). External financing is more expensive, its higher cost can be explained by information asymmetries and agency costs for getting funds (Oliner and Rudebusch 1992). Finding the most proper external source of financing is challenging, because each of finance sources has own criteria (like stage of company’s growth), requirements to a company and a level of risk tolerance (Klonowski 2015: 66). All these factors will influence on the final price of raised funding.
Rogers (2014: 161-237) defines such types of external financing:
· debt financing (family, friends and personal savings, angels, government, foundations, banks, customer or supplier financing, factors, purchase order financing and credit cards);
· equity financing (family, friends and personal savings, angels, VC, private placement offering, private equity firms).
When using debt financing as an external source entrepreneur have to remember that these are borrowed funds, which need to be repaid with interest over exactly defined period of time and prescribed schedule (Burk and Lehman 2004: 43). Equity financing will allow to avoid debt, but business owner will give away some part of business ownership and his own part of the business will be diluted, at some round of raising funds company’s founder could lose control over the company. Using equity financing for raising funds may influence a decision-making process in a company and the way how business is run (Sherrod 2000).
5. YYY’s options for debt or equity financing
In case if YYY will consider expansion of operational activities or any other projects, it might be the right time to examine external financing for the company. First of all, the company must find out the purpose, amount and conditions for raising money. The answers to these questions will determine possible types of financing. The efficiency of funding will affect company’s capability to commence with specific projects and definitely will influence the level of profit from its operations (Govori 2014).
By reviewing YYY’s annual reports and financial statements (YYY 2018), we can conclude that company prefers to use own funds rather than debt financing (no borrowings and non-current loans were used in 2018). Company used a £10m credit line for the prior three years from Lloyds bank. YYY decided not to renew this line. Based on their internal policy it is better to propose alternative sources of financing for new projects, but it doesn’t mean that company will exclude debt financing at all. YYY has a continuous credit history and can get a loan from a bank in form of a corporate credit card (Glanz 2015: 9) or consider opening a new credit line, which can be done reasonably quick (as there is a credit history with Lloyds bank).
While YYY is a fast-growing company it is already mature (founded in 2005), that is why it will not be reasonable to finance new projects by personal, family or friends’ savings as well as angel investors’ or venture capitalists’ funds. Most of them have particular investment criteria, for example company should be on early stages of growth or have a revenue between £2m and £20m (2x Consumer, 2020). YYY had a revenue of £237m as of 2018. Moreover, company is listed on the Alternative Investment Market of London Stock Exchange and trading its securities there, which might be a possible source for getting additional funds. More likely that YYY will sell stocks on the market to attract additional capital.
While this would mainly depend on a purpose of a financing, should YYY want to launch a new drink – product crowdfunding might be the best source for this (Feld 2019: 137). Crowdfunding is the way to support initiative of a company by getting attention, cooperation and trust of people to pool their money into the project (Glanz 2015: 9). For example, UK based companies can launch their campaign at Crowdfunder (https://www.crowdfunder.co.uk/). By using crowdfunding, company will not only get a financing but will also receive customer support and collect useful marketing data and various product ideas (Kohler 2015). Company can reward customers for early orders with various perks or premium supplements complementing pre-orders (Rogers 2014: 279).
Conclusion
To summarise analysed financial performance of YYY for 2014-2018 (years when official reports are available), a stable growth of the company could be clearly recognized. According to calculated financial projections, the company will continue demonstrating steady growth for the following five years. This conclusion can be underpinned by the way company is growing each year – by penetration of existing markets and entering new ones, constantly developing new products.
YYY is on its early maturity stage of growth, which gives the company an opportunity either to rise funds on stock exchange or to use traditional bank loans or use internal funds as retained earnings to finance own activities and to expand.
List of references
2x Consumer (2020) Investment Profile. 2x Consumer Products Growth Partners [online] available from https://www.2xpartners.com/investment-profile/ [28 March 2020]
Alexander
J. (2007) Performance Dashboards and
Analysis for Value Creation. Hoboken, N.J.: John Wiley & Sons. Wiley
Finance Ser. [online] available from https://onlinelibrary.wiley.com/doi/pdf/10.1002/9781119197324.ch4 [29 March
2020]
Burk Lehman (2004) Financing Your Small Business. 1st ed. Naperville, Ill.: Sphinx Pub. [online] available from https://ebookcentral.proquest.com/lib/coventry/reader.action?docID=3035116 [28 March 2020]
Cafferky M. and Wentworth J. (2014) Breakeven Analysis: The Definitive Guide to Cost-volume-profit Analysis. Second ed. Managerial Accounting Collection [online] available from https://ebookcentral.proquest.com/lib/coventry/reader.action?docID=1767126 [28 March 2020]
Farber D. (2014) Breaking Bad? The Uneasy Case for Regulatory Breakeven Analysis. California Law Review 102.6 (2014): 1469-493 [online] available from https://www.jstor.org/stable/pdf/24758175.pdf?refreqid=excelsior%3Af1ab84a10 c7f87f0d2df59ead3b7812c [27 March 2020]
Feld B. and Mendelson J. (2019) Venture Deals: Be Smart Than Your Lawyer and Venture Capitalist. John Wiley & Sons, Incorporated [online] available from https://ebookcentral.proquest.com/lib/coventry/detail.action?docID=5880909 [27
March 2020]
YYY (2014) Annual report and financial statements for the year ended 31 December 2014
YYY (2015) Annual report and financial statements for the year ended 31 December 2015
YYY (2017) Annual report and financial statements for the year ended 31 December 2017
YYY (2018) Annual report and financial statements for the year ended 31 December 2018
Glantz M. (2015) Navigating the Business Loan. Elsevier Inc [online] available from https://www.sciencedirect.com/science/article/pii/B9780128016985000017?via
%3Dihub [28 March 2020]
GOV UK (2018) Soft Drinks Industry Levy Gov UK [online] available from https://www.gov.uk/guidance/check-if-your-drink-is-liable-for-the-soft-drinks- industry-levy [28 March 2020]
Govori F.
(2014) The Development of Capital Market
and its Impact on Providing Alternative Sources of Business Financing: Empirical
analysis, Federal Reserve Bank of St Louis, St. Louis [online] available
from https://mpra.ub.uni- muenchen.de/58189/1/MPRA_paper_58189.pdf
[27 March 2020]
Klonowski D. (2015) Strategic Entrepreneurial Finance: From Value Creation to Realization. Routledge Advanced Texts in Economics and Finance [online] available from https://www.taylorfrancis.com/books/9780203094976
Kohler T. (2015) Crowdsourcing-Based Business Models: How to Create and Capture Value. California Management Review 57 p. 63-84 [online] available from http://web.b.ebscohost.com/ehost/pdfviewer/pdfviewer?vid=1&sid=9412ebe9- d0ee-4efb-93ff-2cb0c790b5be%40sessionmgr103 [28 March 2020]
Oliner St. and Rudebusch Gl. (1992) Sources of the Financing Hierarchy for Business Investment. The Review of Economics and Statistics, Vol.74(4), p.643-654 [online] available from http://web.a.ebscohost.com/ehost/detail/detail?vid=0&sid=86bd86da-2433-45f8- a136-5b0128f2b13f%40sdc-v- sessmgr01&bdata=JkF1dGhUeXBlPWlwLHNzbyZzaXRlPWVob3N0LWxpdmU
%3d#AN=4645436&db=bth [28 March 2020]
Paschal B. (2006) Breakeven Analysis: EMB. EMB, Embroidery Monogram Business, vol. 2, pp. 20 [online] available from https://search.proquest.com/docview/235932099/fulltextPDF/D779863C0CE444 E9PQ/1?accountid=10286 [27 March 2020]
Rogers S. and Makonnen R. (2014) Entrepreneurial Finance and Business Strategies for the Serious Entrepreneur, McGraw-Hill Education [online] available from https://bibliu.com/app/#/view/books/9780071824064/epub/ops/cover.html#
[28 March 2020]
Sherrod L. (2000) Financing Your Business. Essence 31.3 [online] available from https://search.proquest.com/docview/223151794/fulltextPDF/4A22650B98 0C4656PQ/1?accountid=10286 [26 March 2020]
Tyran M. (1973) A Financial Projection Plan. Management Accounting 55.1: 19 [online] available
from https://search.proquest.com/docview/229773380?accountid=10286&rfr_id
=info%3Axri%2Fsid%3Aprimo [26 March 2020]
Appendix 1. Financial ratios
|
Ratio |
Description |
YYY’s ratio for the observed period |
Competitor analysis (Nichols) |
|
Gross margin |
For 2018 ratio was 51.8%, this means that each pound of revenue earned by YYY generated £0.518 of profit before deducting other costs (OpEx, administrative expenses, taxes etc.). |
For the observed period there was no strong fluctuation of the gross margin (2014 – 50.9%, 2018 – 51.8%). While for the period of 2014-2016 gross margin was slightly increasing, period of 2016-2018 demonstrated a slight decline of gross margin due to increasing costs of goods sold. According to accounting statements, there was a significant growth in total inventory amount in 2018. This growth was mainly due to raise of finished goods in almost 2.5 times in 2018 compared to 2017. The reason for that was management’s desire to get increased flexibility in 2019 ahead of the UK’s potential Brexit in 2019. |
When compared to the closest market competitor – Nichols, competitors’ gross margin was slightly smaller (45.7%) in contrast to YYY’s (51.8%) in 2018, we can also see the same trend of Nichols gross margin decreasing starting from 2016 (50.4%) as well. |
|
Net profit margin |
This ratio means that £0.26 of each pound generated as a revenue is translated into profit. |
Period of 2014 to 2016 demonstrated steady net profit margin increase from 3.7% to 26.9%. For the next two years this ratio slightly decreased to 26% in 2018 due to operating costs growing faster than company’s revenue. |
According to available annual reports, YYY’s net profit margin (26%) was higher than Nichols (18%) in 2018. |
|
Return on equity |
Investor would have received around £0.34 for every pound invested in YYY in 2018. |
This ratio for YYY steadily growing starting from 2015. It was only from 2014 to 2015 when there was an exploding growth from £0.02 to £0.2 mainly due to significant increase of net profit in more than 10 times. |
Return on equity ratio was above the average comparing to the peer group, e.g. Nichols’ return on equity was nearly £0.23 for each pound invested. |
|
Operating profit margin |
In 2018 this ratio was 31.7%. It means that YYY makes almost £0.32 of profit on each pound of revenue after paying for costs of production, but before paying interest or tax. A company’s operating margin is a good indicator of how effectively organisation is being managed and the amount of risk it is willing to take. |
Similarly, to net profit margin and gross margin ratio, operating profit margin experienced the same growth in 2014-2016 (from 23.3% to 33.6%) and further decline starting from 2016 to 2018 (from 33.6% to 31.7%). |
Nichols’ operating profit margin was also fluctuating for the observed period, however competitor demonstrated lower results comparing to YYY (2014: 16.3%, 2018: 22.3%). |
|
|
|
||
|
Quick ratio (also known as acid-test ratio) |
As of 2018, YYY’s quick ratio (also known as acid- test ratio) was 3.6, meaning that each pound of current liabilities could be covered by £3.6 of cash, cash equivalents and current receivables (in a reasonably short period of time). Company’s cash amount grew much faster than its current liabilities. It should be noted that quick ratio does not take into consideration such assets as inventory, which cannot be reasonably quickly |
Quick ratio had minor change from 3.32 in 2014 to 3.63 in 2018. |
In 2018 Nichols’ current ratio was nearly £3.35 and quick ratio was £3.06. |
|
|
transformed into cash (or its equivalent). |
|
|
|
Current ratio |
It means that a company’s liquidity was not significantly dependent on its inventory – each pound of liabilities was covered by £4.3 of current assets (including inventory). |
Current ratio had minor change from 4.13 in 2014 to 4.3 in 2018. For the year 2018 the current ratio was slightly higher than quick ratio (4.3 and 3.6 respectively). |
|
|
|
|
||
|
Debt/equity ratio |
It shows proportion debt to equity. |
For 2018 ratio was 0.23. Stable decrease of this ratio can be observed starting from 2016. The main reason for this was a growth of retained earnings which was much stronger comparing to growth of total liabilities (2016 to 2018: 370% vs 145% respectively). In 2014-2016 YYY took more loans to finance its activity than in following years (2017- 2018). According to YYY’s accounting records, starting from the year 2016 company started using more of own funds to finance its activities and operations. |
Nichols followed the same strategy for this period of time. Their debt/equity ratio for 2018 was nearly 0.27 and debt/equity ratio (long- term) ratio was 0.04 and decreased from 2014. For the year 2018 YYY debt/equity ratios were lower than its direct competitor (Nichols). Low leverage ratios indicate a low risk for potential YYY investors. |
|
Debt/equity ratio (long- term) |
It shows proportion debt to equity. |
Ratio steadily decreased starting from 0.161 (2014) to 0.001 (2018) as company prioritized equity funding of own activities. |
|
|
|
|
||
|
Day payable ratio and Day receivable ratio |
For 2018 it took around 105 days for YYY to pay off own bills (day payable ratio) and nearly 97 days to collect receivables (day receivable ratio). |
For the observed period (2014-2018) company had 10 days on average between collecting receivables and paying own bills. High number of days for day payable ratio means that the company has a flexibility to conserve cash and delay paying to its suppliers. Nevertheless YYY collected its receivables faster than paying own payables. |
Despite Nichols had more days between collecting receivables and paying its bills (42 days in 2014, 25 days in 2015, 37 days in 2016 and 13 days in 2018), there was at least one case of a mismatch in inflows and outflows in 2017 (-51 days). This gap could have caused payable issues for Nichols. |
|
Inventory turns |
For the period of 2014- 2018 a company sold and replaced its inventory nearly four times per year. |
Inventory turn ratio had minor change from 3.9 in 2014 to 4.0 in 2018. Only in 2017 YYY could six times per year sell and replace its inventory. |
Comparing to Nichols having this ratio at 11 in 2018, YYY’s inventory turn of 4 was relatively slow, this could be due to different production cycle, different resource planning model or even less effective sales. |
|
Day inventory carried |
In 2018 it took 90 days to turn company’s inventory (including goods that are work in progress) into sales. |
Day inventory carried ratio had minor change from 93.2 in 2014 to 90.3 in 2018. |
Nichols had a smaller ratio (34 days). This is an indicator that competitor is much quicker in selling off its inventory. Given YYY had four times more inventories than Nichols in 2018, these two indicators are difficult to compare. |
|
|
|
||
|
Cash flow ratio |
In 2018 it took around 291 days for YYY to convert its account receivables and inventory into cash. |
There was a stable decrease of this ratio starting from 2016, which was a positive dynamic for the company. |
In comparison it took around 200 days to convert account receivables and inventory into cash for Nichols. This is due to due significant difference in companies inventory amounts. |
|
|
|
||
|
Valuation ratio |
Investors were willing to pay £50 on average for every pound of a YYY's earnings (2015-2018). |
In 2015 it was £51 and £42 in 2018. Earnings per share for 2014 were significantly lower than for the year 2015 and onwards due to the fact that in 2014 the calculation of ratio included amortization, shareholder loan note interest and exceptional items and the statutory tax rates. This was no longer a case in 2015 and following years. Due to amendments in IFRS in 2014, company was required to change the accounting framework in use (this was a new requirement of FRS 100 ‘Application of Financial Reporting Requirements’ which superseded FRS 22). |
For Nichols investors were willing to pay £20 on average for every pound of a company's earnings (2015- 2018). The dynamic of this ratio was the same as for YYY, ratio decreased each year from £29 in 2014 to £20.1 in 2018. |
Appendix 2. Financial projections
|
Shortcut projections |
2018 |
Year +1 (2019) |
Year +2 (2020) |
Year +3 (2021) |
Year +4 (2022) |
Year +5 (2023) |
|
Total net revenues |
£237.5 |
£387.3 |
£631.7 |
£1,030.2 |
£1,680.3 |
£2,740.6 |
|
Compounded annual growth |
63.1% |
63.1% |
63.1% |
63.1% |
63.1% |
63.1% |
|
Net income |
£61.8 |
£82.1 |
£133.9 |
£218.4 |
£356.2 |
£581.0 |
|
Historical average profit margin |
21.2% |
21.2% |
21.2% |
21.2% |
21.2% |
21.2% |
|
|
||||||
|
Shortcut projections |
2018 |
Year +1 (2019) |
Year +2 (2020) |
Year +3 (2021) |
Year +4 (2022) |
Year +5 (2023) |
|
Total assets |
£225.4 |
£296.4 |
£389.7 |
£512.5 |
£673.9 |
£886.2 |
|
Compounded annual growth |
31.5% |
31.5% |
31.5% |
31.5% |
31.5% |
31.5% |
|
Total liabilities |
£42.2 |
£66.4 |
£87.3 |
£114.8 |
£151.0 |
£198.5 |
|
Average as a percent of assets |
22.4% |
22.4% |
22.4% |
22.4% |
22.4% |
22.4% |
|
Total shareholders' equity |
£183.2 |
£230.0 |
£302.4 |
£397.7 |
£523.0 |
£687.7 |
|
Average as a percent of assets |
77.6% |
77.6% |
77.6% |
77.6% |
77.6% |
77.6% |
Appendix 3. Financial ratios (calculations)
|
Ratio |
YYY |
Nichols |
||||||||
|
2014 |
2015 |
2016 |
2017 |
2018 |
2014 |
2015 |
2016 |
2017 |
2018 |
|
|
Net working capital |
16.92 |
28.71 |
53.01 |
90.37 |
138.93 |
41.38 |
46.43 |
54.17 |
52.04 |
59.06 |
|
Profitability |
||||||||||
|
Gross margin |
0.509 |
0.521 |
0.552 |
0.535 |
0.518 |
0.459 |
0.485 |
0.504 |
0.457 |
0.457 |
|
Net profit margin |
0.037 |
0.225 |
0.269 |
0.267 |
0.260 |
0.130 |
0.202 |
0.217 |
0.174 |
0.180 |
|
Return on equity |
0.024 |
0.204 |
0.309 |
0.350 |
0.337 |
0.244 |
0.302 |
0.296 |
0.233 |
0.228 |
|
Operating profit margin |
0.233 |
0.291 |
0.336 |
0.331 |
0.317 |
0.163 |
0.255 |
0.258 |
0.216 |
0.223 |
|
Liquidity |
||||||||||
|
Current ration |
4.128 |
3.373 |
3.540 |
3.536 |
4.305 |
2.939 |
3.231 |
3.275 |
3.208 |
3.348 |
|
Quick ratio (acid test ratio) |
3.323 |
2.845 |
3.036 |
3.164 |
3.632 |
2.718 |
3.042 |
2.993 |
3.003 |
3.064 |
|
Leverage ratio |
||||||||||
|
Dept/equity ratio |
0.263 |
0.303 |
0.328 |
0.321 |
0.230 |
0.475 |
0.339 |
0.364 |
0.283 |
0.265 |
|
Debt/equity ratio |
0.161 |
0.118 |
0.093 |
0.047 |
0.001 |
0.108 |
0.055 |
0.087 |
0.045 |
0.041 |
|
Operating ratios |
||||||||||
|
Day payable |
94.0 |
119.1 |
115.5 |
138.2 |
105.3 |
120.5 |
117.5 |
134.5 |
44.6 |
105.7 |
|
Collection ratio "day receivable" |
88.3 |
103.5 |
108.5 |
119.2 |
96.7 |
78.6 |
93.1 |
98.0 |
95.5 |
93.1 |
|
Inventory turns |
3.9 |
4.4 |
4.4 |
6.0 |
4.0 |
12.5 |
14.3 |
8.7 |
35.7 |
10.8 |
|
Day inventory carried |
93.2 |
82.1 |
83.8 |
61.1 |
90.3 |
29.1 |
25.5 |
42.1 |
10.2 |
33.9 |
|
Cash flow ratios |
||||||||||
|
Cash flow cycle |
273.1 |
298.1 |
325.8 |
317.7 |
290.9 |
174.5 |
206.2 |
239.6 |
83.9 |
205.2 |
|
Price/earnings ratio |
||||||||||
|
Price/earnings ratio |
136.4 |
51.4 |
47.7 |
56.6 |
41.7 |
29.3 |
23.7 |
23.6 |
24.5 |
20.1 |
|
Total breakeven sales |
|
|
|
|
66.25 |
|
|
|
|
|
0 comments:
Post a Comment