Hi Janet,

There is a family of financial functions that address this and similar
problems: RATE(), NPV(), FV(), PMT(), NPER() etc.
In Analysis Toolpak (ToolsAdd-ins, check Analysis Toolpak if not done
already) there is a family for irregular payments.
See HELP for details; post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

"Grd" wrote in message
...
Hi,

How can I do an amortization schedule that gives me the interest as its
being paid off?

Is there a function that can help.

Thanks in Advance
Any help greatly appreciated

Regards
Janet