6. Functions : Finance Library Functions : PC Function
 
Share this page                  
PC Function
The PC function calculates the compounded principal, given the principal, interest rate, and number of periods in the life of an annuity or investment.
This function has the following syntax:
PC(pv = value, i = value, nper = value)
Arguments
Data Type
Description
pv
Float
Present value
i
Float
Interest per period
nper
Integer
Number of periods
This function returns:
• Float—The compounded principle
• Null—On error