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 business cost analysis templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 3 spreadsheets and 1 document from Business Plans & Strategy and Business Finance. Start with Cost-Benefit Analysis, Business Case 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.
Sponsor: Name Author: Name Date: Date Decision needed by: Date
1. Summary
What you propose, what it costs, what it returns and what you are asking for.
2. The problem or opportunity
What is happening today, the evidence, and what it costs the organisation.
3. Objectives
Options, costs, benefits, risks and a recommendation for a proposed investment or change.
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.