BUSINESS FINANCE
JOLLIBEE
VISUAL PRESENTATION OF GROUP 8
JOLLIBEE FOOD CORPORATION
Jollibee Foods Corporation is a Filipino multinational
company based in Pasig, Philippines. JFC is the
owner of the fast-food brand Jollibee. As of October
2020, JFC had a total of more than 5,900 stores
worldwide, with system-wide retail sales totaling 82.1
billion pesos for the 2011 fiscal year. (SEC Form 17-Q:
Quarterly Report, 2022)
LIQUIDITY
A. Working Capital
2021
Current Asset 65,382
Current Liability (45,846)
Working Capital 19,536
2020
Current Asset 80,041
Current Liability (58,928)
Working Capital 21,113
LIQUIDITY
B. Current Ratio
2021
Current Asset 65,382
÷
Current Liability 45,846
Current Ratio 1.4
2020
Current Asset 80,041
÷
Current Liability 58,928
Current Ratio 1.3
LIQUIDITY
C. Acid Test Ratio/Quick Asset
2021
Quick Asset 53,371
÷
Current Liability 45,846
Quick Ratio 1.164
2020
Quick Asset 69,314
÷
Current Liability 58,928
Quick Ratio 1.176
LIQUIDITY
D. Accounts Receivable Turnover Ratio
2021
Net Sales 153,576
÷
Average A/R 7,148
A/R Turnover Ratio 21.48 Times
2020
Net Sales 129,313
Average A/R 7,148 ÷
A/R Turnover Ratio 18.09 Times
LIQUIDITY
E. Average Collection Period
2021
365 365
÷
A/R Turnover Ratio 21.48
Average Collection Period 16.99 days
2020
365 365 ÷
A/R Turnover Ratio 18.34
Average Collection Period 19.90 days
LIQUIDITY
F. Inventory Turnover Ratio
2021
CGS 128,147 ÷
Average Inventory 11,369
Inventory Turnover Ratio 11.27 times
2020
CGS 115,389 ÷
Average Inventory 11,369
Inventory Turnover Ratio 10.14 times
LIQUIDITY
G. Average Days in Inventory
2021
365 365 ÷
Inventory turnover 11.27
Average Days in Inventory 32.38 days
2020
365 365
÷
Inventory turnover 10.14 Average Days in
Inventory 35.99 days
LIQUIDITY
H. Number of Days in Operating Cycle
2021
Collection Period 16.99 +
Average age of Inventory 32.38
Number of Days of OC 49.37 days
2020
Collection Period 19.90 +
Average age of Inventory 35.99
Number of Days of OC 55.89 days
SOLVENCY
A. Debt to Total Asset Ratio
2021
Total Liabilities 156,919
÷
Total Assets 210,855
Debt to Total Asset Ratio 0.74
2020
Total Liabilities 173,366 ÷
Total Assets 210,827
Debt to Total Asset Ratio 0.82
SOLVENCY
A. Debt to Equity Ratio
2021
Total Liabilities 156,919
÷
Total Shareholder’s Equity 55,619
Debt to Equity Ratio 2.82
2020
Total Liabilities 173,366 ÷
Total Shareholder’s Equity 38,556
Debt to Equity Ratio 4.49
SOLVENCY
C. Times Interest Earned Ratio
2021
EBIT 5,752
÷
Interest Expense 4,616
Times Interest Earned 1.24
2020
EBIT (8,149)
÷
Interest Expense 4,330
Times Interest Earned -1.88
PROFITABILITY
A. Gross Profit Ratio
2021
Gross Profit 25,428
÷
Net Sales 153,576
Gross Profit Ratio 16.55%
2020
Gross Profit 13,924 ÷
Net Sales 129,313
Gross Profit Ratio 10.76%
PROFITABILITY
B. Profit margin Ratio
2021
Net Income After Tax 5,982
÷
Net Sales 153,576
Profit Margin Ratio 3.89
2020
Net Income After Tax (11,511) ÷
Net Sales 129,313
Profit Margin Ratio -8.90
PROFITABILITY
C. Operating Expenses to Sales Ratio
2021
Operating Expenses 18,090
÷
Net Sales 153,576
OE to Sales Ratio 11.77
2020
Operating Expenses 20,420 ÷
Net Sales 129,313
OE to Sales Ratio 15.79
PROFITABILITY
D. Return on Investment Ratio
I. Return On Assets
2021
Profit 5,982
÷
Average Total Asset 210,841
Return on Assets 2.83
2020
Profit (11,511)
÷
Average Total Asset 210,841
Return on Assets -5.45
PROFITABILITY
E. Return on Investment Ratio
II. Return On Equity
2021
Profit 5,982
÷
Average SHE 55,619 Return on Equity
10.75
2020
Profit 5,982
÷
Average SHE 38,556
Return on Equity 15.51
PROFITABILITY
F. Asset Turnover Ratio
2021
Net Sales 153,576
÷
Average Total Asset 210,841
Asset Turnover Ratio 72.83
2020
Net Sales 129,313
÷
Average Total Asset 210,841
Asset Turnover Ratio 61.33
HORIZONTAL ANALYSIS
2021 2020 Inc./Dec. Percent(%)
Cash & Short Term Investment 39,185 57,461 -0.31 -31.80
Total Accounts Receivable 7,246 7,050 0.02 2.78
Inventories 12,011 10,727 0.11 11.96
Other Current Assets 6,940 4,802 0.44 44.52
Total Current Assets 65,382 80,041 -0.18 -18.31
Net Property, Plant & Equipment 68,777 62,908 0.09 9.32
Accumulated Depreciation 41,840 37,739 0.10 10.86
Total Investments and Advances 15,467 7,936 0.94 94.89
Long-Term Note Receivable 213 255 -0.16 -16.47
Intangible Assets 50,742 50,365 0.00 0.74
Other Assets 3,399 3,209 0.05 5.92
Total Assets 210,855 210,827 0.00 0.01
HORIZONTAL ANALYSIS
2021 2020 Inc./Dec. Percent(%)
St & Current Portion LT Debt 12,745 27,075 -0.52 -52.92
Accounts Payable 13,257 11,666 0.13 13.63
Income Tax Payable 149 197 -0.24 -24.36
Other Current Liabilities 19,696 19,991 -0.01 -1.47
Total Current Liabilities 45,846 58,928 -0.22 -22.19
Long-Term Debt 104,000 106,360 -0.02 -2.21
Provision for Risks & Charges 3,452 3,953 -0.12 -12.67
Deferred Taxes 3,446 2,259 0.52 52.54
Other Liabilities 192 269 -0.28 -28.62
Total Liabilities 156,919 173,366 -0.09 -9.48
HORIZONTAL ANALYSIS
2021 2020 Inc./Dec. Percent(%)
Common Equity 43,619 38,556 0.13 13.13
Total Shareholders’ Equity 55,619 38,556 0.44 44.25
Total Equity 53,937 37,461 0.43 43.98 .
LIABILITIES & 210,855 210,827 0.00 0.01
SHAREHOLDERS EQUITY
VERTICAL ANALYSIS
2021 Percent (%) 2020 Percent (%)
Cash & Short Term Investment 39,185 18.58 57, 461 27.25
Total Accounts Receivable 7,246 3.43 7,050 3.34
Inventories 12,011 5.72 10,727 5.08
Other Current Assets 6,940 3.29 4,802. 2.27
Total Current Assets 65,382 31 80,041 37.96
Net Property, Plant & Equipment 68,777 32.61 62,908 29.83
Accumulated Depreciation 41,840 19.84 37,739 17.90
Total Investments and Advances 15,467 7.33 7,636 3.76
Long-Term Note Receivable 213 0.10 255 0.10
Intangible Assets 50,742 24.06 50,365 23.88
Other Assets 3,399 1.61 3,209 1.52
Total Asset
VERTICAL ANALYSIS
2021 Percent (%) 2020 Percent (%)
ST Debt & Current LT Debt 12,745 6.04 27,075 12.84
Accounts Payable 13,257 6.28 11,666 5.53
Income Tax Payable 149 0.07 197 0.09
Other Current Liabilities 19,696 9.34 19,991 9.48
Total Current Liabilities 45,846 12.74 58,928 27.95
Long Term Debt 104,000 49.32 106,360 50.44
Provision for Risk and Changes 3,452 1.16 3,953 1.87
Deferred Taxes 3,446 1.63 2,259 1.07
Other Liabilities 192 0.91 269 0.12
Total Liabilities 156,919 74.42 173,366 82.23
VERTICAL ANALYSIS
2021 Percent (%) 2020 Percent (%)
Common Equity (Total) 43,619 20.86 38,556 18.28
Total Shareholders Equity 55,619 26.3 38,556 18.28
Total Equity 53,937 25.58 37,461 17.76