Now we're going to integrate interest during the operational phase, and we have to make sure that we take care of our circular references by using IF statements. The first place we're gonna integrate interest into is our cashflow for debt servicing section in the finance sheet. So down here we have our interest expense line, and we need to link this up to our interest expense for both our revolving credit facility as well as our syndicated loan. So we're gonna start with an if statement, and we're gonna say if switch and switch is the name, we've given our circular switch in this model equals one. Then we wanna bring up our interest calculation. So we're gonna take the interest expense for our revolving credit facility, and we're gonna add to that the interest expense for our syndicated loan. Otherwise, we wanna have a 0 in place. So at the moment, the switch is on and we have enable iterations in Excel. So we can see the actual calculation for interest expense, and we can copy this right all the way through the end of the forecast period.

Next, we need to integrate interest into our income statement. So let's go to our income statement, scroll down a little bit until we see our interest lines. And we have two interest lines. We have interest again on the revolving credit facility and interest on the syndicated loan.

So let's go ahead and take these numbers from our finance sheet of course, using our IF statement. If switch equals one, then we wanna take that number from our finance sheet. Make sure that you take it from the first operational period, otherwise zero.

Next, for the syndicated loan, again we use an if statement. If the switch is equal to 1, then let's take that number from our finance sheet all the way down for the first operational period, otherwise 0.

And now we can simply copy both of those formulas to the right until the end of the operational phase. And finally, let's make sure that our balance sheet is still balanced. So let's go to our balance sheet and take a look at our check all the way down. And as we can see, our balance sheet is balanced for the entire operation of period. Now let's take a look at our cash balance and we can see our cash balance is positive and it's actually growing toward the end of the operation period. And part of the reason why it's growing is because we haven't yet taken care of dividends.