Public municipal finance tools
Capital Project True-Cost Calculator
Look beyond construction cost to understand a capital project’s ongoing local fiscal commitments. Explore financing and the annual operating tail without an account.
No account required. Start with an editable sample.
Reviewed · Editorial responsibility: Aurelius Civic
Results
Cumulative local fiscal cost through Year 20
$17,585,184.33
- Net local capital requirement
- $4,000,000.00
- Annual level debt service
- $220,745.25
- Full-term total interest
- $1,414,905.02
- First operating year (2) net recurring impact
- $500,000.00
- Following year recurring run rate
- $510,000.00
- First operating year total cash impact
- $720,745.25
- Outstanding principal at horizon end
- $0.00
Interpretation
Nominal local cash cost includes Year 0 cash, debt payments, recurring costs and replacement costs, less offsets within the selected horizon. Borrowed principal is repaid through debt service and is not counted twice. The debt is fully repaid within this horizon. The recurring run rate changes with entered inflation; it is not a fixed steady-state amount.
Sample community facility: funding and lifecycle timeline
Construction cost $5,000,000.00 = external funding $1,000,000.00 + local cash $1,000,000.00 + financing $3,000,000.00. Funding reconciles within half a cent; inputs are never adjusted.
Horizon total = local cash $1,000,000.00 + debt service $4,414,905.02 + gross operations $13,247,524.00 + replacements $750,000.00 − offsets $1,827,244.69 = $17,585,184.33. Full-term debt payments are $4,414,905.02.
| Year | Local construction cash | Debt service | Principal | Interest | Gross operations | Offsets | Net operating tail | Replacement | Annual cash impact | Cumulative cost | Outstanding principal |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Year 0 · construction | $1,000,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,000,000.00 | $1,000,000.00 | $3,000,000.00 |
| Year 1 | $0.00 | $220,745.25 | $100,745.25 | $120,000.00 | $0.00 | $0.00 | $0.00 | $0.00 | $220,745.25 | $1,220,745.25 | $2,899,254.75 |
| Year 2 | $0.00 | $220,745.25 | $104,775.06 | $115,970.19 | $580,000.00 | $80,000.00 | $500,000.00 | $0.00 | $720,745.25 | $1,941,490.50 | $2,794,479.69 |
| Year 3 | $0.00 | $220,745.25 | $108,966.06 | $111,779.19 | $591,600.00 | $81,600.00 | $510,000.00 | $0.00 | $730,745.25 | $2,672,235.75 | $2,685,513.62 |
| Year 4 | $0.00 | $220,745.25 | $113,324.71 | $107,420.54 | $603,432.00 | $83,232.00 | $520,200.00 | $0.00 | $740,945.25 | $3,413,181.00 | $2,572,188.92 |
| Year 5 | $0.00 | $220,745.25 | $117,857.69 | $102,887.56 | $615,500.64 | $84,896.64 | $530,604.00 | $0.00 | $751,349.25 | $4,164,530.25 | $2,454,331.22 |
| Year 6 | $0.00 | $220,745.25 | $122,572.00 | $98,173.25 | $627,810.65 | $86,594.57 | $541,216.08 | $0.00 | $761,961.33 | $4,926,491.59 | $2,331,759.22 |
| Year 7 | $0.00 | $220,745.25 | $127,474.88 | $93,270.37 | $640,366.87 | $88,326.46 | $552,040.40 | $0.00 | $772,785.65 | $5,699,277.24 | $2,204,284.34 |
| Year 8 | $0.00 | $220,745.25 | $132,573.88 | $88,171.37 | $653,174.20 | $90,092.99 | $563,081.21 | $0.00 | $783,826.46 | $6,483,103.70 | $2,071,710.46 |
| Year 9 | $0.00 | $220,745.25 | $137,876.83 | $82,868.42 | $666,237.69 | $91,894.85 | $574,342.83 | $0.00 | $795,088.08 | $7,278,191.78 | $1,933,833.63 |
| Year 10 | $0.00 | $220,745.25 | $143,391.91 | $77,353.35 | $679,562.44 | $93,732.75 | $585,829.69 | $0.00 | $806,574.94 | $8,084,766.73 | $1,790,441.72 |
| Year 11 | $0.00 | $220,745.25 | $149,127.58 | $71,617.67 | $693,153.69 | $95,607.41 | $597,546.28 | $0.00 | $818,291.54 | $8,903,058.26 | $1,641,314.14 |
| Year 12 | $0.00 | $220,745.25 | $155,092.69 | $65,652.57 | $707,016.76 | $97,519.55 | $609,497.21 | $0.00 | $830,242.46 | $9,733,300.72 | $1,486,221.46 |
| Year 13 | $0.00 | $220,745.25 | $161,296.39 | $59,448.86 | $721,157.10 | $99,469.94 | $621,687.15 | $0.00 | $842,432.41 | $10,575,733.13 | $1,324,925.06 |
| Year 14 | $0.00 | $220,745.25 | $167,748.25 | $52,997.00 | $735,580.24 | $101,459.34 | $634,120.90 | $0.00 | $854,866.15 | $11,430,599.28 | $1,157,176.82 |
| Year 15 | $0.00 | $220,745.25 | $174,458.18 | $46,287.07 | $750,291.85 | $103,488.53 | $646,803.32 | $750,000.00 | $1,617,548.57 | $13,048,147.84 | $982,718.64 |
| Year 16 | $0.00 | $220,745.25 | $181,436.51 | $39,308.75 | $765,297.68 | $105,558.30 | $659,739.38 | $0.00 | $880,484.63 | $13,928,632.47 | $801,282.13 |
| Year 17 | $0.00 | $220,745.25 | $188,693.97 | $32,051.29 | $780,603.64 | $107,669.47 | $672,934.17 | $0.00 | $893,679.42 | $14,822,311.89 | $612,588.17 |
| Year 18 | $0.00 | $220,745.25 | $196,241.72 | $24,503.53 | $796,215.71 | $109,822.86 | $686,392.85 | $0.00 | $907,138.10 | $15,729,450.00 | $416,346.44 |
| Year 19 | $0.00 | $220,745.25 | $204,091.39 | $16,653.86 | $812,140.02 | $112,019.31 | $700,120.71 | $0.00 | $920,865.96 | $16,650,315.96 | $212,255.05 |
| Year 20 | $0.00 | $220,745.25 | $212,255.05 | $8,490.20 | $828,382.82 | $114,259.70 | $714,123.12 | $0.00 | $934,868.37 | $17,585,184.33 | $0.00 |
Annual operating cost categories
| Year | staffing | utilities | contracts | maintenance | insurance | other |
|---|---|---|---|---|---|---|
| Year 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Year 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Year 2 | $400,000.00 | $70,000.00 | $30,000.00 | $50,000.00 | $20,000.00 | $10,000.00 |
| Year 3 | $408,000.00 | $71,400.00 | $30,600.00 | $51,000.00 | $20,400.00 | $10,200.00 |
| Year 4 | $416,160.00 | $72,828.00 | $31,212.00 | $52,020.00 | $20,808.00 | $10,404.00 |
| Year 5 | $424,483.20 | $74,284.56 | $31,836.24 | $53,060.40 | $21,224.16 | $10,612.08 |
| Year 6 | $432,972.86 | $75,770.25 | $32,472.96 | $54,121.61 | $21,648.64 | $10,824.32 |
| Year 7 | $441,632.32 | $77,285.66 | $33,122.42 | $55,204.04 | $22,081.62 | $11,040.81 |
| Year 8 | $450,464.97 | $78,831.37 | $33,784.87 | $56,308.12 | $22,523.25 | $11,261.62 |
| Year 9 | $459,474.27 | $80,408.00 | $34,460.57 | $57,434.28 | $22,973.71 | $11,486.86 |
| Year 10 | $468,663.75 | $82,016.16 | $35,149.78 | $58,582.97 | $23,433.19 | $11,716.59 |
| Year 11 | $478,037.03 | $83,656.48 | $35,852.78 | $59,754.63 | $23,901.85 | $11,950.93 |
| Year 12 | $487,597.77 | $85,329.61 | $36,569.83 | $60,949.72 | $24,379.89 | $12,189.94 |
| Year 13 | $497,349.72 | $87,036.20 | $37,301.23 | $62,168.72 | $24,867.49 | $12,433.74 |
| Year 14 | $507,296.72 | $88,776.93 | $38,047.25 | $63,412.09 | $25,364.84 | $12,682.42 |
| Year 15 | $517,442.65 | $90,552.46 | $38,808.20 | $64,680.33 | $25,872.13 | $12,936.07 |
| Year 16 | $527,791.51 | $92,363.51 | $39,584.36 | $65,973.94 | $26,389.58 | $13,194.79 |
| Year 17 | $538,347.34 | $94,210.78 | $40,376.05 | $67,293.42 | $26,917.37 | $13,458.68 |
| Year 18 | $549,114.28 | $96,095.00 | $41,183.57 | $68,639.29 | $27,455.71 | $13,727.86 |
| Year 19 | $560,096.57 | $98,016.90 | $42,007.24 | $70,012.07 | $28,004.83 | $14,002.41 |
| Year 20 | $571,298.50 | $99,977.24 | $42,847.39 | $71,412.31 | $28,564.92 | $14,282.46 |
Methodology
Funding and annual cash conventions
Year 0 is construction. Net local capital = initial cost − external contributions. Local cash + financed amount must reconcile to net local capital within half a cent; a mismatch blocks results and identifies the gap without changing inputs. External funding cannot exceed construction cost. Year 0 local cash is counted once; financed principal enters fiscal cost only as debt repayments.
Debt amortization
Debt is issued at Year 0 with fixed interest and one payment at the end of each year from Year 1 through the debt term. With principal P, annual rate r expressed as a decimal, and term n, annual payment = P × r ÷ (1 − (1 + r)⁻ⁿ). At zero interest, payment = P ÷ n. Annual interest = opening debt balance × r; principal = payment − interest. The final principal payment clears floating point residue. No interim rounding is applied. Full-term interest and debt payments are shown even when the analysis horizon ends earlier; remaining principal and annual data make that distinction visible.
Operating costs, inflation, and replacements
Annual staffing, utilities, contracts, maintenance, insurance, other costs, and offsets are entered in first-operating-year dollars. Before that year they are zero. Inflation begins the following year: each category and offset in Year y equals its entered amount × (1 + inflation ÷ 100)^(y − first operating year). Net operating tail = gross costs − offsets. The first-year and following-year recurring impacts describe the operating run rate; inflation means there is no permanently fixed steady-state amount. Offsets exceeding costs remain visible as negative operating impact, not guaranteed savings.
The optional replacement occurs once in its selected operating year, at the nominal amount entered. It is not inflated again. Annual local cash impact = construction cash + debt service + gross operations − offsets + replacement. Cumulative fiscal cost sums these cash impacts from Year 0 through the horizon. This is a nominal cash-flow estimate, not discounted present value or accrual expense.
Worked example
The sample community facility costs USD 5,000,000: USD 1,000,000 external funding, USD 1,000,000 local cash, and USD 3,000,000 financed for 20 years at 4%. Annual debt service is USD 220,745.25. Operations begin in Year 2 with USD 580,000 gross costs and USD 80,000 offsets, giving USD 500,000 net recurring impact. Year 3 net operations are USD 510,000 at 2% inflation. A nominal USD 750,000 replacement occurs in Year 15. The 20-year horizon contains 19 operating years and all 20 debt payments. Full-term interest is USD 1,414,905.02; cumulative local fiscal cost is USD 17,585,184.33, including USD 11,420,279.31 in net operations. Reset and Load sample restore every field and selection.
Supported inputs and source
Amounts are nonnegative and at most USD 1 trillion per category. Blank optional costs, external contributions, and offsets mean zero. Annual interest is 0–100%; operating inflation is greater than −100% and at most 100%. Debt term, horizon, and first operating year are whole numbers from 1 to 50. The first operating year must fall within the horizon; a replacement must fall between that year and the horizon. Displayed USD values are rounded to cents; totals use unrounded amounts.
GFOA: Multi-Year Capital Planning supports considering project funding and future operating and maintenance commitments. The simplified annual conventions and formulas used here are documented above.
Limitations
Local statutes, grant terms, borrowing authority, tax rules, procurement rules, accounting treatment, and debt structure vary by jurisdiction. This model does not determine legal affordability or approve a project. Confirm assumptions with responsible local finance officials.
Construction occurs in one modeled year; financing omits issuance costs, capitalized interest, variable rates, monthly or semiannual payments, balloon payments, refinancing, and construction draw schedules. Operations use one shared inflation rate and omit ramp-up, salvage value, discounting, contingency, and multiple replacements. An asset life entered as the horizon is a planning assumption. A short horizon excludes later costs and debt payments; remaining debt is reported. Future offsets and savings require independent validation.