Ignoring actual financials to make excel give you a lower valuation doesn’t smell like a more accurate method of valuation to me.

Does anyone know of a good program or even a good excel template that would do this for me?

This is actually a real reason why many businesses with a good product fail – they are afraid to focus.The solution, in our case, was to simply create a written list addressing the same questions we are always asked by potential borrowers, plus answers to questions borrowers never think to ask in advance (this educates them and also comprises most of the list).

If you want to see a more detailed financial breakdown of property, PM me and I can send you my Excel with all the specifics. 

He has good material and I've learned a few tips so it was worth the time even if I didn't get the excel.

Hi Everyone,I am trying to build out a 10 year "Portfolio Growth Model" in excel. 

I don't have a lot to add, the advice from @Marcia Maynard is excellent. 

ah, excellent. thank you sir, i will call him. 

Every lender is different and therefore by looking around you can find best product for your situation.

Mortgage banker and have some friends that work for QL; decent company, excellent training, but they would never give anyone anything "free"!