View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grd Grd is offline
external usenet poster
 
Posts: 118
Default How do I calculate the interest payment manually (without using IP

Hi there,

I used IPMT but I'm Canadian and it doesn't work for Canada so I basically
need to do an amortization schedule and I have no clue the formulas needed to
do this manually.

I fugure you need a principle column, interest column, monthly payment column.
I need to figure out the compounded interest.

Any guidance will be helpful

Thanks

Suzanne