Question

What formula do you use in excel to convert a consolidated balance sheet into a common size balance sheet.

Formatting . Table Styles . Styles Filter Select Clipboard Font Alignment Cells Editing B38 Consolidated Balance Sheet (In Millions, Except Par Value) 2012 Common Size Balance Sheet 1 December 28, 2013; December 29, 2012; and December 31, 2011 2-1 (in Millions, Except Par Value) 3 Assets 4 Current assets: 5 Cash and cash equivalents 6 Short-term investments 7 Trading assets 8Accounts receivable, net of allowance for doubtful accounts of $38 (S36 in 2011) 2013 2011 $5,674 $8,478 5,065 s5,972 3,999 5,181 $8,441 $5,685$4,591 $4,172 4,734 4,096 2,594 2,117 1,70o 1,589 10 Deferred tax assets Other current assets S 1,6492,512 12 Total current assets 32,084 $31, 358$ 25,872 Property, plant and equipment, net 14 Marketable equity securities 15 Other long-term investments 16 Goodwill $31,428 27,983 23,627 6,221 4,424 S 562 889 $ 10,513 $ 9,710 S 9,254 $ 5,150 6,235 6,267 $5,489 4,148 4,648 $92,358 $ 84,351 71,119 $1,473 $ 493 17 Identified intangible assets, net 8 Other long-term assets 9 Total assets 20 Liabilities and stockholders equity 21 Current liabilities: Instructions Balance Sheet Income Statement 0 Type here to search 810 PM 1/27/2019 Λ圓

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Excel formula for common size balance sheet

A common size balance sheet show the relative percentage of total asset.

the formula for the above excel should be like below.

please enter the formula in cell F5 as =A5/A$19 the answer will be 6% in this cell.

and copy paste the same to all the cell including 2012 and 2011 column as well.

please don't forget to make cells as percentage format

Add a comment
Know the answer?
Add Answer to:
What formula do you use in excel to convert a consolidated balance sheet into a common...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 16-BI Classified Balance Sheet Intel, the world's largest microprocessor chip company, lists the following balance sheet...

    16-BI Classified Balance Sheet Intel, the world's largest microprocessor chip company, lists the following balance sheet items for January 1, 2012 in millions): Property, plant, and equipment, at cost $58,073 Short-term investments 5,181 Common stock and capital in excess of par value 17,036 Cash and cash equivalents 5,065 Other accrued liabilities 2,814 Accounts receivable 3,650 Other current assets 7,880 Accumulated depreciation (34,446) Accounts payable Identified intangible assets 6,267 Inventories 4,096 Deferred income 1,929 Accrued advertising liability 1,134 Other assets 4,648...

  • Consolidated Balance Sheet Working Paper, Bargain Purchase On December 31, 2012, Paxon Corporation acquired all of...

    Consolidated Balance Sheet Working Paper, Bargain Purchase On December 31, 2012, Paxon Corporation acquired all of the outstanding common stock of Saxon Company for $2.88 billion cash. The balance sheets of Paxon and Saxon, immediately prior to the combination, are shown below: Balance Sheets (in millions) Paxon Saxon Assets Cash and receivables $4,576 $1,152 Inventory 2,720 1,440 Equity method investments -- 480 Land 1,040 280 Buildings and equipment, net 3,840 960 Total assets 12,176 4,312 Liabilities and Shareholders' Equity Current...

  • ratios for consolidated balance sheet Starbucks how do i solve for the ratio template? Consolidated Statements...

    ratios for consolidated balance sheet Starbucks how do i solve for the ratio template? Consolidated Statements of Earn Consolidated Balance Sheets Ratios Template Sep 30, 2018 O . 2017 Consolidated Balance Sheets - USD (S) Sin Millions Current Cash and cash equivalents Short-term in Prepaid Expand Other Ass, Cut Equity and cost investments Property, plant and equipment Deferred income Other long-term acts Other intangible assets TOTAL ASSETS Accued liabili Stowalue and liability Current pro long-term de Long-term debe Deed Revenue...

  • LO1 15-1. (Risk-return trade-off) The balance sheet from 2011 to 2014 for Amaze Online Ltd., a...

    LO1 15-1. (Risk-return trade-off) The balance sheet from 2011 to 2014 for Amaze Online Ltd., a consultancy firm, has been provided (figures in thousands) 2013 2014 2011 2012 $200 165 $365 $120 $100 150 $250 $100 Current assets $150 $130 Fixed assets 100 $250 $30 Total $230 $60 Current liabilities Long-term liabilities Owner's equity 60 50 40 80 185 $365 170 130 70 $250 $230 $250 Total Compute current and debt ratios for 4 years. b. What is your opinion...

  • EXHIBIT 3: AMERICAN APPAREL INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET, 2008–2013 December 31, (Amounts and shares...

    EXHIBIT 3: AMERICAN APPAREL INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET, 2008–2013 December 31, (Amounts and shares in thousands, except per share amounts) 2013 2012 2011 2010 2009 2008 ASSETS CURRENT ASSETS Cash $ 8,676 $ 12,853 $ 10,293 $ 7,656 $ 9,046 $ 11,368 Trade accounts receivable 20,701 22,962 20,939 16,688 16,907 16,439 Restricted cash - 3,733 Prepaid expenses and other current assets 15,636 9,589 7,631 9,401 9,994 5,369 Inventories, net 169,378 174,229 185,764 178,052 141,235 148,154 Income taxes receivable...

  • i need help on finding need help on finding the rations 1-5. Compute the financial ratios...

    i need help on finding need help on finding the rations 1-5. Compute the financial ratios based on financial statements of Intel (Exhibits 38.2 and 33.3 on pp. 3-40 and 3.41. 1) Profit Margin 2) Total Asset Turnover 3) Return on Assets 4) Financial Leverage 5) Return on Equity ) Auto Zoom Percentages Dec. 26, 2015 Dec. 27, 2014 Dec. 28, 2013 EXHIBIT 3B.2 Common-Size Balance Sheets Amounts ($ millions) Intel Corporation Dec. 26, Dec. 27, Dec. 28, Common-Size Balance...

  • Question: How many shares are authorized for common stock? Consolidated Balance Sheet In Millions, except per...

    Question: How many shares are authorized for common stock? Consolidated Balance Sheet In Millions, except per share data 12/31/16 12/31/15 ASSETS Current assets Cash and equivalents Accounts and notes receivable Inventories, at cost, not in excess of market Prepaid expenses and other current assets $1,223.4 1,474.1 58.9 565.2 1,527.0 4,848.6 $7,685.5 1,298.7 100.1 558.7 ssets of businesses held for sale Total current assets 9,643.0 Other assets Investments in and advances to affiliates Goodwill Miscellaneous Total other assets 725.9 2,336.5 1,855.3...

  • As Reported Annual Balance Sheet Report Date 10/31/2011 Currency USD Audit Status Not Qualified Consolidated Yes...

    As Reported Annual Balance Sheet Report Date 10/31/2011 Currency USD Audit Status Not Qualified Consolidated Yes Scale Thousands Cash & cash equivalents 80,886 Customer receivables, gross 144,364 Less: allowance for doubtful accounts 1,964 Customers receivables, net 142,400 Other receivables, net 5,740 Total receivables, net 148,140 Inventories, net 223,030 Prepaid expenses & other current assets 18,303 Deferred income taxes 62,523 Total current assets 532,882 Land & land improvements 26,776 Buildings & leasehold improvements 129,252 Machinery & equipment 434,796 Computer hardware &...

  • please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following...

    please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax...

  • please do the balance sheet. information on photo #2 continues on photo #3 and so on....

    please do the balance sheet. information on photo #2 continues on photo #3 and so on. everything is captured. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement Fiscal Years Ended ($ millions) Net Sales Cost of sales Selling general and administrative expenses Divestitures (gain). net Restructuring, impairment and other exit costs Operating income Interest, net Earnings before income tax expense and equity in income...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT