You can do it in Excel with the financial functions, such as PMT, FV, PV, NPER, and RATE.When you're considering a loan with a balloon, you use the amortization period to calculate the payment.  

Ring Central is excellent.

Now you can export the list to an Excel file, or just use it to see which areas to focus on.

Does anyone have a template they use to track their historical repairs on their units?  I currently own and manage a number of units and want to keep track of the repairs completed.  For example on an individual unit ...

Yeah, it’s kinda like that.Oh excellent thought.

@Kristopher Hanks  excellent post you right there destroyed a lot of myths and things that are marketed in the US rental arena.1. 

Excellent!

Most apartment syndicators in their Excel projections always show at least  3% annual rent increases  built-in.

I understand real estate is a business that you need excel on your own but I think I do need one needs some sort of support from the office who he pays 50% commission on deals. 

Looking for a lender that would feel comfortable with the value of property I already own (free and clear)Current or prior ownership of real estate: Currently own - Current townhome $250-275k (free and clear), Investment commercial warehouse $300k (free and clear), 50% owner in out of state (South Carolina) single family home $275k (free and clear)Occupancy: Current townhome occupied by us, will list for sale once we move - Investment warehouse is fully rented - Out of State home used as vacation homeValue of property at present and/or your offer price: We're shopping for a home in the $400-425k price rangeAfter repair value: $400-425kAnticipated or actual appraisal issues: Actual valueCurrent rents per month: N/A - Will be personal home, not being rented outFair market rents per month: N/aDown payment or equity: We will put at least 20% down, probably $100-150k down paymentSource of down payment funds, if applicable: own fundsIncome Source: self-employed (Retail) and more recently landlordGross monthly income (optional): $7,668.00Monthly debt obligations appearing on credit report, plus (if applicable) personal rent and alimony/child support/etc:  Maybe $400/month at the mostFICO: Excellent - 814 (TransUnion) as of 12/18/18, 810 (Equifax) as of 12/18/18 (via Credit Karma)Credit issues: No credit issues.