Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

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.

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

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92061461

Have any Question?


Related Questions in Financial Management

Case project managementnote use excel spreadsheetto carry

Case: Project Management NOTE : Use Excel Spreadsheet to carry on this project. Only ONE file is needed for the project. You can use several sheets within the same file. (ODD GROUPS) Dream Team Productions, a firm hired ...

When looking at the life of a project plan it is useful to

When looking at the life of a project plan, it is useful to graph and outline the cost variance (CV), and schedule variance (SV). Determining progress, or lack of progress, provides essential information to assess a give ...

Assignmentnow that you have gained an understanding of red

Assignment Now that you have gained an understanding of Red Carpet, Leroy has asked you to join in on a preliminary meeting with the VP of HR and other members of the organization to discuss change. The meeting was very ...

Assignment all assignments should be written in your own

Assignment All assignments should be written in your own words and provide examples and opinions beyond the textbook or any other source you get them from. I will be looking for more of your opinions and examples beyond ...

The following examination is due no later than 9 am monday

The following examination is due no later than 9 AM Monday, October 22nd. You are to email me the exam in an XLSX file named after yourself and containing your section. For example, if your name is Leslie King, the file ...

Problem identification and project outlinethe company that

Problem Identification and Project Outline The company that I we will be speaking on is Uber. Uber is a ride sharing app that is in most major city in the United States. Uber started in San Francisco and has branched out ...

Scenario your team has been hired to provide financial

Scenario: Your team has been hired to provide financial analysis for a start-up company, Bobble in Style, which produces customized bobble heads. The bobble heads are made out of less rigid materials and are more true to ...

Assignmentplease conduct preliminary research on the 2008

Assignment Please conduct preliminary research on the 2008 Lehman Brothers Bankruptcy and its various effects on world financial markets, business management, the credit crisis and individual wealth. Your research and re ...

Assignment the art of negotiationresearch a current

Assignment : The Art of Negotiation Research a current conflict or negotiation in progress from the last 6 months like peace talks in the Middle East, a corporate merger, a labor dispute, etc. Write a six to eight (6-8) ...

Financial management assignment questions -1 explain why

Financial Management Assignment Questions - 1. Explain why companies should discount projects using the cost of equity. When should they use the WACC instead? When should they use either? 2. Given the following informati ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As