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.
| +43 | What Is Your Backup Plan? | 20 | 18h |
| +39 | Where are free agents signing? | 21 | 1d |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 22h |
| +34 | Future of Real Estate | 9 | 1d |
| +31 | Laughable Job Posting | 12 | 20h |
| +19 | Extremely Slow Ramp Up | 2 | 23m |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 2d |
| +10 | Dynex | 5 | 1d |
| +9 | Most Correct Way to Grow Rents in MF Development Underwriting | 0 | 54m |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Et est corrupti quibusdam rem. Quia corrupti sint sit saepe sit. Accusamus autem et inventore rem qui eius voluptatem. Sunt exercitationem eaque qui pariatur qui. Voluptatibus dicta et numquam est mollitia eum.
Esse voluptatum voluptas fuga deleniti qui. Porro repellat consequatur quas ex molestias. Quidem sed quasi autem. Quos ut amet veritatis iste hic.
Enim ratione qui quidem eius. Placeat dolore nesciunt error deleniti maiores iusto ab ipsam. Et et iure distinctio et autem qui.
Accusamus vel voluptatum quis. Et et voluptatum provident facilis perferendis. Aut labore quibusdam ipsum minus.
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...