Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how pmt function works, what is its background / machanizm?
Even I have obtained the result by using the function PMT. But I still
consfuse that how PMT function works, what is its background / machanizm. When we give parameters in this function, how this function manipulate the parameters and give us result? Also how can find any function's background / machanizm in excel help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how pmt function works, what is its background / machanizm?
Mujeeb wrote:
Even I have obtained the result by using the function PMT. But I still consfuse that how PMT function works, what is its background / machanizm. When we give parameters in this function, how this function manipulate the parameters and give us result? Take a look at the mathematical formula at the bottom of the Help page for the PV() function. Algebraically solve for "pmt". If that does not sufficiently answer your question, you might google for "present value formulas" (without quotes). For example, http://en.wikipedia.org/wiki/Present_value might be useful. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how pmt function works, what is its background / machanizm?
PMT is an annuity see this:
http://groups.google.com/group/micro...5a9758c3 034f Mujeeb wrote: Even I have obtained the result by using the function PMT. But I still consfuse that how PMT function works, what is its background / machanizm. When we give parameters in this function, how this function manipulate the parameters and give us result? Also how can find any function's background / machanizm in excel help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how pmt function works, what is its background / machanizm?
Here's the equation I found for calculating payment (PMT) if PV (mortgage
amount), n (number of payment periods) and i (interest rate) are known: http://www.frickcpa.com/tvom/TVOM_formulas.asp (see PMT - Present value of Annuity) Note that "i" is the interest rate per payment period. If payment period is monthly, "i" is (annual interest rate/12) and the annual interest rate is in decimal form (0.08) vs.. percentage (8%). The formula here is a lot easer to follow, IMHO. Hope that this helps. "Mujeeb ur Rehman, FBL-GRW-PK" wrote: Even I have obtained the result by using the function PMT. But I still consfuse that how PMT function works, what is its background / machanizm. When we give parameters in this function, how this function manipulate the parameters and give us result? Also how can find any function's background / machanizm in excel help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Adding cells with the same color, sub works but function doesnt | Excel Discussion (Misc queries) | |||
Concatinate a filename | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |