New Spreadsheet: Single-Family and Multi-family Rental Income Calculator

[Will K]

I have been working with a SFH/MFH excel model for a while, and thought I would clean it up a bit and see if anyone else on the site can get some use out of it. Allows for many inputs so that the model can accurately predict numbers for possible purchasing deals. The spreadsheet also shows ROI, post-tax ROI (assumed 30% tax rate on all income), the value of the deal using the 2% rule, as well as CAP rates, as well as cash flows for both 30-year and 15-year mortgages.

This would make a great filter when searching for deals. Please check it out, and any feedback is more than welcome.

http://www.biggerpockets.com/files/user/wklose99/file/mfh-or-sfh-deal-analyzer