– Total Revenue (TR) which is calculated as number of products sold times unit price
Limited-Time Special: Download All Products Today 60% Off >>
Rated #1 Excel Dashboards, Scorecards and KPIs Reports
Download Free Templates for Sales, HR, Finance, Marketing, Quality...
Financial Analysis and Reporting Templates
– Total Fixed Costs (TFC) generally this number will not change unless the analysis is for a large range / changes in the revenue
– Total Variable Cost (TVC) which varies directly with the number of products sold
The Profit (P) is calculated as total revenue minus total cost:
P = TR –TC
Where:
TR = Unit Price x Units Sold
TC = TFC + TVC
The Break-Even Point shows the number of units the company must sell in order to break even or generate zero profit.
The Break-Even Revenue shows the revenue the company must make in order to break even or generate zero profit.
Free excel download: Break-Even Chart for Microsoft Excel – This excel break-even analysis chart creates chart with +/- 50% of the revenue you specified so you can see how sensitive is your business model and cost structure.
Rated #1 Excel Dashboards, Scorecards and KPIs Reports
Here is How to Easily Track your KPIs in Excel
Free Business Management Templates
Financial Ratios, Metrics and KPIs Templates