Complete a horizontal analysis for Brown Company. (Negative answers should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round the "percent" answers to the nearest hundredth percent.) Answer is complete but not entirely correct. BROWN COMPANY Comparative Balance Sheet December 31, 2020 and 2019 Increase (Decrease) 2020 2019 Amount Percent Assets Current assets: Cash 15,750 10.500 5,260 O 50.00 Accounts receivable 18,000 13,500 4,500 33.33 O Merchandise inventory 18,750 22,500 (3,750) 9,000 O 15,000O 16.67 O Prepaid advertising 54,000 45,000 20.00 O 16.39 O Total current assets 106,500 91,500 Plant and equipment Building (net) 120,000 126,000 (6,000) O 4.76 O Land 90,000 90,000 Total plant and equipment 210,000 216,000 (6.000) O 2.78 Total assets 316.500 307.500 0..

Complete a horizontal analysis for Brown Company. (Negative answers should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round the "percent" answers to the nearest hundredth percent.) Answer is complete but not entirely correct. BROWN COMPANY Comparative Balance Sheet December 31, 2020 and 2019 Increase (Decrease) 2020 2019 Amount Percent Assets Current assets: Cash 15,750 10.500 5,260 O 50.00 Accounts receivable 18,000 13,500 4,500 33.33 O Merchandise inventory 18,750 22,500 (3,750) 9,000 O 15,000O 16.67 O Prepaid advertising 54,000 45,000 20.00 O 16.39 O Total current assets 106,500 91,500 Plant and equipment Building (net) 120,000 126,000 (6,000) O 4.76 O Land 90,000 90,000 Total plant and equipment 210,000 216,000 (6.000) O 2.78 Total assets 316.500 307.500 0..

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Cullumber Company has these comparative balance sheet data: CULLUMBER COMPANYBalance SheetsDecember 31 2020 2019 Cash $ 16,350 $ 32,700 Accounts receivable (net) 76,300 65,400 Inventory 65,400 54,500 Plant assets (net) 218,000 196,200 $376,050 $348,800 Accounts payable $ 54,500 $ 65,400 Mortgage payable (15%) 109,000 109,000 Common stock, $10 par 152,600 130,800 Retained earnings 59,950 43,600 $376,050 $348,800 Additional information for 2020: 1. Net income was $34,000. 2. Sales on account were $383,300. Sales returns and allowances amounted to $26,600. 3. Cost of goods sold was $200,600. 4. Net cash provided by operating activities was $59,000. 5. Capital expenditures were $26,400, and cash dividends were $16,500. Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g.…
Using these data from the comparative balance sheet of Ivanhoe Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Accounts receivable $ 487,200 $ 420,000 2$ Inventory $ 804,000 $ 670,000 $ Total assets $3,237,600 $2,840,000 eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answer %24
Using these data from the comparative balance sheet of Cullumber Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Accounts receivable $ 608,400 $ 520,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal places. % Inventory $ 931,700 $ 770,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal points. % Total assets $3,381,000 $2,940,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal points. %
Using these data from the comparative balance sheet of Ivanhoe Company, perform horizontal analysis. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 0 decimal places, e.g. 12%.) Increase or (Decrease) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Accounts receivable $ 487,200 $ 420,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal places. % Inventory $ 804,000 $ 670,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal points. % Total assets $3,237,600 $2,840,000 $Enter increase or decrease amount in dollars. Enter increase or decrease in percentages rounded to 0 decimal points. %
24. Partially correct answer icon Your answer is partially correct. Condensed financial data of Sheffield Company for 2020 and 2019 are presented below. SHEFFIELD COMPANYCOMPARATIVE BALANCE SHEETAS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,800 $1,130 Receivables 1,770 1,320 Inventory 1,560 1,890 Plant assets 1,900 1,700 Accumulated depreciation (1,220 ) (1,180 ) Long-term investments (held-to-maturity) 1,300 1,430 $7,110 $6,290 Accounts payable $1,220 $890 Accrued liabilities 190 250 Bonds payable 1,410 1,520 Common stock 1,870 1,730 Retained earnings 2,420 1,900 $7,110 $6,290 SHEFFIELD COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,860 Cost of goods sold 4,710 Gross margin…
Prepare the income statements and balance sheets for years 2018 and 2019 for Thompson Company using the following information. The balance sheet numbers are at the end of year figures.Item20182019Accounts Payable120.0150.0Accounts Receivable150.0180.0Accumulated Depreciation330.0360.0Cash & Cash Equivalents10.012.0Common Stock150.0200.0Cost of Goods Sold750.0850.0Depreciation25.030.0Interest Expense30.033.0Inventory200.0180.0Long-term Debt150.0150.0Gross Plant & Equipment650.0780.0Retained Earnings208.5225.0Sales1,500.01,700.0SG&A Expenses500.0570.0Notes Payable51.567.0Tax Rate21%21%(2) Answer the following questions:(a) How much did Thompson Company spend in acquiring fixed assets in 2019?(b) How much dividend did Thompson Company pay out during 2019?(c) Using the end of year numbers, did the long-term solvency ratios improve or deteriorate from 2018 to 2019? Answer this question using at least two long-term solvency ratios.(d) Using the end of year numbers, did the asset…
Rodriquez Corporation’s comparative balance sheets are presented below: RODRIQUEZ CORPORATIONComparative Balance SheetsDecember 31 2020 2019 Cash $16,500 $17,400 Accounts receivable 25,300 22,100 Investments 20,150 15,850 Equipment 59,950 69,850 Accumulated depreciation—equipment (13,850 ) (10,300 ) Total $108,050 $114,900 Accounts payable $14,850 $11,150 Bonds payable 10,600 30,100 Common stock 49,500 45,500 Retained earnings 33,100 28,150 Total $108,050 $114,900 Additional information: 1. Net income was $18,550. Dividends declared and paid were $13,600. 2. Equipment which cost $9,900 and had accumulated depreciation of $1,600 was sold for $3,300. 3. No noncash investing and financing activities occurred during 2020. Prepare a statement of cash flows for 2020 using the…
II. Direction: The following comparative financial statements are provided by Zeus Company. Using Horizontal and Vertical approach, calculate the missing and write your answer on the blank. Show supporting solutions in a separate sheet of paper. Answer the questions at the bottom of this activity. ZEUS COMPANY COMPARATIVE STATEMENT OF FINANCIAL POSITION December 31, 2019 and 2018 2019 2018 Rate of Inc(Dec) Assets: P550,000.00 10% Current assets 45% 21.98% Long-term investments Fixed assets (net) Intangible assets 200,500.00 25% 30% 0.76% 50,000.00 Total Assets PI,211,500.00 Liabilities: Current liabilities 20% P200,800.00 Long-term liabilities Total liabilities 100,000.00 200,000.00 P400,800.00 Owner's Equity P869.200.00 60% Total liabilities and equity
Cullumber Company has these comparative balance sheet data: CULLUMBER COMPANYBalance SheetsDecember 31 2022 2021 Cash $ 16,350 $ 32,700 Accounts receivable (net) 76,300 65,400 Inventory 65,400 54,500 Plant assets (net) 218,000 196,200 $376,050 $348,800 Accounts payable $ 54,500 $ 65,400 Mortgage payable (15%) 109,000 109,000 Common stock, $10 par 152,600 130,800 Retained earnings 59,950 43,600 $376,050 $348,800 Additional information for 2022: 1. Net income was $34,000. 2. Sales on account were $383,300. Sales returns and allowances amounted to $26,600. 3. Cost of goods sold was $200,600. 4. Net cash provided by operating activities was $59,000. 5. Capital expenditures were $26,400, and cash dividends were $16,500. (d) Inventory turnover. enter inventory turnover in times rounded to 2 decimal places times (e)…
A comparative balance sheet for Carter Fuel Injection Systems, Inc. appears below:Carter Fuel Injection Systems, Inc.Comparative Balance SheetDec. 31, 2020 Dec. 31, 2019AssetsCash $ 34,000 $11,000Accounts receivable 25,000 13,000Inventory 18,000 17,000Prepaid expenses 11,000 9,000Long-term investments -0- 17,000Equipment 55,000 33,000Accumulated depreciation—equipment (20,000) (15,000)Total assets $123,000 $85,000Liabilities and Stockholders' EquityAccounts payable $ 27,000 $ 7,000Bonds payable 35,000 45,000Common stock 31,000 23,000Retained earnings 30,000 10,000Total liabilities and stockholders' equity $123,000 $85,000Additional information:1. Net income for the year ending December 31, 2020 was $35,000.2. Cash dividends of $15,000 were declared and paid during the year.3. Long-term investments that had a cost of $17,000 were sold for $14,000.4. No equipment was sold during 2020.HINT: depreciation expense must be determined. Notice in #4 it states no equipment was “sold”during…
Cullumber Company has these comparative balance sheet data: CULLUMBER COMPANYBalance SheetsDecember 31 2022 2021 Cash $ 16,350 $ 32,700 Accounts receivable (net) 76,300 65,400 Inventory 65,400 54,500 Plant assets (net) 218,000 196,200 $376,050 $348,800 Accounts payable $ 54,500 $ 65,400 Mortgage payable (15%) 109,000 109,000 Common stock, $10 par 152,600 130,800 Retained earnings 59,950 43,600 $376,050 $348,800 Additional information for 2022: 1. Net income was $34,000. 2. Sales on account were $383,300. Sales returns and allowances amounted to $26,600. 3. Cost of goods sold was $200,600. 4. Net cash provided by operating activities was $59,000. 5. Capital expenditures were $26,400, and cash dividends were $16,500. Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
Reconstruct the company’s comparative balance sheet for 2019/2020 using the information and compute and show the missing figures to include the appropriate sign as a positive or negative figure. Maple Group Ltd Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Increase/(Decrease) Assets Cash and cash equivalent ? 25,900 (10,600) Accounts Receivable 43,200 39,000 ? Inventories 93,700 ? (46,200) Fixed Assets, net 251,600 ? ? Total Assets 403,800 415,100 (11,300) Liabilities Accounts payable 26,600 21,000 ? Accrued liabilities 22,800 ? (1,300) Long-term notes payable ? 65,000 ? Stockholders' Equity:…