graphc1
 

Exam 77-428 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.4 Create Scenarios: Use Financial Functions

Financial Function: PMT

3. Try it: Use a Financial Function

Select Cell B4.

Go to Formulas->Function Library.

Go to Financial. Click on PMT.

graphic3

When you see the Function Arguments:

Edit the Rate: B3/12

Edit the Nper: B2

Edit the Pv: B1

Keep going, please...

 

Memo to Self: The Yearly Rate is divided by 12 to get the Monthly Rate

Formulas-> Function Library-> Financial-> PMT
graphic2