Sponsor Disposition Fee Not Accounted For in Sponsor Cash Flows?

  • Anonymous
    Inactive
    4 years, 3 months ago #2498

    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!

    Spencer Burton
    Keymaster
    4 years, 3 months ago #2930

    Hi mhagan,

    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.

    Let me know if I’m looking at the wrong cells.

    Thanks again for digging into the model!

    Spencer

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.