Financial Accounting, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780134728520
Author: Robert Kemp, Jeffrey Waybright
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 12, Problem 32AP
Common-size financial statements and profitability ratios (Learning Objective 2) 20-25 min.
Otto's Auto Sales asked for your help in comparing the company's profit performance and financial position with the average for the auto sales industry. The owner has given you the company’s income statement and
| Otto's Auto Sales Income Statement Compared with Industry Average Year Ended December 31,2018 |
||||
| OTTO’S | INDUSTRY AVERAGE |
|||
| Met Sales | $955,100 | 100.0% | ||
| Cost of Goods Sold | 651,400 | 64.3% | ||
| Gross Profit | 303,700 | 35,7% | ||
| Operating Expenses | 217,800 | 27.3% | ||
| Operating Income | 85,900 | 8.4% | ||
| Other Expenses | 11,500 | 1.1% | ||
| Net Income | $74,400 | 7.3% | ||
| Otto's Auto Sales Balance Sheet Compared with Industry Average December 31,2018 |
||||
| OTTO’S | INDUSTRY AVERAGE |
|||
| Current Assets | $516,800 | 77.2% | ||
| Fixed Assets, Net | 112,300 | 16.3% | ||
| Intangible Assets, Net | 23,100 | 2.8% | ||
| Other Assets | 27,900 | 3.7% | ||
| Total Assets | $680,100 | 100.0% | ||
| Current Liabilities | $260,600 | 40.1% | ||
| Long-Term Liabilities | 129,200 | 20.3% | ||
| Stockholders' Equity | 282,300 | 39.6% | ||
| Total Liabilities and |
$680,100 | 100.0% | ||
Requirements
- 1. Prepare a two-column common-size income statement and a two-column common-size balance sheet for Otto's Auto Sales. The first column of each statement should present Otto’s Auto Sales' common-size statement and the second column should show the industry averages.
- 2. For the profitability analysis, examine Otto’s Auto Sales'(a) ratio of gross profit to net sales, (b) ratio of operating income to net sales, and (c) ratio of net income to net sales. Compare these figures with the industry averages. Is Otto’s profit performance better or worse than the industry average?
- 3. For the analysis of financial position, examine Otto’s Auto Sales' (a) ratio of current assets to total assets, and (b) ratio of stockholders' equity to total assets. Compare these ratios with the industry averages. Is Otto’s Auto Sales’ financial position better or worse than the industry average?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
(Learning Objective 2: Analyze accounts payable turnover) Barnacle Sales, Inc.’s,comparative income statements and balance sheets show the following selected information for2017 and 2018:2018$2,850,000$ 800,000$ 600,000$ 305,0002017$2,700,000$ 600,000$ 400,000$ 255,000Cost of goods sold.......................................................Ending inventory.........................................................Beginning inventory ....................................................Average accounts payable ...........................................Requirements1. Calculate the company’s accounts payable turnover and days’ payable outstanding (DPO)for 2017 and 2018.2. On the basis of this computation alone, has the company’s liquidity position improved ordeteriorated during 2018?
(Learning Objective 2: Calculate purchases by analyzing inventory account activity)On Willow Grove Department Stores’ most recent balance sheet, the balance of its inventory at the beginning of the year was $12,000. At the end of the year, the inventory balancewas $14,500. During that year, its cost of goods sold was $55,000. All purchases of inventorythroughout the year were on account. What was the total of Willow Grove’s purchases duringthe year?
(Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Cost of goods sold at:FIFO Cost ...............LIFO Cost...............Sales revenue ...............$ 87,63097,980138,000Company managers need to know the company’s gross profit percentage and rate of inventoryturnover for 2018 under1. FIFO.2. LIFO.Which method produces a higher gross profit percentage? A higher inventory turnover?
Chapter 12 Solutions
Financial Accounting, Student Value Edition (5th Edition)
Ch. 12 - Prob. 1DQCh. 12 - Which amount is the base amount for vertical...Ch. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - How would you expect a recession to affect asset...Ch. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 1SCCh. 12 - Prob. 2SCCh. 12 - Prob. 3SCCh. 12 - Prob. 4SCCh. 12 - Prob. 5SCCh. 12 - Prob. 6SCCh. 12 - Prob. 7SCCh. 12 - Prob. 8SCCh. 12 - Prob. 9SCCh. 12 - Prob. 10SCCh. 12 - Prob. 11SCCh. 12 - Prob. 12SCCh. 12 - Prob. 1SECh. 12 - Prob. 2SECh. 12 - Prob. 3SECh. 12 - Prob. 4SECh. 12 - Prob. 5SECh. 12 - Prob. 6SECh. 12 - Prob. 7SECh. 12 - Prob. 8SECh. 12 - Prob. 9SECh. 12 - Prob. 10SECh. 12 - Horizontal analysis(Learning Objective 2)15-20 min...Ch. 12 - Prob. 12AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 14AECh. 12 - Prob. 15AECh. 12 - Prob. 16AECh. 12 - Prob. 17AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 26BECh. 12 - Prob. 27BECh. 12 - Prob. 28BECh. 12 - Prob. 29BECh. 12 - Prob. 30BECh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Current ratio, debt ratio, EPS (Learning Objective...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 35APCh. 12 - Prob. 36APCh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Prob. 39BPCh. 12 - Calculating various ratios for analysis(Learning...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 42BPCh. 12 - Prob. 1CECh. 12 - Prob. 1CPCh. 12 - Prob. 1EIACh. 12 - Prob. 2EIACh. 12 - Prob. 1FACh. 12 - Industry Analysis Purpose: To help you understand...Ch. 12 - Prob. 1SBACh. 12 - Prob. 1WC
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
- E5-57 O E-F:5-23 Journalizing sales transactions (Learning Objective 3) Journalize the following sales transactions for Antique Mall. Explanations are not required. The company estimates sales returns at the end of each month. Jan. 4 & 4 7 8 13 20 20 29 Sold $16,000 of antiques on account, credit terms are n/30, to Cavalli Designs. Cost of goods is $8,000. Received a $300 sales return on damaged goods from Cavalli Designs. Cost of goods damaged is $150. Antique Mall received payment from Cavalli Designs on the amount due from Jan. 4, less the return. Sold $4,900 of antiques on account, credit terms are 1/10, n/45, FOB destination, to White Furniture. Cost of goods is $2,450. Antique Mall paid $70 on freight out to White Furniture. Received payment from White Furniture on the amount due from Jan. 20, less the discount. 4+ 8 144 9 ▶|| F5-57 U A لا insert ← prt sc backspace 9:28 PM 9/21/2022 delete homarrow_forward(Learning Objective 2: Compare gross profit—FIFO vs. LIFO—falling prices)Suppose a Target store in Chicago, Illinois, ended November 2018 with 500,000 units of merchandise that cost $8.00 each. Suppose the store then sold 110,000 units for $960,000 duringDecember. Further, assume the store made two large purchases during December as follows:Dec 8 35,000 units @ $6.10 = $213,50028 50,000 units @ $5.20 = $260,000Requirements1. Calculate the store’s gross profit under FIFO and LIFO at December 31.2. What caused the FIFO and LIFO gross profit figures to differ?arrow_forwardS3-4. (Learning Objective 2: Apply the revenue and expense recognition principles) A largeauto manufacturer sells large fleets of vehicles to auto rental companies, such as Budget andHertz. Suppose Budget is negotiating with the auto manufacturer to purchase 1,000 vehicles.Write a short paragraph to explain to the auto manufacturer when the company should, andshould not, record this sales revenue and the related expense for cost of goods sold. Mention theaccounting principles that provide the basis for your explanation.arrow_forward
- how to solve the both 1+2arrow_forward(Learning Objective 2: Apply various inventory costing methods) A Gold MedalSports outlet store began August 2018 with 42 pairs of running shoes that cost the store $31each. The sales price of these shoes was $63. During August, the store completed these inventory transactions:Units Unit CostSale ............. 16 $319 Purchase...... 81 33$6313 Sale ............. 26 31 63Sale ............. 33 6422 Sale ............. 36 33 6429 Purchase...... 18 35Aug 218 13Unit Sales PriceRequirements1. The preceding data are taken from the store’s perpetual inventory records. Which costmethod does the store use? Explain how you arrived at your answer.2. Determine the store’s cost of goods sold for August. Also compute gross profit for August.3. What is the cost of the store’s August 31 inventory of running shoes?arrow_forwardLearning Objectives 1, 2: Show how to account for inventory in a perpetual systemusing the average-costing method) Western Trading Company purchases inventory in cratesof merchandise; each crate of inventory is a unit. The fiscal year of Western Trading ends eachJanuary 31. Assume you are dealing with a single Western Trading store in Nashville, Tennessee. The Nashville store began the year with an inventory of 20,000 units that cost a total of$1,060,000. During the year, the store purchased merchandise on account as follows:July (29,000 units at $59) ..................................... $1,711,000November (49,000 units at $63) ........................... 3,087,000December (59,000 units at $69)............................ 4,071,000Total purchases..................................................... $8,869,000Cash payments on account totaled $8,541,000. During fiscal year 2018, the store sold 155,000units of merchandise for $15,887,500, of which $4,900,000 was for cash and the balance…arrow_forward
- need complete and correct answer with workingarrow_forward! Required information [The following information applies to the questions displayed below.] Use the following data to graph the sales revenue and net income for Walmart from 2012-2017 in Excel. Data: Problem 6-3 Data.xlsx. (Students can download this data file solve this Problem.) Year 2012 2013 2014 2015 2016 2017 Sales Revenue $468,651,000,000 $476,294,000,000 $ 485,651,000,000 $482,130,000,000 $485,873,000,000 $500,343,000,000 Net Income $17,756,000,000 $16,695,000,000 $17,099,000,000 $15,080,000,000 $14,293,000,000 $10,523,000,000 Create a bar graph for sales revenue and create a line graph for net income, formatting the x- and y- axes with year and numbers and inserting appropriate chart titles. Upload the Spreadsheet containing your Problem using the button below.arrow_forwardPlease see below.arrow_forward
- please answer and explain correctly and completelyarrow_forward1. Prepare the income statement using the single-step format and the balance sheet using the account form. 2. Insert the missing figures in the income statement above. Note that the Gross Profit is 40% of Net Sales and Profit is 10% of Net Sales.arrow_forward(Learning Objective 2: Compare inventory by three methods) SWAT Surplus beganMarch 2018 with 100 tents that cost $10 each. During the month, the company made the following purchases at cost:1826Mar 6 110 tents @ $20120 tents @ $2540 tents @ $30= $2,200= 3,000= 1,200The company sold 318 tents, and at March 31, the ending inventory consisted of 52 tents. Thesales price of each tent was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for March under theaverage-cost, FIFO, and LIFO costing methods. Round the average cost per unit to twodecimal places, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the SWAT Surplus income statement for March. Report gross profit. Operatingexpenses totaled $3,250. The company uses average costing for inventory. The income taxrate is 36%.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License