Adam - I do remember seeing some spreadsheets circulating but I'd definitely advise making an investment in 1) R.E. software or 2) find a firm that can do it for you.
Especially if you are new, don't have a great track record (15+ years of quality investments) then it is by far in your best interest to get help up front.
There are some great firms that specialize in helping investors analyze every facet of an investment and more important help you prepare everything you need to send to lenders. I can't tell you how much of a difference it makes in securing good financing terms. Additionally, you will learn valuable skills that you can then implement on your own for future investments. It sounds like you could really benefit from some solid guidance. We have a in-house analyst and thousands of spreadsheets but we still often use a RE analysis firm b/c of their knowledge and reporting (offering memorandum, lender packets, etc). Some firms charge practically nothing for amazing stuff.
I've worked with just about every software out there (ie. argus, planease, roi, waterfall irr, RE benefits etc) and they can be very helpful. Never used it, but for $39 bucks, Jack's software looks solid.
If you are just looking to build your knowledge base, there are a number of quality books and financing websites that have more info then you'll ever need. Just google!!
good luck