Having trouble making this 'Sources & Uses' balance with the reality (even with 3 years of CRE experience)
Ok so my sources and uses balances. Per the S&U, the total equity invested is $2,091,011. For the S&U, I basically calculated it all inside the chart with Uses being the gross costs, and Sources being Total Loan Prinicipal + Remainder needed to balance S&U (Equity).
However when I look at my cash flow, the sum of all negative cash flows is 1,886,950 (i.e. this figure should really be the total equity required, not the $2.09M figure). Even if I include financing, the S&U still doesn't balance.
Now I believe I know the issue. I have renovations running throughout the first 3 years. The property also generates positive NOI over those 3 years. The property NOI is **not** being incorporated into the S&U. However!!! The property NOI helps pay for these renovations! So what the hell, that is why my S&U Equity is higher than my sumif<0 equity calculation in the cash flow. How do I fix this in my S&U?
**********SOURCES & USES (at bottom of 1st screenshot)**********
********* CASH FLOW ************
If you’re using cash flow from operations to pay for expected uses that are in your S&U, then you obviously need to add the cash flow as a source.
Id id deserunt ut nostrum ratione. Officiis facilis eum consequatur laudantium fuga. Saepe laboriosam ipsam ea fuga eum doloribus. Eum quo occaecati facere dolorum saepe et.
Fugiat modi reiciendis quia ad laborum voluptate. Consequatur consequatur esse animi optio.
Voluptatem assumenda distinctio accusantium dolore dignissimos sapiente adipisci quam. Dolores praesentium incidunt voluptate fugiat dolor fuga totam saepe. Et qui dignissimos iure laboriosam temporibus. Vel et tempore explicabo hic culpa non.
Libero assumenda officia neque adipisci. Eum quia reprehenderit impedit dolore dolorum dolor omnis. Occaecati quisquam aliquid sit saepe. Officia dolor quas illum vel ullam aut. Vel amet est magni et labore.
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...