Horizon Towers Condominium Association

Welcome to the Reserve Study Dashboard

Interactive preview for Amy Spoede  ·  Version 4  ·  April 2026

Version 4

What you're looking at

📋
This is the 30-year Reserve Fund Study for Horizon Towers (2025–2054) — the same tool you reviewed before, updated with your feedback.
🧭
There are now five tabs: Summary, Expenditure Matrix, Cash Flow, Visual Overview, and a new Owner Summary tab. The tool looks and works the same — you'll find your way around immediately.

What's new since your last review Updated

🔗
Cash Flow now updates live — edit a value in the Expenditure Matrix and the Cash Flow numbers recalculate automatically across all 30 years.
↩️
Undo button added — any edit in Admin mode can now be reversed step by step.
📊
% Funded metric added — the industry standard funding ratio (industry fully-funded standard: 70%) now appears on the Summary, Cash Flow, and Visual Overview, with color-coded progress indicators.
📉
Editable investment return rate — adjust the 3.5% assumption live and watch all 30 years of interest and balances recalculate instantly.
📌
Actuals override (Admin mode) — click any beginning balance in the Cash Flow table to enter the real number. The cascade recomputes forward from that anchor, keeping projections accurate as years close.
📣
New Owner Summary tab — a simplified 5-year view in plain language, designed for board communications to owners.

Key numbers to know

💵
Starting reserve balance (2025): $175,000
⚠️
Special assessment in 2026: $336,000 — a one-time levy to shore up reserves
📉
Lowest reserve point: $173,561 in 2032 — the most financially tight year
📈
Highest expenditure year: $829,407 in 2044 — Elevator + Flooring + Concrete
✅
Projected balance in 2054: $1,326,835 — fund balance stays positive throughout all 30 years

Admin mode

Use Viewer / Admin in the top-right to switch modes. Edits only exist in your browser session — explore freely with zero risk to the master data.
New here? Read this first.

Three short explainer pages (with optional video) put the dashboard's numbers in plain-English context — what "percent funded" means, how Horizon Towers got here, and what the reserve study doesn't show.

📚 What Owners Should Know →

You can reopen this guide anytime using the ? Guide button in the bottom-right corner.

Admin Access

Enter your 4-digit PIN to enable editing.

Incorrect PIN — try again.
📚 What Owners Should Know Asset Spreadsheet Asset Manager
⚡ ADMIN MODE — Adjust rates above · Edit Special Assessment, Addl. Assess., & Expenditures in Cash Flow · Click Beg. Balance to set actuals · Click Interest to adjust yearly rate
Scenario: —

Reserve Study Overview

Horizon Towers · Reserve Study · Study Period: 2025–2054

% Funded — 2025
Industry fully-funded standard: 70%  ·  Color guide: Orange ≥22% · Yellow ≥12% · Red <12%
0%70% target100%
—
Why is this below 70%? Horizon Towers has historically carried lower reserves than the industry fully-funded target. The 2026 special assessment and growing annual contributions are the plan to improve this — and the study confirms the fund balance stays positive throughout all 30 years. The % Funded metric will rise gradually as contributions accumulate.
3.5% = study assumption
Drag to see impact on interest earned & reserve balances across all 30 years
3.0% = study assumption
Affects fully-funded reserve target calculation
The headline number
30-Year Reserve Obligation: $4,938,846
Total projected replacement cost over the study period (2025–2054), including the multiple replacement cycles that short-life components need. 264 events tracked across 104 assets · 3% annual inflation between cycles · calculated live from the current asset table.
Two numbers, two questions. Owners often see two totals depending on context. Both are correct; they answer different questions.
  • $2,683,530 — Next-Replacement Value. What it costs to replace each tracked component the next time it's due. Used for near-term cash-flow planning.
  • $4,938,846 — 30-Year Reserve Obligation. Sum of every replacement we'll make over the next 30 years — components with 10-year and 15-year useful lives get replaced multiple times in that window. Used for reserve-study reporting and percent-funded ratios.
Starting Balance
$175K
January 2025
Projected 2054 Balance
$1.43M
Balance stays positive all 30 years
Annual Contributions
$95K→$191K
Growing over 30 years
Special Assessment
$336K
One-time · 2026
Total 30-Yr Expenditures
$4,938,846
30-yr horizon · 3% inflation · live
Lowest Reserve Balance
$191K
Dec 2032
Peak Expenditure Year
$605K
2044 · High-spend year
Expense Categories
26
Tracked across all years

Top Expenditure Categories

Estimated 30-year totals

CategoryEst. 30-Yr TotalPeak YearPeak Amount
Painting$930,4962046$529,901
Elevator$562,1992044$546,288
Plumbing$413,6622050$46,820
Asphalt$385,4832040$153,142
Roofing$374,5852041$270,501
Concrete$296,4592044$80,421
Fire Safety$264,0662050$134,915
HVAC$262,6372035$134,917
Building Exterior$248,3922026$158,995
Flooring$246,6122044$131,733

Study Assumptions

Inflation Rate
3.00%
Investment Return
3.50%
Prepared By
Facilities Advisors
Rocky Mountain · #F701122

Expenditure Matrix

2025 – 2054
Category202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054Total
Appliances———$5,553—$5,306—$9,067———$7,034———$7,917—$3,786—$8,911———$10,029—$9,583—$16,376——$83,563
Art/Decorator Package———————$3,130—————————$4,206—————————$5,653——$12,990
Asphalt—$8,786—$48,587—$9,889———$11,130———$12,527—$153,142—$87,591———$15,869———$17,860———$20,102$385,484
Balconies-Decks$2,538$101,734———$11,792——$3,215——————$15,847$4,073———————$5,159$21,298————$165,656
Building Exterior—$158,995——$6,075—$3,038——$7,043———$3,736$8,164————$27,402$4,595———$10,972——$5,652—$12,720$248,392
Concrete—$8,368$12,934—$51,619——$8,120—$4,784$6,142—$2,897$6,711$20,913—$7,333$3,359—$80,421——$12,650—$7,454$9,568$29,575$4,514$10,456$8,641$296,461
Doors-Windows———$1,943—$27,709—$1,565———$2,823—$8,991—$11,122—$2,103——$5,511——$3,509—$43,657$4,398$2,827——$116,158
Elevator———————————————$15,911———$546,288——————————$562,199
Entertainment—————————$997————————————————————$997
Equipment—————$6,367————$96,236—————————$4,409$81,854———$6,388————$195,255
Exterior Surfaces—————$11,792——————————————$18,372—————————$30,164
Fences-Walls-Gates————$2,289$3,537—————————$4,753$3,264————————$6,388——$4,653—$24,884
Fire Safety$3,984—$2,156——$74,699—$1,250——$13,697—$1,449——$24,353—$3,359————$1,947——$134,915—$2,257——$264,065
Fitness—————————$12,761——————————————$19,881—————$32,642
Flooring—————$1,769—$92,395——$6,849————————$131,733—————$13,866————$246,612
Furniture Interior———————$3,130—————————$4,206—————————$5,653——$12,990
HVAC————$5,722$67,802————$134,917$7,037———$11,886——$8,655——————$26,618————$262,637
Interior Surfaces—$1,046————$1,213————$1,406————$1,630————$1,889————$2,190———$9,373
Landscape——$3,233———$3,639$1,878——$4,095———$4,609———$5,188$2,678——$5,839———$6,572———$37,731
Lighting—————$34,196——————————————$2,756—————————$36,952
Painting——$10,778———$339,211——$14,253——————$16,303————$529,901—$20,050——————$930,496
Plumbing—$10,460$11,856—$11,430$25,927$6,561$18,750$12,869$1,326$13,648$14,063—$14,913$15,367$7,930$17,927$16,792—$17,807$18,349$10,222$19,459$32,101—$46,820$21,909—$23,235$23,941$413,662
Pool——$808——$34,608————————$2,316——$1,259——$6,154————$55,372———$3,608$104,125
Renovation————$2,575$5,306———$2,985——$1,273—$3,461——$12,670—$4,012————$4,651$9,583—$1,983—$5,391$53,890
Roofing—————$5,896———$5,896—————$7,924$270,501——$7,924—————$10,649———$65,795$374,584
Security—————$11,792—$1,565———————————$2,231—————$21,298————$36,886
ANNUAL TOTAL$6,522$289,389$41,765$56,083$79,710$338,387$353,661$140,849$16,085$61,174$275,584$32,363$5,619$46,879$54,830$260,785$321,030$139,332$13,843$829,407$60,145$639,735$39,895$65,690$48,117$433,862$64,644$44,915$38,343$140,199$4,938,846

📝 Edit Log

Annual Cash Flow

30-year projection · 2025–2054 · Updates live when matrix or rate changes ·

Year Beg. BalanceContributionsSpecial Assess.Addl. Assess. Interest EarnedExpendituresEnding Balance % Funded
2025$175,000.00$95,000.04——$7,787.50$6,522.00$271,265.549.7%
2026$271,265.54$104,500.08$336,000.00—$17,203.05$289,389.14$439,579.5315.8%
2027$439,579.53$114,950.04——$17,396.91$41,765.00$530,161.4819.0%
2028$530,161.48$126,445.08——$20,768.44$56,083.00$621,292.0022.3%
2029$621,292.00$139,089.60——$24,179.29$79,710.39$704,850.4925.3%
2030$704,850.49$152,998.56——$27,347.24$338,387.29$546,809.0119.6%
2031$546,809.01$168,298.32——$22,083.54$353,661.37$383,529.4913.7%
2032$383,529.49$185,128.20——$16,663.28$140,849.17$444,471.7915.9%
2033$444,471.79$188,830.80——$18,861.05$16,084.56$636,079.0922.8%
2034$636,079.09$190,719.12——$25,600.35$61,174.45$791,224.1128.4%
2035$791,224.11$190,719.12——$31,030.43$275,583.96$737,389.7026.4%
2036$737,389.70$190,719.12——$29,146.22$32,363.29$924,891.7533.1%
2037$924,891.75$190,719.12——$35,708.80$5,619.23$1,145,700.4441.1%
2038$1,145,700.44$190,719.12——$43,437.10$46,878.81$1,332,977.8547.8%
2039$1,332,977.85$190,719.12——$49,991.81$54,830.41$1,518,858.3754.4%
2040$1,518,858.37$190,719.12——$56,497.63$260,784.82$1,505,290.3053.9%
2041$1,505,290.30$190,719.12——$56,022.75$321,029.90$1,431,002.2651.3%
2042$1,431,002.26$190,719.12——$53,422.66$139,331.82$1,535,812.2355.0%
2043$1,535,812.23$190,719.12——$57,091.01$13,843.05$1,769,779.3163.4%
2044$1,769,779.31$190,719.12——$65,279.86$829,407.05$1,196,371.2442.9%
2045$1,196,371.24$190,719.12——$45,210.58$60,145.22$1,372,155.7249.2%
2046$1,372,155.72$190,719.12——$51,363.03$639,735.43$974,502.4434.9%
2047$974,502.44$190,719.12——$37,445.17$39,895.21$1,162,771.5241.7%
2048$1,162,771.52$190,719.12——$44,034.59$65,689.98$1,331,835.2547.7%
2049$1,331,835.25$190,719.12——$49,951.82$48,117.14$1,524,389.0554.6%
2050$1,524,389.05$190,719.12——$56,691.20$433,862.48$1,337,936.8948.0%
2051$1,337,936.89$190,719.12——$50,165.38$64,644.49$1,514,176.9054.3%
2052$1,514,176.90$190,719.12——$56,333.78$44,914.78$1,716,315.0261.5%
2053$1,716,315.02$190,719.12——$63,408.61$38,343.36$1,932,099.3969.2%
2054$1,932,099.39$190,719.12——$70,961.06$140,198.72$2,053,580.8573.6%
Annual Expenditures
Hover each bar for category detail · Red bars = over $400K
Reserve Fund Balance
Ending balance each year · Red = under $200K · Gold = $200K–$500K · Green = over $500K
% Funded Trend New
Funding ratio vs. fully-funded standard (70%) · Orange ≥22% · Yellow ≥12% · Red <12%

Owner Communication Summary

Near-term focus: 2025–2029 · Plain-language format

Horizon Towers Condominium Association
Reserve Fund — Owner Summary
5-Year Snapshot · 2025–2029 · Prepared April 2026
Inflation Rate
3.00%
Investment Return
3.50%
% Funded (2025)
—
What is the Reserve Fund? Money set aside each month by all owners to pay for major repairs and replacements — roofing, elevators, concrete, and more. A well-funded reserve reduces the need for special assessments over time. The 2026 special assessment is a one-time step to strengthen our reserves — the goal is to build toward a fully-funded position so future assessments become unnecessary.

5-Year Spending Plan — Major Categories

2025–2029 · Categories with planned expenditures only

5-Year Cash Flow

2025–2029

Year ContributionsTotal Assess.ExpendituresEnding Reserve% Funded
Per-unit approximations (83 units, equal share):  2026 special assessment ≈ $4,048/unit  ·  2025 annual reserve contribution ≈ $1,145/unit/year ($95/month), growing over time. Actual allocation is determined by square footage — contact the Board or Property Manager for your specific amount.
Questions? Contact the Board or Property Manager. The full 30-year study is available upon request.  ·  Prepared by Facilities Advisors — Rocky Mountain · License #F701122