First page of the Capital Improvement Plan Template (5-Year)Excel workbook preview

Public sector finance

Capital Improvement Plan Template (5-Year)

Capital improvement plan template in Excel: 5-year project list, weighted priority scoring, funding by source and year, funding gaps and operating impact.

Excel workbook · 23 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

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.