http://tools.pingdom.com/fpt/GBt...
Sunday, 22 September 2013
Saturday, 21 September 2013
Excel Financial Functions (PMT)
Excel Financial Functions
The
PMT function, one of many Excel's Financial functions, it can be used to
calculate loan repayments or the future value of an investment. This Topic
covers using the PMT function to determine loan repayment
The syntax for the PMT function is: = PMT ( rate , nper , pv , fv , type )
rate = the annual interest rate for the loan.
nper = the total number of payments for the loan.
pv = the present value or the amount borrowed or the "principal of the loan.
fv = future value - for a loan this will be £0.00. For loans this argument can be omitted.
type = indicates when payments are due:
- "0" (or omitted) - at the end of the period ie: end of the month.
- "1" - at the beginning of the period ie: beginning of the month.
Example Using Excel 2010's PMT Function to Calculate Loan Payments:
|
Enter the
following data into cells:
|
|
|
B 2- Rate:
B3- No of payments: B4 - Loan Amnt: B5 - Payment: C2 - 7% C3 - 24 C4 - £10,000.00 |
 |
| Click on cell C5 - the location where the results will be displayed. |  |
|
Click on the Formulas tab. Choose Financial functions > PMT from the ribbon to bring up the function's dialog box. |
  |
|
Click on the Rate line in the dialog box.Click on
cell C2 in the spreadsheet .After the C2, type a forward slash " / " followed by the number 12 in the Rate line of the dialog box. This gives you the interest rate per month. Click on the Nper line in the dialog box, Click on cell C3 in the spreadsheet.. Click on the Pv line in the dialog boxClick on cell C4 in the spreadsheet.. Click OK in the dialog box. |
 |
| The answer -£447.73 appears in cell C5 the value shown is a negative number as this is a debit, to show a posative figure, Type a minus sign ( - ) and then click on cell C4 in the spreadsheet. |  |
| the complete function as it apears in the formula bar | =PMT(C2/12,C3,C4) |
Free Training manuals for excel
Get your free excel training manuals from http://exceltraininglondon.co.uk you need to become a registered user, but then you get access to a free catalogue of training manuals. excel training London is part of the MTC group.
Saturday, 14 January 2012
Mouse training sharepoint site
On the 20th of December a favourite training company of mine closed its doors for the last time.
Bye Bye Mouse Training, But hang on what's happening a company Charis Alexandra Training has taken over the old Mouse training centre Better know as Cat Training how ironic is that the cat finally got the mouse, any way on a serious note Cat Training is a fully accredited training company that has been delivering training in its current format for over 3 years. one of the areas I like is access to a live help forum sign up and give it a whirl, having a trainer available on a helpdesk when you want it is great and to start its free even better. Take a look at the following link CAT Live Chat this takes you to the blog spot then look for the message bottom right corner click to cat chat.
Bye Bye Mouse Training, But hang on what's happening a company Charis Alexandra Training has taken over the old Mouse training centre Better know as Cat Training how ironic is that the cat finally got the mouse, any way on a serious note Cat Training is a fully accredited training company that has been delivering training in its current format for over 3 years. one of the areas I like is access to a live help forum sign up and give it a whirl, having a trainer available on a helpdesk when you want it is great and to start its free even better. Take a look at the following link CAT Live Chat this takes you to the blog spot then look for the message bottom right corner click to cat chat.
Monday, 25 July 2011
Saturday, 11 June 2011
Pivot Tables
Over the coming weeks we shall explore pivot tables in office 2010 all time and materials courtesy of mouse training you can down load free training manuals from the link below
www.mousetraining.co.uk/ms-office-training-manuals.html
Subscribe to:
Posts (Atom)