# loan payment formula excel

Formulas to calculate Loan payments in Microsoft Excel

Formulas that calculate loan payments, principal, interest and more are found in the financial category in the Paste Function dialog box. In the screen shot is a .

http://www.exceltip.com/st/Formulas_to_calculate_Loan_payments_in_Microsoft_Excel/301.html

Using the Excel Loan Payment Function

Using the Excel Loan Payment Function . Excel Payment Function Graphic . The completed formula can be seen in the formula bar above columns B and C.

http://www.nhboa.org/archives/loan_payment_calculator.html

Loan or Investment Formulas

Aug 5, 2012 . The Master Formula; Finding Other Loan Numbers. Payment Amount; Number of Payments; Original Amount; Interest Rate. Solving an .

http://oakroadsystems.com/math/loan.htm

## Link to this comment:

## All Comments (0)

PMT - Excel PMT Function

Oct 20, 2007 . The PMT function, one of Excel's Financial functions, can be used to calculate loan repayments or the future value of an investment. . Calculating Loan Payments Using Excel's PMT Function . Click on the Formulas tab.

http://spreadsheets.about.com/od/excelfunctions/qt/20071020.htm