Commercial Development Feasibility & Debt Sizing Model

This resource is designed for the conversation before a full underwriting package: whether a site merits more diligence, whether the asking land price fits the economics, and which assumption needs attention next. It works best for a single-phase, for-lease retail, flex, light-industrial or office project with a reasonably clear stabilized operating picture.

Detailed commercial modeling tools already exist. ARGUS Developer supports complex development appraisals and cash-flow forecasting, while A.CRE publishes extensive development workbooks. FinData’s approach here is a focused, inspectable decision tool that can complement a team’s existing analysis.

The workbook is an original FinData model. It uses hypothetical inputs to demonstrate the calculations; it does not supply Augusta rents, cap rates, construction costs or lender quotes.

Start with the Deal brief, then work through Inputs. Keep a project copy of the file and record the source of each material assumption. Blue values on pale-gold cells are editable; black formulas calculate within a sheet, and green formulas reference another sheet. Summary outputs use FinData navy.

The model solves the land price two ways. The first uses the entered yield-on-cost target: annual underwriting NOI divided by total development cost. The second uses a target profit on total cost after modeled selling costs. The supported land budget is the lower amount, so both targets must be satisfied.

Land closing costs move with the land price. Non-land costs remain visible in the Development tab. A negative supported land budget is retained: it means the non-land cost burden already exceeds what the entered income and targets support. It is a signal to revisit the economics, not a suggested negative purchase price.

The required-rent calculation also allows initial leasing commission to rise with rent. Holding commission cost fixed while increasing rent would overstate the benefit. This model solves that relationship directly, without macros or a manual Goal Seek step.

Yield on cost and the spread to a cap rate describe stabilized economics. They do not capture when equity is contributed, when cash is distributed or how long the project takes. Neither measure is an IRR.

Permanent debt capacity is the lowest of three entered constraints: loan-to-value, debt-service coverage and debt yield. The model shows each limit and the binding constraint. It uses fixed-rate, monthly amortizing debt, then deducts financing fees before comparing proceeds with the expected construction payoff.

The difference matters. Gross loan capacity is not cash available to repay a lender. A refinance can require new cash even when stabilized value exceeds development cost. The workbook shows additional cash required and potential cash released separately.

The illustrative example has approximately $5.97 million of development cost and $493,472 of annual underwriting NOI. Its yield on cost is about 8.26%, below the entered 8.50% target. Supported land is about $687,391 against an $850,000 input land price. The required annual base rent is about $28.81 per rentable square foot versus the entered $28.00.

With the example financing terms, DSCR limits gross permanent debt to about $4.28 million. After the entered 2% financing fee, roughly $4.19 million remains against a $4.30 million construction payoff, leaving approximately $105,070 of required cash. These are workbook calculations from a fictional project, not lending terms or a recommendation for a real property.

This workbook deducts recurring operating expenses, management fees and a replacement reserve before arriving at underwriting NOI. That same after-reserve NOI drives yield, value and the lender tests. Initial tenant improvements and leasing commissions sit in development cost; debt service and income taxes are excluded from NOI.

Reserve conventions can differ across property reports, transaction comps and lenders. Enter a cap rate and financing tests that match the model’s NOI basis, or commission an explicit reconciliation. The distinction is visible because a small mismatch can change both value and debt capacity.

Rent is annual dollars per net rentable square foot. Shell cost is dollars per gross building square foot. Reimbursements apply to occupied area; gross operating costs apply to all net rentable area. Keep those bases straight when transferring figures from leases, budgets or software exports.

The land table varies rent and cap rate, recalculating both income and initial leasing commissions. The refinance table varies the permanent interest rate and cap rate, recalculating all three loan constraints. Other assumptions stay fixed. Center cells reconcile to the active model, and the increments can be edited.

Additional delay carry is a simple increment beyond the entered base carry budget: months multiplied by interest on the entered construction payoff plus other monthly carry. This extra cost is assumed to be equity funded. If interest is capitalized, update the payoff and reconcile the result to an actual draw schedule.

Invalid or incomplete inputs produce review flags or n.a. outputs. A nonpositive cap-rate case, a negative loan-rate case or a rent calculation that cannot be solved under the entered conditions requires review. The model does not silently turn missing information into zero.

The evidence log keeps the next action attached to the analysis. A sensitivity table is most useful when it helps identify which rent quote, contractor estimate or lender term could change the decision.

The Deal brief is set up for US Letter in portrait, one page. The detailed worksheets are set to landscape and one page wide, with additional pages vertically. Select the brief alone when you need a concise handout. Check printer preview after changing project text or adding detail.

This model does not include monthly construction draws, tenant-by-tenant cash flows, staged absorption, lease escalations, tax analysis, equity waterfalls or an IRR. Those are natural extensions for a project-specific engagement. The free screen is not sufficient on its own for a final investment approval, appraisal or loan commitment.

An experienced team may get more value from improving its existing workbook than replacing it. FinData can review formulas and assumptions, rebuild the presentation layer, reconcile source exports, or develop a deeper cash-flow model around the actual project.