Real Estate - Land Development Model
Originally published: 08/05/2020 07:55
Last version published: 19/10/2020 06:59
Publication number: ELQ-62496-3
View all versions & Certificate
certified

Real Estate - Land Development Model

Real-estate Financial Model for quickly calculating the potential returns and/or estimating the land development project

Description
This is a fully functional, institutional quality, and dynamic real estate Financial Model for quickly calculating the potential returns and/or estimating the land development project. It’s a robust model (with only three tabs), yet, very user-friendly, that will provide the user with a very detailed Excel spreadsheet.

The model assumes one phase of horizontal development where the land is purchased, at the entitlement month, and then construction begins. Prior to the purchase, the model assumes that there is a period spent in due diligence with some expenses incurred (evenly split during the diligence period), and at the end of the DD period a land deposit is made.

The sales of the lots unfold in two phases: the pre-sales where the lots are sold at a discount over the average lot sale price and the regular sales period where the discount is no longer applicable. The template assumes a deposit payment in the month of sell and after the closing period, the remaining proceeds are received.

The construction assumptions (hard and soft costs) are also evenly distributed during the construction period.
Finally, the user needs to enter assumptions related to financing, rate, term, and loan-to-cost.
With all assumptions in place, the template runs an analysis up to 120 months of unlevered and levered monthly cash flows.

Model Options:
• The summary tab is optimized for a dashboard-style overview. All the inputs are shown in bold blue type and everything else is a calculation or a label. All the required assumptions are inputted in the summary sheet.
• Dynamic Monthly & Annual Cash Flow: In order to calculate the key investments metrics needed to determine the feasibility of the project, and the overall value of the deal the cash flows are calculated in a monthly base;
• Dynamic Funding: The model works backward to get the required amount and timing for Equity/loan funding;
• Equity first: The template assumes that the constructions, and operating expenses are funded first by equity and then the remaining costs of the project are funded via loan draws;
• IRR Sensitivity analysis based on an average sale price, land acquisition cost and construction cost variation;
• Equity Waterfall Model: the template provides a 3 tier Equity waterfall model, so the user will be able to determine how much capital the limited partner and General partner will get, and their respective rates of return;

This Best Practice includes
Excel template

Acquire business license for $40.00

Add to cart

Add to bookmarks

Discuss

Further information

Evaluate the feasibility of a land development project (purchase of land, land development and sell of lots) from an investment/investors point of view taking into account various parameters such as operational, leverage capital expenditures, equity structure, average sell price etc

Does not work well for non-real estate businesses.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Jair Almeida

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Real Estate - Land Development Model?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...