As you have probably found there are a lot of calculators out there. A couple sites that I like that have good calculators (and a variety of them) are http://www.bogleheads.org/wiki/Tools_and_Calculators , http://www.mtgprofessor.com/calculators.htm and http://mortgages.longandfoster.com/Calculators.aspx . Unfortunately I'm not sure you'll find one single one that fits all of your needs.
I would also suggest speaking to your mortgage lender or bank, they have all of the tools to help answer the question. If youâ€™re going out shopping for homes it's also best to be pre-approved so you can get both out of the way. They should not charge you for this or make you fill out a complete application, only gather the data needed to answer your questions. I can suggest a few for you to speak to if you need any recommendations, they won't hound you.
I haven't found any complete spreadsheets, if you find one please share! You can check out the affordability excel spreadsheet on this site, it's ok - http://www.inter-lake-lending.com/Calculators.html
Here is an upcoming class on how to use the financial calculator. People fly all over the country to come and see this speaker. I will also be attending this workshop. Come out and see the California sunshine.. unless you love the cold snow. :)
As some of the answers before me state, your best bet is to contact a loan officer licensed in the state you wish to buy your second home. With lending guidelines changing daily it would be best to understand exactly what you need to qualify. You do not need to complete any applications to get education. We would be happy to speak to you about your upcoming purchase with no obligation and no cost. We are a national direct lender and can answer any questions or concerns you may have. I look forward to hearing from you.
Joshua A. Lerette
Senior Loan Officer
Residential Finance Corp.
800-930-7334 ext. 1108