June 17, 2004

Mortgage Calculator

Here's a mortgage calculator I whipped up in Excel that I thought other people might find handy. It assumes you are doing a 80-20 loan for purchasing a home where the first loan is a 30-year ARM and the second is a home equity line of credit (HELOC). Its primarily meant to help with loans that are nudging the Jumbo boundary ($333,700).

If you use the spreadsheet, you'll want to enter the latest rates and Countrywide has an easy-to-use rate sheet. Note: I don't work for them, though I have done three loans through them and I've always been happy with their customer service.