Tesco Plc Report : Business Model Assignment Sample

Tesco Plc: Business Insights and Financial Analysis

  • 72780+ Project Delivered
  • 500+ Experts 24x7 Online Help
  • No AI Generated Content
GET 35% OFF + EXTRA 10% OFF
- +
35% Off
£ 6.69
Estimated Cost
£ 4.35
32 Pages 8101 Words

Introduction Of Tesco Plc Report: International Accounting And Finance

The company introduction that will be offered includes all important non-financial features associated with the selected company classified as Tesco Plc. Main activities and business model along with main markets served and typical features affecting company performance will be cohesively discussed in this part of the report.

Main activities and business model

The main activities conducted by Tesco are mostly associated with retail-based functions that include offering a wide variety of products and services to generic customers that could be used for luxury as well as daily usage. These activities can be further classified based on offering supermarket services, providing doorstep delivery for household goods along with offering financial services in the form of insurance. The business model of Tesco is considered to be a highly flexible one whose foundation is highly dependent upon four important characteristics comprising product, customers, distribution and reinvestment (tescoplc.com, 2023). The following is a classified assessment of products and services sold along with competitive advantage parameters applicable for Tesco.

Products and services sold

Products and services sold by Tesco are considered to be daily care and luxury goods that range from books to household furniture and groceries. Additional emphasis is also being laid by Tesco to offer telecommunication services by expanding its business catalogue towards internet streaming services.

Did you Like Our Samples from Our Delivered work?
Connect with us and make it yours in the Same Quality Order AI-FREE Content Help For Assignment Accounting Assignment Help Online

Competitive advantage parameters

Competitive advantage parameters employed by Tesco mainly include the need to implement cost leadership which highlights the ability to control operating costs and place a variety of costing strategies to achieve best financial feasibility for each product.

1.2: Main markets served

Figure 1: Revenue Generated by Tesco based on Regions

Revenue Generated by Tesco based on Regions

(Source: statista.com, 2023)

  • Region: Region of service by Tesco is considered to be the United Kingdom, Republic of Ireland, partial countries belonging in Central Europe as well as in the Asian subcontinent.
  • Product: Products served by Tesco are classified under wholesale products as well as retail products which are placed in the market by emphasising a reasonable pricing strategy.
  • Customer Type: Customer type associated is considered to be a highly flexible age range that is meant to purposefully serve customers from the age group of 5 to 85 years.
  • Typical features affecting company performance
  • Demographics: The impact of demographics is considered to be highly influential where factors including lower proportion of female workers could implicate lower business sustainability in future for Tesco.
  • Social Trends: Non consideration to employ digital marketing strategies could implicate company performance associated due to lack of engagement for social trends.
  • Consumer Behaviour: Ineffective product qualities and higher pricing are deemed to be important factors affecting company performance based on consumer behaviour for Tesco.
  • Fashion: Affordability, availability and potential generation of lower brand value could implicate company performance due to changes in fashion of customers.
  • Changes in Global Trading Patterns:Lack of ample scope for international trading could be considered a major influence affecting the performance of Tesco based on global trading patterns.
  • Environmental Issues: Encouragement to usage of plastic items could be considered as a major impact leading to business unsustainability for Tesco due to environmental issues.

Sector Review

The sector review applicable for Tesco will be determined on the basis of identifying key market forces that are driving demand along with identification of relative measurement involved under sector competition in the industry where Tesco belongs. Discussion on future prospects along with specific market forces and numerical and statistical evidence will further be offered in this part of the report to ascertain overall sector strengthening forces that Tesco holds.

Key market forces driving demand

The key market forces driving demand for Tesco include branding, integration of technology, supplier management as well as strategic alliances and collaboration. The following is an individual illustration of all important market forces that drive demand for products for Tesco in the UK retail and wholesale industry.

Branding

Branding is identified as the primary market force that drives demand in the industry for Tesco to facilitate healthy movement of goods and services both domestically as well as internationally. As per opinions and explanations of Van Hoa et al. (2022), branding is also alternatively termed as organisational loyalty from customers perspective which usually leads to generation of a higher goodwill value for an organisation. The process of branding employed by Tesco is identified as an integrated and cohesive approach adopted to facilitate better recycling of products to ensure a higher product life cycle. Moreover, innovation is also considered to be an influential driving tool associated with branding of Tesco in which product improvisation is being adopted on frequent intervals. Branding and higher brand value is further achieved by Tesco by offering various cash and non-cash incentives for its customers including discounts and loyalty token systems. The branding of Tesco is further determined on the basis of popularity percentage prevailing in UK which is considered to be 57% popular as of 2022 (statista.com, 2022)

Integration of Technology

Integration of Technology is identified as the second important driving force for Tesco which maximises demand for products in the generic UK retail and wholesale market. Integration of technology mainly includes consideration to adopt digital marketing and social media strategies in order to encourage a higher flexibility to necessitate daily business conduct and operations. Technological integration is also identified as an important driving force that establishes healthy stakeholder relationships along with encouraging Tesco to obtain a higher market concentration and reach.

Integration of technology also encourages Tesco to ensure that a higher number of suppliers can be brought on board and product distribution streams could be more synchronised in order to gain a higher operational scalability parameter. Abdulazizovich (2022), illustrated and explained that the role of technology is deemed to be essential in order to drive new-age business sustainability prospects and also ensure that an organisation has ample scope to introduce new product ranges in the market. Usage of RFID tagging for tracking delivery of goods along with big data implementation can be considered an integral part of technological integration by Tesco that maximises its corporate robustness in the industry.

Figure 2: Technological Integration by Tesco

Technological Integration by Tesco

(Source: globaldata.com, 2022)

Supplier Management

Supplier management is identified as the third important market force that is driving demand for Tesco to keep itself relevant in the retail and wholesale market of the UK. Supplier management is alternatively considered to be linked with vendor management where an ideal scenario would allow Tesco to bring on board a higher plethora of suppliers to focus on high product facilities. The availability of higher suppliers also encourages Tesco to minimise and reduce cost burdens applicable for manufacturing and operational concern and generate a higher proportion of profitability. Supplier management is also considered to be an integral component of stakeholder harmony and association that ensures Tesco's priority towards Business development along with stakeholder maximisation and bundling.

Strategic Alliances and Collaboration

Strategic alliances and collaboration are identified as the fourth important market force driving demand for Tesco. Strategic alliances and collaborations mainly consider business partnerships and ventures with domestic as well as international market players in order to ensure business growth and development in the foreseeable future (Tettamanzi, Venturini & Murgolo, 2022). Strategic partners and collaborators of Tesco and identified as Decathlon, Intellio and RangeMe all of whom are considered to be influential players belonging to the retail market in the UK.

Relative measurement of sector competition

The retail and wholesale market in the UK is considered to be a highly proactive sector where the relevance and traces of market competition are considered to be weighed on higher scales. The relative measurement of sector competition can be further determined on the basis of annual sales revenue generated. The figures for 2021 and 2022 are considered to be valued as GBP 464.16 and GBP 495.71 billion respectively ( statista.com, 2023). Therefore, it can be evaluated that the relative competition existing in the UK is significantly higher than other established countries which also encourages Tesco to maximise its market share and earn a higher profitability proportion from continued operations.

Figure 3: Relative Measurement of Sector Competition

Relative Measurement of Sector Competition

(Source: statista.com, 2023)

Future prospects

The future prospects identified for Tesco are considered to be mostly favourable due to its availability of higher market share to substantiate business development and progression. The future prospects would likely encourage the concerned managerial loggerhead of Tesco to improvise more towards its product service facilities in order to garner a higher customer association in future. Additional services can also be incorporated as part of future prospects that could include mobile based and application-based business drive that would encourage bringing onboard more customers within its business purview. Moreover, territorial expansion into other countries can be contemplated as important future prospect strategies that would allow Tesco to collaborate with more companies and grab a higher market share overseas.

Specific Market Forces

Specific market forces mainly include branding and overseas collaborations for Tesco in order to ensure that the organisation achieves its long-term business goals and objectives. These market forces have been selected specifically since they are identified as important driving parameters where applicability and implementation would allow Tesco to obtain a higher market share both domestically as well as internationally.

Company Assessment

Identification of Peers and competitors

Peers and competitors identified for ratio analysis include Sainsbury, Marks and Spencers and Morrisons. Under performance ratios, net profit ratio will be calculated for a period of 5 years between 2022 to 2018. Calculation of quick ratio will be contemplated under liquidity parameters, while calculation of gearing ratio will be contemplated under solvency parameters. Under efficiency parameters calculation of receivable turnover ratios will be considered from 2022 to 2018. Additional ratio calculations have also been sufficed in detail containing calculations conducted for Tesco from 2022 to 2018.

Calculation and Analysis of Financial Ratios

Performance Ratios

Performance Ratios
Tesco
Net Profit Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Net Profit £ 1,483.00 £ 5,958.00 £ 973.00 £ 1,270.00 £ 1,208.00
Sales £ 61,344.00 £ 57,887.00 £ 64,760.00 £ 63,911.00 £ 57,491.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
2.42% 10.29% 1.50% 1.99% 2.10%
Sainsbury
Net Profit Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Net Profit £ 854.00 -£ 164.00 £ 255.00 £ 202.00 £ 309.00
Sales £ 29,895.00 £ 29,048.00 £ 28,993.00 £ 29,007.00 £ 28,456.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
2.86% -0.56% 0.88% 0.70% 1.09%
Marks and Spencers
Net Profit Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Net Profit £ 309.00 -£ 201.20 £ 27.40 £ 45.30 £ 29.10
Sales £ 10,885.10 £ 9,155.70 £ 10,181.90 £ 10,377.30 £ 10,698.20
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
2.84% -2.20% 0.27% 0.44% 0.27%
Morrisons
Net Profit Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Net Profit -£ 25.00 -£ 247.00 £ 348.00 £ 233.00 £ 311.00
Sales £ 18,479.00 £ 13,483.00 £ 17,536.00 £ 17,735.00 £ 17,262.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
-0.14% -1.83% 1.98% 1.31% 1.80%

Table 1: Performance Ratios

According to above calculation of performance ratios, NPR for Tesco in 2022 and 2021 has been calculated as 2.42% and 10.29%. NPR for Sainsbury in 2022 and 2021 has been calculated as 2.86% and -0.56% respectively, while NPR for Marks and Spencers has been calculated as 2.84% and -2.20%. The NPR for Morrisons during the same period has been calculated as -0.14% and -1.83%. Hence, it can be inferred that trend of performance for Tesco is decreasing in 2022, while trends for competitors is observed to be an increasing one. As illustrated by Hosiyatovich, Kadirovich & Ikromovich (2023), decreasing performance ratio trends are considered to be adverse parameters which mostly indicate higher operational costs and inadequate revenue substantiation.

Liquidity Ratios

Liquidity Ratios
Tesco
Quick Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Quick Assets £ 9,850.00 £ 8,133.00 £ 10,731.00 £ 9,961.00 £ 11,314.00
Current Liabilities £ 16,125.00 £ 15,721.00 £ 17,927.00 £ 20,973.00 £ 19,238.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.61 0.52 0.60 0.47 0.59
Sainsbury
Quick Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Quick Assets £ 4,945.00 £ 5,522.00 £ 5,854.00 £ 5,629.00 £ 6,056.00
Current Liabilities £ 9,868.00 £ 11,829.00 £ 12,047.00 £ 11,849.00 £ 10,302.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.50 0.47 0.49 0.48 0.59
Marks and Spencers
Quick Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Quick Assets £ 1,476.20 £ 970.60 £ 650.90 £ 734.70 £ 536.90
Current Liabilities £ 1,960.90 £ 1,599.00 £ 1,849.40 £ 2,324.90 £ 1,826.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.75 0.61 0.35 0.32 0.29
Morrisons
Quick Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Quick Assets £ 1,033.00 £ 809.00 £ 662.00 £ 666.00 £ 592.00
Current Liabilities £ 5,371.00 £ 4,120.00 £ 3,396.00 £ 3,349.00 £ 3,081.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.19 0.20 0.19 0.20 0.19

Table 2: Liquidity Ratios

Liquidity ratio calculations mainly considered QR as the main ratio for which numerical figures for Tesco in 2022 and 2021 have been calculated as 0.61 and 0.52:1. QR for Sainsbury has been subsequently calculated as 0.50 and 0.47:1, while QR for Marks and Spencers includes numerical figures of 0.75 and 0.61:1. The QR calculated for Morrisons in 2022 and 2021 indicates numerical expressions of 0.19 and 0.20:1 and hence, it can be determined that performance of Marks and Spencers in 2022 is superior. An increasing trend in performance of 2022 can be witnessed for Tesco, Sainsbury and Marks and Spencers while a decreasing trend can be established for Morrisons. As explained by Botica Redmayne et al. (2023), an increasing liquidity trend further encourages an organisation to avail higher cash influxes to substantiate short-term asset and liability management.

Solvency Ratios

Solvency Ratios
Tesco
Gearing Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Debt £ 17,568.00 £ 17,456.00 £ 21,122.00 £ 22,493.00 £ 15,166.00
Debt+Equity £ 33,212.00 £ 29,515.00 £ 34,375.00 £ 35,949.00 £ 25,624.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.53 0.59 0.61 0.63 0.59
Sainsbury
Gearing Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Debt £ 8,621.00 £ 6,730.00 £ 8,117.00 £ 8,380.00 £ 4,288.00
Debt+Equity £ 17,044.00 £ 13,183.00 £ 15,890.00 £ 16,162.00 £ 11,699.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.51 0.51 0.51 0.52 0.37
Marks and Spencers
Gearing Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Debt £ 4,154.70 £ 4,055.80 £ 4,626.00 £ 4,056.90 £ 2,770.00
Debt+Equity £ 7,072.60 £ 6,341.60 £ 8,334.50 £ 6,526.10 £ 5,724.20
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.59 0.64 0.56 0.62 0.48
Morrisons
Quick Ratio Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Quick Assets £ 2,106.00 £ 3,206.00 £ 2,983.00 £ 2,992.00 £ 2,041.00
Current Liabilities £ 6,284.00 £ 7,390.00 £ 7,524.00 £ 7,317.00 £ 6,586.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
0.34 0.43 0.40 0.41 0.31

Table 3: Solvency Ratios

Solvency ratio calculations include calculation of GR for 2022 and 2021 in which numerical expressions identified for Tesco are calculated as 0.53 and 0.59 times respectively. GR calculated for Sainsbury and Marks and Spencers include numerical expressions of 0.51, 0.51 and 0.59 and 0.64 times. GR calculated for Morrisons further includes numerical expressions of 0.34 and 0.43 times respectively. Overall, it can be ascertained that performance of Marks and Spencers under solvency is marginally superior in comparison to Tesco and other competitors. Trend identified for Tesco, Marks and Spencers and Morrisons is considered to be a decreasing one, while performance of Sainsbury is considered to be stagnated. Flayyih, Mutashar & Murad (2022), illustrated that a decreasing trend for GR could implicate low investor harmony leading to inefficient leverage prospects.

Efficiency Ratios

Efficiency Ratios
Tesco
Receivable Turnover Ratios Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Sales £ 61,344.00 £ 57,887.00 £ 64,760.00 £ 63,911.00 £ 57,491.00
Receivables £ 1,263.00 £ 1,263.00 £ 1,396.00 £ 1,550.00 £ 1,482.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
48.57 45.83 46.39 41.23 38.79
Sainsbury
Receivable Turnover Ratios Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Sales £ 29,895.00 £ 29,048.00 £ 28,993.00 £ 29,007.00 £ 28,456.00
Receivables £ 683.00 £ 725.00 £ 811.00 £ 630.00 £ 744.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
43.77 40.07 35.75 46.04 38.25
Marks and Spencers
Receivable Turnover Ratios Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Sales £ 10,885.10 £ 9,155.70 £ 10,181.90 £ 10,377.30 £ 10,698.20
Receivables £ 217.10 £ 209.60 £ 298.00 £ 267.20 £ 308.40
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
50.14 43.68 34.17 38.84 34.69
Morrisons
Receivable Turnover Ratios Amount 2022 Amount 2021 Amount 2020 Amount 2019 Amount 2018
Sales £ 18,479.00 £ 13,483.00 £ 17,536.00 £ 17,735.00 £ 17,262.00
Receivables £ 379.00 £ 427.00 £ 353.00 £ 344.00 £ 250.00
Ratio 2022 Ratio 2021 Ratio 2020 Ratio 2019 Ratio 2018
48.76 31.58 49.68 51.56 69.05

Table 4: Efficiency Ratios

Calculation of efficiency ratios include consideration to RTR in which numerical expressions acquired for Tesco include figures of 48.57 and 45.83 times in 2022 and 2021. RTR values for Sainsbury and Marks and Spencers have been calculated as 43.77, 40.07 and 50.14 and 43.68 times. RTR for Morrisons includes figures of 48.76 and 31.58 and it can be determined that performance of Marks and Spencer's is considerably superior to its competitors. Trend of RTR performance for all companies in 2022 is considered to be an increasing one. An increasing trend of RTR mainly indicates favourable terms to accumulate faster collection of customer credits that yield better cash flow availability (Polzer, Grossi & Reichard, 2022).

Forecasting

Assumptions

The assumptions associated with revenue include that the forecasting period considered is from 2023 to 2027. Expected increase in revenue for Tesco is considered to be 5% each year considering revenue values acquired in 2022. The proportion of cost of sales is forecasted to be 45% of revenues for 5 years and operating costs are considered to be 25% of revenues. Proportion of non-cash operating expenses is further considered to be 8% of revenues and is constituted by interest expenses and tax rate considered will be fixed uniformly at 20% on earnings.

Interest on debt paid is further considered to be 7% of total debt value uniform for all five years of forecast. Expected dividend growth rate is considered to be 4% from 2023 to 2027. Capital expenditure is forecasted to increase by 6% from 2023 to 2027 and depreciation is assumed to be 10% on capital expenditure and working capital is expected to increase by 4% every year. Assumptions also include an increase in fixed assets of 5%, while equity is measured on the basis of considering the debt-equity ratio metric arrived for Tesco in 2022. The additional balances for assets and liabilities will be adjusted based on considering an assumed value of other assets.

Forecast for revenue

Revenue and Earnings Forecast for Tesco Plc (M)
Items 2022 2023 2024 2025 2026 2027
Sales £ 61,344.00 £ 57,887.00 £ 64,760.00 £ 63,911.00 £ 57,491.00 £ 60,365.55
Add: Expected Increase @5% £ 3,067.20 £ 3,238.00 £ 3,195.55 £ 2,874.55 £ 3,018.28
Total Revenue Forecasted £ 61,344.00 £ 60,954.20 £ 67,998.00 £ 67,106.55 £ 60,365.55 £ 63,383.83

Table 5: Forecasted Revenue

According to the above revenue forecast, it can be identified that revenue expected to be generated by Tesco from 2023 to 2027 is considered to be GBP 61,344, GBO 60,954, GBP 67,998 , GBP 60,365 and GBP 63,383.33. The forecasting of revenue is considered to be an important preposition for an organisation to drive future sustainability and accomplish financial goals and objectives (He et al. 2022).

Forecast for Expenses

Forecast for Expenses of Tesco from 2023 to 2027
Items 2023 2024 2025 2026 2027
Cost of Sales £ 27,429.39 £ 30,599.10 £ 30,197.95 £ 27,164.50 £ 28,522.72
Operating Expenses £ 15,238.55 £ 16,999.50 £ 16,776.64 £ 15,091.39 £ 15,845.96
Interest £ 2,681.98 £ 2,991.91 £ 2,952.69 £ 2,656.08 £ 2,788.89
Total Expenses Forecasted £ 45,349.92 £ 50,590.51 £ 49,927.27 £ 44,911.97 £ 47,157.57
Table 6: Forecasted Expenses

The above table of forecasted expenses include numerical expressions of GBP 45,349.92, GBP 50,951.51, GBP 49,927.27 , GBP 44,911.97 and GBP 47,157.57. According to Abass, Flayyih & Hasan (2022), forecasting of expenses mainly include manufacturing and operating as well as non-operating expenses which are further classified as cost of sales, operating expenses and interest expenses.

Forecast of Net Income and Earnings from tax, debt and interest rates

Figure 4: Forecasted Earnings after Tax
Forecast for Interest and Debt of Tesco from 2023 to 2027
Items 2023 2024 2025 2026 2027
Interest Expenses £ 4,876.34 £ 5,439.84 £ 5,368.52 £ 4,829.24 £ 5,070.71
Percentage of Interest on Debt 8.00% 8.00% 8.00% 8.00% 8.00%
Debt Value £ 60,954.20 £ 67,998.00 £ 67,106.55 £ 60,365.55 £ 63,383.83

Table 7: Interest and Debt Forecast

The above forecast for interest and debt indicates numerical values of GBP 60,954, GBP 67,988, GBP 67,106.55, GBP 60,365.55 and GBP 63,383.83. Gao (2022), stated that debt and interest forecast is considered to be an integral part of the assessment of long-term liabilities expected by an organisation in the future.

Dividends from earnings and payout ratios

Forecasted dividend calculated above is numerically expressed as GBP 760.24, GBP 790.65, GBP 822.28, GBP 855.17 and GBP 889.37. Isaev (2022), illustrated that forecasts of dividends and payout ratios are important to ascertain expected levels of stakeholder harmony needed to be incorporated to define future business sustainability.

Cash flow from working capital and depreciation accruals

FCF forecasted from above is considered to contain numerical values of GBP 22,732.14, GBP 24,713.67, GBP 24,800, GBP 23,493.16 and GBP 24,538.33. As Gómez-Villegas & Larrinaga (2023), explained that the forecast of free cash flows is mostly conducted by considering values of operating profit, net working capital changes, capital expenditures and depreciation.

Balance sheet from accruals, retained earnings and cash flows

From the above balance sheet forecast, values of assets and liabilities speculated to be GBP 106,134.67, 115,790.38, 116,172.33, 109,735.90 and 114839.78. Schmidthuber, Hilgers & Hofmann (2022), illustrated that the forecast of the balance sheet is further deemed to be necessary to identify the final statement of financial positioning.

Valuation

Dividend Discounting Model

In order to apply the dividend discounting model, the expected market rate of return in the UK is considered to be 14.38% or 14% rounded off (tradingeconomics.com, 2023). The speculated growth rate for the future in the UK is considered to be 7.5% considering investments in the capital markets (datacommons.org, 2023). The application of the dividend discounting model will be considered from 2023 to 2027.

Valuation of Dividend Discount Model for Tesco
Items 2023 2024 2025 2026 2027
Dividend £ 760.24 £ 790.65 £ 822.28 £ 855.17 £ 889.37
Growth Rate 7.50% 7.50% 7.50% 7.50% 7.50%
Market Return 14.00% 14.00% 14.00% 14.00% 14.00%
Dividend Discount Model £ 11,696.00 £ 12,163.84 £ 12,650.39 £ 13,156.41 £ 13,682.67

Table 8: DDM

Discounted Cash Flow

The calculation of discounted cash flow will be considered on the basis of applying time value of money that includes free cash flows and cost of capital. In order to calculate cost of capital values of debt and equity will be considered along with calculation of weighted average cost of capital. The speculated risk-free rate, beta and market risk premium in the UK is considered to be 1.3%, 0.52 and 5.6% respectively.

Calculation of Discounted Cash Flows for Tesco
Items 2023 2024 2025 2026 2027
Free Cash Flow £ 22,732.14 £ 24,713.67 £ 24,800.40 £ 23,493.16 £ 24,538.33
Discounting Factor 0.93 0.87 0.82 0.76 0.71
Discounted Cash Flows £ 21,244.99 £ 21,585.88 £ 20,244.51 £ 17,922.82 £ 17,495.49

Table 9: DCF

As per above calculations, Cost of equity, WACC has been calculated as 3.54% and 7% respectively. Moreover, DCF calculated from 2023 to 2027 includes numerical expressions of GBP 21,244.99, GBP 21,585.88, GBP 20,244.51, GBP 17,922.82 and GBP 17,495.49 respectively. The relevance and significance of DCF is considered to be essential in order to ascertain future viability and reliability associated with prospective investments and projects (Alabdullah, 2022).

Relative Valuation Methods

In order to conduct application of relative valuation methods, consideration to determine EV/ Revenue will be conducted. EV is also termed as enterprise value and is determined by adding debt and equity and differentiating it with free cash flows (Garanina, Ranta & Dumay, 2022).

Calculation of Relative Models for Tesco
Items 2023 2024 2025 2026 2027
Debt + Equity £ 77,067.52 £ 84,594.72 £ 84,201.17 £ 77,973.01 £ 81,519.51
Free Cash Flows £ 22,732.14 £ 24,713.67 £ 24,800.40 £ 23,493.16 £ 24,538.33
Enterprise Value £ 54,335.38 £ 59,881.05 £ 59,400.77 £ 54,479.85 £ 56,981.18
Sales £ 57,887.00 £ 64,760.00 £ 63,911.00 £ 57,491.00 £ 60,365.55
EV/ Revenue 93.86% 92.47% 92.94% 94.76% 94.39%

Table 10: EV/ Revenue

EV/ Revenue for Tesco in 2023, 2024, 2025, 2026 and 2027 has been calculated as 93.86%, 92.47%, 92.94%, 94.76% and 94.39% respectively. The additional relative valuation methods include price to sales ratios for which numerical expressions identified for Tesco in 2022 are considered to be 0.30 times (finance.yahoo,com, 2023). Comparison with peer ratios also indicate values of price to sales ratio achieved for Sainsbury being calculated as 0.20 times (finance.yahoo.com, 2023a). Price to sales for Marks and Spencers has been calculated as 0.38 (finance.yahoo.com, 2023b). Price to Sales for Morrisons has been calculated as 0.40 times (tools.morningstar.co.uk, 2023). Hence, the price to sales ratios for Morrisons is considered to be superior in comparison to its competitors.

Forecast of Sales, Earnings and Book Value of Equity

The forecast of book value of equity will be conducted by deducting forecasting values of total assets and total liabilities.

Calculation of Book Value of Equity for Tesco
Items 2023 2024 2025 2026 2027
Total Assets £ 1,04,726.71 £ 1,14,340.18 £ 1,14,678.63 £ 1,08,197.38 £ 1,13,255.10
Total Liabilities £ 77,885.45 £ 85,775.81 £ 85,773.25 £ 79,965.59 £ 83,963.87
Book Value £ 26,841.26 £ 28,564.36 £ 28,905.38 £ 28,231.80 £ 29,291.24

Table 11: BV

As per above table of calculations for BV, numerical expressions achieved from 2023 to 2027 have been calculated as GBP 26841.26, 28,567.236, 28905.38, 28.231.80 and 29,921.24.

Sensitivity Analysis

Sensitivity analysis shall be conducted based on taking variables including growth, cost of equity and cost of capital to determine share pricing and valuation for Tesco.

Assumed Changes Cost of Equity 264.7
-15.0% 6.0% 264.7
-10.0% 6.3% 264.7
-5.0% 6.7% 264.7
0.0% 7.0% 264.7
5.0% 7.4% 264.7
10.0% 7.7% 264.7
15.0% 8.1% 264.7
Assumed Changes Growth 264.7
-15.0% 6.4% 264.7
-10.0% 6.8% 264.7
-5.0% 7.1% 264.7
0.0% 7.50% 264.7
5.0% 7.9% 264.7
10.0% 8.3% 264.7
15.0% 8.6% 264.7

Table 12: Sensitivity Analysis

Flat 35% Discount on your first order!
& Extra 10% OFF on your WhatsApp order!
Place Order Now Live Chat Whatsapp Order

As per the above table of calculations, it can be determined that the sensitivity analysis portrays no relations or changes in share pricing when influenced due to cost of capital or growth. This also indicates that share pricing of Tesco is fairly dependent upon determination of internal corporate principles that influence share price strategies in the capital and share markets.

Recommendation and Conclusion

Recommendation

The recommendations applicable for the concerned managerial spearhead of Tesco is mostly associated with identifying additional revenue generation streams in order to maximise performance ratios. The relevance and significance of identifying additional revenue generation streams is also necessary to ensure that an adequate balance of cash inflows is kept to maintain plausible liquidity levels for short term and long-term basis. The additional recommendations identified for Tesco Plc are considered to be related with determining techniques through which operational optimisation can be conducted in order to encourage a better efficiency ratio performance. The efficiency ratio performance backed due to RTR mostly indicates sales being contemplated on cash basis rather than credit basis and this should be rectified by allowing more credit facilities and also simultaneously engaging cost saving tactics.

The recommendations offered to Tesco are further considered to be related with valuation basis in which higher emphasis on equity source of funding is needed to be engaged. The capital structure identified for Tesco is mostly dominated by debt sources of financing which could possess threats of overleveraging and could implicate financial disharmony and difficulties. The identification of adequate sources through equity funding would also encourage Tesco to foster business development relationships with stakeholders and leapfrog its competitors with respect to business dominance and competitive advantage achieved in the retail and wholesale industry. Consideration to lean manufacturing can also be incorporated as a suitable recommendation offer to the management of Tesco that pacifies delivery time and empowers higher onboarding of prospective buyers and customers.

Conclusion

This report has mainly established that the company concerned Tesco is mostly associated with conducting activities relating to retail and wholesale segments in the UK. Major production services sold and offered belong to the daily care and luxury categories which are mostly factualised on the basis of implementing cost leadership strategies. The main market of operations for Tesco is further identified to be UK, Ireland and parts of Central Europe as well as Asia. Typical features affecting company performance include demographic factors that are further divided based on concentration of female workers identified under the working environment of Tesco. Main forces of market drivers are considered to be technological integration and strategic alliances and collaborations. These market forces contain favourable and plausible opportunities that could allow Tesco to succeed financially and non-financially if appropriate marketing and business conduct strategies are implemented.

Additional important attributes of this report discussed the financial performance of Tesco and its competitors where trends identified for performance ratio and solvency ratios are considered to be a decreasing one. Performance trends identified in 2022 for liquidity ratios and efficiency ratios are considered to be increasing for Tesco allowing better opportunities to incorporate short term business growth and development. The overall forecast contemplated from 2023 to 2027 also indicates strong financials available for Tesco that would encourage business progression in the industry. This is also substantiated based on the valuation section conducted in this report where availability of discounted cash flows, relative models and book value are identified to be sustainable and sufficient.

References

  • Abass, Z. K., Flayyih, H. H., & Hasan, S. I. (2022). The relationship between audit services and non-audit actuarial services in the auditor's report. International Journal of Professional Business Review, 7(2), e0455-e0455.https://www.openaccessojs.com/JBReview/article/view/455
  • Abdulazizovich, K. U. (2022). IMPROVING METHODOLOGICAL APPROACHES TO FINANCIAL ASSET ACCOUNTING. INTERNATIONAL JOURNAL OF RESEARCH IN COMMERCE, IT, ENGINEERING AND SOCIAL SCIENCES ISSN: 2349-7793 Impact Factor: 6.876, 16(4), 56-62.http://gejournal.net/index.php/IJRCIESS/article/view/462
  • Alabdullah, T. T. Y. (2022). Management accounting insight via a new perspective on risk management-companies' profitability relationship. International Journal of Intelligent Enterprise, 9(2), 244-257.https://www.inderscienceonline.com/doi/abs/10.1504/IJIE.2022.121752
  • Botica Redmayne, N., Laswad, F., Ehalaiye, D., & Stent, W. (2023). Insights on management commentary in financial reports: the views of users, preparers and auditors. Meditari Accountancy Research, 31(4), 817-840.https://www.emerald.com/insight/content/doi/10.1108/MEDAR-02-2021-1198/full/html
  • datacommons.org, 2023, Growth Rate in UK [online], Retrieved from: https://datacommons.org/place/country/GBR/?utm_medium=explore&mprop=amount&popt=EconomicActivity&cpv=activitySource,GrossDomesticProduction&hl=en [Retrieved on: 29th August, 2023]
  • finance.yahoo.com, 2023, Price to Sales Ratios [online], Retrieved from: https://finance.yahoo.com/quote/TSCO.L/key-statistics?p=TSCO.L [Retrieved on: 29th August, 2023]
  • finance.yahoo.com, 2023a, Price to Sales Ratios [online], Retrieved from: https://uk.finance.yahoo.com/quote/SBRY.L/key-statistics?p=SBRY.L [Retrieved on: 29th August, 2023]
  • finance.yahoo.com, 2023b, Price to Sales Ratios [online], Retrieved from: https://finance.yahoo.com/quote/MKS.L/key-statistics?p=MKS.L [Retrieved on: 29th August, 2023]
  • Flayyih, H. H., Mutashar, S. S., & Murad, A. H. (2022). Measuring the level of performance of accounting units and their impact on the control environment. International Journal of Professional Business Review, 7(4), e0680-e0680.https://openaccessojs.com/JBReview/article/view/680
  • Gao, J. (2022). Analysis of enterprise financial accounting information management from the perspective of big data. International Journal of Science and Research (IJSR), 11(5), 1272-1276.https://www.researchgate.net/profile/Jun-Gao-80/publication/360740813_Analysis_of_Enterprise_Financial_Accounting_Information_Management_from_the_Perspective_of_Big_Data/links/62b62436d49f803365b70235/Analysis-of-Enterprise-Financial-Accounting-Information-Management-from-the-Perspective-of-Big-Data.pdf?_sg%5B0%5D=started_experiment_milestone&origin=journalDetail
  • Garanina, T., Ranta, M., & Dumay, J. (2022). Blockchain in accounting research: current trends and emerging topics. Accounting, Auditing & Accountability Journal, 35(7), 1507-1533.https://www.emerald.com/insight/content/doi/10.1108/AAAJ-10-2020-4991/full/html
  • Gómez-Villegas, M., & Larrinaga, C. (2023). A critical accounting project for Latin America? Objects of knowledge or ways of knowing. Critical Perspectives on Accounting, 93, 102508.https://www.sciencedirect.com/science/article/pii/S1045235422000934
  • He, R., Luo, L., Shamsuddin, A., & Tang, Q. (2022). Corporate carbon accounting: A literature review of carbon accounting research from the Kyoto Protocol to the Paris Agreement. Accounting & Finance, 62(1), 261-298.https://onlinelibrary.wiley.com/doi/abs/10.1111/acfi.12789
  • Hosiyatovich, J. N., Kadirovich, R. N., & Ikromovich, I. F. (2023). Organization of turkic states: interoperation and accounting system. British Journal of Global Ecology and Sustainable Development, 13, 116-129.https://www.journalzone.org/index.php/bjgesd/article/view/245
  • infrontanalytics.com, 2023, CAPM values [online], Retrieved from: https://www.infrontanalytics.com/fe-EN/31985EX/London-Stock-Exchange-Group-plc/Beta [Retrieved on: 29th August, 2023]
  • Isaev, F. I. (2022). Tax Accounting: Theory and Practice. International Journal of Multicultural and Multireligious Understanding, 9(12), 30-38.https://ijmmu.com/index.php/ijmmu/article/view/4297
  • Polzer, T., Grossi, G., & Reichard, C. (2022, January). Implementation of the international public sector accounting standards in Europe. Variations on a global theme. In Accounting Forum (Vol. 46, No. 1, pp. 57-82). Routledge. https://www.tandfonline.com/doi/abs/10.1080/01559982.2021.1920277
  • Schmidthuber, L., Hilgers, D., & Hofmann, S. (2022). International Public Sector Accounting Standards (IPSASs): A systematic literature review and future research agenda. Financial Accountability & Management, 38(1), 119-142.https://onlinelibrary.wiley.com/doi/abs/10.1111/faam.12265
  • statista.com, 2022, Branding of Tesco [online], Retrieved from: https://www.statista.com/forecasts/1304375/tesco-online-grocery-delivery-brand-profile-in-the-united-kingdom#:~:text=All%20in%20all%2C%2048%25%20of,likely%20to%20use%20Tesco%20again. [Retrieved on: 29th August, 2023]
  • statista.com, 2023, Sector Competition [online], Retrieved from: https://www.statista.com/statistics/287912/retail-total-annual-sales-value-great-britain/ [Retrieved on: 29th August, 2023]
  • tescoplc.com, 2023, Main Activities and Business Models [online], Retrieved from: https://www.tescoplc.com/about/how-we-do-business/core-purpose-and-values/ [Retrieved on: 29th August, 2023]
  • Tettamanzi, P., Venturini, G., & Murgolo, M. (2022). Sustainability and financial accounting: A critical review on the ESG dynamics. Environmental Science and Pollution Research, 29(11), 16758-16761.https://link.springer.com/article/10.1007/s11356-022-18596-2
  • tools.morningstar.co.uk, 2023, Price to Sales Ratios [online], Retrieved from: https://tools.morningstar.co.uk/uk/stockreport/default.aspx?tab=10&vw=kr&SecurityToken=0P000090N0%5D3%5D0%5DE0WWE%24%24ALL&Id=0P000090N0&ClientFund=0&CurrencyId=BAS [Retrieved on: 29th August, 2023]
  • tradingeconomics.com, 2023, Market Return [online], Retrieved from: https://tradingeconomics.com/united-kingdom/stock-market-return-percent-year-on-year-wb-data.html#:~:text=Stock%20market%20return%20(%25%2C%20year%2Don%2Dyear)%20in,compiled%20from%20officially%20recognized%20sources. [Retrieved on: 29th August, 2023]
  • Van Hoa, N., Duyen, N. T. H., Huyen, V. N., Quang, H. V., Van Huong, N., Tu, N. T. C., & Nguyet, B. T. M. (2022). Impact of trained human resources, adoption of technology and international standards on the improvement of accounting and auditing activities in the agricultural sector in Viet Nam. AgBioForum, 24(1), 59-71.http://agbioforum.org/menuscript/index.php/agb/article/view/79
Seasonal Offer
scan qr code from mobile

Get Extra 10% OFF on WhatsApp Order

Get best price for your work

×