Question

In: Accounting

SEAGATE TECHNOLOGY PLC Consolidated Balance Sheet June 28, 2019 ($ millions) Current assets Cash and cash...

SEAGATE TECHNOLOGY PLC
Consolidated Balance Sheet

June 28, 2019 ($ millions)

Current assets

Cash and cash equivalents

$2,220

Accounts receivable, net

989

Inventories

970

Other current assets

184

Total current assets

4,363

Property, equipment and leasehold improvements, net

1,869

Goodwill

1,237

Other intangible assets, net

111

Deferred income taxes

1,114

Other assets, net

191

Total assets

$8,885

Current liabilities

Accounts payable

$1,420

Accrued employee compensation

169

Accrued warranty

91

Accrued expenses

552

Total current liabilities

2,232

Long-term accrued warranty

104

Long-term accrued income taxes .

4

Other noncurrent liabilities

130

Long-term debt, less current portion

4,253

Total liabilities

6,723

Shareholders’ equity

Ordinary shares— par value $0.0001, 2.6 billion shares authorized, 1,340,697,595 and

1,354,218,154 shares issued and outstanding, respectively

0

Additional paid-in capital

6,545

Accumulated other comprehensive loss

(34)

Accumulated deficit

(4,349)

Total shareholders' equity

2,162

Total liabilities and shareholders' equity

$8,885



Forecast Seagate Technology’s 2020 balance sheet using the following forecast assumptions, which are expressed as a percentage of revenue unless otherwise indicated.

Accounts receivable, net

9.5%

Inventories

9.3%

Other current assets

1.8%

Deferred income taxes

10.7%

Other assets, net

1.8%

Accounts payable

13.7%

Accrued employee compensation

1.6%

Accrued warranty

0.9%

Accrued expenses

5.3%

Long-term accrued warranty

1.0%

Other noncurrent liabilities

1.3%

  • Forecast no change in the following balance sheet accounts: Goodwill, Long-term accrued income taxes, Long-term debt, less current portion, Ordinary shares, and Accumulated other comprehensive loss.
  • Assume that in 2020, CAPEX will be 5.8% of revenue, and depreciation expense will be 5.4% of Property, equipment and leasehold improvements, gross at the start of the year, which was $9,835 million.
  • Assume that in 2020, the company awards $99 million of stock-based compensation which increases Additional paid-in capital by the same amount. Assume that the company routinely includes this form of compensation in operating expenses each year.
  • The company has a dividend payout ratio of 35.4% of net income.
  • Round all answers to the nearest whole number.
  • Use a negative sign for your Accumulated other comprehensive loss and Accumulated deficit answers.

SEAGATE TECHNOLOGY PLC

Forecasted Balance Sheet

($ millions)

June 2020

Current assets

Cash and cash equivalents

Answer

Accounts receivable, net

Answer

Inventories

Answer

Other current assets

Answer

Total current assets

Answer

Property, equipment and leasehold improvements, net

Answer

Goodwill

Answer

Other intangible assets, net

Answer

Deferred income taxes

Answer

Other assets, net

Answer

Total assets

Answer

Current liabilities

Answer

Accounts payable

Answer

Accrued employee compensation

Answer

Accrued warranty

Answer

Accrued expenses

Answer

Total current liabilities

Answer

Long-term accrued warranty

Answer

Long-term accrued income taxes .

Answer

Other noncurrent liabilities

Answer

Long-term debt, less current portion

Answer

Total liabilities

Answer

Shareholders’ equity

Answer

Ordinary shares— par value $0.0001, 2.6 billion shares authorized, 1,340,697,595 and

Answer

1,354,218,154 shares issued and outstanding, respectively

Answer

Additional paid-in capital

Answer

Accumulated other comprehensive loss

Answer

Accumulated deficit

Answer

Total shareholders' equity

Answer

Total liabilities and shareholders' equity

Answer

Solutions

Expert Solution


Related Solutions

   ABC PLC Consolidated Balance Sheet On December 31, 2019 Working capital Non-current assets Intangible assets...
   ABC PLC Consolidated Balance Sheet On December 31, 2019 Working capital Non-current assets Intangible assets 2,167 Tangible assets 7,937 Investments 74 10,178 Current Assets Inventory 3,739 Account receivable 6,242 cash 1,756 11,737 Current liabilities Account payable: Amounts due within one year (5,023) Net current assets 6,714 Total assets minus current liabilities 1,689.2 Account payable: Amounts due after more than one year (4,884) Provision for liabilities and fees (4,235) Net assets 7,773 Capital and reserves - Capital required - common...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash...
CONSOLIDATED BALANCE SHEET (millions of dollars) 2016 2015 Assets 2016 2015 Current assets 2016 2015 Cash and cash equivalents 3,657 3,705 Notes and accounts receivable 21,394 19,875 Inventories: Crude oil, products and merchandise 10,877 12,037 Materials and supplies 4,203 4,208 Other current assets 1,285 2,798      Total current assets 41,416 42,623 Crude oil, products and merchandise inventories are carried at the lower of current market value or cost (generally determined under the last-in, first-out method – LIFO). Inventory costs include...
ABC PLC Consolidated Balance Sheet at December 31, 2019 CAPITAL EMPLOYED Fixed Assets: Intangible Assets 216,7...
ABC PLC Consolidated Balance Sheet at December 31, 2019 CAPITAL EMPLOYED Fixed Assets: Intangible Assets 216,7 M Tangible Assets 793,7 Investments 7,4 1,017,8 Current Assets Stock 373,9 Debtors 624,2 Cash 175,6 1,173,7 Current Liabilities Creditors: amounts falling due within one year (502,3) Net current assets 671,4 Total assets less current liabilities 1,689.2 Creditors: amounts falling due after more than one year (488,4) Provisions for liabilities and charges (423,5) Net Assets 777,3 CAPITAL AND RESERVES Called up share capital Ordinary shares...
Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash...
Rowan Company Comparative Balance Sheet (dollars in millions) Ending Balance Beginning Balance Assets Current assets: ?Cash and cash equivalents $70 $91 ?Accounts receivable 536 572 ?Inventory ??620 ??580 Total current assets ?1,226 ?1,243 Property, plant, and equipment 1,719 1,656 ?Less accumulated depreciation ??640 ??480 Net property, plant, and equipment ?1,079 ?1,176 Total assets $2,305 $2,419 Liabilities and Stockholders’ Equity Current liabilities: ?Accounts payable $205 $180 ?Accrued liabilities 94 105 ?Income taxes payable ???72 ???88 Total current liabilities 371 373 Bonds...
Complete the following Balance Sheet           ASSETS           Current Assets           Cash    
Complete the following Balance Sheet           ASSETS           Current Assets           Cash                                                                                                   $   250,000           Accounts Receivable           ($_________ less allowance for Doubtful Accounts)                        $1,320,000           Inventory                                                                                             $1,410,000                       Total Current Assets                                                               $_________           Land                                                                                                    $_________           Plant & Equipment ($2,800,000 less                       Accumulated Depreciation ________)                                   $2,110,000           TOTAL ASSETS                                                                               $5,390,000 LIABILITIES AND STOCKHOLDERS EQUITY           Current Liabilities           Accounts Payable                                                                              $   620,000           Notes Payable to banks                                                                      $   130,000           Accrued Wages                                                                                 $________                            Total...
Presented below is the classified balance sheet for one of businesses: ABC PLC Consolidated Balance Sheet...
Presented below is the classified balance sheet for one of businesses: ABC PLC Consolidated Balance Sheet at December 31, 2019 CAPITAL EMPLOYED Fixed Assets: Intangible Assets 216,7 M Tangible Assets 793,7 Investments 7,4 1,017,8 Current Assets Stock 373,9 Debtors 624,2 Cash 175,6 1,173,7 Current Liabilities Creditors: amounts falling due within one year (502,3) Net current assets 671,4 Total assets less current liabilities 1,689.2 Creditors: amounts falling due after more than one year (488,4) Provisions for liabilities and charges (423,5) Net...
COMPARATIVE BALANCE SHEET December 31, 2019 218 2017 Assets Current assets Cash $           3,343,212 $525,710 $658,079...
COMPARATIVE BALANCE SHEET December 31, 2019 218 2017 Assets Current assets Cash $           3,343,212 $525,710 $658,079 Marketable Securities                     120,000               75,000 15,000 Accounts receivable                1,883,580            455,000 525,000 Allowance for Bad Debt (226,030)             (25,000) (105,000) Interest Receivable                        77,378               23,676 21,574 Prepaid Advertising                           4,658 - - Prepaid Insurance                     312,003            139,836 148,945 Prepaid Rent                     111,208               29,050 34,982 Office Supplies                        16,120                  3,520 5,400 Inventory                     757,350            975,000 775,000           Total...
2019 2018 Net Sales $        3,749.9 $        3,917.2 Consolidated Balance Sheet 2019 2018 Cash and Cash equivalents $      &nbs
2019 2018 Net Sales $        3,749.9 $        3,917.2 Consolidated Balance Sheet 2019 2018 Cash and Cash equivalents $             281.9 $             253.2 Trade receivables, net of allowance $7.2 and $9.3, $             450.8 $             448.7 at 12/31/19 & 12/31/18 respectively Other receivables, net $                35.8 $                71.5 Total receivables, net $             486.6 $             520.2 Inventories Finished goods $             255.7 $             242.8 Work in progress $                52.6 $                42.6 Raw materials & supplies $             245.1 $             241.8 LIFO reserve $              (33.8) $              (22.6) Total inventories, net $             519.6 $             504.6 Prepaid expenses and other current assets $                36.8 $                33.2 Total current assets $        1,324.9 $        1,311.2...
Consider the following balance sheet (in $millions): Assets consisting of Cash of $2 and Loans of...
Consider the following balance sheet (in $millions): Assets consisting of Cash of $2 and Loans of $10; Liabilities consisting of Deposits of $8, Debt of $2 and Equity of $2 (Total Assets of $12). The average interest earned on the loans is 7% and the average cost of deposits is 6%. Rising interest rates are expected to reduce the deposits by $3 million. Borrowing more debt will cost the bank 6.5% in the short term. A. What will be the...
A company’s Balance Sheet (in millions) Assets                                  &nbs
A company’s Balance Sheet (in millions) Assets                                                             Liabilities & Equity Current                        $  80               Net Fixed                    $120                            Bonds ($1000 Par)                  130                                                                         Preferred stocks ($100 Par)   40 Total                           $200                            Common Stock ($1 par)         30                                                                         Total                                       $200 The company's bonds have 10 years to mature, pay 10% coupon rate semi-annually and comparable bonds' YTM is 14%. The company’s applicable tax rate is 40%. The market price of common stock is $10.50 per share. The common stock is constantly growing at a rate of 6%. The same growth rate is expected to continue for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT