Compute the gross profit margin and operating income margin

Assignment Help Financial Management
Reference no: EM131306830

Assignment

In this module, you were introduced to the income statement and profitability ratios. In this assignment, use the information to create an income statement and then analyze it for profitability. Selected accounts for Jackson, Inc. are listed below along with their balances before closing the year of 12/31/12. Jackson, Inc. is a firm that manufactures wireless mouse systems for laptops. Use this information to complete the required elements below.


Interest expense

2,000

Sales revenue

297,000

Selling expenses

38,200



Administrative expenses

16,700

Cost of goods sold

162,300

Dividends1

12,200



Gain on sale of equipment

3,600

Loss from fire

7,500

Retained Earnings (1/1/12 balance)

335,000

Tax expense

22,800

Dividends were declared and paid to Jackson, Inc. stockholders

Required:

  1. On a spreadsheet, prepare a multistep income statement for the year ending 12/31/12 with proper heading. See link below for sample income statement. Near the bottom of your income statement should be a subtotal for income before taxes and then you should subtract taxes to compute net income. Net income should have a double underline.
  2. On the same spreadsheet, prepare a statement of retained earnings for the year ending 12/31/12 with proper heading. See link below for sample statement of retained earnings. There are no adjustments to retained earnings and ending retained earnings should have a double underline.
  3. On the same spreadsheet, compute the gross profit margin, operating income margin, and net profit margin for 2012, showing the numerator and denominator for all ratios. Take ratios out to the nearest hundredth of a percentage (e.g., 33.33%).
  4. On the same spreadsheet, write a paragraph analyzing each of the profitability ratios for Jackson, Inc. given the following information from previous years and competitors.


Gross profit margin

Operating income margin

Net profit margin

Jackson, 2011

47.22%

26.52%

17.75%

Jackson, 2010

48.87%

25.43%

17.03%

Competitor, 2012

43.22%

31.20%

21.14%

The following links provide sample formatting for income statements and statements of retained earnings.

  • https://www.accountingcoach.com/online-accounting-course/04Xpg04.html#income-statement-multiple-step
  • https://accountingexplained.com/financial/statements/retained-earnings-statement

Reference no: EM131306830

Questions Cloud

What market structure does airline industry likely resemble : Late in the day on August 7,2006 numerous U.S. airlines cut their fares on leisure travelers. What market structure does the airline industry most likely resemble and why?
Why the estimates from the two valuation methods differ : Explain why the estimates from the two valuation methods differ. Address the assumptions implicit in the models themselves as well as those you made during the valuation process.
Design a perceptron network to solve this problem : Consider again the four-class decision problem that we introduced in Problem P4.3. Train a perceptron network to solve this problem using the perceptron learning rule.
What are some projects in place that will address problem : What are some projects in place that will address the problem (suggest one if none exist yet)? Why did you choose your topic? How has learning about the topic affected your ideas going into this assignment?
Compute the gross profit margin and operating income margin : On the same spreadsheet, compute the gross profit margin, operating income margin, and net profit margin for 2012, showing the numerator and denominator for all ratios.
Submit your topic of interest and tell how it relate to race : In a Word document, submit your topic of interest, tell how it relates to race and ethnicity or social change, and explain what you hope to learn from this topic. You will also provide a brief summary of the article.
How to implement a priority-based scheduler : COP4610: Introduction to Operating Systems - Project 4: Priority-based Scheduler - you will learn how to implement a priority-based scheduler forxv6. To get started, download a new copy of the xv6 source code fromhere.
How do you think you will feel after the reactions : Is it a formal norm or an informal one? What reactions by others do you expect? If published, might these reactions affect your life chances? How do you think you will feel after the reactions?
What implications does imperfect nature of type of research : What implications does the imperfect nature of this type of research have for social psychological science? How can these two competing views (by the same person) be reconciled?

Reviews

Write a Review

Financial Management Questions & Answers

  Research to develop new computer game

KADS, Inc., has spent $340,000 on research to develop a new computer game. The firm is planning to spend $140,000 on a machine to produce the new game. Shipping and installation costs of the machine will be capitalized and depreciated; they total $44..

  Current market price of stock reflects its intrinsic value

The stock of Nogro Corporation is currently selling for $20 per share. Earnings per share in the coming year are expected to be $5. The company has a policy of paying out 50% of its earnings each year in dividends. Assuming the current market price o..

  Net change in income if the new credit terms are adopted

Dome Metals has credit sales of $180,000 yearly with credit terms of next 60 days, which is also the average collection period. Assume the firm adopts new credit terms of 3/18, net 60 and all customers pay on the last day of the discount period. what..

  The expected return on the portfolio

You own a portfolio that has $2,500 invested in Stock A and $3,500 invested in Stock B. If the expected returns on these stocks are 10 percent and 16 percent, respectively, what is the expected return on the portfolio?

  What would that do to the corresponding yields

In our simple model of bond supply/demand we found that available income is a crucial factor for bond demand. Use this argument to show what would happen to bond prices in a recession (i.e. national income drops sharply). What would that do to the co..

  Risk-free rate of interest with continuous compounding

A stock price is currently $50. It is known that at the end of six months it will be either $60 or $42. The risk-free rate of interest with continuous compounding is 12% per annum. Calculate the value of a six-month European call option on the stock ..

  What would be the nominal and effective cost of that credit

Lamar Lumber buys $8 million of materials (net of discounts) on terms of 3/5, net 50; and it currently pays after 5 days and takes discounts. Lamar plans to expand, which will require additional financing. What would be the effective cost of that cre..

  What was the net income

Computer World Inc paid out $22.5 million in total common dividends and reported $278.9 million of retained earnings at year end. The prior year's retained earnings were $212.3 million. What was the net income? Assume all the dividends were actually ..

  What is the profit expressed as future value

The forward price of wheat for delivery in three months is $3.90 per bushel, while the spot price is $3.60. The three-month interest rate in continuously compounded terms is 8% per annum. Is there an arbitrage opportunity in this market if wheat may ..

  Evaluate the impact on the budgeted statements

Familiarise yourself with the Anthonys Orchard company and its current situation; this can be done by exploring each of the tabs across the top of the screen in the Anthony's Orchard case study media.

  Based on the company own trailing pe-the stock is worth

The 5-year average trailing P/E of a stock is 18x. The last year EPS was $4.25 and the estimated EPS for the next year is $4.50. Company also paid a dividend of $3.00 last year and is expected to pay a dividend of 3.10 next year. Based on the company..

  Calculate firm required rates of return

Calculate a firm's required rates of return for both of its equity components: Its common stock sells for $50 per share and will pay a $6 dividend next year which is expected to grow at a constant 5% rate. Its preferred stock sells for $22.50 per sha..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd