Assignment Sample on AAF044-6 Accounting and Finance
1. Introduction
This study will evaluate different types of financial ratios for the previous two years to9 understand their performance. Performance of Ocado Group plc will be compared with Sainsbury group PLC to find gaps in financial and non-financial activities. Along with this investment ratio and capital structure ratio of Ocado Group plc will be calculated in this study to provide recommendations on investment decisions. Moreover, evaluation of financial and non-financial activities will be critically analysed in this study and necessary steps to improve performance will be enlightened.
2. Evaluation performance of Ocado Group Plc over last two years
Financial performance of Ocado Group Plc for last two years
Profitability ratio
Gross profit ratio
Gross profit ratio of Ocado Group Plc in 2019 is around26% and has increased to 28%. As cited by Miransyah and Dempo (2021), the ratio of gross profit is calculated to measure a company’s profitability before deducting indirect expenses. Gross profit ratio is high in Ocado Group Plc the price of products are comparatively higher than competitors.
Gross profit ratio | 2020 | 2019 |
Gross profit/ sales | ||
Gross profits | 650 | 464 |
sales | 2,332 | 1,757 |
Gross profit ratio (%) | 27.87307 | 26.40865111 |
Table 1: Gross profit ratio
(Source: MS Excel)
Net profit ratio
Net profit ratio of Ocado Group Plc is around-12% in 2019 and that will increase to more than -5% in 2020. As opined by Wei et al. (2018), a margin of net profit is actual earnings of a company because every indirect expense has been deducted during calculation of net profit. Ocado Group Plc has been running at a loss for the last two years due to a lack of a proper supply chain.
Calculation of Net profit margin | 2020 | 2019 |
net profit | -126 | -213 |
Sales | 2,332 | 1,757 |
Net profit margin | -5.403087 | -12.12293682 |
Table 2: Net profit margin
(Source: MS Excel)
Liquid ratio
Current ratio
Ocado Group Plc has managed around2.19 in 2019 and more than 4.81 in 2020 current ratio. As per the opinion of Chireka and Fakoya (2017), more than 1.5 currency ratios is considered as an effective ratio that can pay all current liabilities by selling available current assets. Current ratio is significantly high for Ocado Group Plc because the management team is unable to utilise available resources to earn profit.
Current ratio | 2020 | 2019 |
current assets/ current liability | ||
current assets | 2,381 | 1,009 |
current liabilities | 494 | 459 |
Current ratio | 4.819838 | 2.198257081 |
Table 3: Current ratio
(Source: MS Excel)
Quick ratio
The Quick ratio of Ocado Group Plc is around2 in 20196 and around 4.69 in 2020 (ocadogroup.com, 2021). As cited by Haralayya (2021), a large number of current assets are available in Ocado Group Plc but lack of managing financial activities reduced profitability.
Quick ratio | 2020 | 2019 |
current assets | 2,381 | 1,009 |
current liabilities | 494 | 459 |
Inventory | 62.00 | 52.00 |
Liquid ratio | 4.694332 | 2.08496732 |
Table 4: Quick ratio
(Source: MS Excel)
Efficiency ratio
Trade receivable days
Days of trade receivable are around26 days in 2019 and more than 26 days in 2020. As opined by Gong et al. (2019), trade receivable days represent days that are allocated to debtors to pay them due to the company. Ocado Group Plc does not allow its consumers to purchase credit that trade receivable days are low.
Trade receivable days | 2020 | 2019 |
Trade receivable | 167.00 | 124.00 |
Sales | 2,332 | 1,757 |
Trade receivable days | 26.13851 | 25.75981787 |
Table 5: Trade receivable days
(Source: MS Excel)
Trade payable days
Payable days of trade are more than 38 days in 20196 that have decreased to 34 days in 2020 in Ocado Group Plc. Ocado Group Plc has faced competition in management due to the unexpected situation that it takes a long time to pay its suppliers. As per the opinion of Crouzet and Eberly (2018), this company has suffered from managerial issues that it is not efficient enough to pay its dues and suppliers do not allow this company to get materials of credit. Ocado Group Plc is not financially stable because it cannot utilise its available current assets and liabilities efficiently.
Trade payable days | 2020 | 2019 |
Trade Payable | 139 | 121 |
cost of sales | 1,518 | 1,159 |
Trade payable days | 33.42227 | 38.10612597 |
Table 6: Trade payable days
(Source: MS Excel)
Investor’s ratio
Earnings per share
Loss per share of Ocado Group Plc is around -0.29 in 2019 and -1.17 in 2020. As cited by Ko et al. (2017), earning per share represents profitability of a company to attract investors. A large number of investors have withdrawn their investment from Ocado Group Plc because of a consistent loss. Inefficiency of managing available financial resources and lack of controlling power has decreased the share value of Ocado Group Plc.
Earnings per share | 2020 | 2019 |
Profit after tax and dividend | -126 | -213 |
Number of an ordinary share | 107 | 730 |
Earnings per share | -1.17757 | -0.291780822 |
Table 7: Earnings per share
(Source: MS Excel)
Capital structure ratio
Debt equity ratio
Debt Equity ratio of Ocado Group Plc is almost 0.57 in 2019 that has increased to 0.76. Higher ratio of debt to equity represents high risk and the risk of this organisation has increased over the last two years.
Debt equity ratio | 2020 | 2019 |
Total debt | 1405 | 608 |
Total Equity | 1,837 | 1,058 |
Debt equity ratio | 0.764834 | 0.574669187 |
Table 8: Debt equity ratio
(Source: MS Excel)
Assets to equity ratio
Asset to equity ratio of Ocado Group Plc is around 2.16 in 2019 and approximately 2.19 in 2020 that it is necessary to make effective decisions to utilise equity capital to purchase fixed assets that will improve efficiency of this company. Total assets are almost 2293 million GBP in 2019 that will increase to 1837 million GBP in 2020 in Ocado Group Plc.
Assets to equity ratio | 2020 | 2019 |
Total asset | 4,028 | 2,293 |
Total Equity | 1,837 | 1,058 |
Assets to equity ratio | 2.192705 | 2.167296786 |
Table 9: Assets to equity ratio
(Source: MS Excel)
Non-financial performance of Ocado Group Plc for last two years
Online supermarket Ocado Group Plc has cancelled a lot of orders of consumers due to a fire that broke out in a warehouse. This abnormal loss has affected profitability of Ocado Group Plc. As opined by Qin et al. (2019), Ocado Group Plc has invested a lot of funds to build a sustainable supply chain. This company has a large number of financial resources but it has lost its operating area and its performance has declined over the last two years. Around 100 fire-fighters and around15 fire engines have been implemented to control the fire. Ocado Group Plc has invested a large number of funds in developing digital infrastructure of retail marketing but this incident has burnt down every possible success measure of Ocado Group Plc.
preliminary expenses of digital infrastructure are so high that it is hard to compete within the retail industry. As per the opinion of Pinto and Joseph (2019), investors have withdrawn their investments due to consistent loss over the last two years. Ocado Group Plc uses robotic automation technology to provide service to its potential and real consumers. More than 777,000 active consumers are there in Ocado Group Plc that motivates it to create a new sustainable infrastructure that will generate more profit and sustain for a long period.
Online retail store of Ocado Group Plc is based on futuristic technology that allows consumers to buy all necessary groceries for one month within one minute. As cited by Zissis et al. (2017), consumer demand is an ever-changing process that’s affected companies performance and the extra burden of maintaining the sanitisation process has reduced the affected profitability of Ocado Group Plc in 2019.
3. Compare performance of Ocado Group plc to Sainsbury
Gross profit ratio is comparatively lower in Sainsbury than in Ocado Group Plc where consumers get products at a low price. Sainsbury does not include robotic technology that’s its can easily manage uncertainties but Ocado Group Plc has to stop entire production process that cancels so many online orders. Average gross profit is around 7% in Sainsbury over the last two years.
Gross profit ratio | 2020 | 2019 |
Gross profit/ sales | ||
Gross profits | 2294 | 2,200 |
sales | 28,993 | 29,007 |
Gross profit ratio (%) | 7.91225 | 7.58438 |
Table 10: Gross profit ratio
(Source: MS Excel)
Net profit is around0.44% in 2020 and 0.57% in 2019 in Sainsbury. As opined by Saghiri et al. (2017), competitor companies maintain a consistent gross profit ratio to attract investors. . Ocado Group plc is unable to manage its robotic technology because the entire process is automatic but a sudden breakdown of digital tools has affected this organisation.
Calculation of Net profit margin | 2020 | 2019 |
net profit | 129 | 168 |
Sales | 28,993 | 29,007 |
Net profit margin | 0.44493 | 0.57917 |
Table 11: Net profit margin
(Source: MS Excel)
Current ratio of Sainsbury is approximately 0.62 in 2020 and more than 0.63 in 2019 that shows its ability to utilise available assets to manage daily activities. Ocado Group plc is not as efficient as Sainsbury to manage its current assets and liabilities.
Current ratio | 2020 | 2019 |
current assets/ current liability | ||
current assets | 7,582 | 7,550 |
current liabilities | 12,047 | 11,849 |
Current ratio | 0.62937 | 0.63718 |
Table 12: Current ratio
(Source: MS Excel)
Quick ratio is around0.48 in 2020 and around 0.47 in 2019 in Sainsbury it shows an inability of managing current liabilities. Sainsbury will not be able to pay its liabilities without selling inventories. As per the opinion of Walmsley et al. (2018), Ocado Group plc is efficient enough to pay its liabilities without selling its inventories. More than 1 quick ratio helps to reduce managerial complications by providing available working capital to the company and that has been maintained by Ocado Group plc.
Quick ratio | 2020 | 2019 |
current assets | 7,582 | 7,550 |
current liabilities | 12,047 | 11,849 |
Inventory | 1,732 | 1,929 |
Quick ratio | 0.4856 | 0.47439 |
Table 13: Quick ratio
(Source: MS Excel)
Sainsbury is more efficient than Ocado Group plc in that it allows potential debtors to pay their dues within a long period. Trade receivable days are around 54 days in 2019 that has increased to around 60 days in 2020.
Trade receivable days | 2020 | 2019 |
Trade receivable | 4,762 | 4,268 |
Sales | 28,993 | 29,007 |
Trade receivable days | 59.95 | 53.705 |
Table 14: Trade receivable days
(Source: MS Excel)
Trade payable days are around 38 days in 2019 that have been decreased to 37 days in 2020. As opined by Wilczyński (2020), managing financial resources effectively and paying dues within a short period attracts potential investors and suppliers who provide credit services without any complications. Ocado Group plc is more efficient than Sainsbury because it has paid its dues within a shorter period than Sainsbury takes to pay its creditors.
Trade payable days | 2020 | 2019 |
Trade Payable | 2,960 | 3,044 |
cost of sales | 28,993 | 29,007 |
Trade payable days | 37.2642 | 38.3032 |
Table 15: Trade payable days
(Source: MS Excel)
Earnings per share of Sainsbury are around 0.08 in 2019 that has decreased to 0.06 in 2020 due to Covid-19 pandemic period (sainsburys.co.uk, 2021). Sainsbury has executed an attractive EPS during epidemics but share values are in a negative balance in Ocado Group plc.
Earnings per share | 2020 | 2019 |
Profit after tax and dividend | 129 | 168 |
Number of an ordinary share | 2130 | 2100 |
Earnings per share | 0.06056 | 0.08 |
Table 16: Earnings per share
(Source: MS Excel)
Capital structure of Sainsbury is balanced because its debt-equity ratio is around1.06 in 2019 and more than 0.98 in 2020 (sainsburys.co.uk, 2021). Ocado Group plc is dependent on Equity capital and does not have financial infrastructure to manage sources of funds.
Debt equity ratio | 2020 | 2019 |
Total debt | 7419 | 8014 |
Total Equity | 7,525 | 7,534 |
Debt equity ratio | 0.98591 | 1.06371 |
Table 17: Debt equity ratio
(Source: MS Excel)
Assert to Equity ratio is calculated to measure utilisation of equities to purchase assets. Around 3.75 in 2019 asset to equity has been maintained in Sunbury that has been increased to 3.74 in 2020 (sainsburys.co.uk, 2021). As per the opinion of Rahadjeng and Fiandari (2020), this company follows robotic technology to operate daily activities that do not require too many assets to operate business as these technologies are faster than usual speed of operational activities in retail industry. Ocado Group plc is not efficient enough to utilise its available equities to purchase assets.
Asset to Equity ratio | 2020 | 2019 |
Total asset | 28,166 | 28,280 |
Total Equity | 7,525 | 7,534 |
Asset to Equity ratio | 3.74299 | 3.75365 |
Table 18: Asset to Equity ratio
(Source: MS Excel)
4. Recommendation for buying shares of Ocado Group plc
Investment ratio has been discussed in this study to study expected investors’ approach towards Ocado Group Plc for investment. It has seen that As cited by Nugroho and Nurcahyo (2019), Ocado Group Plc has invested a large number of funds to develop automatic warehouse technology but an accident has removed predetermined goals. It is hard to reconstruct a digital infrastructure because it consumes a lot of time and money. Investors will not be able to get a good rate of return on investment within a short period but investing in Ocado Group Plc for a long period can give a high return rate to investors. Net loss of Ocado Group Plc is more than -213 million GBP and that has increased to approximately -126 million GBP.
EPS of Ocado Group Plc has been in a negative balance in the last two financial years due to lack of efficient utilisation of available resources. As opined by Amar et al. (2019), investing in Ocado Group Plc is not profitable because of its inefficient management. Competitor s companies like Tesco and Sainsbury have executed a consistent EPS over years and they are in a financially stable position. Using robotic technology automated data is evaluated through digital tools in Ocado Group Plc that there is a lack of professional viewpoint.
Different effective decisions are made by Ocado Group Plc to recover its loss that purchasing shares at current price will provide excellent growth in upcoming years. Current share price of Ocado Group Plc is around 1635 GBP which has decreased over the year’s ocadogroup.com, (2021). There is no opportunity for short term gain in Ocado Group Plc’s share but can be beneficial for the long term.
5. Conclusion
Based on this study it can be concluded that Ocado Group Plc has suffered to manage profitability for the last two years. Fire broke out and incidents affected the share price of Ocado Group Plc and a large number of investors have withdrawn their funds from it. This company has maintained its liquidity but is unable to manage its current liabilities and assets to operate business activities. It has been found that this company does not allow a longer period for its consumers to recover its dues and it pays its suppliers within short period compared to competitors.
Competitors’ companies focus on total utilisation of available resources but lack of management controlling power entire operational activities are affected. Market competitors of the retail industry have provided consistent growth and high EPS in the last two years as compared to Ocado Group Plc. investing in this company is not profitable for a short period but long term investment can be profitable for investing in Ocado Group Plc.
References
Journals
Amar, J., Candelon, B., Lecourt, C. and Xun, Z., 2019. Country factors and the investment decision-making process of sovereign wealth funds. Economic Modelling, 80, pp.34-48.Available at: https://www.sciencedirect.com/science/article/pii/S0264999317318254
Chireka, T. and Fakoya, M.B., 2017. The determinants of corporate cash holdings levels: evidence from selected South African retail firms. Investment Management & Financial Innovations, 14(2), p.79.Available at: https://www.academia.edu/download/53923055/The_determinants_of_corporate_cash_holdings_levels.pdf
Crouzet, N. and Eberly, J., 2018, May. Intangibles, investment, and efficiency. In AEA Papers and Proceedings (Vol. 108, pp. 426-31).Available at: https://www.aeaweb.org/articles?id=10.1257/pandp.20181007
Eko, E.N., Adebisi, A.W. and Moses, E.J., 2020. Evaluation of Forensic Accounting Techniques in Fraud Prevention/Detection in the Banking Sector in Nigeria. International Journal of Finance and Accounting, 9(3), pp.56-66.Available at: https://www.researchgate.net/profile/Uket-Ewa/publication/344840658_Evaluation_of_Forensic_Accounting_Techniques_in_Fraud_PreventionDetection_in_the_Banking_Sector_in_Nigeria/links/5f92d05b299bf1b53e3da8c1/Evaluation-of-Forensic-Accounting-Techniques-in-Fraud-Prevention-Detection-in-the-Banking-Sector-in-Nigeria.pdf
Gong, Y., Liu, J. and Zhu, J., 2019. When to increase firms’ sustainable operations for efficiency? A data envelopment analysis in the retailing industry. European Journal of Operational Research, 277(3), pp.1010-1026.Available at: https://www.sciencedirect.com/science/article/pii/S0377221719302589
Haralayya, B., 2021. Ratio Analysis at NSSK, Bidar. Iconic Research And Engineering Journals, 4(12), pp.170-182.Available at: https://www.irejournals.com/formatedpaper/1702793.pdf
Ko, K., Chang, M., Bae, E.S. and Kim, D., 2017. Efficiency analysis of retail chain stores in Korea. Sustainability, 9(9), p.1629.Available at: https://www.mdpi.com/223648
Miransyah, G.G. and Dempo, S.R.S., 2021. Profitability Ratio Analysis at PT. Medikaloka Hermina, TBK. BINA BANGSA INTERNATIONAL JOURNAL OF BUSINESS AND MANAGEMENT, 1(1), pp.60-67.Available at: http://bbijbm.lppmbinabangsa.id/index.php/home/article/view/7
Nugroho, M. and Nurcahyo, Y.E., 2019. Investment Decision Making: The System Performance of the Portfolio of Shares on Index Business 27 (2017-2018) using the Model of Constant Correlation. International Review of Management and Marketing, 9(5), p.95.Available at: https://search.proquest.com/openview/0ddac2fc69f6ca3a42d867f31c01de6a/1?pq-origsite=gscholar&cbl=816339
Pinto, P. and Joseph, N.R., 2017. Capital structure and financial performance of banks. International Journal of Applied Business and Economic Research, 15(23), pp.303-312.Available at: https://www.researchgate.net/profile/Naveen-Kumar-239/publication/323685580_Capital_Structure_and_Financial_Performance_of_Banks/links/5aa41c230f7e9badd9a9ad93/Capital-Structure-and-Financial-Performance-of-Banks.pdf
Qin, X., Shen, X., Sun, H. and Guo, Q., 2019. A quasi-dynamic model and corresponding calculation method for integrated energy system with electricity and heat. Energy Procedia, 158, pp.6413-6418.Available at: https://www.sciencedirect.com/science/article/pii/S187661021930205X
Rahadjeng, E.R. and Fiandari, Y.R., 2020. The Effect of Attitude, Subjective Norms and Control of Behavior towards Intention in Share Investment. Jurnal Manajemen Bisnis, 10(2), pp.17-25.Available at: https://eprints.umm.ac.id/71194/
Saghiri, S., Wilding, R., Mena, C. and Bourlakis, M., 2017. Toward a three-dimensional framework for omni-channel. Journal of Business Research, 77, pp.53-67.Available at: https://www.sciencedirect.com/science/article/pii/S0148296317301133
Walmsley, T.G., Walmsley, M.R., Varbanov, P.S. and Klemeš, J.J., 2018. Energy Ratio analysis and accounting for renewable and non-renewable electricity generation: A review. Renewable and Sustainable Energy Reviews, 98, pp.328-345.Available at: https://www.sciencedirect.com/science/article/pii/S1364032118306774
Wei, C., Asian, S., Ertek, G. and Hu, Z.H., 2018. Location-based pricing and channel selection in a supply chain: a case study from the food retail industry. Annals of Operations Research, pp.1-26.Available at: https://link.springer.com/article/10.1007/s10479-018-3040-7
Wilczyński, A., 2020. Farm economic sustainability–financial ratio analysis. Prace Naukowe Uniwersytetu Ekonomicznego we Wrocławiu, 64(2), pp.120-131.Available at: http://cejsh.icm.edu.pl/cejsh/element/bwmeta1.element.desklight-e5762f0c-269e-4c48-ac57-2b18381e04c0
Zissis, D., Aktas, E. and Bourlakis, M., 2017. A new process model for urban transport of food in the UK. Transportation research procedia, 22, pp.588-597.Available at: https://www.sciencedirect.com/science/article/pii/S2352146517301837
Website
ocadogroup.com, (2021), ANNUAL REPORT. Available at: https://www.ocadogroup.com/ [Accessed on 10th December 2021]
sainsburys.co.uk, (2021), ANNUAL REPORT. Available at: https://www.sainsburys.co.uk/
[Accessed on 10th December 2021]