how do i calculate principal payed in one year in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mortgage-style calculation 4
Formula to calculate compound interest on increasing principal 1
calculating Sick pay entitlement 1
Hi, Gruß aus Bayern 7
cumprinc, not sure how to use it, someone please show me steps ple 1
Need help with Excel worksheet....I'm lost. 4
Calculate interest & withdrawals 0
Excel Based Mortgage Calculator 2

Back
Top