This seems to be an excellent site for garnering information. 

@Mike Dunn Excellent write up.

Can anyone recommend an online excel-type tool that would allow me to plug in financing terms for an apartment building to see what the loan paydown would be for each year?

Excellent advice Mr.

I would like to give some update about the lender I found, Sierre Pacific, they did an excellent job for getting me the loan in 16 days without any hassle or headache what-so-ever, no extra documents require beside all the standard such as W2, paystubs, bank statement....any they don't question to every penny you have in your account.

Typically you can download to excel. 

If it's in excellent condition you can expect to pay a six cap, if it's not then maybe a nine or a ten is in the cards.

Here is what I have learned about it...Pros:It is excellent for DIY.  

Excellent.

Most locations have excellent reps to ask any questions.To paint covered white fingers, best of luck