New developers should create their own financial models. Only by doing so will they truly understand the variables and how each affects financial performance. This paper attempts to walk new developers through a financial model that includes development budget, annual return, and capital return. It is simple enough to create but sophisticated enough to present to investors and lenders. It represents one small residential rental building — not condo, and not office or retail.

 Back to All Publications
 Download the PDF

 Download the Financial Model



Before the Model

Before starting your model, do a market study to determine whether the neighborhood supports new construction. Very few neighborhoods do. Most neighborhoods support only the operation of buildings — collecting rent and maintaining, but not renovating them — while some support investment in renovation but not new construction. If your market study shows that new construction is not supported, don’t force it. Forcing it will require a subsidy, and subsidies are not Lean.

Whether a neighborhood supports new construction depends largely on two market variables: market rent and capitalization rate of existing buildings. Market rent is the current average rent per square foot of comparable units. Many people are confused, as I was, by “market cap rate.” A capitalization or “cap” rate is simply the annual income generated by a thing divided by the one-time payment or capital required to make or buy it. Thus market cap rate is the ratio of the average annual net operating income to the price of recently sold comparable buildings.

Your project’s particular cap rate is its annual return — market rent minus expenses divided by the capital required to develop it — which must be a certain amount higher than market cap rate to attract investors and lenders. These concepts are explained in a bit more detail below, but I mention them now to show that your project’s viability is inseparable from the market.

The comparable buildings or “comps” that you include in your study need not be many (five to 10), but should be in the same neighborhood as your project and with similar units and features. For example, if your project has no parking, study buildings with no parking. Your investors and lender will likely do their own market studies, and want to see maximum overlap between your comps and theirs. Small-scale developers can find financing from institutional sources such as banks, particularly with a solid financial model. But some developers may want or need to seek non-institutional sources, and will benefit from Jim Heid’s paper on alternatives to institutional capital.

Starting the Model

To create the model, enter these headings across the top of a spreadsheet: Item, Total, Month 1, Month 2, Month 3, etc. A financial model without columns for months can be very helpful for the phase just after “back of the envelope,” but I suggest going directly to a model with months. It will encourage you to think about how money is spent and made over time. If you really have no idea how a particular item will break down month-by-month, just type in the total for now.

In the line below, type these milestones under the month you think they will occur: Project Start (first month you spend any money on the project), Construction Start, Occupancy Start (first tenants move in), Occupancy Stability (month that occupancy exceeds 90%), and Sale.

Do not use separate tabs for sections such as Development Budget, Annual Return, and Capital Return. Switching between tabs introduces more opportunities for error. Instead, just scroll down as you type your model and add sections.

A sample model in spreadsheet form is provided above for readers to familiarize themselves with content and format. The sample generally follows the format discussed below, but with more detail. Text in blue is placeholder and not accurate, and must be changed for each specific project. Readers are strongly encouraged to create their own financial model rather than use the sample, to truly internalize the relationships among variables.

It is important to remember what your financial model does not show. It does not show non-financial aspects, and it does not even show all financial aspects. For example, it does not show financial risks. Some people try to show financial risks with “sensitivity analysis,” making high, medium, and low assumptions about an important variable (for example the property tax rate at the time of sale), and showing how each affects returns. However, you never know which variable will swing — that’s why it’s called risk — so just make slightly but consistently conservative assumptions throughout your model, and know that it can absorb a hit or two.

Development Budget

A developer makes money not by constructing buildings, but by operating and selling them. The development budget, therefore, is “zero sum”: money in equals money out.

Money in is equity investment plus debt. Equity can be cash from friends and family or high-net-worth individuals, or in-kind contributions such as land or services. Debt can be a construction loan from a local bank or a high-net-worth individual.

Money out is land costs plus soft costs plus hard costs. Land costs include the cost of the land itself, plus acquisition costs such as attorney fees and title insurance. Hard costs include land development costs such as grading, drainage, water, sewer, and paving, and vertical construction costs, which are too numerous to list.

Soft costs include “pre-development” costs such as the market study, architecture, and engineering services such as surveying and geotechnical, environmental, and civil engineering, local government fees for impact and permitting, finance costs such as the debt-origination fee and interest on the construction loan, and administrative costs such as accounting, insurance, a reserve for an operating deficit, a contingency reserve, and a development fee. Don’t view the development fee as an opportunity for you to make a profit, but rather as a contingent cost to hire an “owner’s representative” to babysit the general contractor and write investor reports if you become indisposed.

All these costs are capital costs (one-time), not operating expenses (recurring). However, investors and lenders will allow you to use their one-time money to pay for some portions of recurring costs — in other words to “capitalize” costs such as debt interest during construction or operating expenses before your first tenant moves in.


Equity + Loan Proceeds = Capital
Capital – Costs = 0

Annual Return

Your financial model’s second section shows the annual return. This section is often referred to as the “stabilized pro forma.” Top to bottom, it shows that annual operating income minus operating expenses equals a (hopefully) positive number that is net operating income.

Annual return begins the month your project reaches a certain level of occupancy (typically more than 90%), when it is deemed to be “stabilized.” While the “Total” column of the development budget was the sum of all monthly capital or costs, the “Total” column for annual return is the sum of only the first stabilized month and the eleven subsequent months.

Operating income includes market rent, rent increases, other income such as pet fees, minus vacancy loss (typically five percent), any discounts such as “first month free,” or collection losses (typically one percent combined). Operating expenses or “OPEX” include utilities (water for irrigation, electricity for common areas and vacant units), marketing, maintenance, repair, administration, insurance, replacement reserve, management fee, and property taxes.

At the bottom of this section, add operating income (positive) and OPEX (negative) to find net operating income or “NOI.” Lastly, divide NOI by total capital (equity plus debt) from the development budget section to find your project’s particular cap rate, its annual return on capital (or “ROC”). This is the first opportunity in your project’s financial model to show a return for your investors, your lender, and you. Annual ROC should be approximately 2% higher than the market cap rate, and you should not pursue a project with a lower annual ROC. For example, if the market cap rate is five percent (comps are selling for 20 times their NOI), your project’s annual ROC should be seven percent or higher.

Why? Because real estate development is risky — local government risk, construction risk, occupancy risk, rent risk, cap rate risk, interest rate risk, etc. — and risk requires reward. Investors will simply buy existing buildings that are generating 5% annual return unless they see that new construction returns significantly more to compensate for the additional risk.


Operating Income – Operating Expenses = NOI
NOI / Capital = Annual Return % = Cap Rate

Capital Return

The next section, Capital Return, is your exit strategy. It shows capital return when you sell your project: sale price (positive) plus cumulative NOI (positive) plus sale cost (negative) equals proceeds to distribute. This section requires just the first two columns, not all the months. Your financial model should assume a sale of the completed building three months after stabilization. If you want to keep the building, you will have to deal with the fast-approaching repayment date for the construction loan, but if you can sell your building for a profit by that date, you can also refinance it.

To determine total sale price, multiply the NOI in the month of sale by 12 and divide by the projected market cap rate at that time. For example, if monthly NOI is $7k, then annual NOI is $84k, and if the projected market cap rate is 6%, then sale price is $1.4M. To the sale price, add the sum of all monthly NOI before the month that you sell (including before the project stabilized). Then subtract costs associated with the sale (such as lawyers and taxes, which should total approximately 0.5 percent of the sale price).

The remainder is to be distributed to your capital partners — first your lender, then your investors. Subtract your construction debt principal and post-occupancy interest (pre-occupancy interest was capitalized). Then subtract total equity investments. In other words investors don’t lose money; they at least get their money back. This is the most important thing your model shows, even more important than annual return.

The remainder is capital gains for your investors and you. This is the third-most important thing your model shows. Divide this gain by total capital from the development budget to determine total (not annual) ROC, and divide it by total equity investment to show the total return on equity.


NOI / Market Cap Rate = Sale Price
Sale Price – Sale Costs = Sale Proceeds
Sale Proceeds + Cumulative NOI – Capital – Loan Interest = Profit
Profit / Capital = Capital Return %
Profit / Equity = Equity Return %

With a simple financial model showing development budget, annual return, and capital return, the hard — but rewarding — work can begin!

Andrew Frey

Andrew Frey is a development manager at CC Residential, a developer of luxury rental apartment communities. He is also executive director of Townhouse Center, a not-for-profit that promotes fine-grain urban neighborhoods. Previously he was a zoning lawyer and an urban planner. He has a law degree from the University of Michigan and a BA from Boston College.

More Posts - Website


May 5th, 2021

Lean Comp Plan Tool


States require local governments that have zoning authority to create comprehensive plans. While most comp plans establish laudable policies, they are often poorly implemented and can stand in the way of small-scale, incremental development. This tool outlines a Lean process that planning staff can use to reduce the expense of policy development and increase the likelihood that it will be implemented. For comp plans, Lean Urbanism is not only concerned with leveling the playing field for small-scale actors, but also with directing investments toward areas of greatest impact.

February 27th, 2021

Pink Zone Manual – Making Small Possible


Pink Zones are areas where Lean Urbanism strategies are implemented. They’re areas where red tape is lightened, where barriers are lowered, where it’s easier, faster, and cheaper to create small businesses and develop small properties. When tested and proven effective, those strategies can be applied to other parts of communities.

The Pink Zone Manual will guide you through sequential and detailed instructions to help you implement a Pink Zone in your community.

November 17th, 2020

Lean Code Tool


Writing a new zoning code is time-consuming, politically fraught with landmines, and therefore unlikely to happen in most places. But with a limited number of strategic adjustments, many zoning codes can be repaired to allow Lean Urbanism and improve or create walkable, livable environments.

September 11th, 2019

House Hacking Catalog


Housing can create wealth for existing and new residents. It can also create opportunities for growing, improving, or preserving a neighborhood. House hacking is a powerful tool for Lean Urbanism. It helps overcome the barriers to entry, and accomplishes individual and community goals.

We created this House Hacking Catalog to show how it’s possible and to provide inspiration, information, and ideas to make it happen. It contains descriptions of the types of buildings, rentals, and construction that make good options for house hacking, plus issues to consider including financing and finding the right property, as well as additional resources.

October 31st, 2017

Savannah Pilot Project – Pink Zone Workshop


Savannah is hosting one of the national pilots by the Project for Lean Urbanism. The project sponsor is the Savannah Development and Renewal Authority, with support from elected officials, municipal staff, nonprofits, and neighborhood leaders. In Phase 1 of the pilot, a team from the Project for Lean Urbanism visited Savannah multiple times to identify obstacles to small-scale economic development. In Phase 2, a week-long workshop was held to establish an Action Plan and Lean projects in two Pink Zones within the city. This is the final presentation from the workshop.

November 23rd, 2016

Tool Survey – Existing and Proposed


Lean Urbanism is a way to restore common sense to the processes of development, building, starting small businesses, community engagement, and acquiring the necessary skills. The Project for Lean Urbanism is collecting and developing tools and daylighting techniques to enable and encourage those activities. This collection is the result of a survey to identify tools developed elsewhere and to track ideas for those that are needed. As tools are developed by the Project for Lean Urbanism, they will be made freely available on this website.

November 4th, 2016

The Pink Zone – Where Small Is Possible


The Pink Zone is a powerful tool for concentrating resources on the task of enabling small-scale, community-centered development and revitalization. It defines an area of focus, leverages a suite of available tools, and provides a platform for the community to gather resources, make commitments, and work together on projects that enhance community character and allow existing businesses and residents to remain and profit from the improved quality of life. The Pink Zone tool will be developed and refined in a series of pilot projects, and then released to the public.

August 18th, 2015

Lessons from PHX – Embracing Lean Urbanism


The City of Phoenix has become a model of Lean Governing, demonstrating the benefits of community revitalization when a municipality enables and encourages the work of creative entrepreneurs, small developers, neighborhood leaders, and community organizations. Along the way, it has employed and refined a number of principles and techniques that other cities can use to revitalize their neighborhoods. Phoenix is demonstrating that small projects can lead to big results.

August 13th, 2015

The Lexicon of Lean Urbanism


The Lexicon of Lean Urbanism defines the “terms of art” and other useful words and phrases that have emerged from extended discussions on the online Lean Urbanism discussion group and at Lean Councils. The first section is dedicated to these terms, and the second presents a selection of helpful quotations.

July 29th, 2015

The Katrina Cottage Movement – A Case Study


Appealing, context-aware designs for small-scale homes in small-scale neighborhoods grabbed national attention during the 2005 Mississippi Renewal Forum after Hurricane Katrina. Though it took far longer for the ideas to find traction than anyone imagined, trial-and-error progress has produced models worth emulating, and just in time to address new realities in housing demand in post-recession America.