Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced Excel
Resolved · Low Priority · Version 2003
Wayne has attended:
Excel Advanced course
Excel Intermediate course
How is PMT calculated?
Hi Wayne, Thanks for the post, welcome to the forum, in answer to your question;
The PMT function, one of Excel's Financial functions, can be used to calculate the payments for a loan or the future value of an investment. 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
|
Excel tip:Change the Print button so it brings up the Print dialogue boxIf you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following: |
We'll call during UK business hours
Server loaded in 0.08 secs.