Course Hero Logo

Case 3 Eric Version.xlsx - Group ID g0mk5 20 Please write...

This preview shows page 1 - 6 out of 83 pages.

Group20Please write this out as One or Two, etc.IDg0mk5Georgia Tech USER name of submitter:such as JGARNER47 (not private!)Remember, just submit one file per group!
Procter Gamble12 Months EndedJun. 30, 2019Jun. 30, 2020Jun. 30, 2021Net Sales$ 67,684$ 70,950$ 76,118Cost of Goods and Services Sold34,76835,25037,108Selling, General and Administrative Expense19,08419,99421,0248,34500Operating Income (also known as EBIT)5,48715,70617,986Interest Expense(509)(465)(502)Investment Income, Interest22015545Other Nonoperating Income (Expense)87143886Earnings from Continuing Operations Before Income Taxes6,06915,83417,615Income Taxes on Continuing Operations2,1032,7313,263Net Earnings3,96613,10314,352Net Earnings Attributable to Noncontrolling Interest697646Net Income (Loss) Attributable to Parent$ 3,897$ 13,027$ 14,306BASIC NET EARNINGS PER COMMON SHAREEarnings Per Share, Basic$ 1.45$ 5.13$ 5.69DILUTED NET EARNINGS PER COMMON SHAREEarnings Per Share, Diluted$ 1.43$ 4.96$ 5.50Dividends7,4987,7898,263CONSOLIDATED STATEMENTS OF EARNINGS - USD ($) $ inMillionsGoodwill & Indefinite Lived Intangible Asset ImpairmentChargesABCD123456789101112131415161718192021
Jun. 30, 2019Jun. 30, 2020Jun. 30, 2021CURRENT ASSETS$ 10,287$ 16,181$ 10,2884,9514,1784,725INVENTORIESInventory, Raw Materials and Supplies, Net of Reserves1,2891,4141,645Inventory, Work in Process, Net of Reserves612674719Inventory, Finished Goods, Net of Reserves3,1163,4103,619Inventory, Net, Total5,0175,4985,983Prepaid Expense and Other Assets, Current2,2182,1302,095Assets, Current22,47327,98723,091Property, Plant and Equipment, Net21,27120,69221,686Goodwill40,27339,90140,924Intangible Assets, Net (Excluding Goodwill)24,21523,79223,642Other Assets, Noncurrent6,8638,3289,964Assets115,095120,700119,307CURRENT LIABILITIESAccounts Payable, Current11,26012,07113,720Accrued Liabilities, Current9,0549,72210,523Debt, Current9,69711,1838,889Liabilities, Current30,01132,97633,132Long-term Debt, Excluding Current Maturities20,39523,53723,099Deferred Income Tax Liabilities, Net6,8996,1996,153Other Liabilities, Noncurrent10,21111,11010,269Liabilities67,51673,82272,653SHAREHOLDERS' EQUITYPreferred Stock928897870Common Stock, Value, Issued4,0094,0094,009CONSOLIDATED BALANCE SHEETS - USD ($) shares inMillions, $ in MillionsCash, Cash Equivalents, Restricted Cash and Restricted CashEquivalentsAccounts Receivable, after Allowance for Credit Loss,CurrentABCD12345678910111213141516171819202122232425262728
Additional Paid in Capital63,82764,19464,848Reserve For ESOP Debt Retirement(1,146)(1,080)(1,006)(14,936)(16,165)(13,744)Treasury Stock, Value(100,406)(105,573)(114,973)Retained Earnings (Accumulated Deficit)94,918100,239106,374Stockholders' Equity Attributable to Noncontrolling Interest38535727647,57946,87846,654Liabilities and Equity$ 115,095$ 120,700$ 119,307Common Stock, Shares, Issued4,0094,009.24,009.2Common Stock, Par or Stated Value Per Share$1$ 1$ 1Common Stock, Shares Authorized10,00010,00010,000Treasury Stock, Shares1,504.51,529.51,579.5Accumulated Other Comprehensive Income (Loss), Net ofTaxStockholders' Equity, Including Portion Attributable toNoncontrolling InterestABCD293031323334353637383940
Procter & GambleIncome StatementsHistoricalForecast20192020202120222023Net Sales67,68470,95076,11879,16382,329Cost of Goods and Services Sold34,76835,25037,10839,52941,110Selling, General and Administrative Expense19,08419,99421,02422,16523,051Goodwill & Indefinite Lived Intangible Asset Impairment Charges8,345----Operating Income (also known as EBIT)5,48715,70617,98617,46918,168Net Interest Expense(289)(310)(457)(564)(508)Other Nonoperating Income (Expense)87143886532554Earnings from Continuing Operations Before Income Taxes6,06915,83417,61517,43818,214Income Taxes on Continuing Operations2,1032,7313,2635,7546,011Net Earnings3,96613,10314,35211,68312,203Net Earnings Attributable to Noncontrolling Interest697646Net Income (Loss) Attributable to Parent3,89713,02714,30611,68312,203Dividends7,4987,7898,2638,2638,263Revenue growth4.8%7.3%4.00%4.00%COGS % Revenues51.4%49.7%48.8%49.9%49.9%SG&A % Revenues28.2%28.2%27.6%28.0%28.0%Goodwill Impairment % Revenues12.3%0.0%0.0%0.0%0.0%Other non-operating income, net % Revenues1.3%0.6%0.1%0.7%0.7%Interest % ST and LT Debt

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 83 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
AjayK.Kohli
Tags
Balance Sheet, Procter Gamble, procter

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture