All Forum Posts by: Roman Ripp

Sorry, forgot to mention, my house is near lake Phalen in St Paul. 

I manage a duplex in St Paul from different state myself and I like it this way. The only problem I have is every now and then I need someone, to check on the house. Someone who can stop by and let me know if gutters need to be cleaned, if rain spouts are away from the foundation, if lawn was not taken care of or see if there any other minor issues that can lead to a disaster. It seems to me that hiring a property manager for such small task is an overkill, and finding good handy man every time is hard. Is someone here is willing to do this type of work, or can recommend a good handy man who can do this? 

Hello All,
Thanks for your replies. I found that spreadsheets are very hard to manage, I have hundreds of those now. Instead I have created a web app for myself, where I have all the properties with cash on cash calculations, property details, etc. I cannot share this data with you, because this data is private (provided by agents). But, what I can share is the calculator I used internally. 
You can find it here: https://romanripp.pythonanywhe... . You should be able to get an estimate on cash flow for property you consider. 

Keep in mind that this is a very early prototype and will be changing as time goes. If you have any ideas, suggestions on how I can improve it, I will appreciate it! You can contact me here, or via the web app. 

I see that most of the people use spreadsheets for their calculations, are there other tools you find useful? 

Thanks all for the valuable input. I will update the calculation and publish here my next iteration. 

Hello Dominic

Thanks for your information! It is very valuable. I am happy to share information and hope I can make it more precise and useful.

1) Assumptions:
- Home Price, yes this is a list price, and thanks to you I found an issue with listing updates. Will need to fix this in the future.
- Thanks, I will update downpayment amount. I have a template, that can be customized for a different downpayment amount. But for now, I want to calculate the most common scenario. 
- Thanks, I will update this. 
- Yes, this is a very good idea. For now, however, I did not find a way to pull this data easily. Does tax values look off by a lot? 

Hello,

I have only theoretical experience in real estate, but a lot in software development. I want to automate a process of finding good deals. 
As a first step, I want to make sure I got my math right. Basically what I do, is I look at its purchase price, rent, and expenses such as taxes, maintenance, etc. As a result, I want to know the monthly cash flow, deal, and investment sum. 

I would like someone with experience in purchasing / owning cash flowing properties to look at my analysis and give me suggestions, where I did mistakes. 

As a bonus, maybe you will find a good deal using my tool, or I can set up something that fits your search better. 

Here is the link to the analysis files: https://drive.google.com/drive/folders/17BAS0r-Run...

Basically, it is a google drive folder, with many spreadsheets describing properties in the region I want to invest in. Minneapolis-St Paul area. 

The title has:
- cash flow value: how much property will earn per month.
- deal: indicates if the property is cheaper or more expensive then other properties in this area.  

- how much money I will need to invest. 

If you open any of the files, inside you can see more details about what I use to calculate cash flow. Also, there is an address and a zillow link to the property. And this is where I could use some help. Are my calculation of cash flow match your estimates? 

Thanks. 

Thanks Jian

Hello, 

I am getting overwhelmed by the maintenance of excel sheets. Does anyone know a resource that allows to search for cash flowing properties in the given region? I am aware of RoofStack, but is there anything else? I would like to analyze any property I can find for sale. 

Hello, Is anyone willing to combine efforts? Share the code and write a tool that helps calculate cash flow accurately?