Real Estate Investment Fund Model – Development Properties

Real Estate Investment Fund Model – Development Properties

This model projects monthly future cash flows from development properties in a Real Estate Investment Fund from the purchase of the land through the sale of units. This covers development costs, financing, levered free cash flow, and a cash waterfall for investors. The tabs included are:

• Deal Summary
• Monthly Cash Flows through the purchase of the land, construction, and sale of properties

The Deal Summary tab provides a snapshot of the project’s financials. Details of the properties in the fund such as the construction schedule, development costs, and finance terms are entered in this tab and flow into the Monthly Cash Flows tab.

The Monthly Cash Flows is a proforma with projecting the revenue build-up of the properties from pre-construction to after the sale of the properties. This also includes important aspects such as development costs, financing, levered free cash flow, and a cash flow waterfall for investors.

All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model.