Greg has attended:
Excel Intermediate course
Excel Advanced course
PMT function
how do i soplit the payments between interest and principal for each period?
RE: PMT function
Hi Greg,
There are 2 additional financial functions in Excel, IPMT which calculates the interest only on a loan and PPMT which calculates the principal repaid on a loan. The answer of IPMT plus the answer of PPMT equals the result of the PMT function.
The parameters within these functions are similar to those within PMT.
I hope this answers your question. I look forward to meeting you on the 13th.
Clare Glover
RE: PMT function
Hello Greg,
Regarding your question about calculating interest and capital for each period, I have attached a file which uses the PMT function and I have also created formulas which work out the interest and capital payments for each period. Check it out...
If this works for you, please mark this question as resolved or let us know how else we may help.
Enjoy this weekend...
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
PMT functions.xlsxRE: PMT function
thanks Rodney. do you run a course that teaches how to do these typesw of functions for cashflows and accounting etc?
RE: PMT function
Thanks for the post and it was good to meet you today, but in answer to your question I am afraid we don't currently offer this sort of course as standard at the moment but are thinking of developing one. We'll be in touch if it gets off the ground...
Best wishes
Clare
RE: PMT function
clare thanks for the course yesterday.
can i ask a question outside of excel please.
how do i password protect a file?
others use my laptop and there are some files containing personal info which i want to protect and secure without creating separate user accounts for he laptop.
RE: PMT function
Hi Greg,
It's the same procedure as we covered in the Excel Course:
open the file
go to save as (you must get the dialogue box)
tools and general options
and set a password to open...
It's the same thing in reverse to remove the password protection.
Hope this helps
Clare
RE: PMT function
thanks Clare. id didn't ask the question correctly i am sorry. I want to password protect a folder not a file. can I password protect a folder containing lots of other documents/files please?
RE: PMT function
Hi Greg,
It all depends on your operating software for folder protection. I'll put down a couple of linls for you. The other option is to set up a new user account for other people so they don't have access t your folders.
http://www.computerhope.com/issues/ch000705.htm
This covers slightly older operating systems
http://www.ehow.com/how_4701145_password-protect-folders-vista.html
This one covers the vista operating system.
If you have Windows 7 itβs a bit more complicated but this website gives some options.
http://windows7themes.net/how-to-password-protect-a-folder-in-windows-7.html
There are other options for free password-protecting software β google folder password protection and your windows system.
On a separate topic - we are no longer dealing with PMT, so if you could start a new post if you have further questions, it will help the forum search facility.
Many thanks
Clare
