Free capital improvement plan template

Download the capital improvement plan template (Excel file)

Read the CIP software guide

Preview of the template's example: the Plan sheet's first program and its first project
PROGRAM: EXAMPLE Transportation Improvements (EXAMPLE-P100)
Program Type:EXAMPLE Transportation ImprovementsDepartment:PW-100Description:EXAMPLE: resurfacing and drainage on county roads.
EXAMPLE Main Street Resurfacing
PROJECT ID #: EXAMPLE-PJ110 | Program: EXAMPLE Transportation Improvements
Program Type:EXAMPLE Transportation ImprovementsDepartment:PW-100
Project Type:Status:
Revenue Schedule
Revenue SourcePriorsAdoptedForecast2027-20282028-20292029-20302030-20312031-20322032-20332033-20342034-20352035-20362036-2037FutureTotal
General Fund (GF100)$50,000$200,000$200,000$150,000$100,000$0$0$0$0$0$0$0$0$0$500,000
State Grant (SG200)$0$300,000$300,000$250,000$0$0$0$0$0$0$0$0$0$0$550,000
Total Revenues$50,000$500,000$500,000$400,000$100,000$0$0$0$0$0$0$0$0$0$1,050,000
Expenditures By Account
Account / ActivityPriorsAdoptedForecast2027-20282028-20292029-20302030-20312031-20322032-20332033-20342034-20352035-20362036-2037FutureTotal
Construction (AV-1111)$0$300,000$300,000$250,000$0$0$0$0$0$0$0$0$0$0$550,000
Construction (AV-1112)$0$120,000$120,000$100,000$80,000$0$0$0$0$0$0$0$0$0$300,000
A/E Professional Services (AV-1211)$50,000$50,000$50,000$25,000$0$0$0$0$0$0$0$0$0$0$125,000
In-House Labor (AV-1212)$0$10,000$10,000$5,000$5,000$0$0$0$0$0$0$0$0$0$20,000
Construction Contingency (AV-1311)$0$20,000$20,000$20,000$15,000$0$0$0$0$0$0$0$0$0$55,000
Total Expenditures$50,000$500,000$500,000$400,000$100,000$0$0$0$0$0$0$0$0$0$1,050,000

What the sheets hold

  • Instructions What the workbook is for and what each sheet and column holds.
  • Setup The plan-level settings, such as whether the government is a Florida local government.
  • Plan The sheet to fill in: each program, its projects, funding sources, accounts and amounts by fiscal year.
  • Project details One row per project for its scope, ranking, priority and operating costs.
  • Florida schedule The five-year schedule of capital improvements that Florida local governments complete.

The capital improvement plan template covers GFOA's Multi-Year Capital Planning best practice and Florida's 5-year capital schedule (s. 163.3177, Florida Statutes).

Try the filled-in Excel file in the CIP demo