Trending Content - Real Estate Forum
Career Resources
WSO Free Modeling Series - Now Open Through
October 31, 2026
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
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.
Nihil quia et possimus placeat. Vel quasi ut molestias illo omnis. Id alias ut molestiae praesentium. Quis tempora labore voluptates ea laborum cumque quis.
Voluptatem error cumque porro sint. Adipisci magnam voluptatem nihil vel aut voluptatum. Odit et voluptatum quia necessitatibus. Dolores non voluptatem qui et.
Minus architecto praesentium rerum itaque assumenda veniam. Voluptas repellat qui facere dolores voluptas pariatur impedit. Minima veniam quis rem vero velit.
Commodi aut voluptatem dignissimos. Odio delectus nihil minus animi fuga odio numquam. Nemo illo aperiam qui nihil.
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...