Prospective Analysis On A2 Milk Financial Performance
Question
Task: Create a report on the prospective analysis of the A2 milk. Forecast the future A2 milk financial performance for the next five years and beyond.
Answer
1: EXECUTIVE SUMMARY:
This report forecasts the A2 milk financial performance for the future years. This has been done using the valuation models i.e. Dividend Discount Model, Cash Flow Model and Residual Income Model. A sensitivity analysis has been presented to ascertain the impact of various assumed factors on the financials which shall help the management in impoverishing the possible threats and identifying business opportunities. Suggestions have been made to the management with remedies to the identified challenges. This study on A2 milk financial performance shall help the management of the company in planning its future operations accordingly.
2: FORECASTS
Financial Forecasts refers to estimating the future profits and losses for an entity over a period of time. Generally, projections of the elements of Profit and Loss Account like Sales, Expenses etc. are made. Accordingly, the Balance Sheet and Cash flow projections are made. It is a vital part of operating a healthy business structure. With correct and accurate A2 milk financial performance and planning, entities can look forward to expansion opportunities by planning their allocation of funds in the right way. Any future A2 milk financial performance requirements can be ascertained which shall help the management in making sound decisions on the sources of funds. The management can start preparing for the same at the right time. Any future roadblocks can be predicted and the management can prepare for the same so that the core functions of the business operations are not impacted (Acharya, Eufinger and Hirsch 2018). With correct management decisions, the firm can achieve overall success. With effective sales forecasts, the productions and procurements can be managed effectively. There is control over the cash flows of a company and thus overall satisfaction of all stakeholders.
A2 milk financial performance forecasts are therefore done in order to:
- Determine the requirements of any additional external funding in the plan.
- Determine the availability of surplus cash resources in the future to distribute to investors as dividends from the plans.
- To ascertain if the plans prepared are feasible. If the forecasts show poor results of the company in the future due to certain factors, the management can make amendments to the plans in an endeavor to produce better outcomes.
2.1: Steps to create A2 milk financial performance forecasts:
Financial plans are created to outline the growth of the company. It forms a primary component of a business plan. Financial plan is not just about the numbers, it is also about how various components of the financial forecasts are clubbed together to create an overall financial plan suitable to the business. Sales forecast, expense budget and cash flow statement form the most important components of financial forecasts. An overall business plan which also contains marketing plan and strategies have no meaning unless they are backed by a financial plan which contains the numbers based on which other plans have been derived. A good financial plan can help to win investors in a business model. Investors see future prospects of the company and invest in it. They see the return expectations, the market price fluctuations, free cash flows and various other parameters before making a decision to invest. Investors check if a particular share is currently over-priced or underpriced to determine its purchase viability. Dividend payout ratio is another key parameter impacting investor decisions.
The second important purpose of A2 milk financial performance forecasts or plans are to obtain bank loan. In order to obtain a bank loan, the client company is required to submit the future prospects by way of a project feasibility report. This report contains the previous year data as well the future forecasts with underlying assumptions. The credit rating of the company is done and based on that the bank grants the client company the required loan with the interest rate dependent on various factors like the credit rating, equated monthly instalments, tenure of loan, amount of loan, business industry of the client company etc. Hence, the financial statements play a very important role. The steps to build A2 milk financial performance forecasts are:
- Estimate sales figure of current goods and services based on previous year trends. Usually an average of regular sales is calculated. A markup of growth is added to the average figure. Any new products or services aimed to be sold or serviced are determined. The revenue from the sale of new goods and services is determined based on demand and market study. This is added to the figure or original goods and services initially calculated to arrive at the forecasted sales numbers. Any change expected due to other socio economic, environmental or political factors are factored in.
- Cost of sales: To estimate the cost of sales while evaluating A2 milk financial performance, the purchase forecast is prepared. This is done by preparing a list of suppliers and analyzing the purchases made during the previous year. Obsolete or outdated stocks which are not required to be purchased in the years going forward are excluded. The purchases are done in a manner that the sales targets are achieved and the minimum required inventory is always lying in the inventories. Cost of sales in then determined based on the opening inventory, added to the purchases and deducting the amount of closing inventory required.
- Other income and expenditures (operating): All other operating incomes and expenditures too are arrived by computing the previous year numbers as a percentage of sales.
- Plant and Machinery: With increase in sales volumes, the requirement of additional plant and machinery also increases. New machines are required to cater enhanced supplies if the full capacity of the existing machine is exhausted. A company needs to make investments in its fixed assets as and when required. These are big investments and required years of retaining of funds to be used. A2 milk financial performance forecast need to prepare in a manner that there are surplus funds available to invest. Depreciation and other repair expenditures need to be factored in the forecasts.
- Current Assets and Liabilities: These are usually derived as a percentage of sales and purchases based on past year trends. As per the A2 milk financial performance, the previous year trends of Accounts receivable turnover, accounts payable turnover, current ratios, quick ratio etc. are analyzed and used in preparation of future year forecasts. Any abnormal change in past years needs to be eliminated in the budgets.
- Long term investments: If there is surplus cash arising out of earnings, the same needs to be invested in interest bearing assets. A high level of liquid funds is not ideal for any company. A proper planning of long term investments and their maturities is therefore very important.
- Long term borrowings: Any acute possible cash shortage should be immediately identified and plans should be made in advance to procure funds from external sources. Any growth in business or diversification would require a huge amount of investment which can be procured through debt instruments. The A2 milk financial performance should therefore identify such possibilities and apply for loan in time because the process takes a long time.
The A2 milk financial performance forecast for the next ten years has been presented in the Appendix.
2.1: What are the assumptions in A2 milk financial performance Forecasts:
- Sales: Sales Forecast is the basis for all financial forecast in any company. The management team in-charge of preparing forecasts start with the sales forecasts. The most recent year’s balance sheet values are considered to be the baseline for the budgetary numbers. As per the A2 milk financial performance, the sales of the company have grown at a rate of more than 50% in each year over the last five years before 2019. In 2019, the sales grew at a rate of 41%. However, considering Global Recession and entrance of competitors in the field of dairy product supplies off late, a sales growth of 30% has been assumed for the first five years and a growth rate of 20% for the years thereafter. This growth accommodates both volume increase and price increase in the case of protein free milk provided by the company.
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Sales |
16,95,637 |
22,04,328 |
28,65,626 |
37,25,314 |
48,42,908 |
58,11,490 |
69,73,788 |
83,68,545 |
1,00,42,255 |
1,20,50,705 |
Percentage change |
30% |
30% |
30% |
30% |
30% |
20% |
20% |
20% |
20% |
20% |
- Cost of Sales: The cost of sales as a percentage of total sales of A2 Milk has been reducing since the past years except for 2018. Only in 2018, the cost of sales rose by 60%. The A2 milk financial performance in 2019 signifies that the cost of sales was 45% of total sales. A similar assumption has been made on the A2 milk financial performance to forecast the cost of sales for future years. The percentage increase in cost of sales has been taken to be 50% of sales figure which is at par with the average of last five years. (Anderson et al., 2018).
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Cost of sales |
-8,47,818 |
-11,02,164 |
-14,32,813 |
-18,62,657 |
-24,21,454 |
-29,05,745 |
-34,86,894 |
-41,84,273 |
-50,21,127 |
-60,25,353 |
Percentage change |
44% |
30% |
30% |
30% |
30% |
20% |
20% |
20% |
20% |
20% |
- Other Revenue: The study of A2 milk financial performance signifies that this is an insignificant amount in the company’s income statement. It forms only 0.01% or less of the sales. It has therefore been assumed at a constant of $ 200 for the rest of the years of forecast. A slight upside or downside may be possible for the figures. No correlation of the other revenue figure could be established with sales. This is the reason why a fixed amount assumption has been taken for future years rather than presuming the other revenue total to be a certain percentage of sales.
- Operating Expenses: This includes the distribution, administrative, marketing, occupancy and other expenditures. These have been derived as a percentage of sales for the future forecasts. The basis for deriving the percentage applicable is the actuals of the last year ended 2019. Sales related operating expenses associated with the A2 milk financial performance like distribution expenses, administrative expenses and marketing expenses have been assumed as a percentage of sales same as last year i.e. 2019. Only a slight increase in distribution expense is assumed. Other expenses has been considered at a higher rate in the forecasts since with the addition of new plant, machinery etc. and degradation of existing machinery and equipment’s, the overall expenses like depreciation, repairs, reconstruction etc. shall increase. Thus, while evaluating A2 milk financial performance other expenditures have been assumed to be 15% of sales. This also includes a dividend payout growth of 5%.
Percentage of Sales |
||
Year |
Last 5 year average |
Previous Year 2019 |
Distribution expenses |
-3% |
-2% |
Administrative expenses |
-6% |
-5% |
Marketing expenses |
-9% |
-10% |
Occupancy Expenses |
0% |
0% |
Other expenses |
-6% |
-5% |
- Interest Income: This component is also related to the A2 milk financial performance that has been derived as a percentage of Cash and Short term Investments where money held in the form of deposits in banks and other short term investments earn interest. All interest bearing investments are expected to earn 1%. The interest income is therefore calculated to be 1% of the total of cash and other short term investments.
- Finance Cost: This is also an insignificant amount and assumed at a constant rate of $200 for 2020 and $300 for the remaining period. A2 Milk does not have any financing from debt. It is a debt-free company. The only source of funds is equity. This shows that the A2 milk financial performance would be lower since there is no reliability on debt. In future too, there is no possibility of debt unless A2 Milk plans to expand its existing business or enter into newer lines of business.
- Income Tax Expenditure: This expense comes under the A2 milk financial performance shall be based on the Profits earned during the year under review. There are tax slabs to ascertain the income tax expenditure of an entity. For the analysis we have assumed a flat rate of 35% income tax. The average range may however vary from 30 to 40% depending upon the net taxable income arrived after claiming all deductions.
For Balance sheet items too, the A2 milk financial performance forecasting is done as a percentage of sales. Their relationship with Sales is derived and accordingly accommodated in the forecast numbers.
- Trade Receivables: Trade Receivables have been assumed to be 4% of sales. In a dairy business, the majority of transactions are carried out on a cash basis. However, there are some regular clients who follow the credit system of payments. Referring to the actual figures of previous years, this percentage has been arrived to compute the average trade receivables balance expected in future years.
- Prepayments: Similar to Trade Receivables, this balance too has been calculated as a percentage of Net Sales and contributes to the A2 milk financial performance. This balance is 3.8% of Sales.
- Inventories: Inventories are assumed to be 8% of Net Sales. To carry out regular business in smooth manner, entities are required to maintain certain inventory all the time. Since Dairy products have a shorter life span the inventory requirement at any time during the year is comparatively lower than other lines of business.
- Plant and Machinery: Investment in Plant and Machinery or any other fixed assets depends solely upon management and eventually boosts up the A2 milk financial performance. Investment is done based on requirement to expand the business, enter new lines of business or technology improvement. A 10% year-on-year increase has been assumed for each with some amount of lump sum investments every 2-3 years (Bernstein, Colonnelli and Iverson, 2019).
- Financial Assets: The long term financial assets have been assumed to rise at a certain percentage every year with certain lump sum investments every 2-3 years.
- Trade Payables: Trade Receivables have been assumed to be 27% of Cost of sales. Referring to the actual figures of previous years, this percentage has been arrived to compute the average trade payables balance expected in future years. Credit helps the business to invest cash in other areas.
- Other liabilities: Other liabilities include Income tax Payable and other payables. These have been assumed based on the previous year trends.
With changes in Income Statement and Balance Sheet other factors impacting A2 milk financial performance forecasts are:
- Growth margin: The growth margin in sales is assumed to be 50% of sales which is in line with the previous 5 years average trend. The average profit after tax for the last five years is 18% of sales. For 2019, the PAT is 22% of sales. With our forecast assumptions mentioned above, the profit after tax rises at a rate of 16% for the first two years and 14% thereafter. This is arrived after considering increase in distribution costs after volume rise and factoring of dividend distribution in other expenses.
- Asset Turnover: The asset turnover ratio is defined as Total Revenue divided by Average Total Assets. The average asset turnover ratio for the last five years is 140%. For 2019, the ratio stands at 131%. In our forecasts, the asset turnover after considering accumulated earnings, Depreciation, etc. ranges between 110% to 132%.
- Dividend Payout ratio: As per the calculations on A2 milk financial performance, the company currently does not pay any dividend. Its dividend payout for the last five years is zero. However, for future years, the forecasts consider a dividend payout of $0.15 per share with an annual increase of 5%. The dividend payout ratio stands at 41% for 2020 forecast. It keeps declining as the firm needs to retain earnings to work out its expansion plans.
3. Valuation Techniques:
There are primarily three defined valuation techniques which are used both in relative and absolute categories. The Investment models are Dividend Discount Model, Discounted Cash Flow Method and the Residual Income Approach. Each method has its own pros and cons. amongst these, the Dividend Discount Model is the simplest (Cull, Demirgüç-Kunt and Morduch, 2018). Each of the valuation methods have been discussed with reference to A2 milk financial performance.
3.1: Dividend Discount Model:
Dividend Discount Model is a method of valuation of a company’s share price by discounting its future dividend payments back to their present value. In simpler terms, it is the net present value of all future dividends. It is presumed that the present day price is the sum of all its future dividends discounted back to present value.
In case of A2 milk financial performance, the company has not paid any dividends since its listing on the Australian Securities Exchange. Despite earning a very high return on its Equity, the company fails to meet investor expectations of dividend payout (Das, 2018). A company earns profits from its business processes and makes dividend payments to shareholders from its profits. However, in our forecasts the company may be assumed to have a dividend growth rate of 5% each year since the company is currently in a stable position to pay the investors. The current market rate or cost of capital is assumed to be 7% which is the prevailing rate of interest in the market. The first year dividend in the assumption is taken to be $ 0.150. Dividend has been factored in other expenses forecast of all future years.
Value of Share = Expected Dividend per share / (Cost of capital equity – dividend growth rate)
In case of A2 Milk Company, value of share can be derived using the DDM technique as below –
Value of Share = 0.15 / (0.07-0.05)
= 0.15 / 0.02
= $ 7.5
Therefore, as per Dividend Discount Method, the value of equity of A2 Milk Company is $7.5 per share.
This can be multiplied with the number of outstanding shares to arrive at the value of the company.
Value of the company as per Dividend Discount method = 7.5 * 730,039 (in thousands)
= $ 5.5 billion.
Dividend Discount Model has many variations. Each of these differs in complexity. The simplest model assumes zero growth in the dividend. Another model is the Gordon’s growth model which assumes a constant dividend growth rate. In the above calculation, the Gordon’s growth model has been assumed. The third variant called the Supernormal dividend growth model used within this study of A2 milk financial performance where dividends for initial years are on a high and then the dividend policy assumes a constant growth. In such scenario, each year amount is discounted and added to arrive at the stock price (Lament, 2018).
In case of A2 milk financial performance, the DDM method is valuation is not recommended since the company does not have any past record of dividend payments. The future dividend payout of the company too depends upon various factors which include Management decisions; amount invested in fixed assets, capital buyback decisions etc. In such scenario, it is advisable to rely on other methods of investment valuation to value the company’s stock price.
3.2: Residual Income Method:
Residual Income method of valuation is a valuation method where the company is valued on the basis of present value of future residual incomes that are discounted at the most appropriate cost of equity. The RIM method of investment valuation is expressed as:
Value of Equity = Current Book Value + summation of [Residual Income of each future year / (1+required return on equity)]
Where,
Residual Income = (ROE – r) * B t-1
This method thus measures the value created by a company through its business model and contributes to the A2 milk financial performance.
In case of A2 Milk Company, the current book value of each share is $1.08 for the year ended June 2019. The expected required return on equity is assumed to be 7% as assumed in case of DDM Model. Residual Income of each year has been calculated below: (calculated for 10 years starting 2020)
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
ROE |
25% |
25% |
23% |
23% |
23% |
21% |
20% |
20% |
19% |
19% |
Book Value per Share |
1.45 |
1.93 |
2.48 |
3.21 |
4.15 |
5.28 |
6.64 |
8.27 |
10.22 |
12.57 |
Residual Income per share |
0.20 |
0.26 |
0.30 |
0.39 |
0.50 |
0.60 |
0.71 |
0.84 |
1.00 |
1.20 |
RI / 1+required return on equity |
0.19 |
0.24 |
0.28 |
0.36 |
0.47 |
0.56 |
0.66 |
0.79 |
0.94 |
1.12 |
Value of Equity = 1.08 + 5.60
= $ 6.68.1
Therefore, as per Residual Income Method, the value of equity of equity of A2 Milk Company is $ 6.68 per share.
This can be multiplied with the number of outstanding shares to arrive at the value of the company.
Value of the company as per Residual Income method = 6.68 * 730,039 (in thousands)
= $ 4.9 billion.
This is the best method of equity valuation of firms which do not pay any dividends and have irregular cash flows. This method is thus most suited for the company’s valuation since the available A2 milk financial performance data is used for arriving at the value of the share. This method looks at the economic profitability of the firm and not just its accounting profitability. However, the drawback is that the method relies solely on future forecasts. This leads the valuations to be vulnerable of biases and misrepresentation.
3.3: Discounted Cash Flow Method for the A2 milk financial performance:
This method evaluates the value of a firm using its free cash flows. The future estimated free cash flows are discounted to arrive at the current year value by discounting them using the rate of expected cost of equity.
The study on A2 milk financial performance illustrates that the evaluations are based on how much money a particular company shall generate in the future. In case of DCF method, if the value calculated is greater than the current investment cost, investors consider it as an opportunity to invest in the company since they expect higher returns in the future (Lin, Schmid and Xuan, 2018).
The discount rate is assumed to be the expected cost of equity i.e. 7%, similar to the assumptions in the previously discussed model. The free cash flows and the present value of each using a 7% discount rate has been presented in the table below:
PROJECTIONS (in millions) |
||||||||||
Particulars |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Free Cash Flow |
200 |
289 |
-144 |
377 |
356 |
231 |
775 |
452 |
113 |
269 |
Discount Rate |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
no. of years |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
PV of Free Cash Flow |
187 |
252 |
-118 |
287 |
254 |
154 |
482 |
263 |
62 |
137 |
Present Value of A2 Milk Company as per Discounted Cash flow method (calculated taking free cash flows of 10 years) = $ 2 billion.
Value per share = Value of Firm / no. of shares outstanding
= 2 billion / 730 million
= $ 3 per share (rounded off)
In the calculation of discounted cash flows, the weighted average cost of capital is used to derive the discount rate. In this case, the prevailing market rate of return has been presumed to be the cost of equity. The company is a debt free company.
The risks associated with this method are that the risk free rates keep changing over time. This method can be used for small businesses but is not recommended for big firms with complex projects because there are several assumptions inculcated in the calculations. This method may be used for evaluating the valuation of A2 milk financial performance but is not the most recommended methodology.
3.4: Comparison of share prices obtained with actual share price:
Valuation Methods |
Value per share |
Dividend Discount Model |
$ 7.50 |
Residual Income Method |
$ 6.68 |
Discounted Cash Flow Method |
$ 3.00 |
Current Market Price |
$ 14.36 |
On comparing the value of shares of A2 milk financial performance under different valuation methods, it is observed that currently the market price of A2 Milk Company is overvalued. It is not ideal for investors to make any investments in such highly inflated markets. The valuation arrived as per all the three models are lower than the current market price.
4: Sensitivity Analysis:
Sensitivity Analysis is the measurement of how uncertain the output is to with respect to changes in the input data. In case of A2 milk financial performance, the analysis has been done on the Residual Income approach as per the requirements of the assignment. The sensitivity of share valuation to Sales, Profit Margin, Asset Turnover and Cost of Equity has been ascertained. The company is a debt free company and pays no dividend. These factors have therefore been ignored in performing the sensitivity analysis.
4.1: Sensitivity to Sales and Operating Profit:
With change in sales forecasts, the profit forecasts of the company also changes. This leads to a change in the free cash flows available and ultimately impacts the valuation of the company. In the table below, the analysis has been done on the A2 milk financial performance wherein the change in valuation is determined with respect to the change in sales and operating profit.
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Current Sales Forecast |
16,95,637 |
22,04,328 |
28,65,626 |
37,25,314 |
48,42,908 |
58,11,490 |
69,73,788 |
83,68,545 |
1,00,42,255 |
1,20,50,705 |
Estimated Increase/Decrease |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
Revised Sales Forecast |
18,65,200 |
24,24,761 |
31,52,189 |
40,97,845 |
53,27,199 |
63,92,639 |
76,71,167 |
92,05,400 |
1,10,46,480 |
1,32,55,776 |
Revised Profit after tax |
3,79,121 |
4,92,408 |
5,94,461 |
7,71,614 |
10,03,099 |
12,02,869 |
14,42,511 |
17,33,240 |
20,78,441 |
24,99,040 |
Revised ROE |
36% |
35% |
33% |
33% |
33% |
31% |
30% |
29% |
28% |
27% |
Revised Equity |
12,26,322 |
16,26,318 |
21,00,644 |
27,16,081 |
35,16,150 |
44,38,130 |
55,43,574 |
68,72,335 |
84,65,400 |
1,03,81,990 |
no. of shares |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
Revised Book Value per share |
1.68 |
2.23 |
2.88 |
3.72 |
4.82 |
6.08 |
7.59 |
9.41 |
11.60 |
14.22 |
Revised Residual Income per share |
0.31 |
0.47 |
0.57 |
0.75 |
0.97 |
1.16 |
1.38 |
1.65 |
1.96 |
2.35 |
RI/1+required return on equity |
0.29 |
0.44 |
0.54 |
0.70 |
0.91 |
1.09 |
1.29 |
1.54 |
1.83 |
2.19 |
Revised Value of Equity = |
$ 11.90 |
Previous Value of Equity |
$ 6.68 |
Change |
$ 5.22 |
Percentage change |
78% |
The table is based on the A2 milk financial performance and shows the sensitivity of valuation of share to the company’s sales and operating profits. The value of share is highly sensitive to change in sales. For 10% change in sales, the share value changes by 78%. A similar sensitivity shall be observed in case of operating profit too as change in sales and change in operating profit both directly impact the PAT and Equity. This shows that to lure investors to invest in the company, the company can target higher sales in the future and present it in its A2 milk financial performance forecasts. This will lead to increase in valuation of its shares and impact the market price of the share. A higher market capitalization would show that the company is doing really well.
4.2: Sensitivity to ROA:
With change in ROA, the value of share will be impacted similarly as in the case of change in sales. ROA is calculated as sales divided by net assets. Any change in ROA shall lead to change in both ROE as well as book value (Wright and Zhu, 2018). However, the study of A2 milk financial performance clarifies that the net impact shall be higher change in Share value.
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Current Sales Forecast |
16,95,637 |
22,04,328 |
28,65,626 |
37,25,314 |
48,42,908 |
58,11,490 |
69,73,788 |
83,68,545 |
1,00,42,255 |
1,20,50,705 |
Total Assets forecast |
12,80,501 |
17,07,494 |
22,05,961 |
28,40,608 |
36,77,626 |
46,96,388 |
58,53,195 |
72,43,569 |
89,11,421 |
1,09,16,764 |
Return on Assets |
76% |
77% |
77% |
76% |
76% |
81% |
84% |
87% |
89% |
91% |
Expected percentage change |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
Revised Return on Assets |
86% |
87% |
87% |
86% |
86% |
91% |
94% |
97% |
99% |
101% |
Revised Sales Forecast |
14,97,357 |
19,52,292 |
25,36,168 |
32,93,401 |
42,79,376 |
51,71,543 |
62,31,353 |
75,01,851 |
90,25,207 |
1,08,52,706 |
Revised Profit after tax |
1,40,023 |
1,85,304 |
1,94,048 |
2,48,725 |
3,22,013 |
4,09,157 |
5,06,632 |
6,25,934 |
7,64,613 |
9,37,045 |
Revised ROE |
13% |
13% |
11% |
11% |
11% |
11% |
10% |
10% |
10% |
10% |
Revised Equity |
8,58,479 |
11,53,850 |
14,84,623 |
19,11,637 |
24,68,327 |
32,17,035 |
41,03,761 |
51,68,786 |
64,44,127 |
79,78,920 |
no. of shares |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
Revised Book Value per share |
1.18 |
1.58 |
2.03 |
2.62 |
3.38 |
4.41 |
5.62 |
7.08 |
8.83 |
10.93 |
Revised Residual Income per share |
0.07 |
0.07 |
0.06 |
0.07 |
0.09 |
0.12 |
0.15 |
0.19 |
0.23 |
0.28 |
RI/1+required return on equity |
0.06 |
0.07 |
0.05 |
0.07 |
0.09 |
0.11 |
0.14 |
0.18 |
0.21 |
0.26 |
Revised Value of Equity = |
$ 2.34 |
Previous Value of Equity |
$ 6.68 |
Change |
$ -4.34 |
Percentage change |
-65% |
The value of share is highly sensitive to change in ROA. For 10% change in ROA, the share value reduces by 65%. As per the study on A2 milk financial performance, the value of equity is therefore highly inversely proportional to change in ROA.
4.3: Sensitivity to Cost of Equity:
Cost of Equity is the return an entity is expected to pay to its equity shareholders or investors to compensate them for the risk they have taken by investing their funds in the entity’s business. A large business model needs funds to grow and the same is obtained by obtaining finance from others. The operations are carried out by financing from two major sources i.e. equity and debt. Each of these sources has their own pros and cons and separate costs and benefits associated with them. The cost of debt is usually cheaper for a company, but comes along with high risks. In the table below, the sensitivity of share value towards change in the cost of equity has been ascertained.
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
ROE |
25% |
25% |
23% |
23% |
23% |
21% |
20% |
20% |
19% |
19% |
Book Value of Share |
1.45 |
1.93 |
2.48 |
3.21 |
4.15 |
5.28 |
6.64 |
8.27 |
10.22 |
12.57 |
Percentage change in COE |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
10% |
Revised COE |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
7.70% |
RI per share |
0.19 |
0.25 |
0.29 |
0.37 |
0.48 |
0.57 |
0.67 |
0.80 |
0.94 |
1.12 |
RI/1+required return on equity |
0.18 |
0.23 |
0.26 |
0.34 |
0.45 |
0.53 |
0.62 |
0.74 |
0.88 |
1.04 |
Revised Value of Equity |
$ 6.35 |
Previous Value of Equity |
$ 6.68 |
Change |
$ -0.33 |
Percentage change |
-5% |
It is observed here in the context of A2 milk financial performance that the share price calculated as per Residual Income Approach is inversely sensitive to change in ROE. With a 10% increase in Return on equity, the calculated share price reduced by 5%. The sensitivity however is very low as compared to Sales and ROA.
This indicates that cost of equity is not a major criteria impacting share price volatility. Investors are unaffected by the short term return on equity and are more concerned about their long term earnings.
4.4: Sensitivity to Cost of Debt:
As per the A2 milk financial performance analysis, the company currently does not have any debt or long term obligations. However, if we assume a debt of any amount across all the forecasted years and a cost of debt of 10% as compared to 0% currently, the return on equity shall drop down.
Assuming the revised capital structure to be 40% debt and 60% equity.
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Revised Equity |
6,34,055 |
8,43,531 |
10,88,449 |
14,06,130 |
18,19,116 |
23,14,189 |
29,07,717 |
36,21,288 |
44,76,705 |
55,06,152 |
Revised Debt |
4,22,703 |
5,62,354 |
7,25,632 |
9,37,420 |
12,12,744 |
15,42,793 |
19,38,478 |
24,14,192 |
29,84,470 |
36,70,768 |
Cost of Debt @ 10% |
42,270 |
56,235 |
72,563 |
93,742 |
1,21,274 |
1,54,279 |
1,93,848 |
2,41,419 |
2,98,447 |
3,67,077 |
Revised PAT |
2,41,429 |
3,12,574 |
3,61,029 |
4,68,537 |
6,09,481 |
7,24,840 |
8,63,213 |
10,32,362 |
12,31,704 |
14,77,144 |
Revised ROE |
38% |
37% |
33% |
33% |
34% |
31% |
30% |
29% |
28% |
27% |
Revised Equity |
6,34,055 |
8,43,531 |
10,88,449 |
14,06,130 |
18,19,116 |
23,14,189 |
29,07,717 |
36,21,288 |
44,76,705 |
55,06,152 |
no. of shares |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
Revised Book Value per share |
1.45 |
1.93 |
2.48 |
3.21 |
4.15 |
5.28 |
6.64 |
8.27 |
10.22 |
12.57 |
Revised Residual Income per share |
0.34 |
0.44 |
0.50 |
0.65 |
0.85 |
1.01 |
1.20 |
1.43 |
1.70 |
2.03 |
RI/1+required return on equity |
0.31 |
0.41 |
0.47 |
0.61 |
0.80 |
0.94 |
1.12 |
1.33 |
1.58 |
1.89 |
Revised Value of Equity with change in capital structure |
$ 10.55 |
The above table is based on the A2 milk financial performance and shows how the figures of equity, debt, profits, book value of shares etc. change with change in the capital structure of A2 Milk. Since cost of debt is cheaper than equity, the value of equity is improved with induction of debt.
Now comparing the sensitivity of Share value to cost of debt, the capital structure is assumed to be same as above i.e. 40% debt and 60% equity and the cost of debt is increased by 10%.
This shall lead to change in PAT and revised residual incomes. The revised share price is calculated as:
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Revised Equity |
6,34,055 |
8,43,531 |
10,88,449 |
14,06,130 |
18,19,116 |
23,14,189 |
29,07,717 |
36,21,288 |
44,76,705 |
55,06,152 |
Revised Debt |
4,22,703 |
5,62,354 |
7,25,632 |
9,37,420 |
12,12,744 |
15,42,793 |
19,38,478 |
24,14,192 |
29,84,470 |
36,70,768 |
Cost of Debt @ 20% |
84,540.69 |
1,12,470.84 |
1,45,126.48 |
1,87,483.99 |
2,42,548.76 |
3,08,558.51 |
3,87,695.65 |
4,82,838.43 |
5,96,894.00 |
7,34,153.54 |
Revised PAT |
-54,951 |
-73,106 |
-94,332 |
-1,21,865 |
-1,57,657 |
-2,00,563 |
-2,52,002 |
-3,13,845 |
-3,87,981 |
-4,77,200 |
Revised ROE |
-9% |
-9% |
-9% |
-9% |
-9% |
-9% |
-9% |
-9% |
-9% |
-9% |
Revised Equity |
6,34,055 |
8,43,531 |
10,88,449 |
14,06,130 |
18,19,116 |
23,14,189 |
29,07,717 |
36,21,288 |
44,76,705 |
55,06,152 |
no. of shares |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
4,38,023 |
Revised Book Value per share |
1.45 |
1.93 |
2.48 |
3.21 |
4.15 |
5.28 |
6.64 |
8.27 |
10.22 |
12.57 |
Revised Residual Income per share |
-0.17 |
-0.23 |
-0.30 |
-0.39 |
-0.50 |
-0.65 |
-0.83 |
-1.04 |
-1.30 |
-1.60 |
RI/1+required return on equity |
-0.16 |
-0.21 |
-0.28 |
-0.36 |
-0.47 |
-0.61 |
-0.77 |
-0.97 |
-1.21 |
-1.50 |
Revised Value of Equity |
$ -5.47 |
Previous Value of Equity |
$ 10.55 |
Change |
$ -16.02 |
Percentage change |
-152% |
The sensitivity of share value calculated as per residual income method is seen to be highly sensitive to the cost of debt. With a 10% increase in the cost of debt, the share value dropped down by 152%. With debt becoming more expensive, a higher amount shall be paid to the lenders leaving the equity holders with little or no earnings. This shall lead to disappointment of investors and they would not be willing to invest in the company leading to a steep fall in the value of shares.
4.5: Sensitivity Summary:
Forecasting assumptions are thus chosen based on their sensitivity to various factors both qualitative and quantitative. External factors like political, social, environmental etc. impact the firm’s growth potential. Since the company is a dairy company with its main product being the A2 milk, any change in the environmental factors shall lead to a great change in the sales of A2 Milk. Similarly competition from other dairy product suppliers also impacts A2 milk financial performance. Internal factors include the company’s employees, machineries, quality checks etc. These factors directly impact the demand and supply and thus the market valuation of the company. Any optimistic outcome like increase in demand increases the share price. Similarly, any pessimistic outcome like constraints in labor supply reduces production and leads to underutilization of resources which in turn reduces the market price of the shares. The company should thus forecast its operations keeping in mind the optimistic and pessimistic factors impacting its valuations.
5: Management Consulting Advice:
A2 milk financial performance status is quite well in the market. Its share price is quite high when compared to the valuations arrived using the three given approaches. This shows that there are qualitative factors impacting the status of the company which has led to a higher market capitalization. The company is debt free and the major source of funding is only equity. The sales and profits have risen drastically over the past five years owing to the high demand of protein free milk. The milk is suitable for consumption for people with stomach complaints. The company can thus foresee a rising demand of its products across Australia, New Zealand and all other countries where it has its chains.
The key factors impacting share valuation are:
- Cost of Equity: This is the prevailing market rate of interest which is assumed to be the expected cost of equity. Investors expect a minimum return of cost of equity so as to not divert their invested amount to other areas.
- Free Cash Flow: The free cash flow available with a firm at its disposal anytime is an important factor impacting share valuation. It ascertains how much a company can invest to buy back its shares from the open market or pay of its dues.
- Dividend Payout: This is yet another factor impacting share valuation. A good dividend paying company is valued higher than a non-dividend company. This is because when investor expectations are met, they tend to invest in the share causing a price rise of the particular share.
- Appropriate capital structure: A2 Milk needs to maintain an appropriate capital structure to enhance its market value to the maximum. A cheap source of funds such as debt would be ideal but only to a limit. The management needs to make strong decisions in maintaining an adequate capital structure or gearing ratio.
To improve A2 milk financial performance and current profitability, the company can look forward to Global expansion. It needs to identify potential markets where such protein free milk is in demand. It can open up production centres in countries having demand of milk. The company should also target to reduce its cost of sales. For A2 milk financial performance, the company can improve its distribution network by opening smaller collection and distribution centres to streamline supplies. This will bring down the cost drastically. As seen in the forecasts, the company shall have a lot of surplus funds available. The management can think of expanding and investing the amount into right assets to yield better returns.
There are potential threats as well which may lead to a fall in revenues. This includes factors like competitors gaining market share or quality standards not being met by the company, lawful restrictions etc (Zolfani et al., 2018). The management needs to identify these in advance and work towards diminishing the potential threats.
A2 milk financial performance can improve value by paying out dividends to its investors. Appropriation of cash flows in the right place shall lead to higher valuation. Increase in market demand is another factor that shall contribute to price rise of shares. The management should thus look forward to expansion opportunities to ensure better market valuation to enhance the A2 milk financial performance. The sensitivity analysis of various factors to the valuation of the company can help management to ascertain and drive growth prospects.
References
Acharya, V.V., Eisert, T., Eufinger, C. and Hirsch, C., 2018. Real effects of the sovereign debt crisis in Europe: Evidence from syndicated loans. A2 milk financial performance The Review of Financial Studies, vol.31, no.8, pp.2855-2896.
Anderson, R.W., Bustamante, M.C., Guibaud, S. and Zervos, M., 2018. Agency, firm growth, and managerial turnover. The Journal of Finance, vol. 73, no. 1, pp.419-464.
Bernstein, S., Colonnelli, E. and Iverson, B., 2019. Asset allocation in bankruptcy. The Journal of Finance, vol. 74, no. 1, pp.5-53.
Cull, R., Demirgüç-Kunt, A. and Morduch, J., 2018. The microfinance business model: Enduring subsidy and modest profit. The World Bank Economic Review, vol.32, no.2, pp.221-244.
Das, S., 2018. Analysis of cash flow ratios: A study on CMC. A2 milk financial performance Accounting, vol.4, no.1, pp.41-52.
Lament, M., 2018. Impact of non-financial reporting on return on equity of insurance companies in the Polish market. The 12th International Days of Statistics and Economics, Conference Proceedings. Prague: MELANDRIUM.
Lin, C., Schmid, T. and Xuan, Y., 2018. Employee representation and financial leverage. Journal of Financial Economics, vol.127, no.2, pp.303-324.
Wright, J. and Zhu, B., 2018. Monopoly rents and foreign direct investment in fixed assets. International Studies Quarterly, vol.62, no.2, pp.341-356.
Zolfani, S.H., Yazdani, M. and Zavadskas, E.K., 2018. An extended stepwise weight assessment ratio analysis (SWARA) method for improving criteria prioritization process. A2 milk financial performance Soft Computing, vol.22, no.22, pp.7399-7405.
Appendix:
Statement of Comprehensive Income:
PROJECTIONS |
||||||||||
Year |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Sales |
16,95,637 |
22,04,328 |
28,65,626 |
37,25,314 |
48,42,908 |
58,11,490 |
69,73,788 |
83,68,545 |
1,00,42,255 |
1,20,50,705 |
Percentage change |
30% |
30% |
30% |
30% |
30% |
20% |
20% |
20% |
20% |
20% |
Cost of sales |
-8,47,818 |
-11,02,164 |
-14,32,813 |
-18,62,657 |
-24,21,454 |
-29,05,745 |
-34,86,894 |
-41,84,273 |
-50,21,127 |
-60,25,353 |
Percentage change |
44% |
30% |
30% |
30% |
30% |
20% |
20% |
20% |
20% |
20% |
Gross Margin |
8,47,818 |
11,02,164 |
14,32,813 |
18,62,657 |
24,21,454 |
29,05,745 |
34,86,894 |
41,84,273 |
50,21,127 |
60,25,353 |
Percentage of Sales |
50% |
50% |
50% |
50% |
50% |
50% |
50% |
50% |
50% |
50% |
Other revenue |
200 |
200 |
200 |
200 |
200 |
200 |
200 |
200 |
200 |
200 |
Distribution expenses |
-40,695 |
-52,904 |
-1,43,281 |
-1,86,266 |
-2,42,145 |
-2,90,574 |
-3,48,689 |
-4,18,427 |
-5,02,113 |
-6,02,535 |
Administrative expenses |
-93,260 |
-1,21,238 |
-1,57,609 |
-2,04,892 |
-2,66,360 |
-3,19,632 |
-3,83,558 |
-4,60,270 |
-5,52,324 |
-6,62,789 |
Marketing expenses |
-1,76,346 |
-2,29,250 |
-2,98,025 |
-3,87,433 |
-5,03,662 |
-6,04,395 |
-7,25,274 |
-8,70,329 |
-10,44,394 |
-12,53,273 |
Occupancy Expenses |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Other expenses |
-1,27,172.76 |
-1,65,324.59 |
-2,14,921.96 |
-2,79,398.55 |
-3,63,218.12 |
-4,35,861.74 |
-5,23,034.09 |
-6,27,640.91 |
-7,53,169.09 |
-9,03,802.91 |
Operating profit |
4,10,545 |
5,33,648 |
6,19,176 |
8,04,868 |
10,46,269 |
12,55,482 |
15,06,539 |
18,07,806 |
21,69,327 |
26,03,153 |
Percentage change |
0% |
30% |
16% |
30% |
30% |
20% |
20% |
20% |
20% |
20% |
Interest income |
6,648 |
9,537 |
8,092 |
11,858 |
15,417 |
17,724 |
25,471 |
29,988 |
31,121 |
33,809 |
Finance cost |
-200 |
-300 |
-300 |
-300 |
-300 |
-300 |
-300 |
-300 |
-300 |
-300 |
Net finance income |
3,155 |
3,470 |
8,817 |
9,699 |
12,669 |
13,936 |
15,330 |
21,863 |
24,049 |
36,454 |
Profit before tax |
4,13,699 |
5,37,118 |
6,27,993 |
8,14,567 |
10,58,938 |
12,69,418 |
15,21,868 |
18,29,669 |
21,93,376 |
26,39,607 |
Income tax expenses |
-1,44,795 |
-1,87,991 |
-2,19,798 |
-2,85,099 |
-3,70,628 |
-4,44,296 |
-5,32,654 |
-6,40,384 |
-7,67,682 |
-9,23,862 |
Profit after tax |
2,68,905 |
3,49,127 |
4,08,196 |
5,29,469 |
6,88,310 |
8,25,122 |
9,89,214 |
11,89,285 |
14,25,695 |
17,15,744 |
Statement of Assets and Liabilities:
PROJECTIONS |
||||||||||
Particulars |
2020 |
2021 |
2022 |
2023 |
2024 |
2025 |
2026 |
2027 |
2028 |
2029 |
Assets |
||||||||||
Current Assets |
||||||||||
Cash and short term deposits |
6,64,777 |
9,53,715 |
8,09,248 |
11,85,770 |
15,41,684 |
17,72,434 |
25,47,124 |
29,98,805 |
31,12,057 |
33,80,897 |
Trade receivables |
67,825 |
88,173 |
1,14,625 |
1,49,013 |
1,93,716 |
2,32,460 |
2,78,952 |
3,34,742 |
4,01,690 |
4,82,028 |
Prepayments |
64,434 |
83,764 |
1,08,894 |
1,41,562 |
1,84,031 |
2,20,837 |
2,65,004 |
3,18,005 |
3,81,606 |
4,57,927 |
Inventories |
1,35,651 |
1,76,346 |
2,29,250 |
2,98,025 |
3,87,433 |
4,64,919 |
5,57,903 |
6,69,484 |
8,03,380 |
9,64,056 |
Total current assets |
9,32,688 |
13,01,999 |
12,62,017 |
17,74,370 |
23,06,864 |
26,90,649 |
36,48,983 |
43,21,035 |
46,98,734 |
52,84,909 |
Non-current assets |
||||||||||
Plant and Machinery |
11,326 |
37,458 |
41,204 |
75,324 |
82,857 |
5,91,142 |
6,50,257 |
7,15,282 |
17,86,811 |
19,65,492 |
Goodwill |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Intangible assets |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
13,000 |
Other financial assets |
3,15,488 |
3,47,036 |
8,81,740 |
9,69,914 |
12,66,906 |
13,93,596 |
15,32,956 |
21,86,251 |
24,04,876 |
36,45,364 |
Deffered Tax Assets |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
8,000 |
Total non-current assets |
3,47,813 |
4,05,495 |
9,43,944 |
10,66,239 |
13,70,762 |
20,05,739 |
22,04,212 |
29,22,534 |
42,12,687 |
56,31,856 |
Total assets |
12,80,501 |
17,07,494 |
22,05,961 |
28,40,608 |
36,77,626 |
46,96,388 |
58,53,195 |
72,43,569 |
89,11,421 |
1,09,16,764 |
Liabilities |
||||||||||
Current Liabilities |
||||||||||
Trade payable |
1,59,458 |
2,28,911 |
2,97,584 |
3,86,860 |
5,02,917 |
6,53,793 |
7,84,551 |
9,41,461 |
11,29,754 |
13,55,704 |
Customer Liabilities |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Income tax payable |
63,985 |
72,397 |
93,996 |
1,09,899 |
1,42,549 |
1,85,314 |
2,22,148 |
2,66,327 |
3,20,192 |
3,83,841 |
Total current liabilities |
2,23,443 |
3,01,308 |
3,91,580 |
4,96,758 |
6,45,467 |
8,39,107 |
10,06,699 |
12,07,788 |
14,49,946 |
17,39,545 |
Non current liabilities |
||||||||||
Trade and other payables |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
Deferred Tax liabilities |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Total non-current liabilities |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
300 |
Total liabilities |
2,23,743 |
3,01,608 |
3,91,880 |
4,97,058 |
6,45,767 |
8,39,407 |
10,06,999 |
12,08,088 |
14,50,246 |
17,39,845 |
Net assets |
10,56,759 |
14,05,885 |
18,14,081 |
23,43,550 |
30,31,859 |
38,56,981 |
48,46,196 |
60,35,480 |
74,61,175 |
91,76,919 |
Equity to owners company |
||||||||||
Share Capital |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
1,44,495 |
Retained earnings |
8,47,347 |
11,96,473 |
15,54,669 |
20,84,138 |
26,72,447 |
-5,02,431 |
4,86,784 |
16,76,068 |
-18,98,237 |
-1,82,493 |
Reserves |
64,917 |
64,917 |
1,14,917 |
1,14,917 |
2,14,917 |
42,14,917 |
42,14,917 |
42,14,917 |
92,14,917 |
92,14,917 |
Foreign currency reserve |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Employee payment reserve |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
Total equity |
10,56,759 |
14,05,885 |
18,14,081 |
23,43,550 |
30,31,859 |
38,56,981 |
48,46,196 |
60,35,480 |
74,61,175 |
91,76,919 |
no. of shares |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
7,30,039 |
Book Value per share |
1.45 |
1.93 |
2.48 |
3.21 |
4.15 |
5.28 |
6.64 |
8.27 |
10.22 |
12.57 |
Free Cash Flow |
200 |
289 |
-144 |
377 |
356 |
231 |
775 |
452 |
113 |
269 |
Discount Rate |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
7% |
no. of years |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
PV of Free Cash Flow |
187 |
252 |
-118 |
287 |
254 |
154 |
482 |
263 |
62 |
137 |
Asset Turnover Ratio |
132% |
129% |
130% |
131% |
132% |
124% |
119% |
116% |
113% |
110% |