How do I set up a mortgage calculator in Excel?

3 Responses to “How do I set up a mortgage calculator in Excel?”

1. striving4A1 says:

   September 18, 2010 at 1:55 am

   Try putting this question in the computer section. The techies should definitely have an answer for you there.
2. Dale H says:

   September 18, 2010 at 1:56 am

   I don’t know how often you need to solve for loan amount using rate, term and payment, but this simple calculator would allow you to vary three of the four variables.

   http://www.mortgage-calc.com/mortgage/simple.php

   I will look for guidance on excel and re-post if I find anything useful.
3. nationw1de says:

   September 18, 2010 at 2:32 am

   Excel uses different functions to calculate those different variables i.e. pmt for payment, rate for rate, pv for principal and nper for number of payments. It will require 4 different calculations.

   I believe this is what you’re looking for

   http://nationwidemortgagerate.com/yahoo_answers/calc.xls

Leave a Reply

Click here to cancel reply.

Name (required)

Mail (will not be published) (required)

Website

CAPTCHA Code *

Notify me of followup comments via e-mail