PEPSI-COLA PRODUCTS PHILIPPINES, INC. Balance Sheets (Amounts In Thousands of Pesos) December 31, June 30, 2012 2011 2010 2010 2009 ASSETS Current Assets 413,088 Cash and cash equivalents Accounts receivable' 489,188 359,668 305,686 643,613 1,339,240 1,260,824 1,023,879 1,075,420 987,965 Inventories? 1,153,529 997,224 1,009,367 825,467 703,963 Due from related parties 421,278 382,859 405,465 165,085 116,454 Prepayments and other current assets 134,666 113,629 72,383 48,560 71,928 Total current assets 3,537,901 3,114,204 2,816,780 2,758,145 2,293,398 Noncurrent Assets 3 Investments in associates 527,412 527,316 530,785 529,988 527,723 Bottles and cases - net 3,510,492 2,552,890 2,315,553 2,325,289 2,441,198 Property, plant and equipment, net input tax on capital goods 4,918,518 3,857,126 3,374,631 3,243,647 3,156,001 165,333 147,569 99,176 108,800 143,941 Total noncurrent assets 9,121,755 7,084,901 6,320,145 6,207,724 6,268,863 12,659,656 10,199,105 9,136,925 8,965,869 8,562,261 LIABILITIES AND EQUITY Current Liabilities Notes payable 950,000 750,000 200,000 50,000 Trade payables 2,486,512 1,954,216 1,617,412 1,468,984 1,228,174 Accrued expenses 1,057,196 730,287 969,371 866,046 805,701 Finance lease liability 65,340 17,833 Income tax payable 10,568 58,840 156,456 Nontrade payables 277,976 128,356 95,120 77,840 104,505 Total current liabilities 4,837,024 3,580,692 2,892,471 2,471,710 2,344,836 Noncurrent Liabilities Accrued retirement cost 398,866 255,341 222,550 207,790 131,830 Deferred tax liabilities - net 635,923 419,234 367,113 391,887 375,723 Total noncurrent liabilities 1,034,789 674,575 589,663 599,677 507,553 Total Liabilities 5,871,813 4,255,267 3,482,134 3,071,387 2,852,389 Equity Capital stock, P0.15 par Additional paid-in capital 554,066 554,066 554,066 554,066 554,066 1,197,369 1,197,369 1,197,369 1,197,369 1,197,369 Retained earnings 5,036,408 4,192,403 3,903,356 4,143,047 3,958,437 Total equity 6,787,843 5,943,838 5,654,791 5,894,482 5,709,872 12,659,656 10,199,105 9,136,925 8,965,869 8,562,261 *The company switched its financial reporting to calendar year in 2010.

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
  1. Using the Balance Sheet attached for Pepsi-Cola, perform a vertical analysis and answer the following question: How has the company’s balance sheet composition  changed from 2010-2012? Use December 31 figures.
PEPSI-COLA PRODUCTS PHILIPPINES, INC.
Balance Sheets
(Amounts In Thousands of Pesos)
December 31,
June 30,
2012
2011
2010
2010
2009
ASSETS
Current Assets
Cash and cash equivalents
489,188
359,668
305,686
643,613
413,088
Accounts receivable
Inventories?
1,339,240
1,260,824
1,023,879
1,075,420
987,965
1,153,529
997,224
1,009,367
825,467
703,963
Due from related parties
421,278
382,859
405,465
165,085
116,454
Prepayments and other current assets
134,666
113,629
72,383
48,560
71,928
Total current assets
3,537,901
3,114,204
2,816,780
2,758,145
2,293,398
Noncurrent Assets
Investments in associates
Bottles and cases - net“
527,412
527,316
530,785
529,988
527,723
3,510,492
2,552,890
2,315,553
2,325,289
2,441,198
Property, plant and equipment, net°
Input tax on capital goods
4,918,518
3,857,126
3,374,631
3,243,647
3,156,001
165,333
147,569
99,176
108,800
143,941
Total noncurrent assets
9,121,755
7,084,901
6,320,145
6,207,724
6,268,863
12,659,656 10,199,105
9,136,925
8,965,869
8,562,261
LIABILITIES AND EQUITY
Current Liabilities
Notes payable
Trade payables
950,000
750,000
200,000
50,000
2,486,512
1,954,216
1,617,412
1,468,984
1,228,174
Accrued expenses
1,057,196
730,287
969,371
866,046
805,701
Finance lease liability
65,340
17,833
Income tax payable
10,568
58,840
156,456
Nontrade payables
277,976
128,356
95,120
77,840
104,505
Total current liabilities
4,837,024
3,580,692
2,892,471
2,471,710
2,344,836
Noncurrent Liabilities
Accrued retirement cost
398,866
255,341
222,550
207,790
131,830
Deferred tax liabilities - net
635,923
419,234
367,113
391,887
375,723
Total noncurrent liabilities
1,034,789
674,575
589,663
599,677
507,553
Total Liabilities
5,871,813
4,255,267
3,482,134
3,071,387
2,852,389
Equity
Capital stock, PO.15 par
554,066
554,066
554,066
554,066
554,066
Additional paid-in capital
1,197,369
1,197,369
1,197,369
1,197,369
1,197,369
Retained earnings
5,036,408
4,192,403
3,903,356
4,143,047
3,958,437
Total equity
6,787,843
5,943,838
5,654,791
5,894,482
5,709,872
12,659,656 10,199,105
9,136,925
8,965,869
8,562,261
*The company switched its financial reporting to calendar year in 2010.
Transcribed Image Text:PEPSI-COLA PRODUCTS PHILIPPINES, INC. Balance Sheets (Amounts In Thousands of Pesos) December 31, June 30, 2012 2011 2010 2010 2009 ASSETS Current Assets Cash and cash equivalents 489,188 359,668 305,686 643,613 413,088 Accounts receivable Inventories? 1,339,240 1,260,824 1,023,879 1,075,420 987,965 1,153,529 997,224 1,009,367 825,467 703,963 Due from related parties 421,278 382,859 405,465 165,085 116,454 Prepayments and other current assets 134,666 113,629 72,383 48,560 71,928 Total current assets 3,537,901 3,114,204 2,816,780 2,758,145 2,293,398 Noncurrent Assets Investments in associates Bottles and cases - net“ 527,412 527,316 530,785 529,988 527,723 3,510,492 2,552,890 2,315,553 2,325,289 2,441,198 Property, plant and equipment, net° Input tax on capital goods 4,918,518 3,857,126 3,374,631 3,243,647 3,156,001 165,333 147,569 99,176 108,800 143,941 Total noncurrent assets 9,121,755 7,084,901 6,320,145 6,207,724 6,268,863 12,659,656 10,199,105 9,136,925 8,965,869 8,562,261 LIABILITIES AND EQUITY Current Liabilities Notes payable Trade payables 950,000 750,000 200,000 50,000 2,486,512 1,954,216 1,617,412 1,468,984 1,228,174 Accrued expenses 1,057,196 730,287 969,371 866,046 805,701 Finance lease liability 65,340 17,833 Income tax payable 10,568 58,840 156,456 Nontrade payables 277,976 128,356 95,120 77,840 104,505 Total current liabilities 4,837,024 3,580,692 2,892,471 2,471,710 2,344,836 Noncurrent Liabilities Accrued retirement cost 398,866 255,341 222,550 207,790 131,830 Deferred tax liabilities - net 635,923 419,234 367,113 391,887 375,723 Total noncurrent liabilities 1,034,789 674,575 589,663 599,677 507,553 Total Liabilities 5,871,813 4,255,267 3,482,134 3,071,387 2,852,389 Equity Capital stock, PO.15 par 554,066 554,066 554,066 554,066 554,066 Additional paid-in capital 1,197,369 1,197,369 1,197,369 1,197,369 1,197,369 Retained earnings 5,036,408 4,192,403 3,903,356 4,143,047 3,958,437 Total equity 6,787,843 5,943,838 5,654,791 5,894,482 5,709,872 12,659,656 10,199,105 9,136,925 8,965,869 8,562,261 *The company switched its financial reporting to calendar year in 2010.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Income Statement 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
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