I have created a monthly Canadian ammortization excel spreadsheet, but I
am unable to figure out how to change the it in order to have
semi-monthly, bi-weekly, or weekly schedules. My monthly formula is:

=PMT((1+A/2)^(1/6)-1,B,-C)

A=interest rate
B=payments
C=principal amount

Can anybody help me? email:

Thank you.
Alan B.


--
AFQ
Posted from - http://www.officehelp.in