complete
complete
Keywords
Trending Content
| +48 | Being asked to stay behind and train my replacement | 14 | 2d | |
| +36 | New Comp Database - Google Form (Now with Data Validation) | 24 | 14h | |
| +33 | Best CRE brokerage firms | 24 | 17h | |
| +30 | What does REPE actually do? | 12 | 19h | |
| +26 | Starting University LP Fund | 6 | 14h | |
| +24 | Leave brokerage to be GP | 1 | 7h | |
| +24 | Public Homebuilders | 9 | 20h | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +17 | Seeking Career Guidance in Real Estate Development Post-Graduation | 2 | 5h | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 2d |
Career Resources
This has happened to me, interested to see what anyone else has to say.
If you are using monthly cash flows, I think it may be the formula you use for your accrual. Because not all months have equal number of days, when you account for your accrual this can slightly throw off your hurdles (way out in the ten thousandths of the decimal place and beyond). Switch out the XIRR formula for IRR, and I bet your hurdles will be exact.
yes use effect/nominal formulas for IRR/accrual calcs and not XIRR so accrual would be nominal(12%/12, 12) and then when you run the compounded IRR on your CF (effect(IRRA1-A100 *12,12), it will be 12%
When computing present values / IRR, you should adjust the discount rate to match the time period of the cash flows.
Example If you are calculating an annual pref of 15% - on an annual basis - You simply would use 15%. But if you are calculating an annual pref of 15% - on a monthly basis you would NOT use 15%/12 = 1.25%.
You would use the following formula to adjust your 15% to monthly compounding.
N period discount rate = (1+r)^n-1
Annual Hurdle Rate = 15% Monthly Hurdle Rate Calc =(1+15%)^(1/12)-1 Monthly Hurdle Rate =1.17%
Notice the 1.17% is lower than the 1.25%. This is simply b/c of more compounding periods.
Aut excepturi dolore est et sint recusandae. Exercitationem culpa odio voluptatem natus odio fuga.
Asperiores ut libero aut nisi aut. Ipsa ab autem tenetur nulla sunt. Id ea molestiae culpa eos consectetur molestiae omnis.
Omnis quod numquam ab occaecati aut. Autem vitae optio laboriosam repudiandae. Et quia hic quisquam id et. In ut illum magnam blanditiis ipsam. Animi voluptas repudiandae eius voluptatem et qui. Cumque quia aut doloribus dolore asperiores neque. Recusandae voluptas dignissimos ea optio a eum id.
Minima autem non sunt molestias dolores voluptatem quae fugit. Ab ipsa hic perferendis laudantium et dolor. Quasi saepe ex beatae eum veniam voluptas placeat.
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...