Quality Real Estate Models?
What do you like to see in a high quality, somewhat robust real estate model in excel? Summary, Rent Roll, Monthly CF, Amortization, Partnership CF? Do you build rent roll separately in excel? How do you build annual rent bumps dynamically? Operating expenses on a separate tab? Recoveries? Love to hear your thoughts.
Take the WSO RE modeling course. It matters a lot if you are just trying to do a simple valuation, or if you actually need a yearly CF and IRR. If you need IRR with promote to multiple equity partners, things get further complicated.
Like the other posted said, look at the courses available and check out youtube. A.CRE has EXCELLENT free youtube resources for CRE modelling, also Break Into Real Estate (I think its called?) for basic concepts.
They won't teach you how to build an extremely sophisticated model, you'll only learn that on the job, but it will give you the basics.
Breaking into Wall Street and GETREFM are great resources. Don’t worry about being too complicated. You’ll learn that on the job. Frankly, we build complicated models because our partners demand it, but real estate math should be kept pretty simple. If you can’t make the numbers tie back of the envelope, a complicated model doesn’t matter. I always break deals down to a per square foot or per unit metric and look at return on cost.
For example, If I can buy it for $100 PSF and invest $5 PSF to renovate it, my basis is $105 PSF. If my stabilized rents are $10 PSF and expenses will be $4 PSF, I’m netting $6 PSF of Net Operating Income. Assuming market cap rate of 5.5%, I can sell for $109 PSF. That means my appreciation is $109/$105 and my return on cost is $6/$105 or 5.71%.
If I’m happy with these returns, move forward. I don’t need a complicated model to tell me this. What I’m trying to say is don’t be too concerned over crazy modeling. Just get the basics.
A labore velit voluptas doloribus mollitia. Non debitis praesentium et quos ea quo.
Iusto minus veritatis tenetur quia qui. Omnis maiores nulla sapiente. Quod ratione enim provident vel perspiciatis ratione. Et atque debitis repudiandae nostrum est. Quae molestias hic sit ea eum officiis nulla. Ad vel impedit aut nemo nam sunt repellendus.
Aliquam libero aut nisi libero. Ea eum expedita neque cupiditate voluptas minima laboriosam.
Provident eos quaerat ea a. Modi fuga commodi commodi cupiditate ab tempora beatae. Veritatis provident autem non repellendus qui rerum odit. Maxime unde non soluta culpa quidem. Provident cupiditate ut incidunt optio omnis eum. Labore ullam vel tempora non rerum ex.
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...