What the UFCK is up with my Excel
In my DCF, I have data tables, obviously. When I have everything plugged in, and press and hold F9, my numbers flicker. The enterprise value changes, but as soon as I take my finger off F9, its back to normal. Its like the iterations are causing it to calculate different TEVs, but the TEV is in a lot of times VERY big differences between flickers, maybe 10-15%.
I figure its most likely because I’m backing into an existing value by taking the (DCF value) – (Equity Investment) = Existing equity.
The problem is, some other formulas are not working on the DCF sheet now for some reason. For example, I put in 80% in a cell, the cell below that I put in =1-S19 (which is the 80% cell)…. That should equal 20%... 1-80% = 20%. Instead it says 99%. What the fuck is up with this thing? Anyone know?
SON OF A BITCH. Now that formula is working. But Id still like to know if anyone knows why my numbers are flickering and fluctuating so much. I have another group of cells where it says what portion of TEV is operating period value and what portion is Terminal value. That is then summed to bring it to 100%, when it flickers, that 100% is sometimes above and sometimes below 100%... is this just a function of the order in which excel calculates cells?
WHat a clusterfuck.