98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » PMT function
PMT function
Resolved · Urgent Priority · Version 2007
Wed 8 Jun 2011, 16:40Delegate Greg said...
Greg has attended:
Excel Intermediate course
Excel Advanced course
PMT function
how do i soplit the payments between interest and principal for each period?
Thu 9 Jun 2011, 09:44Trainer Clare said...
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
Fri 10 Jun 2011, 16:39Trainer Rodney said...
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.xlsxFri 10 Jun 2011, 16:46Delegate Greg said...
RE: PMT function
thanks Rodney. do you run a course that teaches how to do these typesw of functions for cashflows and accounting etc?
Mon 13 Jun 2011, 17:14Trainer Clare said...
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
Tue 14 Jun 2011, 07:32Delegate Greg said...
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.
Thu 16 Jun 2011, 13:04Trainer Clare said...
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
Thu 16 Jun 2011, 13:10Delegate Greg said...
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?
Thu 16 Jun 2011, 16:16Trainer Clare said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding multiple rows in an Excel 2010 WorksheetIf you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. |
