Should an investment real estate analysis contain the tax deduction??

[Account Closed]

Hi.  I have modified the BP investing spreadsheet to calculate Cap Rate.  I was going to add a line for the deprection deduction and cash benefit assuming 28% tax rate.  I started thinking that at the end of the investment that money has to be recaptured so I'm not sure if i should add/account for that tax benefit in the analysis.  What do you guys think?  Maybe im confused about what the recapture means.

Also, if you have an awesome spreadsheet that's not on BP and that factors everything in i'd love to hear about it.