Reference no: EM131337521
Financial Statement Assignment
In this assignment, you will use this 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
|
1Dividends 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
APA style.
Very expensive and exclusive restaurant
: Fred takes Betty to dinner at a very expensive and exclusive restaurant. The menu does not mention prices. The server takes their order, and both Betty and Fred enjoyed the meal immensely. When the bill comes, Fred refuses to pay because the menu ..
|
How to run the economy as if the future matters
: Provide a concise discussion of the strengths and weakness of three key arguments in the book. Your discussion for each argument should be analytical rather than descriptive. Avoid lengthy quotes (do not include quotes over one line).
|
Failures to personal shortcomings
: Annie, an employee who often attributes her team failures to bad luck, attributes other teams' failures to personal shortcomings. Which of the following cognitive biases do Annie's attributions exemplify?
|
Nature of the attitude-behavior relationship
: One of the central areas of study and research within social psychology is attitudes. There are three key areas of research: (1) how attitudes are formed, (2) the functions they serve, and (3) the nature of the attitude-behavior relationship
|
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.
|
What organizational parties could be held liable
: What organizational parties could be held liable and why - Are there any grounds to find the patients liable?
|
What is the pressure gradient associated with the flow
: What is the pressure drop associated with water at 27°C flowing with a mean velocity of 0.2 m/s through a 600-m-long cast iron pipe of 0.15-m inside diameter?
|
Explain what types of messages are more effective
: Explain what types of messages are more effective. Explain what types of business message are more effective. List and briefly describe at least three different audiences within your organizations or give examples
|
Find the pressure drop and pump power requirement
: For the smooth pipe condition, generate a plot of pressure drop and pump power requirement for mean velocities in the range from 0.05 to 1.5 m/s.
|