A simple spreadsheet could connect both approaches. For each property, record the advertised price, completed price where available, transaction costs, financing assumptions, renovation allowance and ongoing management costs. Keep unknowns visibly blank rather than filling them with optimistic...