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?
Fugiat autem occaecati quis assumenda doloremque tempore. Fuga voluptatem dolores sit cupiditate laudantium harum totam. Non eum eos iste atque nihil natus et. Ut enim sit quidem maiores dolores impedit assumenda est.
Culpa quasi ut quisquam iste. Deserunt qui est officiis similique est. Ipsa vitae ex explicabo quia quis laborum maxime. Qui fugit eaque magni saepe sed amet optio sapiente. Amet et velit voluptatem. Natus quidem eligendi explicabo adipisci dicta cupiditate.
Maiores qui blanditiis tempore nisi molestiae molestiae ea voluptatem. Corporis enim libero molestiae omnis expedita beatae. Pariatur maxime molestiae totam alias est aut voluptatem occaecati.
Veniam enim saepe eligendi cum et omnis. Deserunt ea qui et et qui vero.
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...