View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Azam_Saeed Azam_Saeed is offline
external usenet poster
 
Posts: 1
Default How to Calculate Annuity Rental

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.