View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vinod Mahendrakar
 
Posts: n/a
Default Calculate Loan Payment Dates

Hi

Can any one help me how to calculate Loan Payment Dates and re payment
amount using following parameters (Loan amount, rate, start date, Frequency?)

Frequency - Monthly, Weekly, Biweekly, Bimonthly

I am trying to populate data as below:

Date - Payment Recd - Payment Due - Total Paid - Balance Amount

Thanks
Vinod