If I come to the top of the model, I can now look at forecasting forward and we're going to forecast the key line items. And the main driver of this model is revenue growth. Once we've done revenue growth, you can see most of the assumptions are linked to the underlying revenue growth.

So that's the very first thing that we're going to do is we're going to go down and do the revenue lines on the income statement and we've broken them down into segments here. I'm going to start with Europe equals open parenthesis and then I'm going to take the assumption first I just did control home. I'll go up to Europe, I'll add 1, and then multiply by the prior cell. The reason I want to do the assumption first is I want to make sure that if I do control F square bracket, it will take me to the assumption cell and then I can change it easily. Now, my USA and America's excluding USA and rest of world should be in the same layout as the top assumptions. Let me just check that. Yep. Europe, USA, America's excluding USA and rest of world. It's important to lay out your model like that. So I'm just gonna copy this down and then I'm going to do the formula as well. And then I can just do alt equals, and then it should add a sum at the bottom of that selection. And I can now calculate cost of goods sold. And what I'm going to do here is I'm going to use the little navigation column on the left, jump back up to the assumptions, and I'm going to take the cost of goods sold times the total revenue. But when I hit enter notice it's a positive number, but I want to change that. So I'm going to multiply it by minus 1 to make sure it's shown as a negative number gross profit. I can just control R and then use the prior formula in the 2023 year. And then SG&A is probably going to be a percentage of sales if I come up here. Yep, it's sg and a's a percentage of total revenue. So I'm gonna go up and take total revenue. Again, times minus 1 because the convention in this model show negative numbers in parentheses. So I personally don't like these long labels, so I'm just going to change that to cost. Good sold and SG&A and a costs, the shorter your labels, the better marketing expenses undoubtedly going to be a percentage of revenues.

Yes it is. I'm gonna take that times revenue, times minus 1, and there's a rhythm to building the model. You can see I'm not trying to do it as fast as possible. I'm just trying to do it in a kind of rhythm and looking at the numbers as we go through to see if anything looks strange.