Real Estate Excel Model

A Real Estate Financial Model where new property owners purchase their houses outright

financefinancial modelmezzanine debtproceedsreal estatereturnsenior debttown house

Description
A few words about the model:

1/ It was for a town house project in Central America where the new owners buy their properties outright

2/ In real estate projects the use of proceeds is particularly important in order to clarify when the developer is getting their return (after the lenders being preferred)

3/ This project has a more involved debt structure than the last model (which was for a startup); there is senior debt and mezzanine debt, which has an interest component and an equity participation component (if it was a business model I would have added a current portion of mezzanine debt to reflect a repayment schedule)

4/ I hate to rebuild models for new assumptions so I built this model so you could easily change the construction time to build a town house and the time to sell the unit by just changing one cell (G47 and G48 respectively on the Assumptions tab); mostly I was concerned about a slow down in the market affecting sell through

5/ Cash flow is managed by draw downs and repayments on the debt schedule under the construction loan; personally I find it confusing to use the cash flow statement to manage cash

- Robert Hacker, www.sophisticatedfinance.typepad.com

This business tool includes
1 Excel Model

Robert H. Hacker offers you this business tool for free!

Download for free

Ask a question

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Real Estate Excel Model

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

  • Robert H. Hacker
    No sorry I have not built a multi-use project model yet.
    arrow_drop_uparrow_drop_downReply reply
    • Vince Chely
      Have you ever made a model for mixed use involving some for sale residential, some commercial lease space and some shor term vacation rental units?Vincechely@yahoo.com
      2arrow_drop_uparrow_drop_downReply reply
      please wait...