BER-Break-Even Revenue
Copyright 2013 ACBA - All Rights Reserved
BusinessAllstars.com

XL    Name Date           
Account1st
Quarter
2nd
Quarter
3rd
Quarter
4th
Quarter
Regression
Option #1
C.O.Rev
Option #2
Revenue $ $ $ $ Var. Cost % % %
Cost of Rev $ $ $ $ Fixed Cost $ $
E.B.I.T. $ $ $ $ R-sqrd

(Enter the quarterly data above, the Income Tax Rate, WACC, & Inv. Capital below and click CALC.
Then enter a Revenue number, Variable Cost %, Fixed Cost and click CALC again.)
% or Rev
Total Year Revenue     $ Revenue $ %
Operating Break-even Revenue     $ Var-Cost $ %
Global Break-even Revenue     $ Cont-Marg $ %
Revenue / GBER        % Fix-Cost $
E.B.I.T. $
Income Taxes     % Adj Taxes $ % or IC
WACC     % NOPAT $ %
Invested Capital     $ Cap charge $ %
Res Income $


Enter Inputs in the YELLOW boxes