1 / 9

Find PV given FV

Find PV given FV. Use PV function. Interest or ROI. Number of periods. Future Value entered as a negative amount. Find FV given PV. Use FV function. Interest or ROI. Number of periods. Present Value entered as a negative amount. Find PV given Annual Amount (A). Use PV function.

waite
Download Presentation

Find PV given FV

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. Find PV given FV Use PV function Interest or ROI Number of periods Future Value entered as a negative amount

  2. Find FV given PV Use FV function Interest or ROI Number of periods Present Value entered as a negative amount

  3. Find PV given Annual Amount (A) Use PV function Interest or ROI Number of periods Annual Amount entered as a negative amount

  4. Find FV given Annual Amount (A) Use FV function Interest or ROI Number of periods Annual Amount entered as a negative amount

  5. Find Annual Amount (A) given PV Use PMT function Interest or ROI Number of periods Present Value entered as a negative amount

  6. Find Annual Amount (A) given FV Use PMT function Interest or ROI Number of periods Future Value entered as a positive amount since salvage will be a negative value

  7. Find Annual Amount (A) given PV Use PMT function Interest or ROI Number of periods Present Value entered as a negative value

  8. Find PV given Monthly Amount (A) Use PV function Annual interest divided by 12 for monthly amount Number of years multiplied by number of periods in the year (12) Monthly amount entered as a negative Value

  9. Example of Combining Functions Combination of functions into one equation Total PV equation

More Related