SURVEY OF ACCOUNTING W/CODE
5th Edition
ISBN: 9781260716252
Author: Edmonds
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
Chapter 9, Problem 17P
To determine
Prepare a horizontal analysis of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
view Policies
Current Attempt in Progress
Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal
place, e.g. 12.5%.)
Dec. 31, 2022
Dec. 31, 2021
Amount
Percentage
Amount
Percentage
Accounts receivable
$ 467,400
$ 410,000
Inventory
$ 785,400
%
$ 660,000
%
Total assets
$3,197,900
%
$2,830,000
%
eTextbook and Media
Save for Later
Attempts: 0 of 3 used
Submit Answer
1. Do the current Ration part
2. Please do a common-size comparative income statements for years Ended December 31,2022, 2019, and 2018
3. Do a balance sheet data in Trend Percents for December 31,2020, 2019, and 2018
Thank you
Instructions
Using the financial statements and additional information, compute the following ratios for the El
Camino Company for 2021. Show all computations.
Computations
1. Current ratio
2. Return on common stockholders' equity
3.
Price-earnings ratio
4.
Inventory turnover
5. Accounts receivable turnover
6.
Times interest earned
7.
Profit margin
8.
Days in inventory
9.
Payout ratio
10. Return on assets
Chapter 9 Solutions
SURVEY OF ACCOUNTING W/CODE
Ch. 9 - 1. Why are ratios and trends used in financial...Ch. 9 - Prob. 2QCh. 9 - Prob. 3QCh. 9 - 4. What is the significance of inventory turnover,...Ch. 9 - 5. What is the difference between the current...Ch. 9 - Prob. 6QCh. 9 - Prob. 7QCh. 9 - Prob. 8QCh. 9 - 9. What are some limitations of the earnings per...Ch. 9 - Prob. 10Q
Ch. 9 - Prob. 11QCh. 9 - Prob. 12QCh. 9 - Prob. 13QCh. 9 - Prob. 14QCh. 9 - Exercise 9-1 Horizontal analysis Winthrop...Ch. 9 - Prob. 2ECh. 9 - Prob. 3ECh. 9 - Prob. 4ECh. 9 - Prob. 5ECh. 9 - Prob. 6ECh. 9 - Prob. 7ECh. 9 - Prob. 8ECh. 9 - Comprehensive analysis The December 31, 2019,...Ch. 9 - Prob. 10ECh. 9 - Prob. 11ECh. 9 - Prob. 12ECh. 9 - Ratio analysis Compute the specified ratios using...Ch. 9 - Prob. 14ECh. 9 - LO 13-2, 13-3, 13-4, 13-5 Exercise 13-15A...Ch. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 19PCh. 9 - Prob. 20PCh. 9 - Problem 9-21 Ratio analysis Selected data for...Ch. 9 - Prob. 22PCh. 9 - Problem 9-23 Ratio analysis The following...Ch. 9 - Prob. 24PCh. 9 - Prob. 1ATCCh. 9 - Prob. 3ATCCh. 9 - ATC 9-5 Ethical Dilemma Making the ratios look...
Knowledge Booster
Similar questions
- ANALY SIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1A, compute the following profitability measures for 20-2 (round all calculations to two decimal places): (a) Profit margin ratio (b) Return on assets (c) Return on common stockholders equity (d) Earnings per share of common stockarrow_forwardSales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.arrow_forwardRATIO ANALY SIS OF COMPARATI VE FIN ANCIAL STATE MENT S Refer to the financial statements in Problem 24-8A. REQUIRED Calculate the following ratios and amounts for 20-1 and 20-2 (round all calculations to two decimal places): (a) Return on assets (Total assets on January 1, 20-1, were 175,750.) (b) Return on common stockholders equity (Total common stockholders equity on January 1, 20-1, was 106,944.) (c) Earnings per share of common stock (The average numbers of shares outstanding were 8,400 shares in 20-1 and 9,200 in 20-2.) (d) Book value per share of common stock (e) Quick ratio (f) Current ratio (g) Working capital (h) Receivables turnover and average collection period (Net receivables on January 1, 20-1, were 39,800.) (i) Merchandise inventory turnover and average number of days to sell inventory (Merchandise inventory on January 1, 20-1, was 48,970.) (j) Debt-to-equity ratio (k) Asset turnover (Assets on January 1, 20-1, were 175,750.) (l) Times interest earned ratio (m) Profit margin ratio (n) Assets-to-equity ratio (o) Price-earnings ratio (The market price of the common stock was 100.00 and 85.00 on December 31, 20-2 and 20-1, respectively.)arrow_forward
- Vanishing Games Corporation (VGC) operates a massively multiplayer online game, charging players a monthly subscription of $15. At the start of January 2021, VGC's income statement accounts had zero balances and its balance sheet account balances were as follows: Cash Accounts Receivable Supplies Equipment Buildings Land Accounts Payable Deferred Revenue Notes Payable (due 2025) Common Stock Retained Earnings $ 1,500,000 150,000 14,700 874,500 422,000 1,200,000 108,000 73,500 60,000 2,500,000 1,419,700 In addition to the above accounts, VGC's chart of accounts includes the following: Service Revenue, Salaries and Wages Expense, Advertising Expense, and Utilities Expense. The January transactions are shown below: a. Received $50,000 cash from customers on 1/1 for subscriptions that had already been earned and charged on account in 2020. b. Purchased 10 new computer servers for $33,500 on 1/2; paid $10,000 cash and signed a three-year note for the remainder owed. c. Paid $10,000 for an…arrow_forwardProblem 17-2A (Algo) Ratios, common-size statements, and trend percer [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets Long-term investments Plant assets, net Total assets Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 2021 $546,242 328,838 217,404 77,566 49,162 126,728 90,676 16,866 $ 73,810 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income KORBIN COMPANY Comparative Balance Sheets December 31 2020 $ 418,466 263,634 2021 % 154,832 57,748 36,825 94,573 60, 259 12,353 $ 47,906 % $61,141 0 113,547…arrow_forwardProblem 13-2A (Algo) Ratios, common-size statements, and trend percents LO P1, P2, P3 (The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2021 2020 2019 $ 442,035 266,105 175,930 62,769 39,783 $ 338,635 212,324 126,311 46,732 29,800 76,532 49,779 10, 205 Sales $ 235,000 Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes 150,400 84,600 31,020 19,505 50,525 34,075 102,552 73,378 13,648 Income tax expense 6,917 Net income $ 59,730 $ 39,574 $ 27,158 KORBIN COMPANY Comparative Balance Sheets December 31 2021 2020 2019 Assets $ 55,578 $ 37,199 $ 49,726 4,570 56,095 Current assets Long-term investments Plant assets, net 900 104,820 95,143 Total assets $ 160,398 $ 133,242 $ 110,391 Liabilities and Equity $ 19,318 $ 23,418 68,000 8,500 60, 480 Current liabilities $ 19,853 Common…arrow_forward
- Problem 17-2A (Algo) Ratios, common-size statements, and trend percents LO P1, [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements. For Years Ended December 31 2021 Sales: Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income Assets Current assets 2020 $436,580 $ 334,456 262,821 173,759 61,994 39,292 Long-term investments Plant assets, net Total assets KORBIN COMPANY Comparative Balance Sheets December 31 Liabilities and Equity Current liabilities Common stock Other paid-in capital Retained earnings Total liabilities and equity 212,045 122,411 46, 155 101,286 72,473 13,480 $ 58,993 $ 37,225 29,432 75,587 46,824 9,599 2021 $ 54,789 0 100, 200 $154,989 $ 22,628 72,000 9,000 51,361 2019 $ 232,100 148,544 83,556 30,637 19,264 49,901 33,655 6,832 $ 26,823 2020 $36,670 900 91,178…arrow_forwardistructions alance sheet for Sandpiper Corporation as of December 31, 2020 using column 2 3 for nets, sub-totals, & totals on the 4-column accounting paper provided online. e the units, tens, hundreds, thousands, etc. in the proper mini column, and leave o commas are necessary when you use the accounting paper properly. Dollar signs f the column and after a total line. o present the following ratios to the nearest tenth: ratio, Debt to assets ratio, Ratio of fixed assets to long-term liabilities, Ratio of total ders' equityarrow_forwardFINANCIAL RATIO: Requirement: Compute for the following financial ratios for the year 2021 (round-off answers to two decimal places) a. Current ratio b. Quick (Acid-test) ratio c. Working capital d. Inventory turnover e. Days of inventory (use 365 days) f. Accounts receivable turnover (assume all sales are on credit) g. Days of receivable (use 365 days) h. Debt ratio i. Equity ratio j. Debt-to-equity ratio k. Gross profit ratio 1. Net profit ratio m. Return on assets n. Return on equityarrow_forward
- Computing Activity Ratios Selected balance sheet and income statement information follows for R.A. Corporation. R.A. Corporation $ millions April 2, 2020 March 28, 2019 Income statement information: Sales $20,967 $22,353 Cost of goods sold 9,654 9,726 Balance sheet information: Accounts receivable, gross 2,313 2,718 Inventory 3,375 3,126 Accounts payable 468 630 Required Compute the following ratios for its fiscal year ended April 2, 2020. Round your answers to two decimal places (for example, enter 20.46 for 20.4555558). a. Accounts receivable turnover Answer b. Average days to collect receivables Answer c. Inventory turnover Answer d. Average days in inventory Answer e. Accounts payable turnover Answer f. Average days payable outstanding Answer g. Cash conversion cycle Answerarrow_forwardPrepare a multi-step vertical analysis income statement for Brea Corporation as of December 31, 2020using column 2 for detail, column 3 for nets, sub-totals, & totals, and column 4 for the vertical analysispercentages to the nearest tenth on the 4-column accounting paper provided online. place the units, tens, hundreds, thousands, etc. in the proper mini column, and leave the pennies blankexcept for earnings per share. Dollar signs are used at the top of the column and after a total line. Double underlining should only beused for net income.Each section starts all the way to the far left of the description column with a header row, then theitems following with an indentation, and then a net or total row with an additional indentation. If thesection is a single item like income tax expense, no header or net total / rows are necessary. Skip a rowbetween each section. Use column 1 as an overflow from the description column. Abbreviations shouldbe avoided on financial statements.Some…arrow_forwardVertical Analysis of Balance Sheet Balance sheet data for a company for the years ended December 31, 20Y2 and 20Y1, are shown below. 20Y2 20Υ1 Current assets $ 752,000 $ 602,000 Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000 Current liabilities 504,000 427,000 Long-term liabilities 1,504,000 1,197,000 Common stock 1,248,000 1,253,000 Retained earnings 4,744,000 4,123,000 | Prepare a comparative balance sheet for 20Y2 and 20Y1, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. Round your answers to one decimal place. Comparative Balance Sheet December 31, 20Y2 and 20Y1 20Y2 Amount 20Y2 Percent 20Y1 Amount 20Y1 Percent Assets Current assets $752,000 % $602,000 % Property, plant, and equipment 6,248,000 5,397,000 Intangible assets 1,000,000 1,001,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage