Main Model - Cash Flow from Investing and Financing Activities
- 04:03
Modeling a large project finance model - cash flow statement - cash flow from investing and financing activities
Transcript
Next, let's work on our cash from investing activities. And the first item is our CapEx.
So we're gonna take the CapEx from our depletion tab within our PP&E base calculation. Let's just make sure this is a negative number since it is a cash outflow.
Now we can take our cash, soft costs, or soft asset expenditure. We can take that from the depletion tab as well under the soft costs spend.
And if we add this two up, we get our cash flow from investing activities. Now, before we move on to our financing activities, let's go back to our balance sheet checklist and let's check off those that we've already completed. And that would be our net PP&E the investing component, as well as our soft cost investment component. So what we have left here, if you notice, is our revolving credit facility, which is a financing item, syndicated loan, another financing item, and then two more financing items related to our equity issuance as well as dividends. So let's go back to our cashflow statement and start working on our financing section, starting with our revolving credit facility changes. And we can compute this change from the balance sheet if we take this year's value minus last year's value. And right now, of course this is blank, but once we populate these cells later, they will flow into the cashflow statement. Let's do the same thing for our syndicated loan.
Take this year's balance minus last year's balance, the issuance of equity can be calculated from our calculations tab.
So let's take that number from row 13 here, and that is 119.1. And finally, dividends will also come from our calculations tab from the equity section.
In this case, of course, dividends is blank, but it will flow through the cashflow statement later in the model. If we add these numbers up, we get our cashflow from financing activities of 19.1, and now we're left with our calculation of our ending cash. So we're gonna do a little base calculation where the beginning cash equals last year's ending cash. Our net cash flow is the sum of our cash from operations, plus our cash flow from investing activities plus our cash from financing activities. And that gives us negative 263.9. We add these two and we get our ending balance of negative 263.9, and we can take all of these formulas across the entire cashflow statement for the financing and investing sections, and we can copy them to the right until the last year of the operational phase.
And here we have our forecasted cash line. So the last step then is to link this up into the balance sheet. So let's go to the balance sheet, up to our cash line at the very top and link this up into our forecast from the cashflow statement.
That's 263.9 negative. And we're gonna copy this to the right across the entire timeline. Once we copy that to the right, if we check our balance sheet check, we should be balanced across all years. And that, as you can see, is the case here.