Check out XL help for the PPMT function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
hi im workin on a college microsoft office 2003 class and i need to calculate
principal payed in one year on a five year note any help?