Next, let's work on our balance sheet, and we're gonna start during our construction phase. Now cash needs to wait until we have completed our cashflow statement. So let's move on to our accounts receivable. We can get this line from our calculations tab, starting in the first year of the construction phase. Inventory is right below our receivables, so we can simply copy down and then we can sum up all of our total assets. Now be careful here to include the cash line as well as receivables and inventories.

Moving on to our long-term assets. All three of these items, PP&E, soft costs, and our asset retirement obligation asset can be found in our depletion tab. So let's begin by taking the PP&E balance at the end of the first year. Then let's move on to our soft cost ending balance 203. And finally, let's get our asset retirement obligation on the asset side 37.2.

Now we can up all of our total assets, and that's equal to my total current assets, plus the sum of my long-term assets, and that gives us 420.2. So let's move on to our liabilities and equity, starting with our revolving credit facility. Now this line is gonna have to wait until we complete our debt schedule, but we can complete our accounts payable right now getting this number from our calculation section first construction year.

Now we can sum up our total current liabilities, of course, including the blank line for the revolving credit facility.

Moving on to our long-term liabilities, we're gonna skip our syndicated loan again until we have completed our debt schedule. So let's get our asset retirement obligation liability from our depletion tab all the way down, we get 37.2.

Now we can compute our total liabilities. We're gonna take our total current liabilities and add both our syndicated loan as well as our asset retirement obligation liability. For our equity. We can simply get this number from our calculations tab all the way down. We'll see ending equity of 119.1, and now we can compute our total liabilities and equity. That's the 37.2 plus the 119.1. That gives us 156.3.

So now we can work on a little check to make sure that our balance sheet is balanced. We're gonna use an if statement, and we're gonna say, if the total assets are equal to our total liabilities and equity, then we want the word okay in that sale.

Otherwise, we want the actual difference between our liabilities and equity and our assets. So we'll take total assets minus total liabilities and equity, press enter. And as you can see, our balance sheet is not balanced, and the reason is that we have not yet completed our cash line, nor our deadlines on the liability side. So lastly, what we can do is take all of our lines, every single formula, and copy them to the right until the very end of our operational period.