Calculate the profit margin on sales ratios

Assignment Help Corporate Finance

Reference no: EM131803049

Assignment: Ratio Analysis

By the due date assigned solve the problem below, calculate the ratios, interpret the results against the industry average, and fill in the table on the worksheet. Then, provide an analysis of how those results can be used by the business to improve its performance. Turn in your completed work to the Submissions Area through the end of the day.

Balance Sheet as of December 31, 2010
Gary and Company
Cash	$45	Accounts payables	$45
Receivables	66	Notes payables	45
Inventory	159	Other current liabilities	21
Marketable securities	33	Total current liabilities	$111
Total current assets	$303
Net fixed assets	147	Long Term Liabilities
Total Assets	$450	Long-term debt	24
		Total Liabilities	$135
		Owners Equity
		Common stock	$114
		Retained earnings	201
		Total stockholders' equity	315
		Total liabilities and equity	$450

Income Statement Year 2010
Net sales	$795
Cost of goods sold	660
Gross profit	135
Selling expenses	73.5
Depreciation	12
EBIT	49.5
Interest expense	4.5
EBT	45
Taxes (40%)	18
Net income	27

1. Calculate the following ratios AND interpret the result against the industry average:

Ratio	Your Answer	Industry Average	Your Interpretation (Good-Fair-Low-Poor)
Profit margin on sales		3%
Return on assets		9%
Receivable turnover		16X
Inventory turnover		10X
Fixed asset turnover		2X
Total asset turnover		3X
Current ratio		2X
Quick ratio		1.5X
Times interest earned		7X

2. Analysis:

Give your interpretation of what the ratios calculations show and how the business can use this information to improve its performance. Justify all answers.

Reference no: EM131803049

Questions Cloud

Capital account increase as a result of transaction : By what amount should the additional paid-in capital account increase as a result of this transaction?

Deferred tax asset net of related valuation allowance : No net deferred tax asset (i.e., deferred tax asset net of related valuation allowance) was recognized in the year 1 financial statements by the Chaise Company

The theory of comparative advantage states that : Which of these statements is (are) true regarding minority, women and disabled veteran-owned firms?

Explaining the blue ocean strategy : Jeff, the owner of The Toy Box (a toy store), has chosen his products carefully. They are all handmade of wood; none are cheap games made of cardboard.

Calculate the profit margin on sales ratios : Balance Sheet as of December 31, 2010. Calculate the Profit margin on sales ratios AND interpret the result against the industry average.

Concerning profitability for mobe : Year 1 $ 300,000 Year 2 (700,000) Year 3 1,200,000 For each year, there were no deferred income taxes, and Mobe's effective income tax rate was 30%.

Provide an overview of influence and the major process : It has been stated that different industries and organizational differences influence which motivational techniques and theories are most effective.

Current income tax expense : Bishop Corporation began operations in year 1 and had operating losses of $200,000 in year 1 and $150,000 in year 2. For the year ended December 31

Compute a adjusted sales forecast for each quarter : Joe Barrow, owner of Barrow's Department Store, has used time-series extrapolation to forecast retail sales for the next 4 quarters.

User Account

All Pages