|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Financial > IPMT |
IPMT(rate, per, nper, pv [,fv] [,type]) |
| Returns the interest paid for a given period of an investment. |
| rate | The fixed interest rate per period. | |
| per | The period for which you want to find the interest. | |
| nper | The total number of payments. | |
| pv | The present value. | |
| fv | The future value or cash balance. | |
| type | The number identifying when the payments are due: 0 = the end of the period 1 = the start of the period |
| REMARKS |
| The present value is the total amount that the payments are worth now. | ||
| Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. | ||
| The "per" must be in the range 1 to "nper". | ||
| If "fv" is left blank, then 0 is used. | ||
| If "type" is left blank, then 0 is used. | ||
| Make sure that you are consistent about the units you use for specifying "rate" and "nper". | ||
| If you make monthly payments on a four-year loan at 12 percent annual interest, use 12%/12 for rate and 4*12 for "nper". | ||
| If you make annual payments on the same loan, use 12% for "rate" and 4 for "nper". | ||
| For all the arguments, cash you pay out, such as deposits to savings, is represented by negative numbers; cash you receive, such as dividend checks, is represented by positive numbers. | ||
| This function is closely related to the PV() function. |
| EXAMPLES |
|
| Functions - I | Index - I | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |