Calculating Cash on Cash Return from Multiple Properties

The gist of this exercise is to get data from Zillow, import it into excel using the “Zillow to Excel” Chrome extension, and then creating another custom tab on the Excel file to analyse the data. We take annual income minus expenses and divide that over our cash investment which consists of our downpayment and closing costs. If there is rehab or initial repair work that would also be in the denominator.

Watch for yourself and see if you can make your own cash return spreadsheet to find the best deal! If you wouldn’t mind I’ve love for you to subscribe to my YouTube channel while you’re at it by clicking on the video via the “Watch on Youtube” link and subscribing.