Alan Freedman -- The Computer Language Company - Computer Desktop Encyclopedia
Computer Desktop Encyclopedia
Longest-Running Tech Reference on the Planet

A CDE Definition

You'll love The Computer Desktop Encyclopedia (CDE) for Tech Term of the Day (TTOD)

LOOK UP ANOTHER TERM


XL Loan payments

Excel can be used as a monthly loan payment calculator by entering the appropriate values.






Compute a Mortgage Payment
Select the Function (Fx) button on the Home ribbon or main toolbar and then select PMT (payment) from the Financial category. Follow these instructions:



1. Highlight a cell to place the result.
2. Click Function button.
3. Select PMT from Financial category.
4. In Rate, enter interest rate, followed by a percent sign,
then a slash and number of payments per year.
5. In Nper, enter duration of loan in months,
in this case, a 30 year loan.
6. In Pv (present value), enter amount of loan.
7. View monthly payment at bottom.





Personal Use Only

Before/After Your Search Term
BeforeAfter
XL Averaging numbersXL Rename worksheets
XL Change row and column dimensionsXL Sort lists
XL ChartsXLANG
XL Cut, Copy and PasteXlib
XL Delete data in cellsXLink
XL Delete row/columnXLISP
XL Edit a formulaXLL
XL Enter date/timeXLR connector
XL Erase data in cellsXLS
XL Insert row/columnXLSX

Terms By Topic
Click any of the following categories for a list of fundamental terms.
Computer Words You Gotta KnowSystem design
Job categoriesUnix/Linux
Interesting stuffPersonal computers
InternetIndustrial Automation/Process Control
Communications & networkingAssociations/Standards organizations
HistoryDesktop publishing
Audio/VideoGraphics
MainframesSecurity
ProgrammingHealthcare IT
System design