Question

Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 (S in millions, except per share amounts) December Assets December 31,
Liabilities and Shareholders Equity Current Liabilities Accounts payable $3,934 $3,234 Unredeemed gift card liabilities 496
Q3 (20 Points) A- For the Balance Sheet above do the vertical and horizontal analysis as shown in the right columns. B- Calcu
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Part A

Assets 31 Dec, 2007 ($) 31 Dec, 2006 ($) Vertical common size for 2007 Calculation Horizontal common size for 2007 Calculation
Current Assets
Cash and Cash equivalents                      1,205                         748 8.88% =1205/Total assets 61.10% =(1205-748)/748
Short Term Investments                      2,588                      3,041 19.07% =2588/Total assets -14.90% =(2588-3041)/3041
Receivables                         548                         449 4.04% 22.05%
Merchandise Inventories                      4,028                      3,338 29.68% 20.67%
Other current Assets                         712                         409 5.25% 74.08%
Total Current Assets                      9,081                      7,985
Property and Equipment
Land & Buildings                         705                         580 5.20% 21.55%
Leasehold Equipments                      1,540                      1,325 11.35% 16.23%
Fixtures and equipments                      2,627                      2,898 19.36% -9.35%
Property under Capital Lease                            32                            33 0.24% -3.03%
Total Property and Equipment                      4,904                      4,836 36.14% 1.41%
Less : accumulated depreciation                      1,966                      2,124 14.49% -7.44%
Net Property and Equipment                      2,938                      2,712 21.65% 8.33%
Goodwill                         919                         557 6.77% 64.99%
Trade name                            81                            44 0.60% 84.09%
Long Term Investments                         318                         218 2.34% 45.87%
Other Assets                         233                         348 1.72% -33.05%
Total Assets                   13,570                   11,864
Liabilities and Shareholders' Equity
Current Liabilities
Accounts Payable                      3,934                      3,234 28.99% =3934/Total liabilities 21.65% =(3934-3234)/3234
Unredeemed Gift card liabilities                         496                         469 3.66% 5.76%
Accrued compensation and related expenses                         332                         354 2.45% -6.21%
Accrued liabilities                         990                         878 7.30% 12.76%
Accrued income taxes                         489                         703 3.60% -30.44%
Short term debt                            41                             -   0.30%
Current portion of long term debt                            19                         418 0.14% -95.45%
Total Current Liabilities                      6,301                      6,056
Non Current Liabilities
Long term liabilities                         443                         373 3.26% 18.77%
Long term debt                         590                         178 4.35% 231.46%
Minority interest                            35                             -   0.26%
Total Non Current Liabilities                      1,068                         551
Shareholders equity
Preferred Stock                             -                               -   0%
Know the answer?
Add Answer to:
Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 (S in millions, except per share amounts) December...
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
  • Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 ($ in millions, except per share amounts) Assets...

    Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 ($ in millions, except per share amounts) Assets December December 31, 2007 31, 2006 Vertical Common Size for 2007 Horizontal Common St $ 1,205 2,588 548 4,028 $ 748 3,041 449 3,338 409 7,985 712 9,081 Current Assets Cash and cash equivalents Short-term investments Receivables Merchandise inventories Other current assets Total current assets Property and Equipment Land and buildings Leasehold improvements Fixtures and equipment Property under capital lease Total Property and equipment...

  • Microsoft Word - (4) TakeHome Bom FSA bCcDdEe CcDdEe dEe cDdEe cDdEe bCcDdEe 11 bCcDdEe ....

    Microsoft Word - (4) TakeHome Bom FSA bCcDdEe CcDdEe dEe cDdEe cDdEe bCcDdEe 11 bCcDdEe . 1 تأكيد دقيق عنوان فرعی العنوانه Yulgas عنوان ۱ بلا تباعد sal 1 آرماد Assets December 31, 2007 December 31, 2006 Vertical Common Size for 2007 Horizontal Common S $1,205 2,588 548 4,028 712 9,081 $748 3,041 449 3,338 409 7,985 Current Assets Cash and cash equivalents Short-term investments Receivables Merchandise inventories Other current assets Total current assets Property and Equipment Land and buildings...

  • 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...

  • CAMPBELL SOUP COMPANY Consolidated Balance Sheets (Millions, except per share amounts) July 30, 2017 319 605 902 74 1,9...

    CAMPBELL SOUP COMPANY Consolidated Balance Sheets (Millions, except per share amounts) July 30, 2017 319 605 902 74 1,900 2,454 2,115 1,118 139 $ 7,726 $ 1,037 666 561 111 20 Current assets Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Plant assets, net of depreciation Goodwill Other intangible assets, net of amortization Other assets ($51 as of 2017 attributable to variable interest entity) Total assets Current liabilities Short-term borrowings Payable to suppliers and...

  • Question: How many shares were outstanding for the year 2015? Consolidated Balance Sheet In Millions, except...

    Question: How many shares were outstanding for the year 2015? 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 Assets of businesses held for sale Total current assets $1,223.4 $7,685.5 1,474.1 58.9 565.2 1,527.0 4,848.6 1,298.7 100.1 558.7 9,643.0 Other assets Investments in and advances to affiliates Goodwill Miscellaneous Total other assets 725.9 2,336.5...

  • Consolidated Balance Sheets - USD ($) $ in Thousands Jun. 30, 2018 Dec. 31, 2017 Current...

    Consolidated Balance Sheets - USD ($) $ in Thousands Jun. 30, 2018 Dec. 31, 2017 Current assets Cash and cash equivalents $ 37,148 $ 235,336 Receivables (net of allowance for doubtful accounts of $14,087 and $12,221, respectively) 186,034 125,870 Income taxes receivable 50 0 Notes receivable, net of allowance 29,237 13,256 Other current assets 30,683 25,967 Total current assets 283,152 400,429 Property and equipment, at cost, net 112,567 83,374 Goodwill 173,741 80,757 Intangible assets, net 248,469 100,492 Notes receivable, net...

  • Please create a horizontal and vertical analysis Jane Doe CORPORATION CONSOLIDATED BALANCE SHEETS (in millions, except...

    Please create a horizontal and vertical analysis Jane Doe CORPORATION CONSOLIDATED BALANCE SHEETS (in millions, except per share data) Sep 30, Oct 1, 2018 2017 ASSETS Current assets: Cash and cash equivalents $          8,756.30 $          2,462.30 Short-term investments 181.50 228.60 Accounts receivable, net 693.10 870.40 Inventories 1,400.50 1,364.00 Prepaid expenses and other current assets 1,462.80 358.10 Total current assets 12,494.20 5,283.40 Long-term investments 267.70 542.30 Equity and cost investments 334.70 481.60 Property, plant and equipment, net 5,929.10 4,919.50 Deferred income...

  • Burch Industries Consolidated Income Statements (in thousands, except per share data) Year ended December 31, 2019...

    Burch Industries Consolidated Income Statements (in thousands, except per share data) Year ended December 31, 2019 2017 2018 $3,405,211 Revenues $3,930,984 $3,003,610 Costs and expenses: Cost of goods sold Selling and administrative $2,386,993 $2,089,089 $1,850,530 922,261 761,498 30,665 Interest 25,739 664,061 27,316 (43) Other expenses (income) 1,475 2,141 Total costs and expenses $3,336,468 $2,883,393 $2,541,864 Income before income taxes $594,516 $521,818 $461,746 Income taxes 229,500 192,600 174,700 Net income $365,016 $329,218 $287,046 Burch Industries Consolidated Balance Sheets (in thousands) December...

  • Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019....

    Presented here are the comparative balance sheets of Hames Inc. at December 31, 2020 and 2019. Sales for the year ended December 31, 2020, totaled $650,000. HAMES INC. Balance Sheets December 31, 2020 and 2019 2020 2019 $ 19,000 78,000 103,000 $ 200,000 50,000 125,000 (65,000) $ 310,000 $ 20,000 72,000 99,000 $191,000 40,000 110,000 (60,000) $ 281,000 Assets Cash Accounts receivable Merchandise inventory Total current assets Land Plant and equipment Less: Accumulated depreciation Total assets Liabilities Short-term debt Accounts...

  • Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments...

    Presented below is the balance sheet for HHD, Inc., at December 31, 2021. Current assets Investments Property, plant, and equipment Intangible assets Total assets Current liabilities Long-term liabilities Shareholders' equity Total liabilities and shareholders' equity $ 660,000 545,000 2,420,000 230,000 $3,855,000 $ 460,000 695,000 2,700,000 $3,855,000 The captions shown in the summarized statement above include the following: a. Current assets: cash, $165,000; accounts receivable (net). $215,000; inventory $240,000; and prepaid insurance, $40,000, b. Investments: Investment in equity securities, short term,...

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