Lender Reserves (Perm Debt tab)
-
AnonymousInactive4 years, 2 months ago #2500
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?Spencer BurtonKeymaster4 years, 2 months ago #2932Thanks for the heads up! If you look at the latter half of the Lender Reserves formula, the MF-OpSt!J34/12 portion should read ORI-OpSt!J34/12.
I’ll include a fix in the next version of the model.
AnonymousInactive4 years, 2 months ago #2934Awesome, 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?
Spencer BurtonKeymaster4 years, 2 months ago #2936No, 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.
Spencer
AnonymousInactive4 years, 2 months ago #2938Thanks Spencer – appreciate the insight!
You must be logged in to reply to this topic.