Ask Experts Questions for FREE Help !
Ask
    ktdanielson's Avatar
    ktdanielson Posts: 16, Reputation: 1
    New Member
     
    #1

    Jun 19, 2010, 04:00 PM
    finding total sales with cm 40% BE $200,000 w/ net income 50,000 after tax 50%
    What is the formula to calculate total sales for a year when you have CM%, BE point in Sales$ with X Net income after tax of 50%??
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #2

    Jun 20, 2010, 01:25 PM
    We'll answer the question using the given constants, by walking through the logic one step at a time. Afterwards, you can generalize those same concepts into a formula, if you like.

    First we'll have to determine Total Fixed Costs, and we'll use the given breakeven data to do so. Hopefully you're familiar with the fundamental breakeven concept, which can be expressed in "income statement" form as

    Total Revenue less Total Variable Costs less Total Fixed Costs = 0

    (Income tax can be ignored in this phase, since there is no tax expense at breakeven. Both pre- and post-tax net income is zero, so we can safely work with pre-tax net income--and disregard tax rates--in finding our total fixed costs.)

    Since Tot Rev - Tot Var Cost is frequently expressed as "Gross Margin", which is Total Revenue x CM%, the breakeven equation becomes

    (Tot Rev x CM%) - Tot FC = 0

    ... or in this case, ($200K x 0.40) - TotFC = 0

    (This is where you take over and solve that one to determine total fixed costs. I'll hold... )

    Part 2. With Fixed Costs in hand you can now answer the question. If the post-tax net is 50K, and the effective tax rate is 50%, then pre-tax net must be??

    Now you'll just solve for "Tot Rev", where

    (Tot Rev x 40%) - TotFC = Pre-tax Net

    Of course, you'll replace TotFC and Pre-tax Net with the actual dollar amounts you determined previously. That just leaves Tot Rev as the only unknown in the equation. Solve for Tot Rev, and you're done. Have fun!
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #3

    Jun 21, 2010, 09:53 AM
    OK, we're not quite ready to stamp "case closed" on this one just yet. (I do appreciate your appreciation, tho' :))

    The breakeven equation (one form of it, anyway)...

    (Sales x CM%) - Fixed Costs = 0

    ... is just another way of saying that when gross margin (Sales x CM%) exactly equals total fixed costs, the resulting net income is zero. A simple rearrangement shows that at breakeven,

    (Sales x CM%) = Total Fixed Costs

    In your case, then, Tot FC = 200K x 0.4 = 80K.

    Now let's see where our after-tax net income would be, if total sales were 500K:

    Pre-tax net is (500K x 40%) - 80K = 120K.

    At a tax rate of 50%, 120K of pre-tax net results in 60K of after-tax net profit. According to your original post, though, the question is asking for the Sales amount that will produce 50K of after-tax net.

    So warm up the calculator, and have another go at it.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Company earns 2,000 in net income for October and 10,000 in net sale. What is profit [ 2 Answers ]

Can someone help me answer these questions. 1. A company earned $2,000 in net income for October. Its net sales for October were $10,000. Its profit margin is: a. 2% (answer) b. 20% (answer) c. 200% d. 500% e. $8,000 2. Prior to recording adjusting entries, the Office Supplies account...

Sales $300,000, cost $265,000, year end of $2000,00 effect on ROE if 60% dbt ratio [ 1 Answers ]

Last year Charter Corp. had sales of $300,000, operating costs of $265,000, and year-end assets of $200,000. The debt-to-total-assets ratio was 25%, the interest rate on the debt was 10%, and the firm's tax rate was 35%. The new CFO wants to see how the ROE would have been affected if the firm...

Dental delights has two divisions. Division A has a profit of $200,000 on sales of $4 [ 1 Answers ]

Dental delights has two divisions. Division A has a profit of $200,000 on sales of $4,000,000. Division b is only able to make $30,000 on sales of $480,000. Based on the profit margins (returns on sales) which division is superior?

The firm currently uses 50,000 workers to produce 200,000 units of output per day. Th [ 1 Answers ]

The firm currently uses 50,000 workers to produce 200,000 units of output per day. The daily wage (per worker) is $80, and the price of the firmís output is $25. The cost of other variable inputs is $400,000 per day. Although you donít know the firmís fixed cost, you know that it is high enough...


View more questions Search