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

  What makes quantitative analysis of country risk challenging

What makes the quantitative analysis of country risk challenging?

  What is the total amount of fees to be paid in a year

Beckheart is seeking financing for its inventory. Safe-proof Warehouses offers space in their facility for Beckheart's inventory. They offer loans with a 15 percent APR equal to 60 percent of the inventory.

  What is the discounted payback period

The initial outlay or cost for a four-year project is $1,000,000. The respective cash inflows for years 1, 2, 3 and 4 are: $500,000, $200,000, $300,000, $300,000. What is the discounted payback period if the discount rate is 10%?

  Calculate the new roe for ll

Observing that HL has a higher ROE, LL's treasurer is thinking of raising the debt-to-capital ratio from 30% to 60%, even though that would increase LL's interest rate on all debt to 15%. Calculate the new ROE for LL. Round your answer to two deci..

  Calculate the amount of caseys expected cash collections

Sales for the quarter are projected as follows: April, $60,000; May, $50,000; and June, $70,000. Accounts receivable on March 31 were $30,000. Calculate the amount of Casey's expected cash collections for June.

  Compare and contrast the weaknesses and the threats

Assuming that a organization is privately held, wants to expand operations, and is faced with three options for expansion: Going public through an IPO, Acquiring another organization in the same industry, Merging with another organization.

  What about the worst-case scenario

What values should the company use for the four variables given here when it performs its best-case scenario analysis? What about the worst-case scenario?

  What is progressive cost of equity and corporate cost

The CFO estimates that the present value of any future financial distress costs is $8 million, and that the probability of distress increases with the amount of debt in the following steps.

  How would this rank order change

What is the risk factor associated with international investing that potentially can also be viewed as a benefit [and hence, a 4th reason to invest internationally -- see question #1]. IF this factor is trending favorably for your investment portf..

  The yields to maturity ?on each bond

Under the assumption that you expect the yields to maturity ?on each bond to be 7% at the beginning of next year.

  What fraction of the payment made at the end

Your company is planning to borrow $1,250,000 on a 9-year, 15%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal plac..

  The capital asset pricing model

Assume that the stock of the new cologne manufacturer, Eau de Rodman, Inc., has been forecast to have a return with standard deviation .30 and a correlation with the market portfolio of .9.

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