Does this spreadsheet or software exist?

[Jon S.]

I want to have a good way to predict what my capital will look like - before - during - and after - a purchase, renovation and final refinance. I'm looking for a spreadsheet or software that will not only show cash flow, but also the net effect on available sources of capital. When considering the costs associated with multiple sources of finance, ie, leveraging a property, using credit cards, private lending, car loans, HELOCs, signature loans, hard money, it gets very complicated very fast to see the total picture on how much the total financial package is going to add to the cost of acquiring and renovation of the property. When all that is added in, there is a good chance that even a good deal becomes a bad deal, that a low price becomes a high price, or that a positive cash flow becomes a neg cash flow. I would like to input purchase price, renovation expenses, as well as interest. points, and fees on multiple sources of creative finance, ie, short term use of various sources of financing, such as hard money until a refinance is possible? I would like to also be able to input the estimated ARV, how many months until the refinance, the terms of the refinance, etc, so that I can estimate the total financial picture that will exist once renovation, rental is occupied and refinance is complete. Does it exist? In the meantime, I'm just assuming it doesn't exist and therefore working on these questions through spreadsheets. I'm making good progress, but the time it takes and the new issues that crop up everyday is flabbergasting to say the least. But has someone already done a good job of this and is it available?

[Christopher Townsend]

Jon,

Have you tried the BP analysis tools? What are your thoughts on that software?