Prepare the price to earnings ratios

Reference no: EM131093943

1. Balance Sheet -------- From the following balance sheet accounts,

a. Construct a balance sheet for 2013 and 2014.
b. List all the working capital accounts.
c. Find the net working capital for the years ending 2013 and 2014.
d. Calculate the change in net working capital for the year 2014.

Balance Sheet Accounts of Roman Corporation
Account	Balance 12/31/2013	Balance 12/31/2014
Accumulated depreciation	$2,020	$2,670
Accounts payable	$1,800	$2,060
Accounts receivable	$2,480	$2,690
Cash	$1,300	$1,090
Common stock	$4,990	$4,990
Inventory	$5,800	$6,030
Long-term debt	$7,800	$8,200
Plant, property, and equipment	$8,400	$9,200
Retained earnings	$1,370	$1,090

Research two companies' financial statements from the following industries:

• Airline
• Oil/gas

Analyze below table in Financial Management: Core Concepts, Ch. 14: "Financial Ratios: Industry Averages." (Table is below)

Prepare the following ratios for the two sets of financial statements in Microsoft Excel:

• Price to Earnings
• Gross Margin

Table Financial Ratios: Industry Averages

Ratio or Account	Airlines	Auto	Pharmaceuticals	Oil and Gas	Retail	Computer Hardware
P/E ratio	22.44	7.38	87.80	5.39	34.29	20.97
Gross margin	19.28%	21.77%	59.54%	47.47%	24.51%	43.54%
Profit margin	0.75%	3.79%	14.85%	12.14%	2.94%	17.08%
Current ratio	0.92	0.32	2.77	1.11	1.23	2.86
Debt-to-equity ratio	1.69	0.34	0.11	0.19	0.81	0.19
Return on assets	0.70%	3.57%	9.40%	12.11%	6.31%	18.22%
Return on equity	0.77%	10.17%	14.71%	20.10%	16.82%	26.24%

Reference no: EM131093943

Questions Cloud

Determine the effect of germination time : An experiment was conducted to determine the effect of germination time (in days) and temperature (degrees C) on the free alpha amino nitrogen (FAN) content of rice malt. The values shown in the following are the treatment means of FAN with n = 2 ..

What are the bases of social power : As you interact with your colleagues this week, think about whether there can be harmful aftereffects to the overuse or abuse of power. What describes the true sharing of power in a high-stakes organizational environment?

Ethical theories of utilitarianism and kantian ethics : Compare and contrast the ethical theories of utilitarianism and Kantian ethics; address fifteen (15) issues in your discussion. In your opinion, which ethical theory has more merit for business decisions? Defend your choice by stating two (2) re..

Question regarding the liability and compliance : Discuss why good emergency management preparation is important in avoiding liability problems and remaining compliant with state and federal regulations. Consider the duty of the organization during an emergency.

Prepare the price to earnings ratios : Analyze below table 14.8 in Financial Management: Core Concepts, Ch. 14: "Financial Ratios: Industry Averages." Prepare the Price to Earnings ratios for the two sets of financial statements in Microsoft Excel.

Determining the imprisonment or defamation : Can Karen successfully sue for false imprisonment or defamation? From what you have learned about the relationship between a principal and an agent, analyze whether Steve or Big Mart could be liable because of Steve's actions.

Determine the effects of the factors on gel strength : An experiment studied the effects of starch source, starch concentration, and temperature on the strength of gels. This experiment was completely randomized with sixteen units.

Measure of the effectiveness of cancer drugs : One measure of the effectiveness of cancer drugs is their ability to reduce the number of viable cancer cells in laboratory settings. In this experiment, the A549 line of malignant cells is plated onto petri dishes with various concentrations of t..

Fire an employee without a good reason : Should the law allow an employer to fire an employee without a good reason? Conduct research to provide examples to support your position and use your own personal employment experiences when possible.

User Account

All Pages