So here we are now going to forecast Red Bull. Red Bull is a private company, so the forecast is probably going to come from assumptions in a CIM, which stands for confidential information memorandum or from a management or from reasonable projections based on industry standards. The first thing to do, we've got the assumptions, a calculation section and an income statement. But in the income statement, we don't have any of these subter, so that's the first thing that we're going to do.

We've broken down revenue into various components here geographically, and we've got a cost of goods sold line, which is negative. So the expenses in this model as a standard shown negative. And then we've got EBITDA. And notice that in this model we have an EBITDA number, which excludes depreciation and amortization above this point. So we can do a simple addition. Sometimes you may see it broken out, but in this case you don't have depreciation expense and amortization expense above the EBIT line. So we can go directly to EBIT. When I do the subtotal, I make sure I don't add in the blank lines. And then I'm going to calculate EBIT. You can do a sum or you can do a simple addition. It's just two cells. And then we have our profit befor tax, which includes EBIT and the interest lines and the other line as well. And then finally, I can calculate net income on the income statement. Now, we don't have any share numbers because this is a private company, so it would be really irrelevant to have shares. But I'm going down to the balance sheet. Now. I'm going to sum up the current assets and I'll sum up the total assets. And again, when you have the blank line, just put a comma to pause the sum function, and then sum the rest of the line items. Sum up the liabilities, very simple in this balance sheet. And then the total liabilities, again, just ignoring the blank line.

And then finally, total liabilities and equity added together. And then we should always do a check. And I'm going to do an if statement that says if, and I'm going to round the number just because later on when we have iterative calculations, I want to make sure I don't run into slight rounding differences. So I round the total liability and equity to two decimal places, and then compare that to the round of the total assets to two decimal places as well. If that equals each other, so comma, then I'm gonna put okay in the cell. If not, I'm gonna ask for the difference. You don't want to say no, you want to ask for the difference, and then I'm going to copy that right. And I can just show the formula to the right. Obviously I'm not going to do the cash flow statement. And we have some of the interest calculations and the operating statistics that I don't want to do either.