Real Estate Excel Model
  • Real Estate Excel Model
  • Real Estate Excel Model
  • Real Estate Excel Model
  • Real Estate Excel Model
  • Real Estate Excel Model
  • Real Estate Excel Model
Originally published: 21/11/2016 15:51
Last version published: 23/05/2017 15:15
Publication number: ELQ-60409-2
View all versions & Certificate
certified

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

Discuss

Reviews


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...