|
DoubleDecliningBalanceComment
|
'Returns the depreciation of an asset using the '+'double-declining balance method. It determines '+'accelerated depreciation values for an asset, '+'given the initial cost, life expectancy, end '+'value, and depreciation period'
|
|
DoubleDecliningBalanceFunctionName
|
'double-declining-balance'
|
|
FutureValueComment
|
'Returns the future value of an investment of '+'<present-value-numeric-expression> where <payment-numeric-expression> '+'is invested for <num-periods-integer-expression> at the rate of '+'<rate-numeric-expression> per period. The '+'last parameter indicates whether the investment '+'is an ordinary annuity or an annuity due (enter '+'ptEndOfPeriod if payments are at the end of each period, '+'ptStartOfPeriod if they are at the beginning)'
|
|
FutureValueFunctionName
|
'future-value'
|
|
InterestPaymentComment
|
'Returns the interest portion of a loan payment. '+'It calculates the portion of a loan payment that reflects '+'the interest. <rate-numeric-expression> represents the '+'fixed periodic interest rate. <period-integer-expression> '+'identifies the payment period. <num-periods-integer-expression> '+'is the number of periods of the loan. <present-value-numeric-expression> '+'represents the amount borrowed (the principal). '+'<future-value-numeric-expression> is the future value '+'of the investment. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
InterestPaymentFunctionName
|
'interest-payment'
|
|
InterestRateComment
|
'Returns the interest rate required to increase '+'<present-value-numeric-expression> to <future-value-numeric-expression>. '+'It calculates the interest rate required in order for an '+'investment of <present-value-numeric-expression>, with '+'periodic payments of <payment-numeric-expression>, to be '+'worth <future-value-numeric-expression> within '+'<num-periods-integer-expression> compounding periods. '+'If <num-periods-integer-expression> represents years, an '+'annual interest rate results; if it represents months, '+'a monthly interest rate results, and so on. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
InterestRateFunctionName
|
'interest-rate'
|
|
InternalRateOfReturnComment
|
'Returns the internal rate of return on an '+'investment. It references a multifield that contains cash flow information '+'and uses the supplied internal rate of return estimate to calculate results. '+'Before using this function, define a multifield containing expected cash '+'flow amounts over a period of time. It is assumed that the amounts are '+'received at regular intervals. Negative amounts are interpreted as cash '+'outflows, and positive amounts as inflows. The first amount must be a '+'negative number, to reflect the initial investment. The following amounts '+'can all be the same for each time period, or they can be different '+'(including a mixture of negatives, positives, or zeros). Specify the '+'estimated rate of return as the <guess-numeric-expression> parameter. '+'Pass the expected cash flow amounts as the <cash-flows-multifield-expression> parameter.'
|
|
InternalRateOfReturnFunctionName
|
'internal-rate-of-return'
|
|
NetPresentValueComment
|
'Returns the current value from a multifield of '+'estimated cash flow values. It calculates the current value of a multifield '+'estimated cash flow values (<cash-flow-multifield-expression>), discounted at the given interest rate of '+'<rate-numeric-expression>. It helps determine how much an investment is '+'currently worth, based on expected earnings, although its accuracy depends '+'on the accuracy of the cash flows. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
NetPresentValueFunctionName
|
'net-present-value'
|
|
NumberOfPeriodsComment
|
'Returns the number of payment periods for an investment. '+'It computes the number of payment periods required for an investment of '+'<present-value-numeric-expression> to reach a value of <future-value-numeric-expression>, '+'while making regular payments of <payment-numeric-expression> and accruing '+'interest at the rate of <rate-numeric-expression> per compounding period. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
NumberOfPeriodsFunctionName
|
'number-of-periods'
|
|
PaymentComment
|
'Returns the fully amortized payment of borrowing '+'<present-value-numeric-expression> at <rate-numeric-expression> percent '+'per period over <num-periods-integer-expression>. It assumes that '+'interest is paid at the end of each period. <future-value-numeric-expression> '+'is the value that the investment will reach at some point. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
PaymentFunctionName
|
'payment'
|
|
PeriodPaymentComment
|
'Returns the principal amount from a full payment. '+'It gives the part of the payment that is principal. The interest-payment '+'function gives the part of the payment that is interest. The <rate-numeric-expression> '+'parameter is the interest rate. <period-integer-expression> is the '+'number of periods into the loan for which the principal is desired, and '+'<num-periods-integer-expression> is the number of periods of the loan. '+'<future-value-numeric-expression> is the value the investment will reach '+'at some point. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
PeriodPaymentFunctionName
|
'period-payment'
|
|
PresentValueComment
|
'Returns the present value of an investment where '+'<payment-numeric-expression> is received for <num-periods-integer-expression> '+'and is discounted at the rate of <rate-numeric-expression> per period. '+'<future-value-numeric-expression> is the value the investment will reach '+'at some point. The '+'last parameter indicates whether the cash flow occurs '+'at the beginning (ptStartOfPeriod) or end (ptEndOfPeriod) '+'of the period'
|
|
PresentValueFunctionName
|
'present-value'
|
|
SLNDepreciationComment
|
'Returns the straight-line depreciation allowance of '+'an asset. The function divides the <cost-numeric-expression> minus the '+'<salvage-numeric-expression> by the number of years of useful '+'<life-integer-expression> of the asset. <cost-numeric-expression> is the '+'amount initially paid for the asset. <salvage-numeric-expression> is the '+'value of the asset at the end of its useful life. To compute accelerated '+'depreciation (allowing higher depreciation values in the first years of '+'the assets life), use the syd-depreciation function'
|
|
SLNDepreciationFunctionName
|
'sln-depreciation'
|
|
SYDDepreciationComment
|
'SYD Depreciation (for "sum-of-years-digits '+'depreciation") returns depreciation amounts for an asset using an '+'accelerated depreciation method. This allows for higher depreciation in '+'the earlier years of an asset''s life. <cost-numeric-expression> is the '+'initial cost of the asset. <salvage-numeric-expression> is the value of '+'the asset at the end of its life expectancy. <life-integer-expression> is '+'the length of the asset''s life expectancy. <period-integer-expression> '+'is the period for which to calculate the depreciation'
|
|
SYDDepreciationFunctionName
|
'syd-depreciation'
|
