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?
| +65 | PERE 100/200 | 10 | 19h |
| +18 | Quitting REPE - thoughts on pivoting out of CRE? | 2 | 21m |
| +16 | Acquisitions Experience Needed? | 7 | 2d |
| +13 | Hyper-scale Data Center Operator Analyst | 4 | 21h |
| Would You Buy an Empty Commercial Building or One With Existing Tenants? | 1 | 23h | |
| +10 | Blackstone RE AM? | 11 | 1d |
| +10 | Nuveen Associate Case Study | 6 | 1d |
| +10 | Life Time / Six Flags Real Estate Roles? | 6 | 21h |
| +9 | Cambridge MPhil Real Estate Finance: Are Graduates Still Staying in the UK? | 3 | 1d |
| +9 | Debt Originations Comp Structure? | 0 | 2h |
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.
Is the property still cash flow positive at all these different occupancy rates? If you fall below breakeven occupancy, then you have an issue of negative cash flow which must be solved. Given what you wrote, that's only thing that jumps out.
It’s not. I have to show my principal the minimum occupancy rate needed in order to have a positive NPV. Problem is, when I run these analyses, the model goes all over the place. I need to figure this out
Not sure what "all over the place" means, so without more detail, hard to give any ideas
So when I ran the basic analysis - at an assumed 100% occupancy rate - the NPV and cashflows were at a certain number. But when I started running sensitivities at different occupancy rates, starting with 10% and gradually moving up, and auto filled the next ten cells, the NPV and cash flows at 100% occupancy were way different than the original analysis at 100% occupancy.
I would just audit the formulas and results line by line, year by year until you figure it out.
Gonna try that.
I’m kind of in charge of the ‘corporate finance’ aspect of our family run re business which would include building excel models, lmk if you have any pointers or excel shortcuts I can use
I'm out of my "excel guy" days so not best person to ask for shortcuts. My only advise with this type of situation is to just not be afraid to grunt it out and rebuild if you need to. Being fast is only a "skill" in fast paced world of transactions (like IB or IS/DE), being methodical and accurate (which takes time) is more apt for your type of role.
Sounds like you have a fucked up circular reference somewhere. How big is the model? Like redever said you’ll have to audit the formulas. It probably went wrong with the interest reserve or capital sizing somewhere.
can you look at a previously saved version of the model and try and back into where things got messed up?
Can you be more specific, maybe post screenshots or a link to the model? It's hard to audit an excel spreadsheet from the info you gave.
Laborum atque enim harum at molestiae vero ut. Praesentium voluptatem sed consequatur pariatur. Aut vel nihil sit dolorem et vel exercitationem. Non dolorem qui rerum architecto. Omnis repellat dolorem qui corporis. Rem aliquid dolor eaque veniam nam possimus.
Dolores error sed sapiente laborum voluptas. Quae accusantium esse minima facilis eaque. Eveniet ea perferendis et cupiditate. Mollitia necessitatibus mollitia iusto veniam mollitia.
Ut quo consequatur recusandae eum. Et rerum sint sunt quaerat illo et. Velit ipsum ratione beatae magni occaecati quis qui.
Voluptatem inventore fuga nisi placeat placeat veritatis ullam. Consequatur ea sed id quia. Vitae ipsam qui modi omnis. Quis tempore doloribus rerum corporis est eius. Ab aspernatur adipisci tempora aut voluptas vero enim. Perspiciatis voluptate qui porro assumenda placeat. Dolores tempore nam velit ut.
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...