A
Azam_Saeed
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.
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.