Math Functions: Finance Calculator
Math Functions: Finance
List of finance functions, including time value of money (TVM), amortization functions, cash flows, bonds, interest conversion, and depreciation functions, with basic definitions. Many functions include links to more in-depth descriptions and examples.
__These functions are only available in templates.__
Time Value of Money
Present Value [pv]
++pv(future value; payment; interest rate; periods)++
Returns the present value given a 'future value', 'payment', annual 'interest rate' and number of 'periods'.
++pv(future value; payment; interest rate; periods; periods per year; compounds per year; payment timing)++
Returns the present value given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year) and 'payment timing'.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return present value of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/47c1622fb9edbd3e2f4a|Savings]
Future Value [fv]
++fv(present value; payment; interest rate; periods)++
Returns the future value given a 'present value', 'payment', annual 'interest rate' and number of 'periods'.
++fv(present value; payment; interest rate; periods; periods per year; compounds per year; payment timing)++
Returns the future value given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year) and 'payment timing'.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return future value of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/47c1622fb9edbd3e2f4a|Savings]
Payment [pmt]
++pmt(present value; future value; interest rate; periods)++
Returns the periodic payment amount given a 'present value', 'future value', annual 'interest rate' and number of 'periods'.
++pmt(present value; future value; interest rate; periods; periods per year; compounds per year; payment timing)++
Returns the periodic payment given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year) and 'payment timing'.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value' and 'future value'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return payment of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/2a7e0fef321c3ce81ae7|Time Value of Money]
Interest Rate [rate]
++rate(present value; future value; payment; periods)++
Returns the interest rate as a decimal (i.e., 0.08) given a 'present value', 'future value', annual 'payment', and number of 'periods'.
++rate(present value; future value; payment; periods; periods per year; compounds per year; payment timing)++
Returns the interest rate as a decimal (i.e., 0.08) given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year) and 'payment timing'.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- Interest rate will be returned as a decimal value (i.e., 0.08). See details below
- 'periods' set to 0 will return interest rate of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0
**Notes About Interest Rate**
Interest rate will be returned as a decimal result. There are two methods to display as a percentage:
- Multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Periods
++periods(present value; future value; payment; interest rate)++
Returns the total number of periods given a 'present value', 'future value', 'payment', and 'interest rate'.
++periods(present value; future value; payment; interest rate; periods per year; compounds per year; payment timing)++
Returns the total number of periods given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year) and 'payment timing'.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Uniform Series Present Value [uspv]
++uspv(interest rate; periods)++
Returns the present value of a series of $1 payments given an 'interest rate' expressed as a decimal and the number of 'periods' payments occur.
__This function is only available in templates.__
**Details**
- 'interest rate' must be defined per compounding period, meaning an annual rate must be divided by the number of interest compounding periods per year.
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/e7bc02097a6018502e7a | Commercial Lease]
Uniform Series Future Value [usfv]
++usfv(interest rate; periods)++
Returns the future value of a series of $1 payments given an 'interest rate' expressed as a decimal and the number of 'periods' payments occur.
__This function is only available in templates.__
**Details**
- 'interest rate' must be defined per compounding period, meaning an annual rate must be divided by the number of interest compounding periods per year
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Single Payment Present Value [sppv]
++sppv(interest rate; periods)++
Returns the present value of $1 given an 'interest rate' expressed as a decimal and the number of 'periods' payments occur.
__This function is only available in templates.__
**Details**
- 'interest rate' must be defined per compounding period, meaning an annual rate must be divided by the number of interest compounding periods per year
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/e7bc02097a6018502e7a|Commercial Lease]
Single Payment Future Value [spfv]
++spfv(interest rate; periods)++
Returns the future value of $1 given an 'interest rate' expressed as a decimal and the number of 'periods' payments occur.
__This function is only available in templates.__
**Details**
- 'interest rate' must be defined per compounding period, meaning an annual rate must be divided by the number of interest compounding periods per year
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Amortizations
End Balance [endbal]
++endbal(end; present value; future value; payment; interest rate; periods)++
Returns the balance of an amortization at the end of period 'end' given a 'present value', 'future value', 'payment', annual 'interest rate' and number of 'periods'.
++endbal(end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round)++
Returns the balance of an amortization at the end of period 'end' given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year), 'payment timing', and number of decimal places to 'round' the result.
++endbal(end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round; positive result)++
Returns the balance of an amortization at the end of period 'end' given the additional values for 'positive result', which, if set to true (1) will always show the end balance as a positive result whether it was calculated as positive or negative.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods' set to 0 will return an end balance of 0
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0; 'decimal places' defaults to 2; 'positive result' defaults to false (0)
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'round' follows the same rules as function [https://.../t/help_functions_number|round()]
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/2a7e0fef321c3ce81ae7|Time Value of Money], [https://.../t/768df4c64fdc9ca7be70 | Auto Loan], [https://.../t/46efc65815103934cbf5 | Mortgage], [https://.../t/df51c33d52ade989929a | Regular Withdrawals], [https://.../t/1a250cde5819d405c6c2 | General Loan]
Principal Paid [prnpaid]
++prnpaid(start; end; present value; future value; payment; interest rate; periods)++
Returns the total principal paid of an amortization from period 'start' to period 'end' (inclusive) given a 'present value', 'future value', 'payment', annual 'interest rate' and number of 'periods'.
++prnpaid(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round)++
Returns the total principal paid of an amortization from period 'start' to period 'end' (inclusive) given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year), 'payment timing', and number of decimal places to 'round' the result.
++prnpaid(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round; positive result)++
Returns the total principal paid of an amortization at the end of period 'end' given the additional values for 'positive result', which, if set to true (1) will always show the principal paid as a positive result whether it was calculated as positive or negative.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return principal paid of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0; 'decimal places' defaults to 2; 'positive result' defaults to false (0)
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'round' follows the same rules as function [https://.../t/help_functions_number|round()]
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/2a7e0fef321c3ce81ae7|Time Value of Money], [https://.../t/768df4c64fdc9ca7be70 | Auto Loan], [https://.../t/46efc65815103934cbf5 | Mortgage], [https://.../t/df51c33d52ade989929a | Regular Withdrawals], [https://.../t/1a250cde5819d405c6c2 | General Loan]
Interest Paid [intpaid]
++intpaid(start; end; present value; future value; payment; interest rate; periods)++
Returns the total interest paid of an amortization from period 'start' to period 'end' (inclusive) given a 'present value', 'future value', 'payment', annual 'interest rate' and number of 'periods'.
++intpaid(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round)++
Returns the total interest paid of an amortization from period 'start' to period 'end' (inclusive) given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year), 'payment timing', and number of decimal places to 'round' the result.
++intpaid(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round; positive result)++
Returns the total interest paid of an amortization at the end of period 'end' given the additional values for 'positive result', which, if set to true (1) will always show the interest paid as a positive result whether it was calculated as positive or negative.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return interest paid of 0
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0; 'decimal places' defaults to 2; 'positive result' defaults to false (0)
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'round' follows the same rules as function [https://.../t/help_functions_number|round()]
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/2a7e0fef321c3ce81ae7|Time Value of Money], [https://.../t/768df4c64fdc9ca7be70 | Auto Loan], [https://.../t/46efc65815103934cbf5 | Mortgage], [https://.../t/df51c33d52ade989929a | Regular Withdrawals], [https://.../t/1a250cde5819d405c6c2 | General Loan]
Amortization Table
++amortization(start; end; present value; future value; payment; interest rate; periods)++
Returns a table of amortization results from period 'start' to period 'end' (inclusive) given a 'present value', 'future value', 'payment', annual 'interest rate' and number of 'periods'.
++amortization(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round)++
Returns a table of amortization results from period 'start' to period 'end' (inclusive) given the additional values for 'periods per year' (payment periods per year), 'compounds per year' (interest compounding periods per year), 'payment timing', and number of decimal places to 'round' the result.
++amortization(start; end; present value; future value; payment; interest rate; periods; periods per year; compounds per year; payment timing; round; positive result)++
Returns a table of amortization results from period 'start' to period 'end' (inclusive) given the additional values for 'positive result', which, if set to true (1) will always show the interest paid as a positive result whether it was calculated as positive or negative.
__This function is only available in templates.__
**Details**
- Cash inflows should be entered as positive values and cash outflows entered as negative values for each 'present value', 'future value' and 'payment'
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'periods' set to 0 will return an empty amortization table
- 'payment timing' is either 0 (false) for end of period computations or 1 (true) for beginning of period computations
- 'periods per year' and 'compounds per year' default to 12 if not provided; 'payment timing' defaults to 0; 'decimal places' defaults to 2; 'positive result' defaults to false (0)
- 'periods per year' or 'compounds per year' less than 0 will return a 'Parameter out of range' calculation error
- 'round' follows the same rules as function [https://.../t/help_functions_number|round()]
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/2a7e0fef321c3ce81ae7|Time Value of Money], [https://.../t/768df4c64fdc9ca7be70 | Auto Loan], [https://.../t/46efc65815103934cbf5 | Mortgage], [https://.../t/df51c33d52ade989929a | Regular Withdrawals], [https://.../t/1a250cde5819d405c6c2 | General Loan]
Interest Conversion
Effective Interest Rate [effrate]
++effrate(nominal rate; compounds per year)++
Returns the effective annual interest rate given a 'nominal rate' and 'compounds per year' (interest compounding periods per year).
__This function is only available in templates.__
**Details**
- 'nominal rate' should be entered as a decimal (i.e., 0.08). See details below
- Effective interest rate will be returned as a decimal value (i.e., 0.08). See details below
- 'compounds per year' must be greater than or equal to 0 or will return a "Parameter out of range" calculation error. 'compounds per year' equal to 0 denotes continuous compounding
**Notes About Rates**
'nominal rate' should be sent to this function as a decimal and effective rate will be returned as a decimal. There are multiple methods to accomplish this:
- Divide 'nominal rate' in the function by 100 and multiply the result by 100:
- Supplement 'nominal rate' in the function with % and multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/116f001eaf9176bd11ff|Interest Conversion]
Nominal Interest Rate [nomrate]
++nomrate(effective rate; compounds per year)++
Returns the nominal annual interest rate given an 'effective rate' and 'compounds per year' (interest compounding periods per year).
__This function is only available in templates.__
**Details**
- 'effective rate' should be entered as a decimal (i.e., 0.08). See details below
- Nominal interest rate will be returned as a decimal value (i.e., 0.08). See details below
- 'compounds per year' must be greater than or equal to 0 or will return a "Parameter out of range" calculation error. 'compounds per year' equal to 0 denotes continuous compounding
**Notes About Rates**
'effective rate' should be sent to this function as a decimal and nominal rate will be returned as a decimal. There are multiple methods to accomplish this:
- Divide 'effective rate' in the function by 100 and multiply the result by 100:
- Supplement 'effective rate' in the function with % and multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Cash Flows
Net Present Value [npv]
++npv(table; interest rate)++
Returns the net present value (NPV) given 'table' of cash flows and an 'interest rate'
__This function is only available in templates.__
**Details**
• 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
• 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
• 'interest rate', by default, is an annual rate. For alternative periodic rates, divide it by the number of annual compounding periods
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
• Example: [https://.../t/c8486805c46d57d87501|Cash Flows]
Net Future Value [nfv]
++nfv(table; interest rate)++
Returns the net future value (NFV) given 'table' of cash flows and an 'interest rate'.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'interest rate', by default, is an annual rate. For alternative periodic rates, divide it by the number of annual compounding periods
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Net Uniform Series [nus]
++nus(table; interest rate)++
Returns the net uniform series (NUS) given 'table' of cash flows and an 'interest rate'.
++nus(table; interest rate; timing)++
Returns the net uniform series (NUS) given 'table' of cash flows, an 'interest rate' and whether payment 'timing' occurs at the beginning (1 or true) or end (0 or false) of the period.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'interest rate', by default, is an annual rate. For alternative periodic rates, divide it by the number of annual compounding periods
- 'timing' defaults to end of period (0 or false)
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Internal Rate of Return [irr]
++irr(table)++
Returns the internal rate of return (IRR) given 'table' of cash flows.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
- irr() returns 0 if there is no sign change in 'table'. The function could also have multiple results if there are multiple sign changes. irr() will most likely return the result closest to 0 in this case
**Notes About IRR**
Internal rate of return will be returned as a decimal result. There are two methods to display as a percentage:
- Multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Modified Internal Rate of Return [mirr]
++mirr(table; interest rate; risk rate)++
Returns the modified internal rate of return (MIRR) given 'table' of cash flows, an 'interest rate' and a reinvestment rate or 'risk rate'.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
- 'interest rate' and 'risk rate' should be entered as a decimal (i.e., 0.08). See details below
- 'interest rate' and 'risk rate', by default, are annual rates. For alternative periodic rates, divide each by the number of annual compounding periods
**Notes About rates**
'interest rate' and 'risk rate' should be sent to this function as a decimal and modified internal rate of return will be returned as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' and 'risk rate' in the function by 100 and multiply the result by 100:
- Supplement 'interest rate' in the function with % and multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Payback
++payback(table)++
Returns the period number when the initial investment of a given cash flow will be paid back given 'table' of cash flows.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Profitability Index [profindex]
++profindex(table; interest rate)++
Returns the profitability index given 'table' of cash flows and an 'interest rate'.
__This function is only available in templates.__
**Details**
- 'table' consists of cash flows where inflows are entered as positive values and outflows entered as negative values, where the first column is values and the second column is occurrences
- 'interest rate' should be entered as a decimal (i.e., 0.08). See details below
- 'interest rate', by default, is an annual rate. For alternative periodic rates, divide it by the number of annual compounding periods
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/c8486805c46d57d87501|Cash Flows]
Bonds
Yield
++yield(settlement date; maturity date; payments per year; coupon rate; redemption value; price)++
Returns the yield expressed as a decimal for a security at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', how often coupon payments occur per year ‘payments per year’, a 'redemption value', and a 'price' where the day-count method is actual days.
++yield(settlement date; maturity date; payments per year; coupon rate; redemption value; price; method)++
Returns the yield expressed as a decimal for a security at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', how often coupon payments occur per year ‘payments per year’, a 'redemption value', a 'price', and a day-count 'method'.
__This function is only available in templates.__
**Details**
- 'redemption value' is the percentage of the security's par value paid to the owner at retirement. Is 1 (100%) if held to maturity
- 'payments per year' less than 0 will return a 'Parameter out of range' calculation error
- 'coupon rate' and 'redemption value' should be entered as a decimal (i.e., 0.08). See details below
- 'method' should be entered as 0 for actual days, 1 for 30/360, 2 for actual/360 and 3 for actual/365. Actual calculates the actual number of days, including leap days, between the two dates. 30/360 calculates 360 days per year plus 30 days for each remaining month plus the remaining days. Actual/360 calculates 360 days per year plus actual day count for the remainder. Actual/365 calculates 365 days per year plus actual day count for the remainder
**Notes About Rates**
'coupon rate' and 'redemption rate' should be sent to this function as a decimal and modified internal rate of return will be returned as a decimal. There are multiple methods to accomplish this:
- Divide each rate in the function by 100 and multiply the result by 100:
- Supplement each rate in the function with % and multiply the result by 100:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
Price
++price(settlement date; maturity date; payments per year; coupon rate; redemption value; yield)++
Returns the price for a security at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', how often coupon payments occur per year ‘payments per year’, a 'redemption value', and a 'yield' expressed as a decimal where the day-count method is actual days.
++price(settlement date; maturity date; payments per year; coupon rate; redemption value; yield; method)++
Returns the price for a security at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', how often coupon payments occur per year ‘payments per year’, a 'redemption value', a 'yield' expressed as a decimal, and a day-count 'method'.
__This function is only available in templates.__
**Details**
- 'redemption value' is the percentage of the security's par value paid to the owner at retirement. Is 1 (100%) if held to maturity
- 'payments per year' less than 0 will return a 'Parameter out of range' calculation error
- 'coupon rate', 'redemption value' and 'yield' should be entered as a decimal (i.e., 0.08). See details below
- 'method' should be entered as 0 for actual days, 1 for 30/360, 2 for actual/360 and 3 for actual/365. Actual calculates the actual number of days, including leap days, between the two dates. 30/360 calculates 360 days per year plus 30 days for each remaining month plus the remaining days. Actual/360 calculates 360 days per year plus actual day count for the remainder. Actual/365 calculates 365 days per year plus actual day count for the remainder
**Notes About Rates**
'coupon rate', 'redemption value' and 'yield' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide each rate in the function by 100:
- Supplement each rate in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
**Example**
[https://.../t/4b3251791fe195f3ea20|Bonds]
Accrued Interest [accint]
++accint(settlement date; maturity date; payments per year; coupon rate)++
Returns the accrued interest for a security that pays interest at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', and how often coupon payments occur per year ‘payments per year’ where the day-count method is actual days.
++accint(settlement date; maturity date; payments per year; coupon rate; method)++
Returns the accrued interest for a security that pays interest at maturity given the 'settlement date' (also known as issue or purchase date), 'maturity date' (or call date), annual 'coupon rate', and how often coupon payments occur per year ‘payments per year’, and a day-count 'method'.
__This function is only available in templates.__
**Details**
- 'payments per year' less than 0 will return a 'Parameter out of range' calculation error
- 'coupon rate' should be entered as a decimal (i.e., 0.08). See details below
- 'method' should be entered as 0 for actual days, 1 for 30/360, 2 for actual/360 and 3 for actual/365. Actual calculates the actual number of days, including leap days, between the two dates. 30/360 calculates 360 days per year plus 30 days for each remaining month plus the remaining days. Actual/360 calculates 360 days per year plus actual day count for the remainder. Actual/365 calculates 365 days per year plus actual day count for the remainder
**Notes About 'coupon rate'**
'coupon rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'coupon rate' in the function by 100:
- Supplement 'coupon rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
< Coupon Rate = %>
**Example**
[https://.../t/4b3251791fe195f3ea20|Bonds]
Depreciation
Book Value [depb]
++depBV(type; cost; salvage; life; month; year; interest rate)++
Returns the book value (original asset cost less the accumulated depreciation) of a depreciable asset given a depreciation type 'type', cost of the depreciable asset 'cost', salvage value at the end of the asset’s life 'salvage', life of the asset in years 'life', the first month to begin depreciation 'month', and year to calculate 'year' and the depreciation rate expressed as a decimal 'interest rate'.
__This function is only available in templates.__
**Details**
- 'type' is 0 for straight line depreciation, 1 for declining balance, 2 for declining balance crossover and 3 for sum of the year’s digits. If the value is greater than 3 then straight line is used.
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
< Interest Rate = %>
**Example**
[https://.../t/2298a24a8c8cfb289615|Depreciation]
Amount [depa]
++depA(type; cost; salvage; life; month; year; interest rate)++
Returns the depreciation amount (total amount of depreciation for the year) of a depreciable asset given a depreciation type 'type', cost of the depreciable asset 'cost', salvage value at the end of the asset’s life 'salvage', life of the asset in years 'life', the first month to begin depreciation 'month', and year to calculate 'year' and the depreciation rate expressed as a decimal 'interest rate'.
__This function is only available in templates.__
**Details**
- 'type' is 0 for straight line depreciation, 1 for declining balance, 2 for declining balance crossover and 3 for sum of the year’s digits. If the value is greater than 3 then straight line is used.
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
< Interest Rate = %>
**Example**
[https://.../t/2298a24a8c8cfb289615|Depreciation]
Value [depv]
++depV(type; cost; salvage; life; month; year; interest rate)++
Returns the depreciation value (book value less salvage value) of a depreciable asset given a depreciation type 'type', cost of the depreciable asset 'cost', salvage value at the end of the asset’s life 'salvage', life of the asset in years 'life', the first month to begin depreciation 'month', and year to calculate 'year' and the depreciation rate expressed as a decimal 'interest rate'.
__This function is only available in templates.__
**Details**
- 'type' is 0 for straight line depreciation, 1 for declining balance, 2 for declining balance crossover and 3 for sum of the year’s digits. If the value is greater than 3 then straight line is used.
**Notes About 'interest rate'**
'interest rate' should be sent to this function as a decimal. There are multiple methods to accomplish this:
- Divide 'interest rate' in the function by 100:
- Supplement 'interest rate' in the function with %:
- Modify the variable itself to include a percentage so PowerOne can handle this automatically:
< Interest Rate = %>
**Example**
[https://.../t/2298a24a8c8cfb289615|Depreciation]
Keywords
-------------
Time Value of Money
TVM
Present Value
pv()
Future Value
fv()
Payment
pmt()
Interest Rate
rate()
Periods
periods()
Uniform Series Present Value
uspv()
Uniform Series Future Value
usfv()
Single Payment Present Value
sppv()
Single Payment Future Value
spfv()
Amortization
endbal()
Principal Paid
prnpaid()
Interest Paid
intpaid()
Interest Conversion
Effective Interest Rate
effrate()
Nominal Interest Rate
nomrate()
Cash Flows
Net Present Value
npv()
Net Future Value
nfv()
Net Uniform Series
nus()
Internal Rate of Return
irr()
Modified Internal Rate of Return
mirr()
Payback
payback()
Profitability Index
profindex()
Bonds
Yield
yield()
Price
price()
Accrued Interest
accint()
Depreciaton
Book Value
depbv()
Amount
depa()
Value
depv()
Straight Line
Declining Balance
Declining Balance Crossover
Sum of the Year's Digits
SOYD
SL
DB
DBxSL
