Question

In: Accounting

Using the income statement below compute the following items. Sales $1,250,000 25 Variable costs 750,000 15...

Using the income statement below compute the following items.

Sales

$1,250,000

25

Variable costs

750,000

15

Contribution margin

500,000

10

40%

Fixed operating costs

200,000

Earnings before interest and taxes

300,000

Interest

125,000

Earnings before taxes

175,000

Taxes (30%)

52,500

Net income

$122,500

Note: The company made and sold 50,000 units this year

Required: Record the answers in the designated spots below. Round to the dollar, do not record the dollar sign, and no comma is needed between thousands and hundreds.

1.    Calculate the breakeven point in sales dollars, assume that interest is a fixed cost.

Answer

2.     Assuming they would like to have a minimum of $250,000 in earnings before taxes.

a)    What is the minimum sales amount in dollars that will need to be maintained?

Answer

b)      How many units would they need to sell?  

Answer

3.    a.     Calculate the Degree of Operating Leverage.  Please record TWO decimals.

Answer

b.     Calculate the Degree of Financial Leverage.

Answer

c.     Calculate their Degree of Combined Leverage

Answer

4.     Using the appropriate degree of leverage from above and assuming that sales increase by 25%, compute the new net income in dollars.

Answer

Solutions

Expert Solution

1)812500.

calculation:-

break even point in sales dollar=fixed cost/pv ratio=(200000+125000)/40%=812500.

2) a)1437500.

calculation

let assume the sales needed to maintain 250000 in earning before tax is x,then

particulars amount($)
sales x
variable expenses(60%) .6x
contribution(40%) .4x
less:fixed expenses 325000
earning before taxes-desired 250000

from the table,we can write as 0.4x-325000=250000 and 0.4x=575000 and x=575000/0.4=1437500.

2b) 57500 units.

calculation

units to be sold=1437500/25=57500 units.

3) a)operating leverage=contribution/earning before interest and tax=500000/300000=1.67 times.

b) financial leverage=earning before interest and taxes/earning before tax=300000/175000=1.71 times.

c) combined leverage=operating leverage x financial leverage=1.67 x 1.71=2.85

4) new net income in dollars=210175

calculation:-

operating leverage=change in EBIT/change in sales

1.67=change in EBIT/25% and change in EBIT=1.67x25%=41.75%

new EBIT=300000+41.75%=425250

EBIT 425250
LESS:interest 125000
EBT 300250
LESS:TAX@30% 90075
Net income 210175

Related Solutions

Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000...
Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000 0.24 $1,350,000 $1,150,000 Fixed Costs Selling $500,000 Administrative $485,000 Manufacturing Overhead $150,000 $1,135,000 Profit Dollars Percentage Calculate the Contribution Margin Calculate the Gross Margin Ratio Calculate Breakeven Sales Calculate Margin of Safety based on the 5% expected sales increase. Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000 0.24 $1,350,000 $1,150,000 Fixed Costs Selling $500,000 Administrative $485,000...
Given the following data below, compute the following statistics: 15 25 24 15 20 30 25
Given the following data below, compute the following statistics:        15        25        24        15        20        30        25     a)The median b)The mode c)The range and the midrange d)?65!" e)The mean f)The variance g)The standard deviation
The following information relates to Wither Ltd £ Sales (250,000 units) 750,000 Manufacturing Costs: Variable 300,000...
The following information relates to Wither Ltd £ Sales (250,000 units) 750,000 Manufacturing Costs: Variable 300,000 Fixed 80,000 Selling & Administrative Costs: Variable 75,000 Fixed 40,000 What is the break even point in units for Wither Ltd?
Presented below is Oxford Ltd.’s income statement for 20x5: Sales (38149 units) $875002 Variable costs -375735...
Presented below is Oxford Ltd.’s income statement for 20x5: Sales (38149 units) $875002 Variable costs -375735 Contribution Margin 499267 Fixed Expenses -213274 Operating Income 285993 Income tax expense -108677 Net Income $177316 How many units must Oxford Ltd. sell in order to generate net income equal to $262438? Select one: a. 69067 units b. 58628 units c. 48640 units d. 36349 units
Presented below is Oxford Ltd.’s income statement for 20x5: Sales (38980 units) $880708 Variable costs -361902...
Presented below is Oxford Ltd.’s income statement for 20x5: Sales (38980 units) $880708 Variable costs -361902 Contribution Margin 518806 Fixed Expenses -186587 Operating Income 332219 Income tax expense -142854 Net Income $189365 Oxford Ltd. is considering installing a robot on its production line. This would decrease variable costs by $3 per unit and increase fixed costs by $160201.   If the company installs the robot, what would be the increase (decrease) in the break-even point (in units)? Note: a negative number...
Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution...
Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution margin 240,000 Fixed costs 80,000 Net income $160,000 (a) At what sales volume (in sales dollars) does Sherpa break even? (b) At what sales volume (in units) does Sherpa break even? (c) Given the income statement above, compute the margin of safety. (d) What level of sales volume must be attained to reach net income of $200,000? (e) What level of sales volume must...
The following items are located “below the line” on the income statement for a manufacturing firm:...
The following items are located “below the line” on the income statement for a manufacturing firm: Select one: a. Interest expense b. All of the listed answers c. None of the listed answers d. Sales tax or value added tax (VAT) taxes e. Deferred revenue
given below is the variable costing income statement for a XY Company:                         Sales, 6,000 units...
given below is the variable costing income statement for a XY Company:                         Sales, 6,000 units @ $35                                                         $210,000 Variable costs: Beginning inventory, 680 units @ $20               $13,600 Variable manufacturing cost of goods manufactured, 6,600 units @ $20       + $132,000 Ending inventory, 1,280 units @ $20               - $25,600 Variable manufacturing cost of goods              $120,000 Variable selling and administrative exp.           + $24,900 Total variable costs                                                       - $144,900 Contribution margin                                                                 $65,100 Fixed costs: Fixed factory overhead                                     $19,800 Fixed selling and...
Consider the following income statement for the Heir Jordan Corporation: Income Statement Sales $45,370 Costs $39,871...
Consider the following income statement for the Heir Jordan Corporation: Income Statement Sales $45,370 Costs $39,871 Taxable Income ? Taxes (35%) ? Net Income ? Dividends $1,349 The projected sales growth rate is 11 percent. What is the projected addition to retained earnings (in $)? Assume costs vary with sales and the dividend payout ratio is constant.
Compute the missing amounts for the following table. A Sales price per unit $1,800 Variable costs...
Compute the missing amounts for the following table. A Sales price per unit $1,800 Variable costs per unit 720 Total fixed costs 669,600 Target profit 1,188,000 Calculate: Contribution margin per unit Contribution margin ratio Required units to break even Required sales dollars to break even Required units to achieve target profit B $10 6 60,000 75,000 C $5,000 3,750 1,187,500 1,875,000 ​(Click the icon to view the​ table.) Compute the missing amounts. ​(Enter the contribution margin ratio to nearest​ percent,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT