Updated about 11 years ago on . Most recent reply
Excel Spreadsheet Analysis
I am new to real estate investing... Although, I have had a condo for 4 years I have been renting out and making a pretty decent return. purchased for $97k, now they are selling at +-$150k and I only owe $68k on the property. Cash flows (after debt service) is about $250 a month.
I just purchased another condo similar to it that I will rent out furnished (these are highly desirable in my area). I will see how that works.
Okay, on with the subject... I am interested in looking at duplexes to purchase. I have created an excel spreadsheet that shows a 5 year holding analysis. From what I have been reading, they say to project 5 years out. So I am attaching this spreadsheet to see if somebody can take a look and see if it looks accurate. I want to make sure I have the correct formulas, etc before I start to use it. I have an example in there for a duplex that is for sale in my area I am looking at. The cash flow looks great, but for some reason after 5 years, if I were to sell it, it shows a negative ROI.
So, if somebody doesn't mind checking this thing out, it would be greatly appreciated. Anybody can feel free to use it, of course.
Thank you in advance!