FILE Paste A1 Clipboard 4 5 1. Use vertical analysis to compare profitability. 6 * Fa...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FILE Paste A1 Clipboard 4 5 1. Use vertical analysis to compare profitability. 6 * Fa 7 HOME Calibri INSERT PAGE LAYOUT BIU Y 8 9 Net sales 10 Cost of goods sold 11 Gross profit * Font V 1 X 12 Operating expenses 13 Operating income 14 Other income 15 Income before tax 16 Income tax expense 17 Net income 11 Y A A B C 1 Lake Athletics sells two distinct product lines: Apparel and Equipment. 2 The income statement for each product line appears below. 3 Y Conditional Format as Cell Cells Formatting Table Styles Styles fx Lake Athletics sells two distinct product lines: Apparel and Equipment. G % Alignment Number Amount Perform Vertical Analysis - Excel FORMULAS DATA REVIEW LAKE ATHLETICS Income Statement For the Year Ended December 31, 20X1 Apparel $3,150,000 1,400,000 1,750,000 800,000 950,000 20,000 970,000 241,250 $728,750 Percent D Amount VIEW Equipment $5,550,000 2,720,000 2,830,000 875,000 1,955,000 10,000 1,965,000 491,000 $1,474,750 E Percent Editing 5 X Sign In F ▸ Net sales Cost of goods sold Gross profit 2 Operating expenses 3 Operating income 4 Other income 15 Income before tax 16 Income tax expense 17 Net income 18 19 Required: 20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns 21 for both product lines above. Express each amount as a percentage of net sales. 25 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 the questions below: 24 26 27 28 29 30 31 $3,150,000 1,400,000 1,750,000 800,000 950,000 20,000 970,000 241,250 $728,750 Which product line has the highest gross profit %? Which product line has the highest net income %? Sheet1 *** $5,550,000 2,720,000 2,830,000 875,000 1,955,000 10,000 1,965,000 491,000 $1,474,750 Ⓒ FILE Paste A1 Clipboard 4 5 1. Use vertical analysis to compare profitability. 6 * Fa 7 HOME Calibri INSERT PAGE LAYOUT BIU Y 8 9 Net sales 10 Cost of goods sold 11 Gross profit * Font V 1 X 12 Operating expenses 13 Operating income 14 Other income 15 Income before tax 16 Income tax expense 17 Net income 11 Y A A B C 1 Lake Athletics sells two distinct product lines: Apparel and Equipment. 2 The income statement for each product line appears below. 3 Y Conditional Format as Cell Cells Formatting Table Styles Styles fx Lake Athletics sells two distinct product lines: Apparel and Equipment. G % Alignment Number Amount Perform Vertical Analysis - Excel FORMULAS DATA REVIEW LAKE ATHLETICS Income Statement For the Year Ended December 31, 20X1 Apparel $3,150,000 1,400,000 1,750,000 800,000 950,000 20,000 970,000 241,250 $728,750 Percent D Amount VIEW Equipment $5,550,000 2,720,000 2,830,000 875,000 1,955,000 10,000 1,965,000 491,000 $1,474,750 E Percent Editing 5 X Sign In F ▸ Net sales Cost of goods sold Gross profit 2 Operating expenses 3 Operating income 4 Other income 15 Income before tax 16 Income tax expense 17 Net income 18 19 Required: 20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns 21 for both product lines above. Express each amount as a percentage of net sales. 25 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 the questions below: 24 26 27 28 29 30 31 $3,150,000 1,400,000 1,750,000 800,000 950,000 20,000 970,000 241,250 $728,750 Which product line has the highest gross profit %? Which product line has the highest net income %? Sheet1 *** $5,550,000 2,720,000 2,830,000 875,000 1,955,000 10,000 1,965,000 491,000 $1,474,750 Ⓒ
Expert Answer:
Answer rating: 100% (QA)
Requirement 1 LAKE ATHELETICS Income Statements For the year ended 31 20x1 Apparel Equipment ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
All the structures shown here have the molecular formula C8H18. Which structures are the same molecule? (Hint: One way to answer this question is to determine the chemical name for each structure.)...
-
BR Inc. owns a 20 percent interest in a limited partnership. All the other partners are individual shareholders in BR. This year, BR sold land to the partnership for use in the partnership's business...
-
As the economy entered the new millennium, Internet companies were competing head to head in many markets with established, traditional retailers for the consumer's dollar. In comparing the financial...
-
On January 1, 2019, Chiz Company acquired equipment to be used in its manufacturing operations. The equipment has an estimated useful life of 10 years and an estimated residual value of P50,000. The...
-
Insurance companies have developed a product called finite insurance. Under finite insurance, a client firm enters into an insurance contract under which it pays annual premiums to the insurer that...
-
Outline the reasons for holding cash and the big cost associated with it. How do these lead to the objective of cash management? How do marketable securities help or hinder achievement of the...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically attractive?...
-
Conlin Corporation had the following tax information. In 2011 Conlin suffered a net operating loss of $480,000, which it elected to carry back. The 2011 enacted tax rate is 29%. Prepare Conlin's...
-
8. A marine biologist measures the presence of a pollutant in an ocean and concludes that the concentration, C, in parts per million (ppm), as a function of the population, P, of the people who visit...
-
This unadjusted trial balance is for Challenger Construction at the end of its fiscal year, September 30, 2014. The beginning balance of the owner's capital account was $46,000 and the owner invested...
-
Advance Auto Parts is evaluating a project with the following cash flows: Year 0 1 2 Cash Flow -$100,000 215,000 -115,500 If the company uses an interest rate of 7.5%, which one of the following...
-
What does the program below print if the input user entered was: 15 -3 0 Question 2. Can you tell what the program does? Write one sentence explaining what the function does, in plain English....
-
. So far, we have seem how to solve various partial differential equations through separation of variables. It is not difficult to extend this to inhomogeneous equations. Consider, for the equation...
-
I need assistance with my array as I am using it as a method, but it's not working. namespace CPT230Maze { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void...
-
A client has four financial instruments to identify and evaluate. The following figure shows the numerical details. He lost the document that described their classification and prices. He engages...
-
Roller Skate Inc. sells roller skates for $50 per pair. The roller skates have a variable cost of $25 per pair. Roller Skate Inc. has fixed costs of $20,000 per year. Using a cost-volume-profit...
-
1. Using the information from Problem 16-4B, prepare a statement of cash flows for Lim Garden Supplies Inc. using the direct method of presenting cash flows from operating activities. 2. How does Lim...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
Using the knowledge you gained from your interview in mini case 1 , design an interface for the individual you interviewed. What interface design modifications are you making so that the program will...
-
The capital market line, CML, is the graph of the risk and return of portfolio combinations consisting of the risk-free asset and: A. Any risky portfolio. B. The market portfolio. C. The leveraged...
-
Relative to portfolios on the CML, any portfolio that plots above the CML is considered: A. Inferior. B. Inefficient. C. Unachievable.
Study smarter with the SolutionInn App