Multifamily Deal Analysis Spreadsheet

[Eric Amzalag]

I'm working on a comprehensive Multifamily deal analysis spreadsheet that will go beyond basic analytics like CAP, GRM, Cash on Cash.
I'm trying to incorporate the tax shelter, mortgage interest deduction to show how those affect the bottom line of a deal. Anyone around BP have a spreadsheet to this effect that they might be willing to share? I'll be posting mine when its done, but a comparison to work out the kinks would probably be nice.

Does this sound like a useful investment of effort?

[Bryan Hancock]

Phil has modified my original sheet here:

Up To V7 Now

Maybe if we ask him nicely he'll implement the rest of the requests. It isn't finished yet.

Modeling tax items is very difficult to do precisely. All you really need to do is to use your marginal rate for the tax shields in your cash flow statement. If you want to use your effective tax rate it will be extremely complicated and not much more accurate. Even if you came up with something super fancy you'll have to update it next year when the guys in power of taxing change the tax laws.