Developed in partnership with leading commercial real estate brokerages, Buildout Grids offers a library of proven templates to underwrite deals from rent roll to cash flow in record time.
Buildout Grids auto-populates spreadsheets with data from Buildout and allows you to make last-minute edits right from the final marketing document.
Spend less time building financial models and updating marketing collateral so you can get back in front of clients and keep deals moving forward.
Enter or copy/paste your data into the Rent Roll sheet, and the Unit Mix sheet will automatically aggregate square footage and rents by unit type. Specify market rents for each unit type so you can calculate your year 1 pro forma income later on.
Model a renovation scenario using the Value-Add sheet. Specify a monthly rent premium for each unit type, enter your cost assumptions, and indicate what percentage of the renovation should be “phased in” each year. The ROI calculation will update as you tweak your assumptions.
The Income / Expenses sheet includes all of the historical income and expenses you entered earlier, plus your year 1 pro forma. For each income and expense line item, you’ll have the option to choose from several pro forma “methods.” For example, you could calculate your pro forma vacancy as a percentage of GPR or by applying a growth rate to the historical vacancy. Provide the method (“% of GPR”) and an input value (-5%), and let the model take care of the rest.
Present a range of acquisition scenarios by generating a pricing matrix on the Pricing sheet. Start by entering a “strike” price, which the model will use as a midpoint. Then enter the “increment” between each scenario you want to present. The model will auto-generate a range of price points and calculate the associated cap rate(s).
Model an acquisition loan or subsequent refinancing of the property using the Financing sheet. Enter the anticipated loan terms, closing costs, and interest-only period (if applicable). Funding sources and uses will be calculated based on the purchase price and renovation costs. Indicate the desired holding period and exit cap rate to determine the net sale proceeds at disposition.
For each income and expense line item on the CF Settings sheet, specify the growth rate or percentage that you want to use in year 2, year 3, and so on. The model will use these settings to populate the Cash Flow sheet, which forecasts the annual income and expenses for the duration of the holding period. This sheet reflects all capital and financing costs, which are used to calculate both levered and unlevered IRRs, along with a host of annual return metrics.
Enter or copy/paste tenant info, rents, recoveries, and lease dates into the Rent Roll sheet. Columns can be toggled on and off so you can conserve space and display the most relevant information only. In the optional “Tenant Notes” section, you can add context on renewal options or any unique leasing scenarios. Then head to the Base Rent Increases sheet to enter the annual rent escalations for each tenant.
The Capital / Leasing Costs sheet allows you to model the cost of tenant improvements (TIs) and leasing commissions (LCs). You can enter separate assumptions for new leases and renewals. As leases expire, the model will forecast the “blended” rent and leasing costs for each space based on the indicated renewal probability. For new leases, you can also specify the downtime between tenants and the market lease rate.
The Inc / Exp Settings sheet gives you complete control over the income and expenses included in your model. Start by setting up the historical periods—for example, you could display the last three years, or just the trailing 12-month period. Next, add each of the income and expense line items that you want to include. Then head to the Historicals sheet, where you can enter or paste in the historical income/expense amounts for each period.
The Income / Expenses sheet includes all of the historical income and expenses you entered earlier, plus your year 1 pro forma. For each income and expense line item, you’ll have the option to choose from several pro forma “methods.” For example, you could calculate your pro forma vacancy as a percentage of GPR or by applying a growth rate to the historical vacancy. Provide the method (“% of GPR”) and an input value (-5%), and let the model take care of the rest.
Present a range of acquisition scenarios by generating a pricing matrix on the Pricing sheet. Start by entering a “strike” price, which the model will use as a midpoint. Then enter the “increment” between each scenario you want to present. The model will auto-generate a range of price points and calculate the associated cap rate(s).
Model an acquisition loan or subsequent refinancing of the property using the Financing sheet. Enter the anticipated loan terms, closing costs, and interest-only period (if applicable). Funding sources and uses will be calculated based on the purchase price and renovation costs. Indicate the desired holding period and exit cap rate to determine the net sale proceeds at disposition.
For each income and expense line item on the CF Settings sheet, specify the growth rate or percentage that you want to use in year 2, year 3, and so on. The model will use these settings to populate the Cash Flow sheet, which forecasts the annual income and expenses for the duration of the holding period. This sheet reflects all capital and financing costs, which are used to calculate both levered and unlevered IRRs, along with a host of annual return metrics.
