Wednesday, March 30, 2011

more financial formulas

solver (2 examples)
1) take nominal rate (APR) and divide it by freq for year. (e.g., if compounds monthly, divide by 12). that is called the periodic effective rate.
2) calculate: (1 + PeriodicEffectiveRate)^NPER - 1. that is called the annual effective rate



quiz up to this point

next time:
back to invoice
pivottable and pivotchart

No comments:

Post a Comment