1 / 8

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:. Use the PMT function to forecast loan payments. Calculate cumulative interest. Compute investment value. Use the IF function. Using the Payment (PMT) Function. To use the Payment (PMT) function

miriam
Download Presentation

After completing this lesson, you will be able to:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. After completing this lesson, you will be able to: • Use the PMT function to forecast loan payments. • Calculate cumulative interest. • Compute investment value. • Use the IF function.

  2. Using the Payment (PMT) Function To use the Payment (PMT) function • Click the cell that will contain the formula. • On the Insert menu, click Function. • In the Or select a category list, click Financial. • In the Select a function list, click PMT and click OK. • Enter the interest rate, number of payments, and principal. • Click OK.

  3. Using the Cumulative Interest (CUMIPMT) Function To use the Cumulative Interest (CUMIPMT) function • Click the cell that will contain the formula. • On the Insert menu, click Function. • In the Or select a category list, click Financial. (continued)

  4. Using the Cumulative Interest (CUMIPMT) Function To use the Cumulative Interest (CUMIPMT) function (continued) • In the Select a function list, click CUMIPMT and click OK. • Enter the interest rate, number of payment periods, and principal. • Enter the start period, end period, and type and then click OK.

  5. Using the Future Value (FV) Function To use the Future Value (FV) function • Click the cell that will contain the formula. • On the Insert menu, click Function. • In the Or select a category list, click Financial. (continued)

  6. Using the Future Value (FV) Function To use the Future Value (FV) function (continued) • In the Select a function list, click FV and click OK. • Enter the interest rate, number of payment periods, and payment amount. • Click OK.

  7. Using the IF Function To use the IF function • Click the cell that will contain the formula. • On the Insert menu, click Function. • In the Or select a category list, click Logical. (continued)

  8. Using the IF Function To use the IF function (continued) • In the Select a function list, click IF and click OK. • Type the Logical_test expression, the Value_if_true, and the Value_if_false. • Click OK.

More Related