From project pro formas to a long-range financial plan
A housing project can look affordable when the discussion is limited to land and construction.
Then the rest of the picture comes into focus: financing, operating costs, rental revenue, subsidies, repairs, renewal and the funding gap that remains after every other contribution is counted.
Multiply that by a pipeline of projects, each with different timelines and affordability targets, and a simple question—“Can we afford this strategy?”—becomes difficult to answer in a spreadsheet built for one project at a time.
Karto’s thirty-year financial planning tool is designed for that problem. It helps housing teams and finance staff build project pro formas, bring them together into a portfolio and compare different project and funding scenarios as part of a long-range financial plan. It shows how each project performs, how the projects work together and what different levels of government investment would mean for the municipality’s overall commitment.
Every project has its own financial story
A supportive housing development, a deeply affordable rental project and a mixed-income building do not behave the same way over thirty years.
They have different capital costs, revenue, financing structures, operating needs and repair schedules. Treating them as interchangeable can hide the obligations a municipality is taking on.
In Karto, staff begin by entering the projects being considered for the affordable housing strategy, including:
housing type;
number of units;
affordability level;
project timing; and
ownership and delivery approach.
This creates a working project pipeline: what may be built, when it may proceed and what housing it would provide.
Housing teams can then build a thirty-year pro forma for each project using its own assumptions for:
land and construction;
debt and financing;
operating costs;
rental and other revenue;
ongoing repairs and renewal; and
municipal funding, land and incentives.
Each project-level pro forma shows how the development is expected to perform over time, including its revenues, operating requirements, financing needs and remaining funding gap. Karto carries those results into the portfolio model rather than leaving each project in a separate file.
Move from a folder of pro formas to a portfolio view
Individual project analysis cannot answer every question a council or finance team will ask about a housing strategy.
What is the total capital cost? How much debt would the portfolio carry? When do operating pressures appear? What will repairs and renewal require in year 15 or year 25? How much of the strategy is the municipality committing to fund?
Karto rolls the project pro formas into one portfolio view so housing teams and finance staff can see:
all projects, units and housing types;
total capital cost;
operating costs and revenue;
funding gaps and debt; and
total municipal cost over thirty years.
This provides both levels of analysis: the financial performance of each project and the combined cost and performance of the full portfolio. A project that appears manageable on its own may create a difficult overlap with several other projects. A portfolio that works with expected federal or provincial support may look very different if that support is delayed or reduced.
Identifying those pressures early gives staff time to adjust the project mix, funding plan or delivery schedule before they become future budget pressures.
Test the funding plan, not just the build plan
Housing strategies are often assembled while major funding decisions are still uncertain.
Karto lets staff create different versions of the portfolio by changing:
which projects are included;
the number and mix of units;
project timing;
the mix of supportive, deeply affordable and other housing;
federal and provincial funding; and
municipal reserves, land and debt.
One scenario might assume that major outside funding is secured. Another can show what the same project mix would require from municipal sources. A third might stage the projects differently or adjust the housing mix to reduce near-term pressure.
Housing teams can compare what happens if federal or provincial governments invest at different levels, if funding is delayed or if no additional outside investment is received. Each scenario shows what can be delivered, the full thirty-year cost and the financial commitment that would remain with the municipality.
Each version shows both sides of the decision: what the community would receive and what it would cost over the full thirty years.
The comparison may show that a lower-cost project mix produces fewer deeply affordable units, while a portfolio with a larger upfront capital requirement creates lower operating pressures over time. The model allows staff to assess those trade-offs using the same assumptions and time horizon.
An example: a pipeline is not yet a financial plan
Imagine a municipality considering five housing projects over the next eight years.
Together, the projects would add supportive and deeply affordable housing, but they are at different stages. One site is municipally owned. Two projects depend on federal or provincial contributions. Another could proceed sooner with municipal debt. Each has different operating and repair assumptions.
The housing team needs to show what the projects could deliver. Finance needs to understand the obligations attached to them. Council wants to know how much the municipality must contribute—and what happens if outside funding does not arrive on schedule.
In Karto, the housing team could compare three portfolio scenarios:
proceed with the full pipeline based on the expected funding mix;
phase the projects to reduce near-term municipal borrowing; or
prioritize the projects that can move first with municipal land and adjust the later phases as outside funding is confirmed.
The housing team could also compare the full pipeline with and without additional federal or provincial investment. This would show what the municipality could deliver on its own, what additional government investment would make possible and how much funding would be required to close the gap.
For each scenario, staff could compare the number and mix of units, capital cost, operating and repair costs, outside funding, debt, remaining funding gap and total municipal cost.
The discussion would no longer be limited to whether each project works on its own. Staff could see whether the full strategy works, when financial pressures appear and which assumptions require the closest attention.
Support budget decisions and government funding requests
Housing development and municipal finance staff often approach the same strategy from different starting points.
Housing staff focus on need, affordability, delivery and the project pipeline. Finance staff focus on debt, timing, operating exposure and long-term obligations. Both views are necessary.
A shared portfolio model helps housing teams and finance staff work from the same project assumptions and compare the same scenarios. It also gives senior leaders a clearer basis for deciding which option to carry into budgets, funding applications and council discussions.
Instead of presenting a single total with little room to test it, staff can show:
what each option would build;
when the projects would proceed;
how the portfolio would be funded;
what remains for the municipality; and
how costs and revenues develop over thirty years.
The same analysis can support advocacy and funding discussions with other levels of government. Rather than presenting only a total funding request, municipalities can show which projects are ready or planned, the housing outcomes different levels of investment would support, the municipal contribution already assumed and the consequences if outside funding is not secured.
If a project is delayed or a funding program changes, staff can update the scenario and rerun the comparison.
Replace the fragile master spreadsheet with a living plan
Many municipalities already do this work in Excel. The issue is not whether a spreadsheet can perform a calculation. It is whether a web of project files can remain consistent, explainable and safe to update as staff, assumptions and funding decisions change.
A one-time consulting study has a similar limitation. It may answer the original question, but the model often sits outside the organization. When council asks a new question six months later, staff may not be able to rerun it.
Karto gives housing teams a living financial model they can continue to use. The calculations are deterministic, so the same inputs produce the same results. The model uses project- and community-level planning information, not individual client records.
See the full commitment before making it
Affordable housing decisions have consequences that extend well beyond a construction schedule or a four-year budget cycle.
A thirty-year view does not remove uncertainty. It shows where that uncertainty sits and gives staff a practical way to test it.
Long-range financial planning allows housing teams to understand how individual projects perform, how the full portfolio works and what the municipality would be committing under different funding scenarios. It also provides clear evidence for budget decisions and requests for investment from other levels of government.
See what Karto can do with your project pipeline. Book a working session using a question your housing team is already trying to answer.