How would you model this scenario?

debt payments/additions reflected in cfi on cf statement which decreases/increases your overall cash balance on b/s, which is offset by change in debt on liability side of b/s, also going fwd new interest exp affects net income which flows into cash on b/s (by way of cfo) and also into retained earnings

can't you add lines for issuance/repayment of each type of loan, corresponding interest lines, and balances and input it manually? obv make sure things flow through

Easiest way is just to have a month-by-month input for drawdown and then calculate the appropriate balances. Might not be the most elegant solution but is the easiest to see what is happening, make draw-down schedule changes and avoid mistakes.

Thanks guys. I'll go with the monthly draw down if the addition of new rows doesn't work.

Appreciate the input.

dont tell me you work for Citi and you can't fix this problem... I'm assuming revolver is least expensive, so drawdown $X every month until it is fully drawn. then move onto the senior, then sub debt (assuming that is the order they will draw on. create a couple of if statements so that all you need is one new row for company drawdown and your model will automatically recognize the revolver is fully drawn and then to automatically draw the senior, then same for senior to sub.

all in, you will have one row for company cash needs, and all the input boxes that initially tied to the model will be useless.