PLEASE SHOW THE FORMULARS ClipboardFontStylesA1Lake Athletics sells two distinct product lines: Apparel and Equipment.ACDEF4LAKE ATHLETICSIncome Statement6.For the Year Ended December 31, 20X17ApparelEquipment8AmountPercentAmountPercent$3,150,0001,400,0001,750,000800,0009 Net sales$5,550,00010 Cost of goods sold11 Gross profit12 Operating expenses13 Operating income14 Other income2,720,0002,830,000875,0001,955,000950,00020,00010,0001,965,000491,00015 Income before tax970,00016 Income tax expense241,250$728,75017 Net income$1,474,7501819 Required:20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columnsfor both product lines above. Express each amount as a percentage of net sales.22 Note: You should use absolute references in the divisors of all formulas.23 2. Use the Excel IF function and the completed vertical analysis above to answer each of thequestions below:212425Which product line has the highest gross profit %?Which product line has the highest net income %?2627Sheet1READY+100%Attempt(s)曲

Answered: Image /qna-images/answer/b56419d9-4979-4ba8-a502-860606da5509.jpg

Answered: Which product line has the highest…

Business

Accounting

Which product line has the highest gross profit %? Which product line has the highest net income %?

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

Sports Emporium has two operating segments: sporting goods and sports apparel. The income statement for each operating segment is presented below. SPORTS EMPORIUMIncome StatementFor the year ended December 31, 2021 Sporting Goods Sports Apparel Amount % Amount % Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income $ 1,800,000 1,040,000 760,000 450,000 310,000 20,000 330,000 80,000 $ 250,000 $ 970,000 440,000 530,000 340,000 190,000 (15,000) 175,000 70,000 $ 105,000 Required:1. Complete the “%” columns to be used in a vertical analysis of Sports Emporium’s two operating segments. Express each amount as a percentage of sales.2. Use vertical analysis to compare the profitability of the two operating segments. Which segment is more profitable?
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Sales $10,850,000.00 $10,000,000.00 3 Cost of goods sold 6,000,000.00 5,450,000.00 4 Gross profit $4,850,000.00 $4,550,000.00 5 Selling expenses $2,170,000.00 $2,000,000.00 6 Administrative expenses 1,627,500.00 1,500,000.00 7 Total operating expenses $3,797,500.00 $3,500,000.00 8 Income from operations $1,052,500.00 $1,050,000.00 9 Other revenue 99,500.00 20,000.00 10 $1,152,000.00 $1,070,000.00 11 Other expense (interest) 132,000.00 120,000.00 12 Income before income tax $1,020,000.00 $950,000.00 13 Income tax expense 420,000.00 400,000.00 14 Net income $600,000.00 $550,000.00 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 1 20Y2 20Y1 2 Assets…
salamagundi, inc. has the following income statement: For the year ended December 31, 2021 net sales: $160 Cost of goods sold: $100 gross profit: $60 Operating expenses: $40 Net income: $20 Using vertical analysis, what percentage is assigned to operating expenses? a. 25% b. 40% c. 66.7% d. 200%
Lamar Swimwear Income Statement 20X1 20X2 20X3 Sales (all on credit) $ 1,200,000 $ 1,500,000 $ 1,875,000 Cost of goods sold 800,000 1,040,000 1,310,000 Gross profit 400,000 460,000 565,000 Selling and admin. Expense 239,900 274,000 304,700 Operating profit (EBIT) 160,100 186,000 260,300 Interest expense 35,000 45,000 85,000 Net income before taxes 125,100 141,000 175,300 Taxes 36,900 49,200 55,600 Net income (EAT) $ 88,200 $ 91,800 $ 119,700 Shares of common stock outstanding 30,000 30,000…
Assume the following information for Fruitful Proprietary Limited. for the year ended December 31, 2011: Sales R5,160 Cost of goods manufactured for the year R1,800 Beginning finished goods inventory R834 Ending finished goods inventory R593 Selling and administrative expenses R424 What is the cost of goods sold for the year ended 31 December 2011?
Game-On Sports operates in two distinct segments: athletic equipment and accessories. The income statement for each operating segment is presented below. GAME-ON SPORTSIncome StatementFor the year ended December 31, 2021 Athletic Equipment Accessories Amount % Amount % Net sales Cost of goods sold Gross profit Operating expenses Operating income Other income (expense) Income before tax Income tax expense Net income $ 3,050,000 1,350,000 1,700,000 750,000 950,000 80,000 1,030,000 235,000 $ 795,000 $ 3,500,000 1,670,000 1,830,000 800,000 1,030,000 (15,000) 1,015,000 210,000 $ 805,000 Required: 1. Complete the “%” columns to be used in a vertical analysis of Game-On Sports’ two operating segments. Express each amount as a percentage of sales. 2. Use vertical analysis to compare the profitability of the two operating segments. Which segment is more profitable?