Help determining depreciation recapture

[Jim Hwang]

Hi all,

I've struggled for weeks to get a definitive answer to this, and am hoping the magic of the BP community comes through here: how do I calculate a rental property's total depreciation amount from which 25% will be taxed as recapture?  Below is the link to a spreadsheet template I found (credit to Coach Carson's YouTube channel), with my actual numbers entered.  Line 12 is the mystery- one CPA estimated 56K, but I got 140K by taking the purchase price X 70% (land was the other 30%), then dividing by 27.5 and lastly multiplying by the 17 years I owned the property.  I'd appreciate any feedback!  https://docs.google.com/spread...