Negative CFs funded by Equity - Modelling
Hi Everyone,
I'm currently working on a real estate acquisition model. We are here talking about a standing asset, which will directly generate CFs at Q1 (quaterly model). So my CFs pretty much look like this: Q0 initial cash out flow and then Q1 CF>0 Q2 CF>0 Q3 CF>0 etc.
But, as it appears I have some negative CFs (Unlev as well as lev) during three consecutive quaters, due to a tenant's departure and to CAPEX taking place during the vacancy period. The instructions I have are the following: "Assume that in any quarter, positive cash-flow is distributed to the Fund and that negative cash-flow is funded by the Fund's equity."
Now, I don't really understand how to model this additionnal contributed equity supposed to compensate for those negative CFs. Are we talking about adding additional equity and in this case how do I add it to my model? (the only times I had to model equity outflows, they were always taking place at Q0) Or am I suppose to use the precedently distributed CFs to fund these outflows? I guess I have to add an "Additionnal Equity Contributions" right after my "Debt lines" between my Unlev CFBT and my Lev CFBT, but still this remains quite obscure for me.
Did any of you guys have to deal with such a situation (I'm sure it's not a rare thing) and how should I proceed?
Hope I was clear enough & Many thanks in advance!
Lenders will either enforce (i) a cash trap, (ii) some sort of ongoing reserve during the periods of positive CF to cover the periods of negative CF, or (iii) capitalize the operating deficit into the sources and uses for the deal, which should be funded by a combination of debt and equity.
Et porro facilis deleniti aut error. Necessitatibus sed laudantium est fugit. Sint provident quis nam. Saepe officiis magnam dolores ipsam error nobis eaque.
Dignissimos aliquam quae adipisci qui est. Aspernatur optio hic non nihil in. Quia enim tempora officia nostrum. Veniam deserunt ipsam esse reiciendis nemo rem exercitationem qui. Quia nesciunt sit voluptas similique aut blanditiis quod.
Eaque quam nulla aliquam reiciendis facere voluptas laborum eos. Quod deleniti accusantium omnis sunt quo. Illo iusto maiores voluptatem corrupti ratione consequatur. Et amet provident laborum possimus reiciendis. Voluptas quos sed facilis iusto repellendus necessitatibus. At iure consequatur perspiciatis aut ipsam nulla est.
Atque tempore est distinctio numquam. Id in inventore ducimus voluptas animi. Tempora nihil aut et est quam quae distinctio.
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...