Model Debt Draws / Requirements + Waterfall
Does anybody have a model for a real estate financing deal, where you can actually book inflows - sales while you are constructing?
the unlevered cashflows stack up, but I can't get the draws right, given that in some months the inflow from sales is higher than the outflow from building, which seems to mess up my formulas.
There are 2 sources of funding: max equity draw, then max debt, any excess cash should be used to pay pack the debt first, then the equity.
How are you booking the sales, to immediately pay off the loan. If you are so early in the process you may not have hit your financing term so you won't be able to repay before month 18 for example.
You can make a culmulative line item and then have the draw repayment below reference sum+ if end of term date/period
Are you talking about income during an I/O construction reserve period? If so, I've previously created a 'reserve' account that would capture all projected income above the cost line and draw it down as necessary prior to it hitting the actual cost line; then add in a negative balance in your cap table to adjust for it.
It's pretty simple to do, just create a 'Beginning Balance', 'Funded' and 'Ending Balance' to capture the income/sale coming in. Then you create another three rows below to draw from and just subtract the costs from the captured balance. If you exceed this amount, it flows down to a cash inflow and assume payout to equity.
Not sure if that's the best way to do things, but it's one way I've seen it done.
if that's his point, I agree with you.
Minima dicta in non cupiditate ratione impedit sunt dolorem. Maxime laudantium illo aspernatur quisquam velit. Unde sint dolorum et.
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...