Exercise relates to chap 8 relating to finance to reinforce the key concept of valuing a firm.
Calculate the ratios and cash value of PepsiCo using one of these depending on your text edition:
- The case data and tables are in the Cohesion Case at the end of chapter 1.
- There are 3 steps to this.
- Calculate financial worth of company using 4 methods: (1) the net worth or stockholders' equity (2) the future value of PepsiCo's earnings (3) the price-earning ration, and (4) the outstanding shares method
- Use the values below
- Show your work in each method
- Get an average of 4 methods
- Determine the Goodwill/Total Assets ratio
search Bush EW OF STRATEGIC MANAGEMENT EXHIBIT B PepsiCo's Recent Balance Sheets (in millions of 5) 2011 2010 2012 beci tim 6,619.0 7.041.0 3,581.0 1,479.0 6,369.0 6,323.0 3,372.0 1,505.0 0.0 2.522 13341 0.0 4.425.0 6,912.0 3.827.0 2.277.0 0.0 17,441.0 19.698.0 16,800.0 16,445.0 1,566.0 10. Cath and Short Term Investments Total Receivables. Nel Total Inventory Prepaid Expenses Other Current Assets, Total Total Current Assets Property PlantEquipment, Total, Net Goodwill, Net Intangibles, Net Long-Term Investments Note Receivable, Long-Term Other Long-Term Assels, Total 18,720.0 11.6639 19,136.0 17,569,0 19,058.0 14,661.0 13,808.0 2.021.0 165.0 871.0 5.134 1,8600 16,971.0 16,525.0 2,351.0 1.36.0 799.0 159.0 773.0 2.5430 0, 72,882.0 68,153.0 35,994.) 2,846.0 4,083.0 0.0 3,876.0 3.865.0 0.0 3,620.0 4,898.0 0.0 3.509.0 2.8430 369.0 6,205.0 0.0 3,990.0 2,729.0 18,154.0 20,568.0 4,995.0 3110 8.266.0 15,892.0 19,999.0 4,057.0 312.0 6,729.0 8,787.0 7.858.11 2260 6,541.0 23,888. 74,638.0 Total Assets Liabilities and SEquity 4,451.0 Accounts Payable 0.0 Payable/Accrued 3,892.0 Accrued Expenses Notes Payable/Short-Term Debt 4,815.0 Current Port of LT Debu/Capital Leases 0.0 Other Current Liabilities, Total 3,931.0 Total Current Liabilities 17.089.0 Total Long-Term Dcht 23,544.0 Deferred Income Tax 5,063.0 Minority Interest 105.0 Other Liabilities, Total 6.543.0 Total Liabilities 52,844.0 Redeemable Preferred Stock 0.0 Preferred Stock, Non Redeemable, Net -(123.0) Common Stock 26.0 Additional Paid-In Capital 4,178.0 Retained Earnings 43.158.0 Treasury Stock, Common -(19.458.0) ESOP Debt Guarantee Unrealized Gain (Loss) 0.0 Other SEquity, Total -15,487.0) Total SEquity 22,294.0 Total Liabilities & SEquity 74,638.0 Total Common Shares Outstanding 1,544.0 Total Preferred Shares Outstanding 0.8 970 52,294.0 0.0 (116.0) 26.0 4.461.0 40.316.0 (17.870.0) 0.0 0.0 -6,229.0) 20,588.0 46,989.0 0.0 -1049.0) 31.0 4,527.0 37,090.0 -(16,745.0) 0.0 0.0 (3,630.0) 21.164.0 300 351.0 30,6380 14.122.0 0.0 00 12.106.0 72,882.0 1.565.0 0.8 68,153.0 1,581.0 0.8 35,994.0 1,553.0 0.8 Source: Based on company documents. practices. DJSI is comprised of companies across all industries that outperform their peers in ous sustainability metrics. PepsiCo has been named a member of the Dow Jones Sustainability America Index seven times and the World Index six times. CDP represents 655 institutional In with $78 trillion in assets, and its indices highlight companies that have displayed a strong $ Sustainability North institutional investor Ong approach EXHIBIT 2 PepsiCo Revenues (%) 2012 2011 AMEA Europe PepsiCo Americas Beverages (PAB) PepsiCo Americas Foods (PAF) 10.2 20.5 32.7 36.6 100.0 11.1 20.4 33.7 34.8 100.0 Source: Company documents. EXHIBIT 3 PepsiCo's Revenue by Country (in millions of $) 2012 2011 % Change Revenue 0.89 33,348 33,053 USA 2.36 4,749 4,861 Russia 3,955 -17.29 4,782 Mexico 3,364 -2.20 3,290 Canada 2,075 1.30 2,102 UK 1.52 1,838 1,866 Brazil 16,070 16,643 -3.44 All Other Countries Source: Company documents. EXHIBIT 4 Recent Trends in PepsiCo's Operating Profit % Change 2012 2011 2012 2011 2010 2009 3,376 3,646 695 3,621 797 741 NORTH AMERICA FLNA QFNA LAF PAB OUTSIDE NORTH AMERICA 3,105 781 904 2,172 1.078 3.273 0.7 -12.8 -1.8 -10.3 1,059 2.937 1,004 2,776 7.6 7.3 17.9 Europe AMEA Total Operating profit margin 1,330 747 9,667 13.9% 1,210 887 9,633 14.5% 1,054 708 8,332 14.4% 948 700 8,044 18.6% 9.9 -15.9 0.4 -0.6 14.8 25.3 15.6 0.1 Source: Based on company documents. 7,392 EXHIBIT 5 PepsiCo's 2012/2011/2010 Revenue/Assets by Segment (in millions of REVENUE FLNA QFNALAF PAB EUROPE AMEA TOTAL 2012 13,574 2,636 7,780 21,408 13,441 6,653 65,492 2011 13,322 2,656 7,156 22,418 13,560 66,504 2010 12,573 2,656 6,315 20,401 9,602 6,291 57,838 TOTAL ASSETS 2012 5,332 966 4,993 30,899 19,218 2011 5,738 67,146 5,384 1,024 4,721 31,142 18,461 6,038 66,770 Source: Based on company documents. search Bush EW OF STRATEGIC MANAGEMENT EXHIBIT B PepsiCo's Recent Balance Sheets (in millions of 5) 2011 2010 2012 beci tim 6,619.0 7.041.0 3,581.0 1,479.0 6,369.0 6,323.0 3,372.0 1,505.0 0.0 2.522 13341 0.0 4.425.0 6,912.0 3.827.0 2.277.0 0.0 17,441.0 19.698.0 16,800.0 16,445.0 1,566.0 10. Cath and Short Term Investments Total Receivables. Nel Total Inventory Prepaid Expenses Other Current Assets, Total Total Current Assets Property PlantEquipment, Total, Net Goodwill, Net Intangibles, Net Long-Term Investments Note Receivable, Long-Term Other Long-Term Assels, Total 18,720.0 11.6639 19,136.0 17,569,0 19,058.0 14,661.0 13,808.0 2.021.0 165.0 871.0 5.134 1,8600 16,971.0 16,525.0 2,351.0 1.36.0 799.0 159.0 773.0 2.5430 0, 72,882.0 68,153.0 35,994.) 2,846.0 4,083.0 0.0 3,876.0 3.865.0 0.0 3,620.0 4,898.0 0.0 3.509.0 2.8430 369.0 6,205.0 0.0 3,990.0 2,729.0 18,154.0 20,568.0 4,995.0 3110 8.266.0 15,892.0 19,999.0 4,057.0 312.0 6,729.0 8,787.0 7.858.11 2260 6,541.0 23,888. 74,638.0 Total Assets Liabilities and SEquity 4,451.0 Accounts Payable 0.0 Payable/Accrued 3,892.0 Accrued Expenses Notes Payable/Short-Term Debt 4,815.0 Current Port of LT Debu/Capital Leases 0.0 Other Current Liabilities, Total 3,931.0 Total Current Liabilities 17.089.0 Total Long-Term Dcht 23,544.0 Deferred Income Tax 5,063.0 Minority Interest 105.0 Other Liabilities, Total 6.543.0 Total Liabilities 52,844.0 Redeemable Preferred Stock 0.0 Preferred Stock, Non Redeemable, Net -(123.0) Common Stock 26.0 Additional Paid-In Capital 4,178.0 Retained Earnings 43.158.0 Treasury Stock, Common -(19.458.0) ESOP Debt Guarantee Unrealized Gain (Loss) 0.0 Other SEquity, Total -15,487.0) Total SEquity 22,294.0 Total Liabilities & SEquity 74,638.0 Total Common Shares Outstanding 1,544.0 Total Preferred Shares Outstanding 0.8 970 52,294.0 0.0 (116.0) 26.0 4.461.0 40.316.0 (17.870.0) 0.0 0.0 -6,229.0) 20,588.0 46,989.0 0.0 -1049.0) 31.0 4,527.0 37,090.0 -(16,745.0) 0.0 0.0 (3,630.0) 21.164.0 300 351.0 30,6380 14.122.0 0.0 00 12.106.0 72,882.0 1.565.0 0.8 68,153.0 1,581.0 0.8 35,994.0 1,553.0 0.8 Source: Based on company documents. practices. DJSI is comprised of companies across all industries that outperform their peers in ous sustainability metrics. PepsiCo has been named a member of the Dow Jones Sustainability America Index seven times and the World Index six times. CDP represents 655 institutional In with $78 trillion in assets, and its indices highlight companies that have displayed a strong $ Sustainability North institutional investor Ong approach EXHIBIT 2 PepsiCo Revenues (%) 2012 2011 AMEA Europe PepsiCo Americas Beverages (PAB) PepsiCo Americas Foods (PAF) 10.2 20.5 32.7 36.6 100.0 11.1 20.4 33.7 34.8 100.0 Source: Company documents. EXHIBIT 3 PepsiCo's Revenue by Country (in millions of $) 2012 2011 % Change Revenue 0.89 33,348 33,053 USA 2.36 4,749 4,861 Russia 3,955 -17.29 4,782 Mexico 3,364 -2.20 3,290 Canada 2,075 1.30 2,102 UK 1.52 1,838 1,866 Brazil 16,070 16,643 -3.44 All Other Countries Source: Company documents. EXHIBIT 4 Recent Trends in PepsiCo's Operating Profit % Change 2012 2011 2012 2011 2010 2009 3,376 3,646 695 3,621 797 741 NORTH AMERICA FLNA QFNA LAF PAB OUTSIDE NORTH AMERICA 3,105 781 904 2,172 1.078 3.273 0.7 -12.8 -1.8 -10.3 1,059 2.937 1,004 2,776 7.6 7.3 17.9 Europe AMEA Total Operating profit margin 1,330 747 9,667 13.9% 1,210 887 9,633 14.5% 1,054 708 8,332 14.4% 948 700 8,044 18.6% 9.9 -15.9 0.4 -0.6 14.8 25.3 15.6 0.1 Source: Based on company documents. 7,392 EXHIBIT 5 PepsiCo's 2012/2011/2010 Revenue/Assets by Segment (in millions of REVENUE FLNA QFNALAF PAB EUROPE AMEA TOTAL 2012 13,574 2,636 7,780 21,408 13,441 6,653 65,492 2011 13,322 2,656 7,156 22,418 13,560 66,504 2010 12,573 2,656 6,315 20,401 9,602 6,291 57,838 TOTAL ASSETS 2012 5,332 966 4,993 30,899 19,218 2011 5,738 67,146 5,384 1,024 4,721 31,142 18,461 6,038 66,770 Source: Based on company documents
