RE Excel Modeling: Study Techniques & Best Practices?
Just a bit of background...Currently in an investment sales role at a big brokerage house (think CBRE, JLL, Cushman) primarily focused on private capital (we sell assets between $2-$25 million). Looking to make a big transition in the next few years to a team or shop with institutional deal exposure. Primarily interested in Eastdil (Investment Sales or Debt/JV Placement) to be quite frank.
I recently got my hands on the REFM's "Real Estate Finance Bootcamp" to brush on the quantitative side of real estate. I have intentions of studying and getting certified in Argus after I finish studying REFM's material.
I know the Argus certification is NOT going to carry much weight when I begin to evaluate other career opportunities but I want to have a very sound understanding of the platform and underwriting. I am very eager to start using Argus on my own deals without leveraging analysts so I can get comfortable with using the program on live deals.
1) Has anyone here used REFM's material for self study?
2) How are you studying the material? Any 'best practices' or study techniques that worked well for you?
3) How does modeling in excel compare to Argus?
If you have any other guidance or comments on real estate financial modeling or Argus please feel free to chime in. Thank guys.
I've done the Wallstreet prep Real estate modeling program, which is great. I've also used ARGUS DCF to build pro formas and do cash flow analysis for mixed use properties, multifamily housing, and hotels. In my opinion, I think it would be wise to start with a RE financial modeling program and learn to build the model from scratch. That way you can see everything that goes into it, how all the numbers and assumptions flow together and get to the final result.
With ARGUS, all that stuff happens behind the scenes, and you basically just input your assumptions and out pops the analysis with IRR's etc, but you don't really get a great understanding of everything that is happening. Thats why I think its better to do it the hard way in Excel first, then move onto ARGUS where you can appreciate the computing power of the software and really know what's going on.
I just finished the REFM Office self study. I learned a lot. What I did not learn, and what is not in the course are modeling some critical assumptions. Like MLA's. What makes some folks here so valuable is that they can model in probability of lease renewal or extension for any number of tenants with any number of sqft leased. The self study course does not get involved at all with any of that.
Appreciate the review Pac. Could anyone who does have these skills (modeling in renewal/extension probabilities) offer an example of the thought process behind that? (for any type of tenant that comes to mind)
The rent at turnover will be weighted by the probability of renewal. If 75/25, new rent is 75%Tenant Rent + 25%Market Rent.
Of course this is just the bare bones. Applying it dynamically is where you make your money.
Most of it is logic like looking at in-place versus market to shade your renewal % downwards or upwards. Additionally, in retail you usually have tenant sales reported so you calculate occupancy costs. You'll find specific types of tenants have occupancy costs in certain range and some public retailers even report what their occupancy costs are.
Acquisition firms usually have general rules of thumb that they stick to on renewal percentages (65% to 75%) unless you have a good reason to diverge. Example 1) an industrial tenant has a 10 year contract to make materials for a company that is located next door and the lease is up in 2 years so you put a 80% (or whatever) of renewal instead of whatever standard renewal percentage you use.
One thing to note is that ARGUS DCF rounds up or down on the blended months downtime so if the new tenant MLA is 50%, months vacant=9, ARGUS DCF will round 4.5 (50% * 9 + 50% *0 = 4.5) to 5 months. ARGUS does not understand partial month periods well at all.
Velit dolorem autem voluptas ut eum aut quam. Rerum voluptatibus accusantium vero facilis voluptatem eaque.
Amet architecto fuga quas harum. Atque temporibus magni culpa ab excepturi. Amet fugit harum aliquid dolore et vitae ea. Deleniti illum numquam unde qui. Sed sunt est aspernatur quia voluptatem sed consequatur vel. Dolores aliquam aperiam provident dolores est amet nostrum nihil. Commodi aut fuga ipsam velit excepturi dolores.
Impedit repellendus in ut inventore dolor quidem. Dolores optio veniam quasi error. Ad magni officiis laudantium blanditiis voluptatem dicta.
Autem beatae voluptate asperiores tenetur unde minus distinctio. In nihil neque voluptatum facere. Asperiores cupiditate earum voluptas rerum eum repellat. Odit rerum ut quaerat eveniet animi qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...