Mutifamily Analysis - Excel Spreadsheet HELP!

[Rick L.]

Hello BP,

I'm attempting to modify J. Scott's single family rental analysis spreadsheet located in the FilePlace to be better suited for multifamilies. I've added, what I believe to be, all the pertinent categories for a multifamily deal analysis. With my limited knowledge of Microsoft Excel, I've attempted to correct the excel formulas. However, many formulas are still incorrect. Would anyone be willing to collaborate and assist me in modifying the spreadsheet. I plan on posting it to the FilePlace when it's complete to benefit the BP community.

[Giovanni Isaksen]

@Rick L. Although the measures of performance on the single family spreadsheet are quite simplistic for measuring the returns on an apartment building, to make it work you would need to add a Unit Mix Table (see example below) to calculate the total monthly or annual potential income and plug it into the sheet you've downloaded: