o Looking at the calculation in cell E22, there appears to be an error resulting in a DIV/0 error if the ORI function is enabled. I think this is related to the last argument in the function, which is referencing the MF OpSt tab, when the MF module is off.
o Should there be any cells relying on the result of E22 of the Perm Debt tab, or is this intended to provide the user with a ball park Reserves estimate which can then be used in other areas of the model?
Awesome, thanks for all the work on this. The model is superb.
One follow up question: Should there be any cells relying on the result of E22 of the Perm Debt tab, or is this intended to provide the user with a ball park Lender Reserves estimate which can then be used in other areas of the model? What is best practice here?
No, E22 is for visualization purposes only. An All-in-One user asked me to add something to help estimate reserves that a lender make request, and so I created that simple module. But the results of E22 do not flow into the actual analysis.
