Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pmt() uses 360-Days Bases, I need 365-Days Bases
In Excel PMT () uses 360-Days bases to calculate Interest. I need such a
formula / function / method which use 365-Days bases to calculate an annuity / interest |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pmt() uses 360-Days Bases, I need 365-Days Bases
PMT() doesn't use either a 360 or 365 day basis. It doesn't know
anything about how long the periods are. The basis is set in the relationship between periods and interest rate. If you want to calculate a 365-day basis: =PMT(APR/365, nyears*365, PV, FV) In article , Mujeeb ur Rehman, FBL-GRW-PK m wrote: In Excel PMT () uses 360-Days bases to calculate Interest. I need such a formula / function / method which use 365-Days bases to calculate an annuity / interest |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Adding Time | Excel Discussion (Misc queries) | |||
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
No. of days split into periods | Excel Discussion (Misc queries) | |||
Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions |