20% down, mortgaged the rest through a local bank How did you add value to the deal?

If you can buy a 4 flex that will allow your tenants to pay most if not all your mortgage. 

4) Payoff Rental Mortgage: super conservative option.

I wanted to help them out and minimize their loss and saw an opportunity to get a property slightly below market because of my commission savings, immediate mortgage and maintenance relief, in addition to keeping a lower short term interest rate How did you find this deal and how did you negotiate it?

Marketing to find what is a deal, $$ to fund that many deals along with utilities, mortgage payments, taxes, cost overruns, etc.

I'm looking more for an overarching portfolio spreadsheet to track asset performance over the lifetime of holding the asset.If you have the property manager paying the mortgages, taxes, insurances, doing all the accounting, etc why not just ask them to generate whatever report you want?

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases:Class A Properties:Cashflow vs Appreciation: Typically, 3-5 years for positive cashflow, but you get highest relative rent & value appreciation.Vacancy Est: Historically 10%, 5% the more recent norm.Tenant Pool: Majority will have FICO scores of 680+ (roughly 5% probability of default), zero evictions in last 7 years.Class B Properties:Cashflow vs Appreciation: Typically, decent amount of relative rent & value appreciation.Vacancy Est: Historically 10%, 5% should be applied only if proper research done to support.Tenant Pool: Majority will have FICO scores of 620-680 (around 10% probability of default), some blemishes, but should have no evictions in last 5 yearsClass C Properties:Cashflow vs Appreciation: Typically, high cashflow and at the lower end of relative rent & value appreciation.

In C4D the mortgage remains untouched.

Paid $50k down took out an owner financing note for $112,000 and a mortgage for $743/mn Front home rented out for $1,200/mn and back home rented out for $900/mn (currently on the market for sale).I wanted to give some feedback of our deals prior to digging in.

If it is a larger bank/mortgage broker, you should be fine.