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)
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);