Examlex
Jacob is depositing $125 per month into his RRSP at an interest rate of 4.5% compounded monthly. How long will it take for his RRSP to accumulate to $10,000?
COUNTIF
A function in spreadsheet applications that counts the number of cells within a range that meet a specified condition.
AVERAGEIF
An Excel function that calculates the average of all numbers in a range that meet specified criteria.
Financial Functions
Specific mathematical formulas used in spreadsheets or financial software to perform calculations related to finance, such as interest rates, payments, and investment returns.
FV
Future Value, a finance function that calculates the future value of an investment based on a constant interest rate and fixed payments over time.
Q61: A $10,000 face value strip bond was
Q68: What is the present value of $300
Q78: A credit union pays 5.25% compounded annually
Q133: If you have $45,000 earning 9.6% compounded
Q137: How long (before the first withdrawal) must
Q139: A $15,000 deposit earns 6% compounded quarterly.
Q156: What is the present value of monthly
Q210: Manuel begins investing $700 per month for
Q220: Determine the present value (accurate to the
Q227: Kristina is saving $150 every two weeks