![]() ![]() Click cell B2 on the worksheet, which is the price of the car.Remember that cell locations or values used to define the Pv argument must be preceded with a minus sign. This is the third argument we will define in the function. Click the Collapse Dialog button next to the Pv argument in the Function Arguments dialog box.You will also see that the Nper argument is now defined. This returns the Function Arguments dialog box to its expanded form. If the term was defined in years, instead of months, we would need to multiply the terms (years) of the loan by 12 to convert the years to months. Since the term is already expressed in months, we can just reference cell B5 and move to the next argument. This is the term or the length of time for the lease contract. This is the second argument we define in the function. Click the Collapse Dialog button next to the Nper argument in the Function Arguments dialog box.You will also see that the Rate argument is now defined. Since our goal is to calculate the monthly lease payments, we divide the interest rate by 12 to convert the annual rate to a monthly rate. This is the interest rate being charged for the lease. This will be the first argument defined for the monthly car lease payment. Click the Collapse Dialog button next to the Rate argument in the PMT Function Arguments dialog box.This will open the PMT Function Arguments dialog box. Scroll down and click on the PMT Function in the drop-down list.This opens the Financial Function drop-down list. Click the Financial button in the Function Library group.Click cell B6 in the Car Lease Payments worksheet.The following steps explain how the PMT function is added to the Personal Budget workbook to calculate the lease payments for a car: The terms for loans and leases, and the definitions for the arguments of the PMT function were listed in the previous chapter. However, you must know the definitions for each argument of the function and understand how these arguments need to be defined based on your objective. Similar to the statistical functions, we can either type the PMT function directly into a cell or use the Insert Function button. The details for the lease payments are found in the Car Lease Payments worksheet. In addition to calculating the mortgage payments for a home, the PMT function will be used in the Personal Budget workbook to calculate the lease payments for a car. ![]() ![]() 9.2 The PMT (Payment) Function for Leases The PMT (Payment) Function for Leases ![]()
0 Comments
Leave a Reply. |