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