| ACCRINT |
Accrued Interest |
| ACCRINTM |
Accrued Interest at Maturity |
| COUPDAYS |
Coupon Days |
| COUPDAYSBS |
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 |
| CUMIPMT |
Cumulative Interest paid |
| CUMPRINC |
Cumulative Principal paid |
| DB |
Declining Balance |
| DDB |
Double Declining Balance |
| DISC |
Discount Rate |
| DOLLARDE |
Dollar - fraction to Decimal |
| DOLLARFR |
Dollar - decimal to Fraction |
| DURATION |
Annual Duration of a Security |
| EDATE |
Maturity and Due dates |
| EFFECT |
Effective Annual Interest Rate |
| ENPV |
Enhanced Net Present Value |
| ENPV_q |
Enhanced Net Present Value |
| EOMONTH |
Last Day of Month |
| FV |
Future Value |
| FVSCHEDULE |
Future Value based on Compound Rates |
| INTRATE |
Interest Rate of a Security |
| IPMT |
Interest Payment based on Constant Rate |
| IRR |
Internal Rate of Return |
| IRR_q |
Internal Rate of Return |
| MDIETZ |
Modified Dietz [beta] |
| MDIETZ_q |
Modified Dietz [beta] |
| MDURATION |
Macauley Duration |
| MIRR |
Modified Internal Rate of Return |
| MIRR_q |
Modified Internal Rate of Return |
| NOMINAL |
Annual Nominal Interest Rate |
| NPER |
Number of Periods |
| NPV |
Net Present Value |
| NPV_q |
Net Present Value |
| ODDFPRICE |
Odd First Period Price |
| ODDFYIELD |
Odd First Period Yield |
| ODDLPRICE |
Odd Last Period Price |
| ODDLYIELD |
Odd Last Period Yield |
| PMT |
Payment of an Annuity |
| PPMT |
Prinicpal Payment |
| PRICE |
Price of a Security |
| PRICEDISC |
Price of a Discounted Security |
| PRICEMAT |
Price at Maturity |
| PV |
Present Value |
| RATE |
Interest Rate for an Annuity |
| RECEIVED |
Amount Received at Maturity |
| SLN |
Straight Line Depreciation |
| SYD |
Sum-of-Year's-Digits Depreciation |
| TBILLEQ |
Bond Equivalent Yield for a Treasury Bill |
| TBILLPRICE |
Price for a Treasury Bill |
| TBILLYIELD |
Yield for a Treasury Bill |
| VDB |
Depreciation using Declining Balance |
| XIRR |
Internal Rate of Return with non-periodic cashflows |
| XIRR_q |
Internal Rate of Return with non-periodic cashflows |
| XNPV |
Net Present Value for non-periodic cashflows |
| XNPV_q |
Net Present Value for non-periodic cashflows |
| YEARFRAC |
Fraction of Year |
| YIELD |
Yield of a Security |
| YIELDDISC |
Yield of a Discounted Security |
| YIELDMAT |
Yield with Interest at Maturity |
| XLDB_FINANCIAL_VERSION |
Version Information |