0 of 46 lessons complete.
Module 8: Analysis · Lesson 45 of 46
PMT
Calculate loan payments for equipment purchases.
Step 1 of 10%
A plant is financing a $250,000 machine. PMT calculates the payment: =PMT(rate per period, number of periods, loan amount). Payments are monthly, so divide the rate by 12 and multiply years by 12. In B4, type =PMT(B2/12,B3*12,-B1).
Target: B4
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Loan amount ($) | 250000 | ||||
| 2 | Annual rate | 0.06 | ||||
| 3 | Years | 10 | ||||
| 4 | Monthly payment ($) | |||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $