Please test out my deal analysis spreadsheet - feedback requested

[Kevin Chan]

Hi, I adapted Brandon's spreadsheet into a different format. Please check it out and let me know if there are any mistakes in the calculations or modeling.

My goal is to use it to evaluate foreclosure deals and to determine max bid.

Two different versions - one to evaluate Max Bid for foreclosure auction (tweak target discount rate) and another where the price is known.

[url]http://www.biggerpockets.com/files/user/Kevinhpchan/file/rental-vs-flip-analysis

Thanks