PV and RATE

  1. Calculate an APR%
  2. Calculate principal from rate, period and payment
  3. Calculate a PAF from an APR

Two functions are used

  • PV
  • RATE

To see alternative results, change figures in cells with a light yellow background.

   Missing: Microsoft Office Web Components
 
This page requires the Microsoft Office Web Components.

Click here to install Microsoft Office Web Components..

This page also requires Microsoft Internet Explorer 4.01 (SP-1) or higher.

Click here to install the latest Internet Explorer.
 

You can copy the above into a blank worksheet.

Published: 02-Feb-2004
Last edited: 05-Jun-2005 19:16