| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IPMT Function for fractional periods
I'm want to know, for an equal amortizing loan, the interest amount for each
period. However, the first period is a fractional period. It starts today and calculated until the beginning of Sept. I'm not sure how to use the PMT and IPMT functions for fractional periods. thx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IPMT Function for fractional periods
Adjust the units you express the period in to days (or half months or weeks, whatever your requirements are).
Of course you'll have to adjust the interest rates accordingly. -- Kind regards, Niek Otten Microsoft MVP - Excel "Woody13" wrote in message ... | I'm want to know, for an equal amortizing loan, the interest amount for each | period. However, the first period is a fractional period. It starts today | and calculated until the beginning of Sept. I'm not sure how to use the PMT | and IPMT functions for fractional periods. thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Depreciation function inconsistencies | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
