Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave C. in Hudson Valley, NY
 
Posts: n/a
Default Equation for PMT formula

I need to recreate the PMT formula in a non-Excel equation format and looking
for some mathematics assistance. I also don't know the underlying logic
built into the PMT formula for compounding interest; is it montly/annual?

Thanks in advance for any assistance.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

The logic for PMT is "periodic" - it depends on the periodicity of the
interest rates and number of payments. The key is to make sure that the
two are kept coordinated, e.g., if a monthly payment is wanted, the
interest rate and number of payments need to be expressed as monthly
rate (APR/12) and months (yrs * 12). If semi-annual payments are
desired, the interest rate must be semiannual (APR/2) and number of
periods equal to twice the number of years.

For the formula, see Help's PV entry.


In article ,
"Dave C. in Hudson Valley, NY" <Dave C. in Hudson Valley,
wrote:

I need to recreate the PMT formula in a non-Excel equation format and looking
for some mathematics assistance. I also don't know the underlying logic
built into the PMT formula for compounding interest; is it montly/annual?

Thanks in advance for any assistance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 12:55 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 04:13 PM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"