how do i calculate principal payed in one year in excel
 

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?

If I remember correctly, I'd need the following information:

Interest Rate
# payments
Simple or compound interest.
Original Principal

"bigjd45" wrote:

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?

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?