more-arw search

Q&A Forum

Does any one know how to calculate the revenue need for net income on a certain GM%

Lindsay Ho's Profile

I am working on a budget for next year need to figure out what is the revenue requirement for each GM and net income. For example, operating expense % over revenue is at 27% and GM is at 27%. For Net income of $1000, how much revenue require?

If the GM is 1% lower which is at 26%, operating expense % of revenue is the same at 27%. How much revenue require to have net income at $1000.

Thanks,
Lindsay

Answers

Mark Sutherland
Title: CFO
Company: Profit By Design CFO & Controller Servic..
(CFO, Profit By Design CFO & Controller Services) |

I'm not sure I completely understand your question, but "Target Profit" = (Target Profit $ + Fixed Cost $) / (Contribution Margin Ratio), where:
>Contribution Margin = Sales - Variable Costs, and
>Contribution Margin Ratio = Contribution Margin/Sales

Steve Sheridan
Title: Associate
Company: Dean Lewis Associates
(Associate, Dean Lewis Associates) |

I think I understand your question. I have done something similar, but with fixed operating costs, trying to find what level of sales we need at a given GM to cover expenses.

In your case I created a simple spreadsheet you can try. I believe it's correct but please check the numbers.
Column A is revenue, column B = GM, column C = operating costs, and Column D = net income. Columns A and B are manual inputs. Column C = Column A * .27 (your operating costs as a percentage of revenue). Column D is the formula =ABS((A1*B1)-A1)-C1 where the first part calculates the COGS and then we subtract the operating expenses. If you then do trial and error in Column A, you'll see that at .26 GM, you need revenue of 2128 to get NI of 1000 (1000.16 to be exact).
At 27% GM, you need 2175 of revenue to get NI of 1000 (1000.50).
Those variable operating costs are the tricky part as they go up as revenue does.

Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Yep. aka breakeven analysis?

Steve Sheridan
Title: Associate
Company: Dean Lewis Associates
(Associate, Dean Lewis Associates) |

Yes, it is breakeven analysis, and then we added in the desired NI of 1000

Mark Sutherland
Title: CFO
Company: Profit By Design CFO & Controller Servic..
(CFO, Profit By Design CFO & Controller Services) |

It's "Target Profit" analysis, which is a derivative of breakeven analysis. If you know your fixed vs variable costs, you can skip the trial and error and divide [Target Profit + Fixed costs] by [Contribution margin ratio], which is [Sales - Var.Costs] / Sales.

1955 views
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.