Question: i need help putting my balance sheet into an Excel format. can you provide an example, using my data, to insert where the appropriate placements

Common Balance Sheet 2013 2012 Assets: Current Assets Cash and Equivalents Short-term investments Trading Assets A/R Inventories Deferred tax assets Other current assets 6% 6% 9% 4% 5% 3% 2% 10% 5% 7% 4% 6% 2% 3% 37% 33% Total Current Assets 35% Property, plant and 34% equipment, net Marketable equity securities 7% Other long-term investments 1% Goodwill 11% Identified intangible assets, 6% net Other long-term assets 6% Total Assets 100% 5% 1% 12% 7% 5% 100% 2013 2012 Liabilities: Current Liabilities A/P 3% 4% 4% 4% Accrued Compensation and Benefits Accrued advertising Deferred income 1% 2% 1% 2% in e 4% Accrued Compensation 4% and Benefits Accrued advertising 1% Deferred income 2% Other accrued liabilities 5% Total current liabilities 15% Long-term debt 14% Long-term deferred tax liabilities 5% Other long-term liabilities 3% Total liabilities 37% 1% 2% 4% 15% 16% 4% 4% 39% Stockholders' Equity: Common stock Accumulated other and comprehensive income Retained earnings 23% 1% 23% N/A 39% 38% Case 2.1 Discussion Total Stockholders' Equity Total liabilities & stockholders' equity 63% 100% 61% 100%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
