| RATES OF RETURN |
| EFV |
Enhanced Future Value |
| EMDIETZ - 2008 |
Enhanced Modified Dietz 2008 only |
| ENPV |
Enhanced Net Present Value |
| ENPV_q |
Enhanced Net Present Value |
| ENPV - 2008 |
Enhanced Net Present Value 2008 only |
| EPV |
Enhanced Present Value |
| FV |
Future Value |
| FVGA |
Future Value of a Growing Annuity |
| FVSCHEDULE |
Future Value based on Compound Rates |
| IRR |
Internal Rate of Return |
| IRR_q |
Internal Rate of Return |
| IRR - 2008 |
Internal Rate of Return 2008 only |
| MDIETZ |
Modified Dietz |
| MDIETZ_q |
Modified Dietz |
| MIRR |
Modified Internal Rate of Return |
| MIRR_q |
Modified Internal Rate of Return |
| MIRR - 2008 |
Modified Internal Rate of Return 2008 only |
| NFV - 2008 |
Net Future Value 2008 only |
| NOMINAL |
Annual Nominal Interest Rate |
| NPER |
Number of Periods |
| NPERGA |
Number of Periods of a Growing Annuity |
| NPV |
Net Present Value |
| NPV_q |
Net Present Value |
| NPV - 2008 |
Net Present Value 2008 only |
| PMTGA |
Initial Payment of a Growing Annuity |
| PV |
Present Value |
| PVGA |
Present Value of a Growing Annuity |
| RATE |
Interest Rate of an Annuity |
| TWRR - 2008 |
Time Weighted Rate of Return 2008 only |
| XFV |
Future Value of a Cashflow between two dates |
| XIRR |
Internal Rate of Return with non-periodic cashflows |
| XIRR_q |
Internal Rate of Return with non-periodic cashflows |
| XIRR - 2008 |
Internal Rate of Return with non-periodic cashflows 2008 only |
| XMIRR - 2008 |
Modified Internal Rate of Return with non-periodic cashflows 2008 only |
| XNFV - 2008 |
Net Future Value for non-periodic cashflows 2008 only |
| XNPV |
Net Present Value for non-periodic cashflows |
| XNPV_q |
Net Present Value for non-periodic cashflows |
| XNPV - 2008 |
Net Present Value for non-periodic cashflows 2008 only |
| XPV |
Discounted Value of a Cashflow between two dates |
| |
|
| BOND FIGURATION |
| AIFACTOR new! |
Accrued Interest Factor |
| AIFACTOR_IAM new! |
Accrued Interest Factor, Interest at Maturity |
| AIFACTOR_OFC new! |
Accrued Interest Factor, Odd First Coupon |
| AIFACTOR_OLC new! |
Accrued Interest Factor, Odd Last Coupon |
| AIFACTOR_RPI new! |
Accrued Interest Factor, Regular Periodic Interest |
| ACCRINT |
Accrued Interest |
| ACCRINTM |
Accrued Interest at Maturity |
| BONDAMORT new! |
Amortization Schedule of a Bond |
| BONDINT |
Accrued Interest on a Bond |
| COUPDAYS |
Coupon Days |
| COUPDAYBS |
Coupon Days - beginning to settlement |
| COUPDAYSNC |
Coupon Days - settlement to next coupon |
| COUPNCD |
Coupon Days - next coupon date |
| COUPNUM |
Number of Coupon Days |
| COUPPCD |
Previous Coupon Date |
| DISC |
Discount Rate |
| DURATION |
Annual Duration of a Security |
| EDATE |
Maturity and Due dates |
| INTRATE |
Interest Rate of a Security |
| MDURATION |
Macauley Duration |
| ODDFINT |
Odd First Interest |
| ODDFPRICE |
Odd First Period Price |
| ODDFYIELD |
Odd First Period Yield |
| ODDLINT |
Odd Last Interest |
| ODDLPRICE |
Odd Last Period Price |
| ODDLYIELD |
Odd Last Period Yield |
| PRICE |
Price of a Security |
| PRICEDISC |
Price of a Discounted Security |
| PRICEMAT |
Price at Maturity |
| RECEIVED |
Amount Received at Maturity |
| TBILLEQ |
Bond Equivalent Yield of a Treasury Bill |
| TBILLPRICE |
Price of a Treasury Bill |
| TBILLYIELD |
Yield of a Treasury Bill |
| YIELD |
Yield of a Security |
| YIELDDISC |
Yield of a Discounted Security |
| YIELDMAT |
Yield with Interest at Maturity |
| |
|
| LOANS |
| AMORTRATE new! |
Constant daily effective rate for bond/loan amortization |
| AMORTSCHED |
Amortization Schedule of a loan |
| CUMIPMT |
Cumulative Interest paid |
| CUMLIPMT |
Cumulative Interest payments of a loan |
| CUMLPPMT |
Cumulative Principal payments of a loan |
| CUMPRINC |
Cumulative Principal paid |
| EFFECT |
Maturity and Due dates |
| IPMT |
Interest Payment based on Constant Rate |
| LIPMT |
Interest Payment of a loan |
| LPMT |
Periodic Payment of a loan |
| LPMTSCHED new! |
Generate Loan Amortization with ballon payment and other parameters |
| LPPMT |
Principal Payment of a loan |
| LRATE new! |
Interest rate for an annuity with an odd first period |
| NPD |
Next payment date of a loan |
| NPNO |
Next payment number of a loan |
| ODDPV new! |
Present value of an annuity with an odd first period |
| PMT |
Payment of an Annuity |
| PERIODRATE |
Adjust the nominal rate of a loan |
| PMTSCHED |
Payment Schedule of a loan |
| PPD |
Previous Payment date of a loan |
| PPMT |
Principal Payment |
| PPNO |
Previous Payment number of a loan |
| R78IPMT |
Interest Payment of a loan using Rule of 78 |
| R78PAYOFF |
Payment amount of a loan using Rule of 78 |
| R78PPMT |
Principal Payment of a loan using Rule of 78 |
| R78REBATE |
Rebate amount of a loan using Rule of 78 |
| TOTALINT |
Total interest amount of a loan |
| |
|
| DEPRECIATION |
| DB |
Declining Balance |
| DDB |
Double Declining Balance |
| SLN |
Straight Line Depreciation |
| SYD |
Sum-of-Year's-Digits Depreciation |
| VDB |
Depreciation using Declining Balance |
| |
|
| OTHER |
| BUSDAYS new! |
Calculate number of Business Days |
| BUSINESSDATE new! |
Calculate a Business Date from an offset |
| BUSINESSDATEWE new! |
Calculate a Business Date from an offset and specified weekend days |
| CALCDATE |
Convert MDY to date |
| DATEFLOAT |
Convert MDY to float |
| DATEINT |
Convert MDY to int |
| DAYS360 new! |
Calculate number of days using 30/360 day count conventions |
| DAYSNL new! |
Calculate number of days excluding Leap Years |
| DOLLARDE |
Dollar - fraction to Decimal |
| DOLLARFR |
Dollar - decimal to Fraction |
| EOMONTH |
Last Day of Month |
| NBD new! |
Convert a series of dates to flat csv string in YYYYMMDD format |
| YEARFRAC |
Fraction of Year |
| |
|
| |
|
| XLDB_FINANCIAL_VERSION |
Version Information |