User:Sqltool/financialfunctionsedittest
[[ http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ACCRINT/Default.aspx | ACCRINT ]]
>Accrued Interest<
>Accrued Interest at Maturity
[[ http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/COUPDAYS/Default.aspx" | COUPDAYS]]
>Coupon Days<
href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/COUPDAYSBS/Default.aspx">COUPDAYSBS</a><o:p></o:p>
Coupon Days - beginning to settlement<o:p></o:p>
<a COUPDAYSNC >Coupon Days - settlement to next coupon< href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/COUPNCD/Default.aspx">COUPNCD</a><o:p></o:p>
Coupon Days - next coupon date<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/COUPNUM/Default.aspx">COUPNUM</a><o:p></o:p>
Number of Coupon Days<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/COUPPCD/Default.aspx">COUPPCD</a><o:p></o:p>
Previous Coupon Date<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/CUMIPMT/Default.aspx">CUMIPMT</a><o:p></o:p>
Cumulative Interest paid<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/CUMPRINC/Default.aspx">CUMPRINC</a><o:p></o:p>
Cumulative Principal paid<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DB/Default.aspx">DB</a><o:p></o:p>
Declining Balance<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DDB/Default.aspx">DDB</a><o:p></o:p>
Double Declining Balance<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DISC/Default.aspx">DISC</a><o:p></o:p>
Discount Rate<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DOLLARDE/Default.aspx">DOLLARDE</a><o:p></o:p>
Dollar - fraction to Decimal<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DOLLARFR/Default.aspx">DOLLARFR</a><o:p></o:p>
Dollar - decimal to Fraction<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/DURATION/Default.aspx">DURATION</a><o:p></o:p>
Annual Duration of a Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/EDATE/Default.aspx">EDATE</a><o:p></o:p>
Maturity abd Due dates<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/EFFECT/Default.aspx">EFFECT</a><o:p></o:p>
Effective Annual Interest Rate<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ENPV/Default.aspx">ENPV</a><o:p></o:p>
Enhanced Net Present Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ENPV_q/Default.aspx">ENPV_q</a><o:p></o:p>
Enhanced Net Present Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/EOMONTH/Default.aspx">EOMONTH</a><o:p></o:p>
Last Day of Month<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/FV/Default.aspx">FV</a><o:p></o:p>
Future Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/FVSCHEDULE/Default.aspx">FVSCHEDULE</a><o:p></o:p>
Future Value based on Compound Rates<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/INTRATE/Default.aspx">INTRATE</a><o:p></o:p>
Interest Rate of a Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/IPMT/Default.aspx">IPMT</a><o:p></o:p>
Interest Payment based on Constant Rate<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/IRR/Default.aspx">IRR</a><o:p></o:p>
Internal Rate of Return<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/IRR_q/Default.aspx">IRR_q</a><o:p></o:p>
Internal Rate of Return<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/MDURATION/Default.aspx">MDURATION</a><o:p></o:p>
Macauley Duration<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/MIRR/Default.aspx">MIRR</a><o:p></o:p>
Modified Internal Rate of Return<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/MIRR_q/Default.aspx">MIRR_q</a><o:p></o:p>
Modified Internal Rate of Return<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/NOMINAL/Default.aspx">NOMINAL</a><o:p></o:p>
Annual Nominal Interest Rate<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/NPER/Default.aspx">NPER</a><o:p></o:p>
Number of Periods<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/NPV/Default.aspx">NPV</a><o:p></o:p>
Net Present Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/NPV_q/Default.aspx">NPV_q</a><o:p></o:p>
Net Present Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ODDFPRICE/Default.aspx">ODDFPRICE</a><o:p></o:p>
Odd First Period Price<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ODDFYIELD/Default.aspx">ODDFYIELD</a><o:p></o:p>
Odd First Period Yield<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ODDLPRICE/Default.aspx">ODDLPRICE</a><o:p></o:p>
Odd Last Period Price<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ODDLYIELD/Default.aspx">ODDLYIELD</a><o:p></o:p>
Odd Last Period Yield<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PMT/Default.aspx">PMT</a><o:p></o:p>
Payment of an Annuity<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PPMT/Default.aspx">PPMT</a><o:p></o:p>
Prinicpal Payment<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PRICE/Default.aspx">PRICE</a><o:p></o:p>
Price of a Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PRICEDISC/Default.aspx">PRICEDISC</a><o:p></o:p>
Price of a Discounted Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PRICEMAT/Default.aspx">PRICEMAT</a><o:p></o:p>
Price at Maturity<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/PV/Default.aspx">PV</a><o:p></o:p>
Present Value<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/RATE/Default.aspx">RATE</a><o:p></o:p>
Interest Rate for an Annuity<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/RECEIVED/Default.aspx">RECEIVED</a><o:p></o:p>
Amount Received at Maturity<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/SLN/Default.aspx">SLN</a><o:p></o:p>
Straight Line Depreciation<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/SYD/Default.aspx">SYD</a><o:p></o:p>
Sum-of-Year's-Digits Depreciation<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/TBILLEQ/Default.aspx">TBILLEQ</a><o:p></o:p>
Bond Equivalent Yield for a Treasury Bill<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/TBILLPRICE/Default.aspx">TBILLPRICE</a><o:p></o:p>
Price for a Treasury Bill<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/TBILLYIELD/Default.aspx">TBILLYIELD</a><o:p></o:p>
Yield for a Treasury Bill<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/VDB/Default.aspx">VDB</a><o:p></o:p>
Depreciation using Declining Balance<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XIRR/Default.aspx">XIRR</a><o:p></o:p>
Internal Rate of Return with non-periodic cashflows<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XIRR_q/Default.aspx">XIRR_q</a><o:p></o:p>
Internal Rate of Return with non-periodic cashflows<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XNPV/Default.aspx">XNPV</a><o:p></o:p>
Net Present Value for non-periodic cashflows<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XNPV_q/Default.aspx">XNPV_q</a><o:p></o:p>
Net Present Value for non-periodic cashflows<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/YEARFRAC/Default.aspx">YEARFRAC</a><o:p></o:p>
Fraction of Year<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/YIELD/Default.aspx">YIELD</a><o:p></o:p>
Yield of a Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/YIELDDISC/Default.aspx">YIELDDISC</a><o:p></o:p>
Yield of a Discounted Security<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/YIELDMAT/Default.aspx">YIELDMAT</a><o:p></o:p>
Yield with Interest at Maturity<o:p></o:p>
<a href="http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/XLDB_FINANCIAL_VERSION/Default.aspx">XLDB_FINANCIAL_VERSION</a><o:p></o:p>
Version Information<o:p></o:p>
<o:p> </o:p>
</body>
</html>