Thank you for posting the model. I have a question, why do you use if statements with quotation marks? For instance, your formula in row 67 of the Equity CF tab (Distributions to LP Hurdle 2) uses the following formula – =IF(K63=””,””,MIN(K63+K64-K66,K59*$I$15)).
What is the benefit of using the quotation marks in the formula? I don’t understand their purpose.
I use the IF(Cell=””,””) logic most often to make my model dynamic to some condition such as analysis period. So for a dynamic hold period, I will typically build my date header such that if a certain period is beyond the user specified analysis period, than the date in that period will return an empty cell (i.e. “”). Then, within the outputs below that period, I’ll first ask, is the date cell empty (i.e. “”)? If so, return an empty cell (i.e. “”), otherwise perform whatever calculation would otherwise be in that cell.