### Programs: Microsoft Excel : Lesson 2

Lesson 2

Main Objectives:

• PMT Function

• Paste Function

Lesson 2: PMT & Paste Functions

Objective # 1 PMT Function

 Used in Financial Decisionn Making nNeeds three values to compute the payments on the loan nThe interest rate period nThe number of periods nThe amount of the loan n nExample =PMT(.05/12,24,-10000) n.05/12 = interest rate period = annual rate divided by 12 n24 = number of periods = 2 years * 12 months in a year n10000 = amount of loan, entered as a negative amount =PMT(B5/12,B6*12,-B4) nUse cell numbers to calculate terms of a specific loan nB5 contains the interest rate nB6 contains the the period in years nB4 contains the amount of the loan
Objective # 2 Paste Function
 nPurpose nTo be able to select arguments for the function that you typed nHow to use the Paste Function nOnce you have put a formula in a cell, click the symbol that looks like a italicized f with a star next to it that is to the right of the formula bar. nThe ‘paste function dialogue box’ should now appear. nSelect which function you would like to use (we will be using the PMT function). nThen type in the arguments. (In the PMT function, you only need to insert arguments for the first three.) nThe formula bar should say the function you selected times the three arguments you just put in and then the cell in which you selected.

DEMO PROBLEM

After Completing the Analysis of a car loan  demonstration problem, you should master the PMT Function

Excercises

1. The PMT function uses formulas to calculate the final price.

[FrontPage Save Results Component]

True        False

2. You can figure out the Monthly payment without putting in the Price of the car

True        False

3. The Monthly payment will not change if the Interest rate is changed.

True        False

4. The Manufacturer’s rebate and Down Payment are added to the Price of the car to calculate the Amount to finance.

True        False

5. The Goal seek command sets the Monthly payment as a standard and changes other variables in order to reach that goal.

True        False

6. There are only 6 function categories to choose from

True        False

7. When using the PMT function, you have to use all 5 arguments

True        False

8. To activate the PMT function, you have to type an equal sign in a cell

True        False

9. When typing in an interest rate, you divide the interest by 12

True        False

10. The amount of a loan when using the PMT function is entered as a positive number

True        False

[FrontPage Save Results Component]

continue to lesson 3