I need a common size analysis for company P&G on an EXCEL document. I have attached a photo of the company's numbers (you may need to do more research on the company if thats not enough info). I also attached an excel document where I started on the formatting. This is a link of an example of what I need for a different company (IBM) so you can get the idea:http://www.investopedia.com/articles/investing/111413/commonsize-analysis-financial-statements.asp?layout=orig

When finished please write a short paragraph explaining the common size analysis for company P&G on a Word document.

\fAssets Current Assets Total cash Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets Non-current assets Property, plant & equipment Gross property, plant & equipment Accumulated Depreciation Net property, plant & equipment Equity & other investments Goodwill Intangible assets Deferred income taxes Other long-term assets Total non-current assets Total assets Liabilities Current liabilities Short-term debt Accounts payable Taxes payable Accrued liabilities Deferred revenues Total current liabilities Non-current liabilities Long-term debt Deferred revenues Pensions & other benefits Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity Common stock Retained earnings Treasury stock Accumulated other comprhensive income Total stockholders' equity Total liabilities & stockholders' equity