Hi,
I have a model that I'm working on and I've encountered an error with a circular reference (I think) and I have not been able to figure it out. See columns Q,R and S on the "3 Statement Model" tab of the attached workbook.
If you look at rows 136-140 on the 3 Statement Model tab, you can see that I have set up a revolving debt schedule that is working perfectly for all the months of 2019. Basically, the idea is to take the change in cash on the cash flow statement and either add or subtract from the revolver based on how much of a deficit or surplus there is. The problem I am encountering is that for some reason, for the 2019-2021 yearly projections, the formula isn't working. If you look up at row 46 you can see I've highlighted the cash section for the 3 columns. This takes the ending balance of cash after the revolver and uses that as the amount on the balance sheet.
The reason I know there is a problem is because both rows 95 and 141 (both highlighted in red) should net out to 0 - as you can see on all the previous months/years.
Please let me know if there is any further explanation you need on how the model works, I will be at my computer!
Bookmarks