匹配xirr的优先
杂草问题有点,但是是否有人成功地建立了一个瀑布,他们能够在给定的层次上获得Pref,以与Xirr吐出的内容完全匹配?
I'm currently running a waterfall with an 8.25% hurdle where pref is accrued on a daily basis and hits the capital account on the first day of the month, so using a January 1 accrual date as an example, the logic for the accrual schedule is (Beg. Bal * ((1.0825)^(31/365)-1)). The issue is that after accruing that way, once everything in the capital account is distributed at sale, XIRR is giving me an 8.244%IRR. This results in distribution splits getting fucked since those percentages are being looked up based on what theIRRis...so 1/10 of a bp has wrecked my functionality.
是否有人成功获得了您的应计时间表以与XIRR或反之亦然结婚?我猜该问题与每个月使用的应计日有关(大约360天VS 365或在每个月中包括额外的一天以占应计时),但无法进行任何更改奏效了。
评论 (8)
发现了这个问题,如果将来有人遇到了同一问题,那么对设计这种公式的Motherfucker的细节不注意是不熟悉的,这是不熟悉的。
I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
As you discovered, need to account for leap years. Also make your number of days dynamic by changing 31 to (Current Month Date - Prior Month Date).
It's the opposite - XIRR doesn't account for leap years...also, not hardcoding anything, dawg.
Know you're actually trying to be helpful, but spent ~3 years in anrx小组have used Excel几次,如果我正在阅读别人的帖子,他们列出了日期公式,我会立即停止阅读。例如,我假设/希望任何人都会停止阅读,如果写了“ = {(imonth(if(Year范围=当前年份,年范围))),0)-min(如果(IF(年范围=当前年,年,年))范围))+1}“ 365”
I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
Damn bro, three years in RX? That's sick
Rx is fuckin hard core bro, what was that poser thinking when he questioned you and your excel skills?
Yeah - I got touchy when someone implied that I suck at my one marketable skill
I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.
了解更多大声笑哇,我的家伙,防御很多吗?我们彼此同意,您完全误解了我的帖子。
1.那是我的观点,XIRR不考虑LEAP年。您的预定公式必须。您要么在公式中使用365.25天,要么您必须写一些东西,无论现金流的当前年度是leap年(这是过多的,但我已经看到团队做到了)。
2. Nobody said write a date formula... Do you not have a row at the top of your cash flow that has the date of each month/quarter/year? Pro tip my excel wizard friend, if you link to the cell that says 12/31/2021 and deduct the cell that says 11/30/2021, you will get the number of days between them. Alternatively DATEDIF.
The issue was that my pref accrual calc was picking up whether a year was a leap year, so had to make each year 365 days for pref accrual calcs for XIRR to agree w/ accrual schedule.
I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done
Ut sint pariatur ut distinctio voluptas consequatur. Nisi autem temporibus totam temporibus dolor. Voluptatem voluptas quibusdam id consequatur. Rerum distinctio hic laborum ea nam eum. Sit veritatis necessitatibus facere tempora.
在laudantium rerum et fugiat中坐在numquam cupidate。Nihil ea自动moletiae pariatur turema perspiciatis iste。Deserunt Pabueenda唯一的Accusamus Quisquam Sint。Eius Dolor est uspudiandae Dolores Mollitia veniam Quia Beatae。
自动ipsam ut quidem quo officiis耳朵。EUM eum eum explicabo。Labore Sit上的cupidates鼻孔。
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)
或者Want toUnlock通过签署您的社交帐户?