# Capex Planning Dashboard

Compare eight capital projects by capex, NPV, payback, ROI, timing, and approval status, then review monthly outlays, budget headroom, and portfolio economics in one planning dashboard.

- Canonical: https://finamodel.com/excel-dashboard/capex-planning
- Excel download: https://finamodel.com/templates/capex-planning.xlsx

## About this dashboard

The Capex Planning dashboard brings eight candidate projects into a single portfolio view. Projects span replacement, expansion, IT, compliance, and ESG categories, with each project described by total capex, start month, duration, useful life, annual benefit, priority, and approval status.

Review portfolio committed capex, NPV, present value of inflows, average payback, average ROI, projects passing the NPV hurdle, peak monthly capex, envelope utilisation, and ending headroom. Monthly schedules show when spending occurs, while the budget tracker compares scheduled outlay with the monthly envelope and follows cumulative headroom. Project status and category information keep the portfolio easy to review during planning meetings.

Use the workbook for annual capex board reviews, tighter-envelope re-forecasts, or project hurdle screening. Compare project economics and timing, identify months where spending is concentrated, and assess how the candidate portfolio fits within the available budget before decisions are made.

## What's included

- Eight projects across five capital categories
- Project capex, timing, useful life, and benefits
- NPV, payback, and ROI by project
- Monthly outlay schedule and annual totals
- Budget envelope and running headroom tracker
- Portfolio economics and approval status summary

## Frequently asked questions

### How many projects does it cover?

The planning portfolio contains eight candidate projects across replacement, expansion, IT, compliance, and ESG categories, each with project-level operating and approval inputs for comparison and review.

### What project economics are shown?

Each project includes total capex, annual benefit, NPV, payback, ROI, priority, and a status flag indicating whether it passes the relevant hurdle or requires review by the planning team.

### How does the budget tracker work?

The tracker lays scheduled capex beside the monthly envelope, then follows variance, cumulative envelope, cumulative scheduled spending, running headroom, and monthly utilisation over the planning period.

### What appears on the portfolio dashboard?

The dashboard summarises committed capex, NPV, present value of inflows, average payback, average ROI, projects passing the NPV hurdle, peak monthly capex, envelope utilisation, and ending headroom for the portfolio.

### When is this useful?

Use it for annual capital allocation reviews, re-forecasting under a tighter budget envelope, and screening candidate projects against NPV and payback hurdles before approval decisions.

## Related dashboards

- [Financial Health Dashboard](https://finamodel.com/excel-dashboard/financial-health)
- [Board Reporting Pack Dashboard](https://finamodel.com/excel-dashboard/board-reporting)
- [Cash Flow Dashboard](https://finamodel.com/excel-dashboard/cashflow)
- [Income Statement Dashboard](https://finamodel.com/excel-dashboard/income-statement)