GIVE THE COMPARATIVE BALANCE SHEET VERTICAL ANALYSIS FROM THE GIVEN BALANCE SHEET BELOW JOLLIBEE BALANCE SHEET ASSETS ITEM 2016 2017 2018 2019 2020 Cash & Short Term Investments 17.46B 22.52B 24.17B 23.02B 57.46B Cash & Short Term Investments Growth - 28.99% 7.32% -4.75% 149.59% Cash Only 16.73B 21.11B 23.29B 20.89B 21.36B Short-Term Investments 726M 1.41B 883.2M 2.13B 36.1B Cash & ST Investments / Total Assets 23.96% 25.08% 16.06% 12.28% 27.26% Total Accounts Receivable 3.59B 4.02B 4.86B 5.91B 7.05B Total Accounts Receivable Growth - 11.86% 21.04% 21.46% 19.36% Accounts Receivables, Net 3.03B 3.39B 4.41B 5.37B 5.8B Accounts Receivables, Gross 3.61B 4.08B 5.09B 5.76B 6.46B Bad Debt/Doubtful Accounts (579.79M) (690.12M) (676.91M) (392.36M) (658.63M) Other Receivable 562.75M 630.06M 451.73M 536.62M 1.25B Accounts Receivable Turnover 31.69 33.26 33.14 30.41 18.34 Inventories 7.27B 8.25B 10.37B 12.02B 10.73B Finished Goods - - - 9.12B - Work in Progress - - - - - Raw Materials 5.46B 6.38B 8.29B 228.22M 7.68B Progress Payments & Other 1.81B 1.88B 2.08B 2.67B 3.05B Other Current Assets - - 3.14B 4.67B 4.8B Miscellaneous Current Assets 117.55M 187.9M 239.1M 239.1M 140.74M Total Current Assets 30.37B 37.33B 42.54B 45.62B 80.04B Net Property, Plant & Equipment 16.66B 20.89B 63.24B 75.06B 62.91B Property, Plant & Equipment - Gross 38.87B 47.14B 93.89B 110.18B 100.65B Buildings - 3.35B 4.08B 7.51B 7.96B Land & Improvements 673.25M 673.51M 677.03M 1.07B 1.04B Computer Software and Equipment - - - - - Other Property, Plant & Equipment 33.94B 40.08B 46.55B 54.8B 53.05B Accumulated Depreciation 22.21B 26.25B 30.65B 35.12B 37.74B Total Investments and Advances - - 4.48B 7.44B 7.94B Other Long-Term Investments 1.09B 890.79M 971.67M 610.92M 606.51M Long-Term Note Receivable 245.37M 231.21M 435.39M 411.3M 254.74M Intangible Assets 9.09B 15.8B 31.62B 50.98B 50.36B Net Goodwill 6.54B 9.05B 14.4B 14.5B 14.1B Net Other Intangibles 2.54B 6.75B 17.23B 36.48B 36.27B Other Assets - - 3.5B 3.5B 3.21B Total Assets 72.88B 89.8B 150.53B 187.46B 210.83B Total Assets Growth - 23.22% 67.63% 24.53% 12.47% Liabilities & Shareholders' Equity All values PHP. ITEM 2016 2017 2018 2019 2020 ST Debt & Current Portion LT Debt 1.56B 1.47B 10.64B 32.63B 27.07B Short Term Debt - - - 22.18B 15.88B Current Portion of Long Term Debt 1.56B 1.47B 10.64B 10.45B 11.2B Accounts Payable 9.94B 10.88B 13.09B 14.4B 11.67B Accounts Payable Growth - 9.38% 20.38% 10.01% -19.01% Income Tax Payable 309.33M 223.77M 263.47M 391.91M 196.66M Other Current Liabilities - - 15.63B 19.92B 19.99B Dividends Payable 47.71M 56.05M 80.78M 87.96M 579.1M Accrued Payroll 1.41B 1.86B 2.13B 2.77B 2.74B Miscellaneous Current Liabilities 10.56B 12.46B 13.42B 17.05B 16.67B Total Current Liabilities 23.83B 26.95B 39.63B 67.35B 58.93B Long-Term Debt 10.59B 16.7B 56.26B 59.45B 106.36B Long-Term Debt excl. Capitalized Leases 10.59B 14.9B 21.37B 19.18B 73.76B Non-Convertible Debt 10.59B 14.9B 21.37B 19.18B 73.76B Convertible Debt - - - - - Capitalized Lease Obligations - 1.8B - - - Provision for Risks & Charges 1.69B 2.31B 2.15B 3.05B 3.95B Deferred Taxes (2.08B) (2.72B) (1.23B) (276.63M) (2.26B) Deferred Taxes - Credits 639.77M 1.19B 3.48B 4.17B 3.86B Deferred Taxes - Debit 2.72B 3.91B 4.71B 4.45B 6.11B Other Liabilities - - 2.91M 58.24M 269.37M Other Liabilities (excl. Deferred Income) 1.83B 51.04M 2.91M 58.24M 269.37M Deferred Income - - - - - Total Liabilities - - 101.52B 134.07B 173.37B Non-Equity Reserves - - - - - Total Liabilities / Total Assets - - 67.44% 71.52% 82.23% Preferred Stock (Carrying Value) - - - - - Redeemable Preferred Stock - - - - - Non-Redeemable Preferred Stock - - - - - Common Equity (Total) 33.62B 40.8B 47.51B 53.49B 38.56B Common Equity / Total Assets 46.13% 45.43% 31.56% 28.53% 18.29% Common Stock Par/Carry Value 1.09B 1.1B 1.11B 1.11B 1.12B Retained Earnings 11.66B 34.61B 39.39B 23.88B 9.87B ESOP Debt Guarantee - - - - - Cumulative Translation Adjustment/Unrealized For. Exch. Gain (20.81M) 340.37M 587.4M 832.08M (477.55M) Unrealized Gain/Loss Marketable Securities 4.29M 6.76M - - - Revaluation Reserve - - - - - Treasury Stock (180.51M) (180.51M) (180.51M) (180.51M) (180.51M) Total Shareholders' Equity 33.62B 40.8B 47.51B 53.49B 38.56B Total Shareholders' Equity / Total Assets 46.13% 45.43% 31.56% 28.53% 18.29% Accumulated Minority Interest 679.19M 1.8B 1.5B (100.6M) (1.1B) Total Equity 34.3B 42.6B 49.01B 53.39B 37.46B Liabilities & Shareholders' Equity 72.88B 89.8B 150.53B 187.46B 210.83B
GIVE THE COMPARATIVE
JOLLIBEE BALANCE SHEET
ASSETS
|
ITEM |
2016 |
2017 |
2018 |
2019 |
2020 |
|
Cash & Short Term Investments |
17.46B |
22.52B |
24.17B |
23.02B |
57.46B |
|
Cash & Short Term Investments Growth |
- |
28.99% |
7.32% |
-4.75% |
149.59% |
|
Cash Only |
16.73B |
21.11B |
23.29B |
20.89B |
21.36B |
|
Short-Term Investments |
726M |
1.41B |
883.2M |
2.13B |
36.1B |
|
Cash & ST Investments / Total Assets |
23.96% |
25.08% |
16.06% |
12.28% |
27.26% |
|
Total |
3.59B |
4.02B |
4.86B |
5.91B |
7.05B |
|
Total Accounts Receivable Growth |
- |
11.86% |
21.04% |
21.46% |
19.36% |
|
Accounts Receivables, Net |
3.03B |
3.39B |
4.41B |
5.37B |
5.8B |
|
Accounts Receivables, Gross |
3.61B |
4.08B |
5.09B |
5.76B |
6.46B |
|
|
(579.79M) |
(690.12M) |
(676.91M) |
(392.36M) |
(658.63M) |
|
Other Receivable |
562.75M |
630.06M |
451.73M |
536.62M |
1.25B |
|
Accounts Receivable Turnover |
31.69 |
33.26 |
33.14 |
30.41 |
18.34 |
|
Inventories |
7.27B |
8.25B |
10.37B |
12.02B |
10.73B |
|
Finished Goods |
- |
- |
- |
9.12B |
- |
|
Work in Progress |
- |
- |
- |
- |
- |
|
Raw Materials |
5.46B |
6.38B |
8.29B |
228.22M |
7.68B |
|
Progress Payments & Other |
1.81B |
1.88B |
2.08B |
2.67B |
3.05B |
|
Other Current Assets |
- |
- |
3.14B |
4.67B |
4.8B |
|
Miscellaneous Current Assets |
117.55M |
187.9M |
239.1M |
239.1M |
140.74M |
|
Total Current Assets |
30.37B |
37.33B |
42.54B |
45.62B |
80.04B |
|
Net Property, Plant & Equipment |
16.66B |
20.89B |
63.24B |
75.06B |
62.91B |
|
Property, Plant & Equipment - Gross |
38.87B |
47.14B |
93.89B |
110.18B |
100.65B |
|
Buildings |
- |
3.35B |
4.08B |
7.51B |
7.96B |
|
Land & Improvements |
673.25M |
673.51M |
677.03M |
1.07B |
1.04B |
|
Computer Software and Equipment |
- |
- |
- |
- |
- |
|
Other Property, Plant & Equipment |
33.94B |
40.08B |
46.55B |
54.8B |
53.05B |
|
|
22.21B |
26.25B |
30.65B |
35.12B |
37.74B |
|
Total Investments and Advances |
- |
- |
4.48B |
7.44B |
7.94B |
|
Other Long-Term Investments |
1.09B |
890.79M |
971.67M |
610.92M |
606.51M |
|
Long-Term Note Receivable |
245.37M |
231.21M |
435.39M |
411.3M |
254.74M |
|
Intangible Assets |
9.09B |
15.8B |
31.62B |
50.98B |
50.36B |
|
Net Goodwill |
6.54B |
9.05B |
14.4B |
14.5B |
14.1B |
|
Net Other Intangibles |
2.54B |
6.75B |
17.23B |
36.48B |
36.27B |
|
Other Assets |
- |
- |
3.5B |
3.5B |
3.21B |
|
Total Assets |
72.88B |
89.8B |
150.53B |
187.46B |
210.83B |
|
Total Assets Growth |
- |
23.22% |
67.63% |
24.53% |
12.47% |
Liabilities & Shareholders' Equity
All values PHP.
|
ITEM |
2016 |
2017 |
2018 |
2019 |
2020 |
|
ST Debt & Current Portion LT Debt |
1.56B |
1.47B |
10.64B |
32.63B |
27.07B |
|
Short Term Debt |
- |
- |
- |
22.18B |
15.88B |
|
Current Portion of Long Term Debt |
1.56B |
1.47B |
10.64B |
10.45B |
11.2B |
|
Accounts Payable |
9.94B |
10.88B |
13.09B |
14.4B |
11.67B |
|
Accounts Payable Growth |
- |
9.38% |
20.38% |
10.01% |
-19.01% |
|
Income Tax Payable |
309.33M |
223.77M |
263.47M |
391.91M |
196.66M |
|
Other Current Liabilities |
- |
- |
15.63B |
19.92B |
19.99B |
|
Dividends Payable |
47.71M |
56.05M |
80.78M |
87.96M |
579.1M |
|
Accrued Payroll |
1.41B |
1.86B |
2.13B |
2.77B |
2.74B |
|
Miscellaneous Current Liabilities |
10.56B |
12.46B |
13.42B |
17.05B |
16.67B |
|
Total Current Liabilities |
23.83B |
26.95B |
39.63B |
67.35B |
58.93B |
|
Long-Term Debt |
10.59B |
16.7B |
56.26B |
59.45B |
106.36B |
|
Long-Term Debt excl. Capitalized Leases |
10.59B |
14.9B |
21.37B |
19.18B |
73.76B |
|
Non-Convertible Debt |
10.59B |
14.9B |
21.37B |
19.18B |
73.76B |
|
Convertible Debt |
- |
- |
- |
- |
- |
|
Capitalized Lease Obligations |
- |
1.8B |
- |
- |
- |
|
Provision for Risks & Charges |
1.69B |
2.31B |
2.15B |
3.05B |
3.95B |
|
|
(2.08B) |
(2.72B) |
(1.23B) |
(276.63M) |
(2.26B) |
|
Deferred Taxes - Credits |
639.77M |
1.19B |
3.48B |
4.17B |
3.86B |
|
Deferred Taxes - Debit |
2.72B |
3.91B |
4.71B |
4.45B |
6.11B |
|
Other Liabilities |
- |
- |
2.91M |
58.24M |
269.37M |
|
Other Liabilities (excl. Deferred Income) |
1.83B |
51.04M |
2.91M |
58.24M |
269.37M |
|
Deferred Income |
- |
- |
- |
- |
- |
|
Total Liabilities |
- |
- |
101.52B |
134.07B |
173.37B |
|
Non-Equity Reserves |
- |
- |
- |
- |
- |
|
Total Liabilities / Total Assets |
- |
- |
67.44% |
71.52% |
82.23% |
|
|
- |
- |
- |
- |
- |
|
Redeemable Preferred Stock |
- |
- |
- |
- |
- |
|
Non-Redeemable Preferred Stock |
- |
- |
- |
- |
- |
|
Common Equity (Total) |
33.62B |
40.8B |
47.51B |
53.49B |
38.56B |
|
Common Equity / Total Assets |
46.13% |
45.43% |
31.56% |
28.53% |
18.29% |
|
Common Stock Par/Carry Value |
1.09B |
1.1B |
1.11B |
1.11B |
1.12B |
|
|
11.66B |
34.61B |
39.39B |
23.88B |
9.87B |
|
ESOP Debt Guarantee |
- |
- |
- |
- |
- |
|
Cumulative Translation Adjustment/Unrealized For. Exch. Gain |
(20.81M) |
340.37M |
587.4M |
832.08M |
(477.55M) |
|
Unrealized Gain/Loss Marketable Securities |
4.29M |
6.76M |
- |
- |
- |
|
Revaluation Reserve |
- |
- |
- |
- |
- |
|
|
(180.51M) |
(180.51M) |
(180.51M) |
(180.51M) |
(180.51M) |
|
Total Shareholders' Equity |
33.62B |
40.8B |
47.51B |
53.49B |
38.56B |
|
Total Shareholders' Equity / Total Assets |
46.13% |
45.43% |
31.56% |
28.53% |
18.29% |
|
Accumulated Minority Interest |
679.19M |
1.8B |
1.5B |
(100.6M) |
(1.1B) |
|
Total Equity |
34.3B |
42.6B |
49.01B |
53.39B |
37.46B |
|
Liabilities & Shareholders' Equity |
72.88B |
89.8B |
150.53B |
187.46B |
210.83B |
Step by step
Solved in 3 steps
