The easiest thing might be to go to insert/function in Excel. Under category choose all, then press 'p' till you get to PMT. change screen echo to all, so it reads each field. If you're looking for a payment period that is not yearly, be sure to adjust the period parameter to fit. For monthly at 5 percent, you would type either 5%/12 or .05/12.
At 06:55 PM 6/30/2010, you wrote:
Greetings: I have forgotten the format for the PMT Excel formula for computing principal and interest on a mortgage. Where can I find this info or, in the alternative, help off list would be appreciated. Thanks, Mitch<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> There once was an old man from Esser, Who's knowledge grew lesser and lesser. It at last grew so small, He knew nothing at all, And now he's a College Professor.
-- JFW related links: JFW homepage: http://www.freedomscientific.com/ Scripting mailing list: http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com JFW List instructions: To post a message to the list, send it to jfw@xxxxxxxxxxxxx To unsubscribe from this mailing list, send a message to jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line. Archives located at: //www.freelists.org/archives/jfw Alternative archives located at: http://n2.nabble.com/JAWS-for-Windows-f2145279.html If you have any concerns about the list, post received from the list, or the way the list is being run, do not post them to the list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx