Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to calculate annuity installment in excel with following parameters:
1. interest rate 2. present value 3. future value 4. Grace period, i.e. to start repayment after certain no. of repayment periods 5. annuity type, i.e. rental in advance, or arrears 6. no. of repayments The PMT function in excel takes into account all the above parameters except grace period. Can anyone tell me how take effect of grace period in above calculation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate NPV of perpetual annuity. | Excel Worksheet Functions | |||
How to calculate the RATE in annuity? | Excel Discussion (Misc queries) | |||
How to calculate the RATE in annuity? | Excel Worksheet Functions | |||
How to calculate the accumulated payments from an annuity at yr 10 | Excel Worksheet Functions | |||
How do I calculate the accumulated payments from an annuity at yr | New Users to Excel |