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)


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
XL Averaging numbersXL Rename worksheets
XL Change row and column dimensionsXL Sort lists
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
ProgrammingHealthcare IT
System design