Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)[The following information applies to the questions displayed below.]The balance sheets for Company A for Year 2 and Year 1 are presented below.Exercise 12-4B Part 1Required:1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. Express each amount as a percentage of totalassets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.)COMPANY ABalance SheetDecember 31Year 2Year 1AmountAmountAssetsCash$ 2,310,000$840,000Accounts receivable1,305,0001,044,000Inventory4,005,0002,136,000Buildings8,580,0008,580,000Less: Accumulated depreciation(1,200,000)(600,000)Total assets$ 15,000,000$ 12,000,000Liabilities and Stockholders' EquityAccounts payable$1,725,000$ 1,380,000Contingent liability1,230,000Common stock4,920,0004,920,000Retained earnings7,125,0005,700,000Total liabilities and stockholders' equity$ 15,000,000$ 12,000,000 Reyuii eu immoITTiativiIExercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)[The following information applies to the questions displayed below.]The balance sheets for Company A for Year 2 and Year 1 are presented below.Exercise 12-4B Part 22. Prepare a horizontal analysis for Year 2 using Year 1 as the base year. (Note: If the percentage increase or decrease cannot becalculated, then leave the cell blank. Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimalplace.)COMPANY ABalance SheetDecember 31YearIncrease (Decrease)Year 2Year 1Amount%AssetsCash$ 2,310,000 $840,000Accounts receivable1,305,0001,044,000Inventory4,005,0002,136,000Buildings8,580,0008,580,000Less: Accumulated depreciation(1,200,000)(600,000)Total assets$ 15,000,000$ 12,000,000Liabilities and Stockholders' EquityAccounts payable$1,725,000 $ 1,380,000Contingent liability1,230,000Common stock4,920,0004,920,000Retained earnings7,125,0005,700,000Total liabilities and stockholders' equity$ 15,000,000 $ 12,000,000

Balance Sheet is a statement of an entity which is generally prepared on yearly basis. It shows…

Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. Express each amount as a percentage of total assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) COMPANY A Balance Sheet December 31 Year 2 Year 1 Amount Amount % Assets Cash $ 2,310,000 2$ 840,000 Accounts receivable 1,305,000 1,044,000 Inventory 4,005,000 2,136,000 Buildings 8,580,000 8,580,000 Less: Accumulated depreciation (1,200,000) (600,000) Total assets $ 15,000,000 $ 12,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,725,000 $ 1,380,000 Contingent liability 1,230,000 Common stock 4,920,000 4,920,000 Retained earnings 7,125,000 5,700,000 Total liabilities and stockholders' equity $ 15,000,000 $ 12,000,000

Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. Express each amount as a percentage of total assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) COMPANY A Balance Sheet December 31 Year 2 Year 1 Amount Amount % Assets Cash $ 2,310,000 2$ 840,000 Accounts receivable 1,305,000 1,044,000 Inventory 4,005,000 2,136,000 Buildings 8,580,000 8,580,000 Less: Accumulated depreciation (1,200,000) (600,000) Total assets $ 15,000,000 $ 12,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,725,000 $ 1,380,000 Contingent liability 1,230,000 Common stock 4,920,000 4,920,000 Retained earnings 7,125,000 5,700,000 Total liabilities and stockholders' equity $ 15,000,000 $ 12,000,000

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity Problem 13-5A (Algo) Part 1 $ 19,500 37,400 84,640 5,900 350,000 $ 497,440 $ 33,000 56,400 134,500 6,900 304,400 $ 535,200 $ 68,340 86,800 190,000 152,300 $ 497,440 $ 535,200 $ 91,300 115,000 206,000 122,900 statement Sales Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividends per share Beginning-of-year balance sheet data Accounts receivable, net Merchandise inventory Total assets Common stock, $5 par value Retained earnings Required: 1a. For both companies compute the (a) current ratio, (b) acid-test ratio, (c) accounts receivable turnover, (d) invent sales in inventory, and () days' sales uncollected. Note: Do not round intermediate calculations. 1b. Identify the company…
A condensed balance sheet for Simultech Corporation and a partially completed vertical analysis are presented below. Complete the vertical analysis by computing each missing line item as a percentage of total assets. (Round your answers to the nearest whole percent.) SIMULTECH CORPORATION Balance Sheet (summarized) January 31 (in millions of U.S. dollars) Cash $433 29 % Current Liabilities $409 27 % Accounts Receivable 294 19 Long-term Liabilities 495 33 Inventory 206 14 Total Liabilities 904 Other Current Assets 109 Common Stock 118 Property and Equipment 27 2 Retained Earnings 492 32 Other Assets 445 29 Total Stockholders’ Equity 610 Total Assets $1,514 100 % Total Liabilities & Stockholders’ Equity $1,514 100 % 2A. What percentage of Simultech’s total assets relate to inventory? (Round your answer to the nearest whole percent.) 2B. What percentage of Simultech’s total assets relate to property…
* Question Completion Status: 1. 4 6 7 8 10 11 12 Presented below are selected account balances for DEF Corporation as of December 31, 2021. (All accounts have their normal balances) Inventory 12/31/21 $65,000 Cost of Goods Sold $230,000 Sales Revenue 450,000 Selling Expenses 26,000 Interest Revenue 10,000 Administrative Expenses 28,000 Dividends 20,000 Income Tax Expense 20,000 Common Stock 70,000 Retained Earnings 48,000 Rent Revenue 13,000 Allowance for Doubtful Accounts 11,000 Accounts Receivables 88,000 Rent Expense 16,000 Instructions: Prepare the necessary closing entries for DEF Corporation on December 31, 2021. Select and copy the table below to answer in the space provided. Account Description Debit Credit Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Close Window Save and Submit
q. 13 A company has $628 in inventory, $1,921 in net fixed assets, $300 in accounts receivable, $141 in cash, and $354 in accounts payable. What are the company’s total current assets? $769 $1,069 $2,990 $1,123 $1,423
Subject: acounting
Question 1 The following are financial statements of Crane Company. Crane CompanyIncome StatementFor the Year Ended December 31, 2022 Net sales $2,192,500 Cost of goods sold 1,010,500 Selling and administrative expenses 900,500 Interest expense 78,000 Income tax expense 62,500 Net income $ 141,000 Crane CompanyBalance SheetDecember 31, 2022 Assets Current assets Cash $ 55,100 Debt investments 89,000 Accounts receivable (net) 168,400 Inventory 236,500 Total current assets 549,000 Plant assets (net) 572,500 Total assets $ 1,121,500 Liabilities and Stockholders’ Equity Current liabilities Accounts payable $ 152,000 Income taxes payable 31,000 Total current liabilities 183,000 Bonds payable 220,740 Total liabilities 403,740 Stockholders’ equity Common stock 345,000 Retained earnings 372,760…
Computation.
1
Click on the icons located on the top-right corners of the data tables below to copy their contents into a spreadsheet. Income Statement Balance Sheet Sales $202,590 Assets Cash and Equivalents Accounts Receivable Costs Except Depreciation $14,950 (99,910) $102,680 EBITDA 1,980 (5,940) $96,740 4,100 $21,030 Depreciation Inventories EBIT Total Current Assets Property, Plant, and Equipment Interest Expense (net) (490) 9,990 Pre-tax Income $96,250 Total Assets $31,020 (33,688) $62,562 Income Tax Liabilities and Equity. Accounts Payable Net Income $1,550 4,080 $5,630 Debt Total Liabilities Stockholders' Equity Total Liabilities and Equity 25,390 $31,020 For the next fiscal year, you forecast net income of $49,600 and ending assets of $508,300. Your firm's payout ratio is 10.6%. Your beginning stockholders' equity is $299,900, and your beginning total liabilities are $120,400. Your non-debt liabilities such as accounts payable are forecasted to increase by $10,400. Assume your beginning…
Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets $ 31,600 88,000 112,500 10,650 281,000 $523,750 $ 36,250 $ 38,400 62,000 83,800 9,350 249,500 $440,900 $ 379,900 Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net 49,500 52,500 4,500 235,000 Total assets Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings $128,400 $ 74,750 $ 50,800 97,000 160,500 137,850 98,250 160,500 107,400 81,600 160,500 87,000 Total liabilities and equity $523,750 $440,900 $ 379,900 ces The company's income statements for the Current Year and 1 Year Ago, follow. 1 Yr Ago For Year Ended December 31 Sales Current Yr $755,000 $ 620,000 Cost of goods sold other operating expenses Interest expense $445,450 234,050 11,300 9,550 $390,600 148,800 12,700 8,925 Income tax expense Total costs and expenses 700,350 561,025 Net income $ 54,650 $…
Single-Step Income Statement The following selected accounts and their current balances appear in the ledger of Prescott Inc. for the fiscal year ended September 30, 20Y8: Cash $187,875 Retained Earnings $ 571,050 Accounts Receivable 337,500 Dividends 281,250 Inventory 855,000 Sales 8,025,750 Estimated Returns Inventory 78,750 Cost of Goods Sold 4,893,750 Office Supplies 33,750 Sales Salaries Expense 874,800 Prepaid Insurance 27,000 Advertising Expense 103,275 Office Equipment 259,200 Depreciation Expense— Store Equipment 18,675 Accumulated Depreciation— Office Equipment 111,375 Miscellaneous Selling Expense 4,500 Store Equipment 1,150,875 Office Salaries Expense 174,150 Accumulated Depreciation— Store Equipment 420,075 Rent Expense 89,775 Accounts Payable 109,350 Insurance Expense 51,638 Customer Refunds Payable 78,750 Depreciation Expense— Office Equipment 36,450…
Assume a company had net Income of $72,000 and provided the following excerpts from its balance sheet: This Year Last Year Current assets: $40,000 $53,000 $13,000 $46,000 $50,000 $11,000 Accounts receivable Inventory Prepaid expenses Current liabilities: $38,000 $18,000 $13,000 $44,000 $15,000 $10,000 Accounts payable Accrued liabilities Income taxes payable If the company did not sell any noncurrent assets during the period and the credits to its accumulated depreciation account were $21,000, then based solely on the informatlon provlded, the company's net cash provided by (used in) operating activities would be: Multiple Cholce $94,000. $52,000. $68,000. $92,000.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS