User:Sqltool/financialfunctionsedittest

[[ http://www.westclintech.com/Documentation/XLeratorDBfinancialDocumentation/tabid/64/topic/ACCRINT/Default.aspx | ACCRINT ]]

>Accrued Interest<

ACCRINTM

>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>