FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
I NEED HELP SETTING UP AN VERTICAL & HORIZONTAL ANALYSIS
Suppose the comparative balance sheets of Nike, Inc. are presented here.
Nike, Inc.
Comparative Balance Sheets May 31 ($ in millions) |
||||
---|---|---|---|---|
2020
|
2019
|
|||
Assets | ||||
Current assets
|
$ 10,179 | $ 8,700 | ||
Property, plant, and equipment (net)
|
1,890 | 1,800 | ||
Other assets
|
1,404 | 1,800 | ||
Total assets
|
$13,473 | $12,300 | ||
Liabilities and |
||||
Current liabilities
|
$ 3,564 | $ 3,600 | ||
Long-term liabilities
|
1,344 | 1,400 | ||
Stockholders’ equity
|
8,565 | 7,300 | ||
Total liabilities and stockholders’ equity
|
$13,473 | $12,300 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 10..new Comparative balance sheet accounts of Sheridan Inc. are presented below. SHERIDAN INC.COMPARATIVE BALANCE SHEET ACCOUNTSAS OF DECEMBER 31, 2020 AND 2019 December 31 Debit Accounts 2020 2019 Cash $41,600 $33,700 Accounts Receivable 70,500 60,600 Inventory 29,700 23,700 Equity investments 22,300 38,900 Machinery 29,900 18,800 Buildings 67,600 56,300 Land 7,600 7,600 $269,200 $239,600 Credit Accounts Allowance for Doubtful Accounts $2,200 $1,500 Accumulated Depreciation—Machinery 5,600 2,300 Accumulated Depreciation—Buildings 13,500 9,000 Accounts Payable 34,700 24,800 Accrued Payables 3,300 2,600 Long-Term Notes Payable 20,900 31,300 Common Stock, no-par 150,000 125,000 Retained Earnings 39,000 43,100 $269,200 $239,600 Additional data (ignoring taxes): 1.…arrow_forwardCurrent Attempt in Progress Here is financial information for Crane Inc. Current assets Plant assets (net) Current liabilities Long-term liabilities Common stock, $1 par Retained earnings December 31, 2025 $108,600 404,500 103,500 124,600 132,600 152,400 December 31, 2024 $94,500 352,600 67,600 94,500 117,600 167,400 Prepare a schedule showing a horizontal analysis for 2025, using 2024 as the base year. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.)arrow_forwardCondensed financial data of Larkspur, Inc. follow. Larkspur, Inc.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $105,900 $47,000 Accounts receivable 92,700 33,100 Inventory 112,800 101,000 Prepaid expenses 29,200 25,500 Long-term investments 139,400 114,200 Plant assets 274,500 241,400 Accumulated depreciation (46,800 ) (52,400 ) Total $707,700 $509,800 Liabilities and Stockholders’ Equity Accounts payable $111,900 $67,800 Accrued expenses payable 16,000 17,300 Bonds payable 117,200 149,500 Common stock 219,100 175,300 Retained earnings 243,500 99,900 Total $707,700 $509,800 Larkspur, Inc.Income StatementFor the Year Ended December 31, 2022 Sales revenue $392,600 Less:…arrow_forward
- Quantitative Problem: Rosnan Industries' 2022 and 2021 balance sheets and income statements are shown below. Balance Sheets: 2022 2021 Assets Cash and equivalents $ 100 $ 85 Accounts receivable 275 300 Inventories 375 250 Total current assets $ 750 $ 635 Net plant and equipment 2,300 1,490 Total assets $ 3,050 $ 2,125 Liabilities and Equity Accounts payable $ 150 $ 85 Accruals 75 50 Notes payable 150 75 Total current liabilities $ 375 $ 210 Long-term debt 450 290 Total liabilities $ 825 $ 500 Common stock 1,225 1,225 Retained earnings 1,000 400 Total common equity $ 2,225 $ 1,625 Total liabilities and equity $ 3,050 $ 2,125 Income Statements: 2022 2021 Sales $ 2,405 $ 1,585 Operating costs excluding depreciation 1,250 1,000 EBITDA $…arrow_forward10. Comparative balance sheet accounts of Sage Inc. are presented below. SAGE INC.COMPARATIVE BALANCE SHEET ACCOUNTSAS OF DECEMBER 31, 2020 AND 2019 December 31 Debit Accounts 2020 2019 Cash $42,400 $33,800 Accounts Receivable 70,500 59,700 Inventory 30,300 24,200 Equity investments 22,100 38,300 Machinery 30,200 18,500 Buildings 67,500 55,800 Land 7,400 7,400 $270,400 $237,700 Credit Accounts Allowance for Doubtful Accounts $2,300 $1,500 Accumulated Depreciation—Machinery 5,500 2,300 Accumulated Depreciation—Buildings 13,500 8,900 Accounts Payable 34,700 24,700 Accrued Payables 3,300 2,700 Long-Term Notes Payable 20,800 31,000 Common Stock, no-par 150,000 125,000 Retained Earnings 40,300 41,600 $270,400 $237,700 Additional data (ignoring taxes): 1. Net income…arrow_forwardCondensed financial data of Concord Inc. follow. CONCORD INC.Comparative Balance SheetsDecember 31 Assets 2022 2021 Cash $80,500 $48,700 Accounts receivable 87,900 38,600 Inventory 111,900 102,100 Prepaid expenses 29,400 27,900 Long-term investments 139,800 113,700 Plant assets 284,200 241,900 Accumulated depreciation (47,700) (49,100) Total $686,000 $523,800 Liabilities and Stockholders’ Equity Accounts payable $106,000 $63,700 Accrued expenses payable 16,500 21,200 Bonds payable 117,100 149,500 Common stock 219,000 175,100 Retained earnings 227,400 114,300 Total $686,000 $523,800 CONCORD INC.Income StatementFor the Year Ended December 31, 2022 Sales revenue $382,500 Less: Cost of goods sold…arrow_forward
- Determine the WACC, and determine whether the company generated value or not, and what the amount was for both years ANSWER 2020 2021 WACC EVA ROICarrow_forwardHypothetical balance sheets of Nike, Inc. are presented here. Assets NIKE, INC. Condensed Balance Sheet May 31 ($ in millions) Current Assets Property, plant, and equipment (net) Other assets Total assets Liabilities and Stockholders' Equity Current Liabilities Long-term liabilities Stockholders' equity Total liabilities and stockholders' equity $13,150 2022 Assets $9,710 B 1,940 1,500 $3,253 1.270 8,627 Current Assets $13,150 $12,280 Other assets (a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, eg. -55,000, -20 % or (55,000), (20%). Round percentages to 1 decimal place, eg. 12.5%) Total assets 2021 Long-term liabilities $8,720 Property, plant, and equipment (net) 1,870 Assets 1,690 $3,330 Liabilities and Stockholders' Equity Current Liabilities 1,380 7,570 $12,280 Other assets Stockholders' equity Total liabilities and stockholders equity Total assets Current Assets…arrow_forwardcarrow_forward
- Suppose the hypothetical comparative condensed balance sheets of Nike, Inc. are presented here. NIKE, INC.Condensed Balance SheetMay 31($ in millions) 2022 2021 Assets Current Assets $9,580 $8,770 Property, plant, and equipment (net) 1,810 1,800 Other assets 1,540 1,670 Total assets $12,930 $12,240 Liabilities and Stockholders' Equity Current Liabilities $3,150 $3,320 Long-term liabilities 1,320 1,370 Stockholders’ equity 8,460 7,550 Total liabilities and stockholders' equity $12,930 $12,240 Prepare a vertical analysis of the balance sheet data for Nike for 2022. (Round percentages to 1 decimal place, e.g. 12.1%.)arrow_forwardConsider the following abbreviated financial statements for Raines Corp: Current Assets Net fixed assets Raines Corp 2018 and 2019 Partial Balance Sheet Assets 2018 $4,810 2019 $5,930 13,650 16,800 -$3,848.8 -$1,165.8 $381.2 $4,562.8 Liabilities and Owners' Equity 2018 2019 $2,900 $3,150 Current liabilities Common Stock 8,310 8,700 Raines Corp 2019 Income Statement Sales Costs Depreciation Interest paid $25,800 16,050 4,050 The tax rate for 2019 was 34%. Dividends paid during 2019 were $1,300. What is the cash flow from assets for 2019? 1,880arrow_forwardrefer to the photoarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education