The optimal spreadsheet would include pro-forma projections of all expenses and expected re-sale value of the home.

My favorite part so far...for comedic purposes, and please keep in mind this comes with some sarcasm.....I found things like: "The weights of the components are statistically optimized for each metro area in order tobest capture the underlying cyclical movements in the local areaeconomy." translation....

Sometimes lenders on properties that are non-optimal in the portfolio with TRY to find any reason to call the loan due especially if interest rate is low and they can relend that money at higher rates.They can look for any reason to try.These are more complex type deals.Regular single tenant NNN are vanilla deals so nothing really to go after there.    

In this way, my partner and I will each receive 49% of the operating income through the pass-through entity (with income, capital gains, etc. individually being managed and optimized through individual tax planning) and the LLC will further offer us indirect control while still limiting our personal liability exposure as it's an LLC.  

In my experience if you are wanting to hold the home as a rental for the long term future, then living in it while you renovate it has one main benefit (low down payment) and a litany of pain-points (like dusty EVERYWHERE, cash out of pocket for rehab, and a whole lot more).Typically when investors think through the "live-in" angle it is either to optimize the down payment (as in a house-hack, where you'd ideally bring little to closing and have a higher cash-on-cash return) or to optimize the tax scenario (as in a live-in flip, where the goal may be to live in it for two years and then sell it within the next few years, triggering the "tax free capital gains on the first $250k of profit idea). 

I'll definitely take heed to your advice and continue to make changes and optimize it the best i can. 

Vigilantly monitoring and optimizing your cash flow to ensure it adequately covers your debt obligations can safeguard your investments and strengthen your relationship with lenders.Vacancy per Unit Type: A novel perspective shared by Gary was to focus on vacancy per unit type rather than evaluating the building as a whole.

My family has gone from disbelief to cautious optimism to cheerleaders to co-investors.I have friends that I just don't talk about it with though.  

Like any math problem you can optimize for 1 variable.What is the point of maximizing the cash flow?

You are best to optimize your Schedule E for taxes to optimize your DTI from your existing rentals as you scale your portfolio.