CRE Modeling - NPV Rate
I am new to CRE modeling and I am building a model on a property acquisition and resale for a uni assignment. I found a pretty nice model on wallstreetprep course library that comes to IRR.
I am wondering which discount rate should I use for the NPV? (As it is required in the assignment instruction, but no CRE model I found calculates it): should it be a WACC (and in this case, how do we calculate cost of equity?) or the cap rate?
Any hint would be much appreciated.
hi
Choose minimum required return on investment for NPV. Use excel function to find actual NPV. Generally, I'll start at around 8% and adjust if needed. Cap rate is simply NOI/Purchase Price. Your cost of equity would be the same as your "minimum required return".
Should be cost of equity since you are discounting after interest cash flows (I think). In practice many people will throw in ~10% and have a large terminal value in their model, but really the actual market clearing cost of equity is probably significantly lower: https://www.aqr.com/research-archive/research/white-papers/demystifying…
10% for their NPV?? In that case, is their exit cap through the roof?
Sit aut quo enim recusandae omnis quo. Cupiditate voluptatem labore modi esse molestiae recusandae reiciendis excepturi. Magnam explicabo non odio.
Quo ullam sed rem architecto. Enim libero sed debitis et. Voluptatum quidem ex corrupti fugiat culpa molestiae cum. Unde et consectetur et blanditiis voluptatum esse. Incidunt exercitationem totam ipsam sed eos harum pariatur.
Pariatur aut vel doloremque perferendis. Sapiente enim corporis ut ad ipsam consequatur quisquam et. Sint in et unde.
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...