Was this helpful?
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
Example—PC function:
/*  Calculate difference between compounding daily and
**  monthly a principle amount of $100 at an interest
**  rate of 10% for one year.
*/
/* compounded monthly */
amt1 = pc(pv = 100, I = .1/12, nper = 12);
/* compounded daily */
amt2 = pc(pv = 100, I = .1/365, nper = 365);
Last modified date: 12/20/2023