Community Land Trust Resale Equity Balancer
Introduction
A community land trust resale formula has to balance two goals that are both important and sometimes in tension. On one hand, a homeowner should be able to leave with a fair return after years of making payments, caring for the home, and investing in approved improvements. On the other hand, the home should remain affordable for the next income-qualified buyer rather than drifting toward unrestricted market pricing. This calculator is built to make that balancing act easier to see. It estimates a restricted resale price, the stewardship fee collected at resale, the seller's net proceeds, and a simple affordability check based on household income.
In a typical CLT structure, the trust or another nonprofit steward owns the land while the resident owns the house or condominium improvements and leases the land through a long-term ground lease. Because the initial purchase price is usually below unrestricted market value, the resale price is also limited by a policy formula. Different programs use different approaches. Some formulas rely heavily on market appreciation, some use inflation or area income growth as a guardrail, and many include credits for approved capital improvements. This page gives you a practical way to test how those pieces interact without building a spreadsheet from scratch every time you want to compare scenarios.
The calculator is educational rather than legal or programmatic. It helps boards, staff, homeowners, lenders, and public partners understand how policy choices affect affordability and equity sharing over time. It does not replace your ground lease, resale policy, lender requirements, or legal review. What it does well is frame the right questions. How much appreciation should the seller keep? Should inflation create a floor? How much stewardship revenue is enough to support counseling, compliance, and future resales? Does the resulting price still fit the income level the program intends to serve? Those are the questions that shape a durable shared-equity program.
How to use the calculator
Start with the original restricted sale price of the home. That is the amount the current homeowner paid when they bought into the CLT program. Next, enter the cumulative regional market appreciation since purchase. This should be the total change over the ownership period, not an annual rate unless you have already converted it into a cumulative percentage. Then enter the share of that appreciation the seller is allowed to keep. If your policy gives the seller one quarter of market appreciation, enter 25. If your policy uses a different benchmark, you can still use this tool to approximate the effect by adjusting the appreciation input and the seller share together.
After that, enter any stewardship fee charged at resale as a percentage of the gross resale price. Add the dollar amount of verified capital improvements that your program recognizes. Then enter the cumulative change in the consumer price index and the cumulative growth in local median income since purchase. Finally, enter the target price-to-income ratio and the target household income at resale. When you submit the form, the result area updates with the modeled resale price, fee amount, seller proceeds, seller gain, appreciation captured, and the resulting price-to-income ratio.
The best way to use the tool is to run more than one scenario. A single result tells you what happens under one set of assumptions. Two or three runs reveal the policy trade-offs. You can compare a lower seller share with a higher seller share, test whether a modest stewardship fee meaningfully changes affordability, or see how much approved improvements matter in the final outcome. That kind of side-by-side testing is often the most useful way to support board discussion, homeowner education, and policy drafting.
What each input means in plain language
Initial restricted sale price is the original CLT purchase price paid by the homeowner. It is the starting point for the resale formula and anchors every later calculation. Regional market appreciation since purchase is the cumulative percentage change in comparable unrestricted home values over the same period. Share of market appreciation allowed to seller is the policy choice that determines how much of that market gain the seller may keep. Stewardship fee at resale is a percentage collected to support long-term program administration, monitoring, counseling, and resale work.
Verified capital improvements credit is the amount your program agrees to recognize for approved improvements, such as a roof replacement, accessibility work, or major systems upgrades. Consumer price index change since purchase provides an inflation reference that can act as a floor in the modeled calculation. Local median income growth since purchase updates the affordability benchmark over time. Target price-to-income ratio is the affordability standard you want the resale price to stay within, and target household median income at resale is the income level of the buyer group you intend to serve.
These inputs matter because a CLT resale formula is not just a math exercise. It is a policy statement about who benefits from appreciation, how the program remains financially sustainable, and how the home stays available to future buyers. A formula that is too generous to the seller may weaken long-term affordability. A formula that is too restrictive may discourage participation or feel unfair to homeowners. The calculator helps you see those trade-offs in a way that is concrete and easier to discuss.
How the formula works
The script preserves the calculator's original logic. It converts the entered percentages into decimal factors, estimates a market-based price by applying the seller's allowed share of appreciation to the initial restricted price, calculates an inflation-adjusted value, and creates an income-based affordability cap. The preliminary resale value is then constrained by those guardrails before approved improvements are added and the stewardship fee is deducted. The result is not meant to mimic every CLT policy in the country, but it does capture the core balancing idea behind many shared-equity resale formulas.
The market-based portion can be summarized as follows:
This means the initial restricted price is increased only by the seller's permitted share of broader market appreciation rather than by the full market gain.
The inflation reference can be expressed as:
This provides a floor-like reference so the resale value is not modeled below the inflation-adjusted starting point when inflation is positive.
The affordability benchmark is expressed as:
That formula lets the target income move with local conditions rather than staying frozen at the original purchase date.
The preliminary resale value is then bounded by the market and affordability guardrails:
In plain language, the script compares the market-based result, the inflation-adjusted value, and the income cap, then chooses a preliminary value that reflects those constraints.
After that, approved improvements are added to estimate the gross resale price:
Finally, the stewardship fee is deducted to estimate what the seller receives:
Together, these six formulas show the structure behind the live calculation. They also make it easier to explain the policy to homeowners, board members, and public partners who want to understand why the resale price differs from unrestricted market value.
Worked example
Suppose a CLT home was originally sold for $185,000. Since purchase, the surrounding market has appreciated by 28 percent. The seller is allowed to keep 25 percent of that appreciation. The home also has $15,000 in verified improvements, and the program charges a 2.5 percent stewardship fee at resale. Inflation since purchase is 12 percent, local median income growth is 9 percent, the target price-to-income ratio is 3.2, and the target household income at resale is $72,000.
Under those assumptions, the market-based value rises modestly because the seller receives only a share of the broader market gain. The inflation-adjusted value creates another reference point, and the income-based cap checks whether the resulting price still aligns with the intended buyer group. After improvements are added, the gross resale price is calculated. The stewardship fee is then deducted to estimate net seller proceeds. In this example, the result remains within the target affordability band while still allowing the seller to leave with more than the original purchase amount. That is the balancing act many CLTs are trying to achieve: preserving access for the next buyer without erasing the current owner's stake.
If you change only one variable in that example, the policy effect becomes easier to see. Raising the seller share increases the market-based component and usually increases seller proceeds, but it can also push the resale price closer to the affordability ceiling. Raising the stewardship fee may strengthen the program's long-term operating capacity, yet it reduces the seller's net proceeds. Increasing recognized improvements can reward responsible maintenance and investment, but if credits are too broad or poorly documented, affordability can erode faster than intended. The calculator is useful because it turns those abstract policy choices into visible dollar outcomes.
How to interpret the results
Gross resale price is the modeled restricted price paid by the next buyer before the stewardship fee is deducted. Stewardship fee collected shows the amount retained to support the ongoing work of the CLT or stewarding organization. Net seller proceeds is the amount left after the fee is removed. Seller gain above initial investment compares those proceeds with the original restricted sale price, while appreciation captured under formula isolates the portion of market appreciation the seller was allowed to keep under the policy settings you entered.
The resulting price-to-income ratio is a quick affordability signal. If the ratio stays at or below the target band used by the script, the tool reports that affordability is preserved. If it rises above that band, the result warns that the modeled price may be too high for the intended buyer group. That does not automatically mean the policy is wrong. It may simply mean you should look more closely at subsidy layering, buyer income assumptions, or the appreciation share built into the formula. In practice, many programs use this kind of result as a prompt for discussion rather than as the only decision rule.
It is also important to remember what the result does not show. The calculator does not subtract mortgage payoff, closing costs, taxes, deferred maintenance, or any subordinate financing that may need to be repaid. A homeowner's actual cash at closing could therefore be lower than the net proceeds shown here. Likewise, the affordability check is simplified. It uses a price-to-income ratio rather than a full monthly housing cost model that would include interest rates, taxes, insurance, dues, and utilities. The result is best read as a planning estimate and a communication tool.
Common policy trade-offs
Higher seller shares usually increase homeowner proceeds and may strengthen the wealth-building side of shared equity. However, they can also move the resale price closer to unrestricted market levels, especially in rapidly appreciating neighborhoods. Lower seller shares preserve affordability more aggressively, but they may feel too restrictive to homeowners if the formula is not well explained. Stewardship fees create another trade-off. A fee that is too low may leave the organization without enough revenue to support counseling, monitoring, compliance, and future resales. A fee that is too high can reduce seller proceeds and create frustration at the point of sale.
Improvement credits are equally important. If a program does not recognize legitimate capital improvements, homeowners may feel discouraged from maintaining or upgrading the property. If credits are too generous or loosely documented, affordability can erode faster than intended. Inflation and income growth assumptions matter as well. In a period of high inflation, an inflation floor may protect the seller from seeing the restricted price lag too far behind general cost increases. In a period of weak income growth, however, an affordability cap may become the binding limit. This calculator does not decide the right policy for you, but it helps make those choices visible in dollar terms.
Assumptions and limitations
This tool is intentionally simplified. It does not model mortgage payoff, closing costs, taxes, deferred maintenance, soft second mortgages, silent liens, or lender-specific underwriting rules. It assumes user-entered percentages are cumulative since purchase. If your organization tracks annual changes, convert them before entering them here. Some CLTs use more complex formulas with annual caps, appraisal corridors, depreciation schedules for improvements, or separate treatment of subsidy recapture. Those details are not included in this estimator.
The affordability check is also simplified. It uses a price-to-income ratio rather than a full monthly housing cost model. In practice, affordability may depend on interest rates, taxes, insurance, HOA dues, utilities, and household size. For that reason, the result should be read as a planning estimate rather than a compliance determination. It is best used to compare scenarios, explain policy choices, and identify when a proposed formula may be drifting away from the income group the program intends to serve.
Who this calculator is for
CLT staff and boards can use this page to test draft resale policies before adopting them. Housing agencies and funders can use it to understand how shared-equity rules affect long-term affordability. Homeowners and prospective buyers can use it to see why a restricted resale formula works differently from a conventional market sale. Because the calculator runs entirely in the browser, it is also convenient for workshops, counseling sessions, and community meetings where transparency matters.
If you are comparing several policy options, keep notes on each run and focus on the pattern rather than any single number. A strong resale policy is usually one that remains understandable, fair to the seller, and durable for the next buyer. This calculator helps you see whether your assumptions are moving in that direction. Used carefully, it can support clearer communication, better policy drafting, and more informed conversations about how shared-equity homeownership should work over time.