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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Horizontal Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education