Skip to content

Cost Analysis & Breakdown: Cost-Benefit, Capex, Opex and Unit Cost

Lay out costs and benefits, capital requests, product costs or a project cost breakdown, and get NPV, payback, sensitivity, depreciation and charts instantly — ready for an approval pack in Excel or PowerPoint.

7 Cost Analysis & Breakdown templates

Pick a starting point — every template opens with sample numbers, live charts and one-click PowerPoint and Excel export.

How to use the Cost Analysis & Breakdown

  1. 1

    Pick cost-benefit, capex request, unit cost, capex report, capex vs opex or cost breakdown.

  2. 2

    Edit the assumptions and line items — NPV, payback, sensitivity and margins update live.

  3. 3

    Download Excel with formulas or a PowerPoint approval pack.

Key terms and formulas

The measures this tool calculates, in plain English.

Cost-benefit analysis
Comparing a project's costs with its benefits over time to decide whether it is worth doing.
Benefit-cost ratio (BCR)
Present value of benefits ÷ present value of costs. Above 1.0 means benefits exceed costs.
Net present value (NPV)
Discounted benefits minus discounted costs. Positive NPV means the project earns more than the discount rate.
Capex
Capital expenditure: money spent on assets that last more than a year, such as equipment, buildings or software licences. It is depreciated over the asset's life.
Opex
Operating expenditure: day-to-day running costs such as salaries, rent, subscriptions and maintenance, expensed in the year they occur.
Payback period
How long it takes for cumulative savings or cash inflows to repay the initial investment.
Sensitivity analysis
Changing one assumption at a time (discount rate, benefits, costs) to see how much the result moves and which risk matters most.
Full cost per unit
Materials + direct labour + absorbed overhead + setup, divided per unit. Price minus full cost is the profit per unit.

Need a designer-made Cost Analysis & Breakdown deck?

Browse professionally designed, fully editable PowerPoint templates on SlideTeam — drop in the numbers you calculated here.

Browse Cost Analysis & Breakdown templates →

Frequently asked questions

How do I do a cost-benefit analysis?

List every cost (upfront and ongoing) and every benefit by year, then discount them at your cost of capital. If NPV is positive and the benefit-cost ratio is above 1, the benefits outweigh the costs. The template does the discounting for you.

What is capex (capexとは)?

Capex, or capital expenditure, is spending on long-lived assets — machinery, vehicles, IT hardware, buildings. Unlike opex, it is recorded on the balance sheet and depreciated over several years.

What should a capex approval form include?

What is being bought and why, itemised costs, running costs, contingency, expected savings or revenue, payback or NPV, and the sponsor and approvers. The capex request template covers each of these.

What is the difference between capex and opex?

Capex buys assets used for more than a year and is depreciated; opex covers running costs and is expensed immediately. Moving to cloud or SaaS usually shifts IT spend from capex to opex.

How do I build a capex report?

Show each project's annual budget, spend by quarter, spend to date, remaining budget and % used. Flag projects close to or over budget and those that are slipping.

How do I test how sensitive a cost-benefit analysis is?

Use the scenario buttons (base, pessimistic, optimistic) or change benefits realised, cost overrun and discount rate. The sensitivity rows show NPV if the rate moves 2 points, benefits fall 20% or costs rise 20%, and a KPI shows how far benefits can fall before NPV turns negative.

How do I calculate the cost per unit of a product?

Add direct materials, labour hours × labour rate, overhead absorbed per labour hour and setup cost ÷ batch size. The product cost template does this for several products side by side and shows margin and annual profit.

How does capex affect the P&L?

Through depreciation: the cost is spread over the asset's useful life instead of hitting profit at once. The capex request shows the yearly depreciation, and the depreciation calculator (Accounting & Depreciation Tools) builds the full schedule.

Related finance tools

Goes well with this — from our other free tools

Results are estimates for planning and presentation; they are not financial, tax or legal advice. Nothing you type is stored on our servers — exports are generated and returned immediately.