Using MS Excel to Analyze Revenue and Market Capitalization of McDonald's

This report explains how to use MS Excel to analyze the revenue and market capitalization of McDonald's. It includes the computation of revenue and market capitalization of McDonald's which can be analyzed by using the functions of Excel such as sum, count, minimum and maximum. The report also discusses the tools of descriptive statistics such as mean, mode and median which can be estimated by using MS-Excel.

MS Excel task

INTRODUCTION
The application software of Microsoft office consists of various applications such as
Microsoft windows, excel and access. The Microsoft excel is used to perform the various
calculations which are complex(Akcam,2020.)
. This report consists the introduction of McDonald, which is an American multinational
corporation. It also includes the computation of revenue and market capitalization of McDonald
which can be analysed by using the functions of Excel such as sum, count, minimum and
maximum. There are various tools of descriptive statistics such as mean, mode and median are
also estimated by using MS-Excel.
MAIN BODY
1. Research topic for the case study of McDonalds.
The case study that has been chosen is McDonalds. The topic is of analysing the improvement in
the business performance through the utilisation of technology. The data has been collected of
the market capitalisation, revenue and the number of employees existing in the organisation all
over its branches over the years since 2015 to 2021.
2. Collect the raw data of the chosen topic.
McDonalds
Year Market capitalization (in billion $) Revenue Number of employees
2021 200.31 22.87 195000
2020 159.88 18.86 200000
2019 147.47 21.07 205000
2018 136.21 21.02 210000
2017 137.21 22.82 235000
2016 101.08 24.62 375000
2015 107.12 25.41 420000

3. By using the statistical techniques compute some of the excel functions.
McDonalds
Year Market Capitalization (in billion $) Revenue
Number of
employees
2021 200.31 22.87 195000
2020 159.88 18.86 200000
2019 147.47 21.07 205000
2018 136.21 21.02 210000
2017 137.21 22.82 235000
2016 101.08 24.62 375000
2015 107.12 25.41 420000
Mean 141.3257143 22.3814 262857.1429
Median 137.21 22.82 210000
4. Produce the relevant charts for the above statistical techniques.

5. Interpret and explain the finding and analysis.
Microsoft Excel is the spreadsheet tool which helps in performing various calculations.
The ms-excel assists in data entry, data management, accounting, financial analysis , charting
and graphing, programming, time management and task management(Ivanov and Webster,
2019.). It also has pivot tables and options for representing the data in form of charts, figures and
tables.
 Sum : In ms- excel, there are variety of functions which helps in performing different
arithmetic calculations. The Function of Sum helps in the total of the all the given values.
It can be applied by selecting the complete row. The formula for sum can be applied by

putting the sign of (= ) and then drag the row till the sum of values is required. In context
of McDonald, the sum of the market capitalisation is 989.28 . The total of revenue is
156.67 and total of employee's in McDonald's is 184000.
 Count : The count is an excel statistical function, it is used to find the number of
observations of the data. This function is also used by using the sign of = and drag the
rows till the count of observations is required(Rodriguez, 2020) According to the data of
McDonald, the count of market capitalisation, revenue and number of employees are 7.
It is same in all the three different variables.
 MAXIMUM : This function of ms-excel is used to produce the highest value from the
total given events in the series. It can be used by putting the sign( =) and writing the
name of the function. The maximum value in case of market capitalisation rate is 200.31
and maximum revenue is 25.41. The maximum number of employees is 420000. The
graphs can also be created which shows the graphical representation of the given data.
 Minimum : The minimum function will return the lowest value . The minimum value of
market capitalisation of McDonald's is 101.08. The lowest value of revenue and number
of employees are 18.86 and 195000. This function can be applied by = min () and in the
brackets, the range of cells is specified(Thompson, 2021)
 Mean : The mean is the average value of the given data set. The mean is the measure of
central tendency which can be computed by adding all the given values and divided by
the number of observations(Mitryasova, O Pohrebennyk and Kardasz, 2018) . The mean
for the market capitalisation rate is 141.3257143 and average value for the revenue is
22.3814 and mean for number of employees is 262857.1429. It is impacted by the
extreme values and helpful in further algebraic treatment.
 Median : The median is defined as the mid value of the data set. It can be computed
differently in case of odd and even observations(Pili, 2020).. When observations are
even , n+1/2 is applied and when observations are odd, n/2 formula will be applied. The
median for the market capitalisation rate is 137.21 and mid value for revenue of
McDonald is 22.82. the mid value for number of employees is 21000(Teoh, et.al., 2018).

CONCLUSION
From the above report, it can be concluded that Ms- Excel is an application software
which eases the work by performing complex calculation in very less time. The function of
spreadsheet such as sum, count, minimum and maximum helps to find the total and maximum
values from the revenue of McDonald. The measures of central tendency such as mean, mode
and median of the revenue and market capitalisation rate can also be analysed which helps in
taking the various decisions .

REFERENCES
Books and Journals
Akcam, B.K., 2020. Improving order processes with information technology: McDonald’s
case. Journal of Information Technology Teaching Cases. 10(2). pp.102-107.
Ivanov, S. and Webster, C., 2019. Conceptual framework of the use of robots, artificial
intelligence and service automation in travel, tourism, and hospitality companies.
In Robots, artificial intelligence, and service automation in travel, tourism and
hospitality. Emerald Publishing Limited.
Mitryasova, O., Pohrebennyk, V. and Kardasz, P., 2018. Hydrochemical aspects of surface water
quality assessment. International Multidisciplinary Scientific GeoConference:
SGEM. 18(5.2). pp.513-520.
Pili, U.B., 2020. Sound-based measurement of g using a door alarm and a smartphone: listening
to the simple pendulum. Physics Education.55(3). p.033001.
Rodriguez, M., 2020. Brand storytelling: Put customers at the heart of your brand story. Kogan
Page Publishers.
Teoh, T.T., et.al., 2018, July. Anomaly detection in cyber security attacks on networks using
MLP deep learning. In 2018 International Conference on Smart Computing and
Electronic Enterprise (ICSCEE) (pp. 1-5). IEEE.
Thompson, R., 2021. Counter-formation for faithful living: Biblical immersion and cultural
engagement part 3. Christian Teachers Journal. 29(3). pp.4-9.