![]()
|
Links to >>> |
| Dear Executive, | |||
* Excel:
Break-Even Analysis for Start-Ups * |
|||
This is a back of the envelope kind of calculation to provide a first-level approximation for the required break-even sales, given the GP% and fixed cost. I say for start-ups, because many of my clients are early-stage companies and the required assumptions are a good fit. For early-stage companies that provide software products or are a fabless semiconductor company, the primary fixed cost is people. I have experience as the VP Sales and Marketing (and officer of the company) at a couple of pre-IPO start-ups, and as a member of the senior management team we used the same calculations as a simple sanity check for several variables. Any college text on Finance or Accounting will have a formula for break-even analysis in terms of fixed and variable cost, i.e. S=F/(1-V/P) ; where S=beak-even revenue, F=fixed cost, V=variable cost and P=selling price. Our assumptions are that all cost are fixed and that we use the average GP% for all products. We would rather express the formula in terms found in an Income Statement and then we could write S=OpEx/(1-COGS/Sales), but we note that 1-COGS/Sales can be replaced by GP%, so now we have S=OpEx/GP%. Since
we assumed that all our costs are fixed and primarily
consist of salaries, if we use the average monthly
salary x the number of employees
x burden rate x 12 - it would equal our OpEx. I have created a break-even calculator in Excel that allows you to enter the variables (including EBIT for profitable companies) and quickly solve for headcount or break-even revenue. You can request it by clicking this link -> Please Send Me the Break-Even Calculator. Managerial Cost Accounting, 4th Ed, by Gordon Shillinglaw, 1977, ISBN 0-256-01905-3 Basic Financial Management, 4th Ed, by David F. Scott, Jr., 1988, ISBN 0-13-060716-9 |
|||
| ABOUT
Corbitt Associates Corbitt Associates - your outsourcing choice for sales, marketing or training needs. |
| Sales | Marketing | Training | |
| • Forecasting | • Corporate Presentations | • PowerPoint | ![]() ![]() |
| • Customer Engagement Models | • Product Briefs / Marketing Materials | • Excel | |
| • Dashboard /KPI / EIS | • Creating Price Models | • Word | |
| • Pareto: 80/20 Rule for Sales | • Corporate Intelligence (SWOT) | • Outlook | |
| • Commission Plans | • Organizational Balance | • ACT! and GoldMine | |
| • Territory Coverage | • Targeted Emails /eNewsletters | • Workshops - Full and half day | |
| • Due Diligence Review | • Literature Fulfillment | ||
| • Sales Force Automation (SFA) | • Demand Printing | ||
| • INCOTERMS Explained | • List Rental / Database Hygiene | ||
| • Understand VMI PLans | • Mail Automation Compatibility | ||
| • Negotiating: Beyond Price | • Managing Image Libraries | ||
| • SPC / Quality Topics for Sales |
| If you wish to opt-out from this distribution list, click Unsubscribe and you will be automatically removed |
| If you would like to contact us, please send email to: editor@corbittassociates.com |
Corbitt Associates 3590 Lester CT SW Lilburn, GA 30047-7504 |