Spreadsheet for Low DTI, small but mighty

[Chester Davis]

Hello colleagues, 

The question: 

Does anyone have a resource, chart or best an excel spreadsheet function which explores the relationships of future cash flow goals, time horizon and DTI, perhaps oriented toward someone looking to the small but mighty perspective?

The reason: 

The biggest elements of getting my wife’s enthusiastic mutual agreement is:

A. Having a clear plan showing a variety of “if bad things happen” scenarios plotted out (economic woes, bad tenants, unexpected expenses) 

B. Keeping a low level of risk; low DTI, diversified risk, etc but I think primarily it is solving the question "if something bad happens can we carry the property and for how long?".

to further these objectives I am planning to start the acquisition process as "cash only" plus some forced appreciation, put into LTR or managed MTR, establish records and build a very healthy reserve account attached to the property, refinance with low DTI to pull some equity for next acquisition.
i started building a spreadsheet but thought “I know I am not the only one, why reinvent the wheel without reason?”, I’m sure that someone already has done it and might be willing to share.

Thank you all. 

Chet Davis

Projects4Missions.com