Excel workbook previewCapital Improvement Plan Template (5-Year)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A capital improvement plan, or CIP, is a rolling five-year schedule of the roads, utility lines, buildings, vehicles and systems a local government plans to build or replace, with the cost and funding source of each. Councils adopt it with the annual budget, and grantors, bond rating analysts and auditors read it to see whether assets are kept up and paid for.
This workbook lists each project with its spending by year, scores it on six weighted criteria and ranks it into four priority bands. Funding by source and year is compared with the money expected to be available, so unfunded years show in red. It follows public practice such as Sacramento County's CIP policy: a defined scope, a completion year, a priority and an operating budget impact analysis for every project.
Who it is for
The town manager or public works director who must present a five-year capital plan with the budget and show how each project was ranked and paid for.
What is inside
- 8 sheets: How to use, Settings, Projects, Criteria, Scoring, Funding Summary, Operating Impact, Project Request
- Worked plan with 11 projects across 6 categories and 8 funding sources
- Weighted scoring on 6 criteria with editable weights and 4 priority bands
- Funding by source and year, set against funding available, with red gaps
- Spending by category and year from SUMIF formulas
- Operating budget impact by year once each project is in service
- One-page project request form with cost build-up, contingency and a funding check
- Year headers that follow the first plan year on the Settings sheet
How to use it
Set the first plan year on the Settings sheet, then list each project on the Projects sheet and score it on the Scoring sheet.
Files
- XLSXcapital-improvement-plan-template.xlsx23 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is included in a capital improvement plan?
A capital improvement plan lists each project with its description, category, total cost, spending by year, funding source, priority and the effect on the operating budget once it is in service. Most plans cover five years and are updated every year with the budget. The first year usually becomes the capital budget that the governing body appropriates.
How do you prioritize capital projects?
Many governments score each project against weighted criteria such as health and safety, legal mandates, asset condition, service benefit, operating cost effect and outside funding. The Scoring sheet uses those six criteria, scores each from 1 to 5, converts the weighted result to a 0 to 100 scale and assigns one of four priority bands. The weights can be changed.
Why include operating budget impact in a CIP?
A new building, trail or system brings staffing, utilities and maintenance costs, and a replacement can save energy or repairs. Public policies such as Sacramento County's require this analysis for each project. The Operating Impact sheet adds up the yearly effect of every project from the year it enters service.




