It’s hard to make sense of your numbers the way you’ve laid them out.
Instead use this model:
Price Less Down Payment
Equals Balance Owed (to be financed)
GSI (Gross Scheduled Income)
Less Vacancy/Credit Loss (5%, or actual vacancy factor) Less GOE (Gross Operating Expenses) (45% of GSI)
Equals NOI (Net Operating Income) Less Debt Service
Equals Cash Flow
This will help everyone get on your page. Otherwise, it’s too much thinking to figure out what you’re talking about. Just saying.
Try using this analysis sheet to help organize your thoughts…