Overview

This financial model can be used to evaluate a real estate investment opportunities such as a land development project. It’s a robust model (with only three tabs), yet, very user-friendly, and 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 Due Dilegence 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.

Tags
Reviews Add a review
No reviews yet

More From Jair

Browse our top rated business templates. See All
Convenience Store Gas Station Financial Plan
97
0
This Financial Plan Model is a perfect tool for a financial feasibility study on launching a Convenience Store Gas Station. The model can be used to create 5 years’ projections.   The model…
Bakery Financial Plan
164
0
This financial model can be utilized to evaluate a bakery business feasibility. This template is detailed, robust and very user-friendly.…
Mobile App Business Case Financial Model
177
0
The mobile app financial model provides a comprehensive financial plan template for a mobile app business such as a startup…
Real Estate Condo Development Model - With Pre-sold units
194
0
This is a fully functional, institutional quality and dynamic real estate Development Financial Model, which will allow the user to…
10 Years Financial Forecast and Valuation Excel Model
324
0
Excel Financial Model & Valuation. This is a generic financial model that allows the user to forecast the Company's profit and loss account, balance sheet, cash flow statement, and it…
Hotel Valuation - Real Estate Development Model
265
0
This template is a very detailed financial model that takes into account the specifics of the real-estate niche that is…
See All