STREET SHEET

Street Repair Debt Service & Blocks Funded ⛶ Open full page

Level annual payment to fully amortize each principal over the term (5–20 yrs). Blocks Funded = principal ÷ cost per block (pre-interest). Matrix shading = affordability vs. the Annual Budget figure. Click any matrix cell to fill the Clicked Cell Detail panel.

Inputs

Annual Interest Rate

Cost Per Block ($)

Base Amount ($)

Amount Increment ($)

Yellow cells are the only inputs — everything else recalculates.

Forward Scenario

Amount ($)

Term (years)

Annual Debt Service–

Blocks Funded–

Total Repaid–

Total Interest–

Annual $ / Block–

Budget Capacity

Annual Budget ($)

Term (years)

Max Principal–

Blocks Funded–

Total Repaid–

Total Interest–

Budget also sets the green/red line in the matrix.

Clicked Cell Detail

Amount ($)–

Term (years)–

Annual Debt Service–

Blocks Funded–

Total Repaid–

Total Interest–

Annual $ / Block–

Street Sheet · Matrix = level ANNUAL payment (principal + interest) to fully retire the principal over the term at the input rate. Green = payment within Annual Budget; Red = exceeds it. Blocks Funded ignores financing cost. Payments are level annual debt service; actual bond structuring — wrapped or sculpted maturities, a reserve, issuance costs — will move the exact numbers. A cash-basis planning aid, not a substitute for the financial advisor's official sizing.  ·  City of St. Marys, Kansas