Skip to main content

How to calculate monthly payment( installment) for a Loan Amount in Excel


In Excel there is built in function PMT() to calculate the payment for a loan amount.

For example - our loan amount is $50000 ,interest rate is 10.5% and period is 48 months

*Get PMT function from Financial formula's
*Enter the data properly on fiels

Rate is the interest rate which is divided by 12 (to convert to monthly)
As per our example 10.5% divided by 12 (Cell reference can select instead of direct value)

Nper is the terms or number of months(48) (Cell reference can select instead of direct value)

Pv is the present value or Loan Amount ($50000)  (Cell reference can select instead of direct value)



Comments

Post a Comment

Popular posts from this blog

Java Tutorial Part 5

Keywords Keywords are the predefined words in a program,we can't alter the meaning of keywords. Ex:- for,do,if,class,public. There are almost 62 keywords are in java Identifiers Which is used to give name for a variable or class or methods. Rules for a valid identifier are, *identifiers name must need to begin with an alphabet not by a number.(i.e. 1name is invalid name1 is valid) *Keywords will not be an identifier *Case sensitive, upper case and lower case are treated differently (if you have a variable HELLO and hello, system will treat both in differently)
Post a Comment
Read more

Basic Computer Shortcuts

Ctrl+C : Copies selected content. Ctrl+V : Pastes copied content Ctrl+X : Cut's selected content Ctrl+Z : undo the previous action Ctrl+Y : redo the action you undid Ctrl+A : Selects whole content Ctrl+P : print Windows Logo key( )+Down Arrow : Minimizes the window. Windows Logo key( )+Up Arrow : Maximizes the window. Windows Logo key( )+Left/Right Arrow : To compare two windows. While pressing the Windows logo key  , click the Right Arrow key or the Left Arrow key and your browser will slide over to one side. Select another window (such as a Word document) and use the shortcut only with the opposite arrow. Windows Logo key( )+L  : Locks your computer Windows Logo key( )+P : Presentation display mode Windows Logo key( )+Plus(+)/Minus(-)  : Zoom In and Zoom Out Windows Logo key( )+F : Search for a file Windows Logo key( )+F1 : help Ctrl+Shift+Esc : To open Task Manager
Post a Comment
Read more

Windows 10 preview

World wide Microsoft Windows users are eagerly waiting for the latest operating System Windows 10,which is going to launch very soon. If you are interested with Windows 10,you can download the preview and evaluation versions from the following link. click here for windows 10 preview
Post a Comment
Read more