Hi, on the most recent version v.761 of the all-in-one model, the sponsor cash flows do not appear to include the disposition fee (in the Equity CF tab). The acquisition fee is accounted for in Year/Month 0, but I cannot see the disposition fee accounted for in the cash flows. Thanks!
On my end the disposition fee is appearing both in the ‘Sponsor Fees’ line (row 144 of Equity CF tab) as well as in the ‘Total Sponsor Distributions’ line (row 122 of Equity CF tab). Perhaps we’re looking at different lines?
Opening up the Equity CF tab of v0.761 and going to cell DV122, the formula is:
=IF(DV113=””,””,DV161+DV176+DV191+DV198+DV144)
DV144 is the Sponsor fees line, and if you dig into DV144 you’ll find the cell is equal to asset management fees in that period plus disposition fee.