This is an awesome model. However , I have two questions/ issues.
In the Sources and Uses of the S&U tab , when in the Dev Mode for multifamily, the sources and uses are matching up between cells V12 & V23. However, in this same tab Cells C11 and H16 are not matching up. I then looked at the Dev Int. Calc Tab. The cell D17 is showing Incomplete.
The aforementioned I think is a bug.
The second question, which may relate to my inexperience with the model, I am showing a 100% physical occupancy when I only want to show 95 pr 96% occupancy when stabilized. What am I doing wrong.
Spenser: I came up with a work around until the bug is fixed . I entered the loan closing costs in the regular budget. My sources and uses matched. Cell D17 in the Deb Int. Calc now shows completed and not incomplete.
1) This is a great catch. I’ll include the fix in the next version of the model.
2) How the multifamily module works, is the model assumes 100% physical occupancy once stabilized. The user then applies a general vacancy to the potential gross income such that the economic occupancy drops below 100%. You can see this in rows 8 and 9 of the MF-OpSt tab.
