Break-Even Analysis Model

The break-Even analysis Model is a perfect Planning and Scenario Analysis Tool. Just enter few inputs into the model and observe how the next twelve periods will unfold. By changing single or multiple variables, application user can perform The(input-to-output) Sensitivity Analysis as well.

Model automatically calculates the following key metrics:

• Break-Even point in unit sales for every period;

• Break-Even Point in overall dollar sales for every period;

• Revenue per period;

• Total Variable Cost per period;

• Total Fixed Cost per period;

• Total Cost of the period (Variable + Fixed);

• Profit per period.

In addition to computing values from above, model also generates Tables detailing steps involved in calculations and charts a Graph showing:

• Total Revenue;

• Total Cost; &

• Profit for every period.

By observing the slopes & intersections of these curves, application user can visually evaluate risks, rewards and sensitivity issues reflected in his/her projections.

As an added bonus, application displays (in table): Unit Sales Price; Quantity of Goods Produced and Sold, and Variable Cost Per Unit VALUES AT EVERY (12) BREAK-EVEN POINT!



***NOTE: xlsx format requires MS Office 2007!