Spreadsheet Calculating Cash Flow and Net Worth Based on Purchase Timeline
This weekend a friend and I were talking about when we would be millionaires. He started using the Dave Ramsey calculator to determine how his IRA and 401k would grow. We realized real estate should be a part of the calculation but we didn't have anything to figure out how much cash flow and net worth we'd have based on when we bought properties.
I created the attached to help me out and thought it may be beneficial to others. You can input some of the fixed values at the top, purchase dates of houses (it assumes you buy houses on Jan 1 for simplicity), and this calculates how much cash you'd have to put in to the business and the returns you'll get.
http://www.biggerpockets.com/files/user/dclight07/file/cash-flow-planner
It's my first stab at a spreadsheet like this so any feedback is appreciated. Hope someone else can find it useful!