excel sheet KFC vs McDonald's

McDonald's 5 year record
in millions 2018 2017 2016
total revenue ($) $ 21,025.00 $ 22,820.00 $ 24,622.00
net income ($) $ 5,924.00 $ 5,192.00 $ 4,687.00
profit margin (%) 28% 23% 19%

Base-year analysis (index figures) 2018 2017 2016
total revenue (%) 100% 92% 85%
net income (%) 100% 88% 79%

2018 2017 2016
total assets $ 32,811.00 $ 33,804.00 $ 31,024.00
total liabilities $ 26,553.00 $ 30,536.00 $ 28,820.00
equity $ 6,258.00 $ 3,268.00 $ 2,204.00
total liabilities (%) 81% 90% 93%
equity (%) 19% 10% 7%

2018 2017 2016
total assets (%) 100% 103% 95%
total liabilities (%) 100% 115% 109%
equity (%) 100% 52% 35%

GRAPHS:



Profit margin McDonald's (%)
30%


25%


20%


15%
profit margin (%)

10%


5%


0%
1 2 3 4 5

, Solvency McDonald's
$35,000.00

$30,000.00

$25,000.00

$20,000.00

$15,000.00

$10,000.00

$5,000.00

$-
2018 2017 2016 2015 2014

total liabilities equity




Conclusion: The total revenue and net income of KFC is growing through the years and this means that KFC has a h
and comparing to McDonald's that has an decreasing profit every year KFC is doing relatively better.

, 2015 2014
$ 25,413.00 $ 27,441.00
$ 4,529.00 $ 4,758.00
18% 17%

2015 2014
83% 77%
76% 80%

2015 2014
$ 37,939.00 $ 34,227.00
$ 30,851.00 $ 21,374.00
$ 7,088.00 $ 12,853.00
81% 62%
19% 38%

2015 2014
116% 104%
116% 80%
113% 205%




6%


5%


4%


3%
profit margin (%)

2%


1%


0%

, $400,000.00
$350,000.00
$300,000.00
$250,000.00
$200,000.00
$150,000.00
$100,000.00