Evaluate ten financial ratios

Reference no: EM1315938

Calculation of financial ratios.

Utilizing the attached Enclosure 1 "Balance Sheet and Income Statement for Spectrum, Inc"
a) Compute the following ten (10) financial ratios and provide a one sentence explanation of the analytic use of each ratio test. Show your formulas and input. Accuracy to two decimal points is sufficient.
b) Evaluate how Spectrum's financial performance compares to their Industry for each calculated ratio. It is sufficient to rate each ratio as "G"= good, "S" = satisfactory, or "P" = poor.

1	Current ratio	2
2	Acid test ratio	1.06
3	Debt Ratio	0.58
4	Total asset turnover	1.18
5	Inventory Turnover	5.78
6	Operating Income Return on Investment	9.80%
7	Operating profit margin	8.30%
8	Times interest earned	3.93
9	Average collection period*	75 days
10	Return on Equity	12%

* ---Assume all sales are credit sales

Spectrum, Inc. BALANCE SHEET (000)
Cash	$500
Accounts receivable	1,500
Inventories	500
Current assets	2,500
Net fixed assets	5,000
Total Assets	$7,500.00

Accounts payable	1,200
Bank note	300
Total current liabilities	1,500
Long term debt	4,000
Common stock	300
Retained earnings	1,700
Total liabilities and owner\\'s equity	$7,500

Spectrum, Inc. INCOME STATEMENT (000)
Net sales	$8,500
Cost of goods sold	3,400
Gross profit	5,100
Operating expenses	2,900
Net operating income	2,200
Interest expense	580
Earnings before taxes	1,620
Income tax (34%)	551
Net income	$1,069

Reference no: EM1315938

Questions Cloud

Correlation coefficient and the regression equation : Interpret the correlation between each set of variables.

Find unknown variable : Find unknown variable

Financial statement analysis by ratio analysis : Financial statement analysis by ratio analysis of given data and Which company has the higher profit margin and Which company has the higher investment turnover?

Difference between movement along and shift of demand curve : Create a graph that shows Price on the Y-axis and Q demanded and Q Demanded and Q supplied on the X-axis.

Evaluate ten financial ratios : Calculation of financial ratios - Evaluate the following ten (10) financial ratios and provide a one sentence explanation of the analytic use of each ratio test. Show your formulas and input. Accuracy to two decimal points is sufficient.

Calculating and graphing the industry supply curve : Consider the table below the supply schedules for three competitive firms, each producing honey. These three firms make up the overall industry-Calculate the total industry supply at each price and fill in the table.

The algebraic equation of cost functions : The algebraic equation of cost functions

Identifying the error in the given statement : A researcher has a series of Likert-scale items and a measure of frequency of absenteeism. He uses each of the Likert-scaled items in a separate bivariate correlation with absenteeism without testing for the assumptions of linear relationships. Is th..

Impact of increase in price of one good : Assume x and y are the only two goods a person consumes. If after a rise in p x , the quantity demanded of y decreases, one could say

User Account

All Pages