Question

In: Operations Management

Dynex Company had the following income statement for last year: Sales $200,000 Less: COGS   100,000 Gross...

Dynex Company had the following income statement for last year:

Sales $200,000
Less: COGS   100,000
Gross Profit $100,000
Less: Selling & Admin. Expense     40,000
Operating income $  60,000

Beginning assets were $280,000, and ending assets were $300,000.

Use the excel document found in the Assignments tab to answer the questions below.

  1. Average operating assets were:
  2. Margin was:
  3. Turnover was:
  4. Return on investment was:

Solutions

Expert Solution

Important formula:

Average Operating Asset = (Beginning Assets + Ending Assets)/2

Margin=(Sales-COGS)/Sales

Turnover=(COGS/Average Operating Asset)

Return on Investment=(Operating Income/COGS or Investment) in Percentage format

1 B C D E
2 Sales $200,000
3 Less: COGS $100,000
4 Gross Profit $100,000
5 Less: Selling & Admin. Expense $40,000
6 Operating income $60,000
7 Average Operating Asset = (Beginning Assets + Ending Assets)/2 290000
8 Margin=(Sales-COGS)/Sales 50%
9 Turnover=(COGS/Average Operating Asset) 0.345
10 Return on Investment=(Operating Income/COGS or Investment) in Percentage format 60%

Excel formula:

1 B C D E
2 Sales 200000
3 Less: COGS 100000
4 Gross Profit 100000
5 Less: Selling & Admin. Expense 40000
6 Operating income 60000
7 Average Operating Asset = (Beginning Assets + Ending Assets)/2 =(280000+300000)/2
8 Margin=(Sales-COGS)/Sales =(E2-E3)/E2
9 Turnover=(COGS/Average Operating Asset) =E3/E7
10 Return on Investment=(Operating Income/COGS or Investment) in Percentage format =E6/E3

keosha answered 6 months ago
Next > < Previous

Related Solutions

ABC Company reports the following comparative income statement: 2017 Revenue $100,000 COGS 42,000 Gross Profit 58,000...
ABC Company reports the following comparative income statement: 2017 Revenue $100,000 COGS 42,000 Gross Profit 58,000 SGA Expenses 25,000 Income before tax 33,000 Income tax expense. 11,000 Net Income 22,000 2016 Revenue $70,000 COGS 25,000 Gross Profit 45,000 SGA Expenses 28,000 Income before tax 17,000 Income tax expense. 6,000 Net Income 11,000 Prepare a vertical and horizontal analysis for ABC Company and then calculate the profit margin for ABC Company
Building an Income Statement. During the year, the Senbet Discount Tire Company had gross sales of...
Building an Income Statement. During the year, the Senbet Discount Tire Company had gross sales of $925,000. The firm's cost of goods sold and selling expenses were $490,000 and $220,000, respectively. Senbet also had notes payable of $740,000. These notes carried an interest rate of 4 percent. Depreciation was $120,000. Senbet's tax rate was 35 percent. a. What was Senbet's net income? b. What was Senbet's operating cash flow? Please provide the following for each in the tan box: Sales...
Freeport Company's income statement for last year is as follows: Income Statement Sales $300,000 Less: Cost...
Freeport Company's income statement for last year is as follows: Income Statement Sales $300,000 Less: Cost of goods sold 200,000 Gross margin 100,000 Less: Operating expenses 60,000 Income before taxes 40,000 Less: Income taxes 16,000 Net income $24,000 The beginning and ending balances for last year are available for the following accounts: Ending balance Beginning balance Accounts receivable $32,000 $40,000 Inventory 60,000 50,000 Prepaid expenses 12,000 8,000 Accumulated depreciation (40,000) (30,000) Accounts payable 30,000 45,000 Accrued liabilities 16,000 10,000 Income...
Income Statement Sales  $5 million        -COGS -4.2 million      There are 50,000 shares of c.s. outstanding Gross Profits...
Income Statement Sales  $5 million        -COGS -4.2 million      There are 50,000 shares of c.s. outstanding Gross Profits 800,000 -Operating Expenses -350,000 Operating Profit          450,000 -Interest -125,000 EBT 325,000 -Taxes -97,500 EAT 227,500 Balance Sheet Cash $100,000                     Current liabilities            $480,000 Acct. Rec. $300,000                     Bonds                          $1.5 million Inventory $800,000                     Common stock            $500,000 Fixed Assets $2 million                    Paid-in Capital $600,000         Total Assets   $3.2 million                 Retained Earnings            $120,000 Total Liabilities & Stockholders Equity $3.2 million 1. Based on the financial statements, calculate: A. Current ratio         ...
Tesla, Inc. had the following income statement for last period: Sales $27,000 Cost of Sales (manufacturing)...
Tesla, Inc. had the following income statement for last period: Sales $27,000 Cost of Sales (manufacturing) 11,000 Selling and General Administrative     2,000 Net Income $14,000 If costs of sales was 70% variable and 30% fixed, and Selling and General Expense was 65% variable and 35% fixed. Required: A. Prepare a contribution format income statement. B. Calculate its contribution margin percentage.
Use the following information to construct income statement for the company. • Quantity of sales $100,000...
Use the following information to construct income statement for the company. • Quantity of sales $100,000 • Price per unit $2 • Cost of one unit $1.1 • Total Sales Expenses $25,000 • Total Rent and Utilities $5,000 • Total Marketing Expenses $4,000 • Other expenses $6,000 • Interest Expenses $10,000 Equity $175,000 • Tax expenses $10,000 what is the: cost of goods sold net income sales(revenue) total other expenses EBIT internet expenses tax expenses
Company A shows the following information on its 2009 income statement: sales = $200,000; costs =...
Company A shows the following information on its 2009 income statement: sales = $200,000; costs = $87,000; other expenses = $4,900; depreciation expense = $9,100; interest expense = $14,500; taxes = $29,575; dividends = $10,000. In addition, you're told that the firm issued $7,100 in new equity during 2009 and redeemed $8,700 in outstanding long-term debt. (b) What is the 2009 cash flow to creditors? (c) What is the 2009 cash flow to stockholders? (d) If net fixed assets increased...
(Deferred Income Taxes) This year, a company has each of the following income statement items: Gross...
(Deferred Income Taxes) This year, a company has each of the following income statement items: Gross profits on installment sales. Revenues on long-term construction contracts. Estimated costs of product warranty contracts. Premiums on officers’ life insurance policies with the company as beneficiary. Indicate where deferred income taxes are reported in the financial statements. Specify when deferred income taxes would need to be recognized for each of the items above, and indicate the rationale for such recognition.
The income statement for Huerra Company for last year is provided below: Total Unit   Sales $...
The income statement for Huerra Company for last year is provided below: Total Unit   Sales $ 15,400,000 $ 154.00   Less: Variable expenses 12,320,000 123.20   Contribution margin 3,080,000 30.80   Less: Fixed expense 1,540,000 15.40   Net operating income 1,540,000 15.40   Less: Income taxes @ 30% 462,000 4.62   Net income $ 1,078,000 $ 10.78 The company had average operating assets of $14,000,000 during the year. Required: 1. Compute the company’s ROI for the period using the ROI formula stated in terms of margin...
The income statement for Huerra Company for last year is provided below: Total Unit   Sales $...
The income statement for Huerra Company for last year is provided below: Total Unit   Sales $ 51,000,000 $ 510.00   Less: Variable expenses 35,700,000 357.00   Contribution margin 15,300,000 153.00   Less: Fixed expense 7,650,000 76.50   Net operating income 7,650,000 76.50   Less: Income taxes @ 30% 2,295,000 22.95   Net income $ 5,355,000 $ 53.55 The company had average operating assets of $17,000,000 during the year. Required: 1. Compute the company’s ROI for the period using the ROI formula stated in terms of margin...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT