Now that we have completed our balance sheet during the construction phase, we can take these formulas and copy them to the right across the operational phase. Now remember, we're still missing the cash line as well as the revolver and long-term deadlines. So let's move on to our cashflow statement and we're gonna begin our cashflow statement in year one with net income, which we're gonna bring down from our income statement. Now notice of course, this sale is blank during the construction years, but once we copy this to the right, we're gonna pick up the values during the operational phase. For depreciation and amortization. We have to make sure these are add-backs. So these are positive values. So we're gonna change the sign of the depreciation expense and amortization expense in the income statement. So let's go ahead and link that up to the income statement. And here we go again, we have blank cells, but we're gonna pick up the values during the operational phase once we copy the formulas to the right. For the amortization, we can simply copy this down.

And now we need to figure out our increase or decrease in operating working capital. So we are gonna take last year's working capital calculation, and we can take this from a few different places, but we have our working capital calculation up here, minus this year's working capital.

And for now that would be 0. If we add these numbers up we get our cash flow from operations. Next, our CapEx.

Our CapEx must be negative here is a cash outflow. So we're gonna take this number from our PP&E workings at the very top.

And there we go. That would be negative 100. The same is true for our capitalized setup costs. These are gonna be a cash outflow. Let's bring them, bring them down.

There we go. So if we add these two, we get our cashflow from investing activities of negative 120. Next, our revolver issuance, our long-term debt issuance, as well as our common stock issuance. We can take these values from our balance sheet and what, what we need to do here is take this year's revolver minus last year's revolver and of, again, this cells are blank, but they'll be filled out later.

Now we can simply take this formula and copy it down to pick up our long-term debt issuance as well as our common stock issuance. So let's go ahead and sum this up to get our cash flow from financing. And lastly, We need to work out a little base calculation for our ending cash balance. So our beginning cash is last year's ending cash of zero. We're gonna take the net cash flow, and that's just the sum of the cash flow from operations, plus our cashflow from investing activities and our cashflow from financing. We're gonna add these two up here and we get our ending cash balance of negative 66. Now that might look a little weird to have a negative cash balance, but remember, we haven't yet completed our revolver and long-term debt.

So there's one last step in this calculation of the cashflow statement, and that is to link it up to our balance sheet. All the way up the very first line in our balance sheet is cash. And if you remember, that is an empty line for now. But now we can go ahead and link it to our ending balance on the cashflow statement of negative 66. And what you will see is that now our balance sheet is balanced for year one.

Before we can copy this to the right, we have to come down to the cashflow statement and make sure we copy our cashflow statement to the right from year one all the way to year eight. Once we've done that, we can come back to our cash line on the balance sheet and then copy this to the right across all eight years. And as you'll see, our balance sheet now is balanced across both the construction and the operational phase.