Based on this rental income estimate, it would be a good value at a $950K price but this is without knowing how much work each unit needs or which capital expenditures are due.

Finally, how much above the down payment should I have in reserves for any unforeseen capital expenditures?

Have you accounted for insurance, capital expenditures, and vacancies in your numbers?

I guess the real question here is i suck at excel and would love to see template examples of some sheets that auto calculate well like for when i input my expenses after rent like percentage saved for vacancy repairs and capital expenditures plus other miscellaneous expenses to help me remain error free. lasrt thing i want to do is realize i forgot something then have to re do the whole thing months from now.

If it appears there isn't enough money to cover capital expenditures coming up, then that money comes from one of two places -- increase in dues or a special assessment.Anyway, I wish you luck. 

Right now I'm looking for input on keeping track of rental expenses and income as well as tracking expenditure during the rehab/purchase process.  

Right now I'm looking for input on keeping track of rental expenses and income as well as tracking expenditure during the rehab/purchase process.

Since you're rebuilding anyway, now might be a great time to house hack to help reduce your own housing expenditures and allow you to get back on track with your own mortgage.

Here are the numbers: all in Purchase price $95,500  Gross income is $21,660 this is facturing in a 5% vacancyExpenses: Property taxes $2,260, Insurance $450, Property management $2,200, Repairs and maintenance 5% $1,140, Utilities $2,025, Lawn & grounds keeping $600, Capital expenditures & miscellaneous, 5% $1,140.

Most of this is already in place, so the plan is to begin offering the platform to other teams/agents with some level of monthly coaching around their Chart of Accounts & expenditures.