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

am. 401.
Can you help prepare the 2 attached journal entries for this example The management of Banciu Corporation provides you with comparative balance sheets at December 31, 20X1, and December 31, 20X0, appearing below. December 31, 20X1 20X0 Assets Cash $ 174,000 $ 223,200 Accounts receivable 306,000 327,600 Allowance for uncollectible accounts (19,200 ) (20,400 ) Inventories 579,600 645,600 Machinery and equipment 1,112,400 776,400 Accumulated depreciation on machinery and equipment (499,200 ) (446,400 ) Leasehold improvements 104,400 104,400 Accumulated amortization on leasehold improvements (69,600 ) (58,800 ) Securities held for plant expansion 180,000 0 Patents 33,360 36,000 Totals $ 1,901,760 $ 1,587,600 Liabilities and stockholders’ equity Accounts payable $ 279,360 $ 126,000 Dividend payable 48,000 0 Current portion of 6% serial bonds…
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
Current assets Cash Accounts receivable Inventory Prepaid expenses Total current assets Current liabilities Accounts payable Salaries payable Income tax payable Total current liabilities (a1) a. $8,600 Current ratio 12,900 b. Quick ratio 145,000 5,200 $171,700 $53,300 3,600 1,000 $57,900 2024 $30,100 10,300 :1 105,000 $152,300 :1 6,900 $40,400 5,000 1,000 $46,400 $27,100 7,700 100,000 During 2024, credit sales and cost of goods sold were $138,040 and $82,500, respectively. The 2023 and 2022 credit sales were $151,200 and $151,840, respectively, and the cost of goods sold for the same periods were $79,950 and $82,325, respectively. The accounts receivable and inventory balances at the end of 2021 were $6,900 and $85,000, respectively. 5,600 $140,400 Using the above data, calculate the following ratios: (Round receivables turnover ratio and average collection period to 1 decimal place, e.g. 15.2, days to sell inventory to 0 decimal places, e.g. 152 and all other answers to 2 decimal…
At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year Interest expense Income tax expense Total costs and expenses Net income Earnings per share $ 31,880 88,776 116, 174 9,763 283, 158 $ 529,751 $ 127,951 100,589 162,500 138,711 $529,751 For both the current year and one year ago, compute the following ratios: $ 420,092 213,490 11,707 8,953 Current Year 1 Year Ago The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: $ 688,676 $36,900 63,296 86,176 9,686 260,624 $ 456,682 654,242 $34,434 $ 2.12 2 Years Ago $36,930 50,235 $ 75,636 105, 037 163,500 $ 49,240 81,607 162,500 83,453 112,509 $ 456,682 $ 376,800 54, 576 4,186 230,873 $…
! Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Assets Current Year 1 Year Ago 2 Years Ago Cash $ 29,953 Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity 85,945 110,242 9,742 271,795 $ 507,677 Accounts payable $ 123,883 Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity 94,489 162,500 126,805 $ 34,312 60,046 78,537 9,283 255,475 $ 437,653 $ 71,744 100,660 163,500 101,749 $ 507,677 $ 437,653 For both the current year and one year ago, compute the following ratios: $ 36,464 48,619 52,814 3,893 219,310 $ 361,100 $ 49,095 82,197 162,500 67,308 $ 361,100 Exercise 17-6 (Algo) Common-size percents LO P2 1. Express the balance sheets in common-size percents. 2. Assuming annual sales have not changed in the last…
Computation.
acccounting The following items are reported on a company’s balance sheet: Cash $120,000 Marketable securities 40,000 Accounts receivable (net) 50,000 Inventory 90,000 Accounts payable 150,000 Determine (a) the current ratio and (b) the quick ratio. Round your answers to one decimal place. a. Current ratio fill in the blank 1 b. Quick ratio fill in the blank 2
1
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 $…
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.
TB SA Qu. 16-59 (Static) Complete: Complete: Current Assets Cash Accounts receivable Prepaid rent Merchandise inventory Total current assets $ Amount $ $ $ 12,000 9,000 5,000 28,000 Round to Nearest Hundredth Percent % % % % 100 %

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