Excel model is all over the place

I'm trying to calculate cash flows at different occupancy rates, but when I try to find the NPV of the property at those assumed occupancy rates, the whole model goes awry. I don't know what's happening.

Any pointers on how to run these analyses more efficiently?

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (11)

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Start Discussion

Total Avg Compensation

May 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (35) $364
  • Associates (195) $233
  • 2nd Year Analyst (110) $151
  • Intern/Summer Associate (96) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (404) $131
  • Intern/Summer Analyst (330) $82