Expected monthly profit
$5,110
Fixed costs to cover
$30,500
Products below break-even
1
Break-Even Analysis
Units and revenue needed to cover costs for each product, with margin of safety at your expected sales.
4 free finance analysis templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Financial Statements & Reporting and Business Finance. Start with Break-Even Analysis, Financial Ratio Analysis and Customer Profitability Analysis: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Expected monthly profit
$5,110
Fixed costs to cover
$30,500
Products below break-even
1
Units and revenue needed to cover costs for each product, with margin of safety at your expected sales.
Ratios healthy
9
To review
0
Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.
Total profit
$176,775
Overall margin
31%
Loss-making customers
1
Revenue, direct costs and cost to serve by customer, with margin, ranking and who is unprofitable.
NPV
$118,225
IRR (approx.)
15%
Profitability index
1.2
Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.