Hi,
I am building a cash flow model and am having trouble with my plug.
This is a balance sheet. Assets = Liabilities + Equity.
In Years 2-7 of the model, Cash is the plug. So I said =assets-(L+E). Since assets is the sum of all assets, it includes cash, and thus there is a circular reference.
In Year 1, I have a different plug. Goodwill is my plug in Year 1. Similar formula, circular reference.
I have iterations turned on.
However, the model won't balance appropriately. Whenever I hit save the numbers just keep getting wilder and the model doesn't balance at all.
Does anyone know why this might be happening, I apprecaite the help.
Bookmarks