Total costs
$687,000
Total benefits
$1,457,000
PV of costs
$613,577
Cost-Benefit Analysis
Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.
4 free cost 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 Business Plans & Strategy, Financial Statements & Reporting and Business Finance. Start with Cost-Benefit Analysis, Break-Even Analysis and Customer Profitability Analysis: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Total costs
$687,000
Total benefits
$1,457,000
PV of costs
$613,577
Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.
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.
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.
Internal costs
$72,300
External costs
$59,050
Total hires
25
Add up internal and external recruiting costs, allocate shared costs and calculate cost per hire by role family.