ROI excel spreadsheet

[Don Phil]

Hey my name is Dontay Phillips I am new to the realestate game. My wife and I our first time buyers. We are looking to purchase a fourplex in the Colorado springs area, for our first property in about a month or so. We've limited down our options to a handful of places. I realized that the best way to compare and contrast these properties is to calculate the ROI of each. I wanted to see if there was anyone out there that has used Microsoft excel to keep track of the ROIs of there properties? If so do you recommend it ? Do you have any templates or tips I could possibly use to help me get started ?

[JD Gunter]

I use Excel to track ROI all the time. The calculators on Bigger Pockets are helpful, but building your own will really help you see behind the numbers. I would recommend checking out the BP calculators and basing your spreadsheet on that. Keep it simple and focus on cashflow. Also, the sooner you can plug in actual numbers rather than projected, the sooner you can determine whether specific deals work or not. Sometimes it's difficult for people to shift from hypothetical to actual. I'm happy to help if you need someone to look over your shoulder.