Calculation of operating profit margin and time interest

Assignment Help Finance Basics
Reference no: EM13356894

Calculation of Operating Profit Margin and Time interest earned.

Utilizing the attached Enclosure 1 "Balance Sheet and Income Statement for Spectrum, Inc"

ENCLOSURE 1

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

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.

 

Industry Norms

Operating profit margin

8.3%

Times interest earned

3.93

 

Reference no: EM13356894

Questions Cloud

Deriving cash collected and cash paid using financial : deriving cash collected and cash paid using financial ratios given.all questions relate to the kimberly-clark corp.
Deriving days in inventory cash to cash cycle and operating : deriving days in inventory cash to cash cycle and operating cycle using ratiosall questions relate to the
Finding net income effective tax rate from given financial : finding net income effective tax rate from given financial ratiosall questions relate to the kimberly-clark corp.
Risk and return involves calculation of stocks beta and : risk and return involves calculation of stocks beta and expected return.beta and required rate of return a stock has a
Calculation of operating profit margin and time interest : calculation of operating profit margin and time interest earned.utilizing the attached enclosure 1 balance sheet and
Calculation of debt ratio and total asset turnover : calculation of debt ratio and total asset turnover ratio.utilizing the attached enclosure 1 balance sheet and income
Calculation of average collection period and return on : calculation of average collection period and return on equity.utilizing the attached enclosure 1 balance sheet and
Calculation of current ratio and acid test ratioutilizing : calculation of current ratio and acid test ratio.utilizing the attached enclosure 1 balance sheet and income statement
Financial statement analysis by ratio analysis of given : financial statement analysis by ratio analysis of given data.you are given the following data on two companies m and n

Reviews

Write a Review

Finance Basics Questions & Answers

  Yield to call and realized rates of return

Calculate the realized rate of return for investors who purchased the bonds when they were issued and who surrender them today in exchange for the call price.

  What is the total dollar amount they will need at closing

They will make a 20% down payment, and they must pay 2 points on the loan. Closing costs should be 3% of the purchase price. What is the total dollar amount they will need at closing?

  Nominal interest rates-inflation and exchange rates

How much would you expect to receive for a nominal interest rate in Spain if funds can be invested in the U. S. at a rate of 7 % when inflation is expected to be 2.5 % in the U. S. and 7 % in Spain?

  Calculate npv of the campaign

Piano Tuners Unlimited is planning a promotional campaign at cost $6,000,000. The resultant after tax cash flows would be $500,000 each year in the absence of debt, and appropriate discount rate for an unlevered PTU would be 7.5 percent.

  Real gdp for fish and chips

The Republic of Republic produces two goods/services, fish (F) and chips (C). In 2006, the 2000 units of F produced sold for $5 per unit and the 5000 units of C produced sold for $2 per unit.

  Calculate the debt to total assets ratio

The following information were taken from the 2004 and 2003 financial statements of American Eagle Outfitters.

  Determine the average return on security

Assume the security I and security J have the following historical returns: determine the average return on security I?

  What must the coupon rate be on mertons bonds

Merton Enterprises has bonds on the market making annual payments, with 16 years to maturity, and selling for $968. At this price, the bonds yield 8 percent.

  Analysis of financial position of the companyin april 1991

analysis of financial position of the company.in april 1991 the owner and manager of pops recycling company j. r. vann

  What is the year-end 2012 balance in accounts receivable

What is the year-end 2012 balance in accounts receivable for Mr. Husker's Tuxedos?

  Calculate price per share required in a new public issue

Calculate the price per share required in a new public issue if the entire surplus generated by the new project is to accrue to the existing shareholders.

  Prepare analyses to help in making their decisions

Using the data provided by the controller, prepare analyses to help Robert and Jane in making their decisions. (Hint: Prepare cost calculations for both product lines using ABC to see whether there is any significant difference in their unit costs). ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd