FINANCE-Problem One Using the data in the student spreadsheet file P&G.xlsx

Question
The Procter & Gamble Company
Pro-Forma Annual Balance Sheet
Jun-10 Jun-09 Jun-08 Jun-07 Jun-06
Assets
Cash & Equivalents 2,879 4,781 3,313 5,354 6,693
Short Term Investments 0 0 228 202 1,133
Accounts Receivable 5,335 5,836 6,761 6,629 5,725
Inventory 6,384 6,880 8,416 6,819 6,291
Prepaid Expenses 3,194 3,199 3,785 3,300 2,876
Other Current Assets, Total 990 1,209 2,012 1,727 1,611
Total Current Assets 18,782 21,905 24,515 24,031 24,329
Gross Plant and Equipment 37,012 36,651 38,086 34,721 31,881
Accumulated Depreciation, Total 17,768 17,189 17,446 15,181 13,111
Net Plant and Equipment 19,244 19,462 20,640 19,540 18,770
Goodwill, Net 54,012 56,512 59,767 56,552 55,306
Intangibles – Gross 35,194 35,812 36,904 35,537 35,004
Accumulated Intangible Amortization 3,558 3,206 2,671 1,911 1,283
Intangibles, Net 31,636 32,606 34,233 33,626 33,721
Other Long Term Assets 4,498 4,348 4,837 4,265 3,569
Total Assets 128,172 134,833 143,992 138,014 135,695
Liabilities
Accounts Payable 7,251 5,980 6,775 5,710 4,910
Accrued Expenses 4,679 4,361 4,544 9,586 9,587
Notes Payable / Short Term Debt 7,908 9,379 11,338 9,495 198
Current Portion of Long Term Debt / Capital Leases 564 6,941 1,746 2,544 1,930
Income Taxes Payable 622 722 945 3,382 3,360
Other Current Liabilities 3,258 3,518 5,610 0 0
Total Current Liabilities 24,282 30,901 30,958 30,717 19,985
Long Term Debt 21,360 20,652 23,581 23,375 35,976
Deferred Income Tax 10,902 10,752 11,805 12,015 12,354
Minority Interest 324 283 290 0 0
Pension Benefits – Underfunded 6,616 5,314 3,658 0 0
Other Long Term Liabilities 3,573 3,832 4,206 5,147 4,472
Total Long Term Liabilities 42,775 40,833 43,540 40,537 52,802
Total Liabilities 67,057 71,734 74,498 71,254 72,787
Owner’s Equity
Redeemable Convertible Preferred Stock 1,277 1,324 1,366 1,406 1,451
Common Stock 4,008 4,007 4,002 3,990 3,976
Additional Paid-In Capital 61,697 61,118 60,307 59,030 57,856
Retained Earnings 64,614 57,309 48,986 41,797 35,666
Less: Treasury Stock and Other 70,481 60,659 45,167 39,463 36,041
Total Equity 61,115 63,099 69,494 66,760 62,908
Total Liabilities & Shareholders’ Equity 128,172 134,833 143,992 138,014 135,695
Total Common Shares Outstanding 2,843.47 2,917.04 3,032.72 3,131.95 3,178.84