Financial
YIELDMAT
Calculates the annual yield for a bond that pays interest on maturity. Syntax YIELDMAT(settlement; maturity; issue_date; rate; price; [basis]) settlement: Date of purchase of the security. Eg., "5/1/2017" maturity: Date on which the security ...YIELDDISC
Calculates the annual yield for a non-interest paying discounted bond. Syntax YIELDDISC(settlement; maturity; price; redemption_value; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security ...YIELD
Calculates the annual yield for a security with periodic interest. Syntax YIELD(settlement; maturity; rate; price; redemption_value; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the ...XNPV
Returns the net present value of an investment with irregular cash payments. Syntax XNPV(rate; payments; dates) rate: The annual interest rate. Eg., 2.3% payments: The range or array containing payments made. Positive if received, negative if paid. ...XIRR
Calculates the internal rate of return for a series of irregular cash flows. Syntax XIRR(payments; dates; [guess]) payment: The range containing the payments made or received, at irregular intervals. Eg., B2:B5 dates: The range containing dates ...VDB
Returns the depreciation of an asset for a given period using the variable declining-balance method. Syntax VDB(original_cost; salvage_value; lifetime; period_start; period_end; [factor]; [straight_line]) original_cost: The initial cost of the ...TBILLYIELD
Returns the yield for a US Treasury bill based on a given price. Syntax TBILLYIELD(settlement; maturity; issue_price) settlement: Date of purchase of the Treasury bill. Eg., "2/1/2018" maturity: Date on which the Treasury bill matures. Eg., ...TBILLPRICE
Returns the price per $100 par value for a US Treasury bill, for a given discount rate. Syntax TBILLPRICE(settlement; maturity; discount_rate) settlement: Date of purchase of the Treasury bill. Eg., "2/1/2018" maturity: Date on which the Treasury ...TBILLEQ
Returns the equivalent annual return rate for a US Treasury bill for a given discount rate. Syntax TBILLEQ(settlement; maturity; discount_rate) settlement: Date of purchase of the Treasury bill. Eg., "2/1/2018" maturity: Date on which the ...SYD
Returns the depreciation of an asset for a given period using the sum-of-years' digits method. Syntax SYD(original_cost; salvage_value; lifetime; year) original_cost: The initial cost of the asset. Eg., 50000 salvage_value: Value at the end of ...SLN
Calculates the depreciation of an asset for a single period using the straight-line depreciation method. Syntax SLN(original_cost; salvage_value; lifetime) original_cost: The initial cost of the asset. Eg., 50000 salvage_value: Value at the end ...RRI
Returns the interest rate required for an investment to reach a value in a given period. Syntax RRI(nper; pv; fv) nper: The number of periods in the term. Eg., 12 pv: The value at the start of the term. Eg., 10000 fv: The value at the end of the ...RECEIVED
Calculates the amount received at maturity that is paid for a fixed-interest security for a given time. Syntax RECEIVED(settlement; maturity; purchase_value; discount_rate; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" ...RATE
Calculates the interest rate of an annuity with constant periodic payments and constant interest rate. Syntax RATE(nper; pmt; pv; [fv]; [type]; [guess]) nper: The total number of payment periods in the term. Eg., 12 pmt: The payment made per ...PV
Returns the present value of an annuity investment with constant periodic payments and constant interest rate. Syntax PV(rate; nper; [pmt]; [fv]; [type]) rate: The interest rate per period. Eg., 0.2 nper: The total number of payment periods in ...PRICEMAT
Calculates the price per 100 currency units of the security that pays interest at maturity. Syntax PRICEMAT(settlement; maturity; issue_date; rate; yield; [basis]) settlement: The date of purchase of the security. Eg., "4/1/2018" maturity: Date ...PRICEDISC
Calculates the price per 100 currency units of face value for a discounted security. Syntax PRICEDISC(settlement; maturity; discount; redemption_value; [basis]) settlement: The date of purchase of the security. Eg., "2/1/19" maturity: Date on ...PRICE
Returns the price per 100 currency units of a security with periodic interest. Syntax PRICE(settlement; maturity; rate; yield; redemption_value; frequency; [basis]) settlement: The date of purchase of the security. Eg., "2/1/2018" maturity: Date ...PPMT
Returns the payment on a principal for an investment with constant periodic payments and constant interest rate, for a given period of time. Syntax PPMT(rate; period; nper; pv; [fv]; [type]) rate: The interest rate per period. Eg., 4% period: The ...PMT
Returns the payment per period for a constant period payment and constant interest rate. Syntax PMT(rate; nper; pv; [fv]; [type]) rate: The interest rate per period. Eg., 4% nper: The total number of payment periods in the given term. Eg., 3 pv: ...ODDLYIELD
Returns the yield of a security having an odd or irregular last period. Syntax ODDLYIELD(settlement; maturity; last_interest_date; rate; price; redemption_value; frequency; [basis]) settlement: The date of purchase of the security. Eg., ...ODDLPRICE
Returns the price per 100 currency units of the security having an odd or irregular last period. Syntax ODDLPRICE(settlement; maturity; last_interest_date; rate; yield; redemption_value; frequency; [basis]) settlement: The date of purchase of the ...ODDFYIELD
Returns the yield of a security with an odd or irregular first period. Syntax ODDFYIELD(settlement; maturity; issue_date; first_interest_date; rate; price; redemption_value; frequency; [basis]) settlement: The date of purchase of the security. ...ODDFPRICE
Returns the price per 100 currency units of a security having an odd or irregular first period. Syntax ODDFPRICE(settlement; maturity; issue_date; first_interest_date; rate; yield; redemption_value; frequency; [basis]) settlement: The date of ...NPV
Returns the net present value of an investment with a series of varying periodic cash payments and a discount rate. Syntax NPV(discount_rate; payment; [payment1]; ...) discount_rate: Discount rate of the investment over a period. Eg., 2.3% ...NPER
Calculates the number of periods for an investment based on constant periodic payments and constant interest rate. Syntax NPER(rate; pmt; pv; [fv]; [type]) rate: The constant interest rate per period. Eg., 0.2 pmt: The payment made each period. ...NOMINAL
Returns the annual nominal interest rate, given the effective rate and the number of compounding periods per year. Syntax NOMINAL(eff_rate; num) eff_rate: The effective interest rate. Eg., 2.34% num: Number of compounding periods per year. Eg., 4 ...MIRR
Returns the modified internal rate of return for a series of periodic cash flows. Considers both the investment cost and interest during reinvestment. Syntax MIRR(payments; finance_rate; reinvest_rate) payments: An array or range containing the ...MDURATION
Returns the modified Macaulay duration of a given security. Syntax MDURATION(settlement; maturity; rate; yield; frequency; [basis]) settlement: Date of purchase of the security. Eg., "2/1/2018" maturity: Date on which the security matures. Eg., ...ISPMT
Returns the interest paid for a given period on an investment or loan with fixed rate. Syntax ISPMT(rate; period; nper; pv) rate: Periodic interest rate. Eg., 15 period: Period used to calculate the interest. Eg., 2 nper: Total number of payment ...IRR
Calculates the internal rate of return for a series of periodic cash flows that occur at regular intervals. Syntax IRR(payments; [guess]) payments: The range containing the payments made or received, at regular intervals. Eg., B2:B4 guess: The ...IPMT
Returns the interest payment for a given period for an investment with constant periodic payments and a fixed interest rate. Syntax IPMT(rate; period; nper; pv; [fv]; [type]) rate: The interest rate per period. Eg., 0.5 period:The period that you ...INTRATE
Returns the equivalent annual interest rate for an investment bought at one price and sold at another. Syntax INTRATE(settlement; maturity; purchase_value; maturity_value; [basis]) settlement: The date the item was bought. Eg., "2/1/2018" ...FVSCHEDULE
Returns the future value of an investment with a series of varying interest rates. Syntax FVSCHEDULE(principal; interest_rates) principal: The initial sum of investment. Eg., 50000 interest_rates: A range or an array containing a schedule of ...FV
Returns the future value of an investment with constant interest rate and periodic payments. Syntax FV(rate; nper; pmt; [pv]; [type]) rate: The fixed interest rate per period. Eg., 0.06 nper: The total number of payment periods in the term. Eg., ...EFFECT
Returns the annual effective interest rate given a nominal interest rate and the number of compounding periods per year. Syntax EFFECT(nom_rate; num) nom_rate: Nominal interest rate. Eg., 4% num: Number of compounding periods per year. Eg., 6 ...DURATION
Returns the Macaulay duration, i.e., the weighted average duration for maturity of cash flows from a bond of a security. Syntax DURATION(settlement; maturity; rate; yield; frequency; [basis]) settlement: Settlement (purchase) date of the bond. ...PDURATION
Returns the number of periods needed for an investment to reach a certain value, at a specified interest rate. Syntax PDURATION(rate; present_value; future_value) rate: Interest rate per period that will apply to the investment. Eg., 12.3 ...DOLLARFR
Converts a given dollar decimal number into its fractional representation. Syntax DOLLARFR(decimal; denominator) decimal: The decimal number to convert. Eg., 2.34 denominator: The denominator for the fractional representatio n. Eg., 20 Examples ...DOLLARDE
Converts a dollar price given as a fractional number into a decimal number Syntax DOLLARDE(fractional_rep; denominator) fractional_rep: The fractional representation. Eg., 2.34 denominator: The denominator in the given fractional representation. ...Next page
Access your files securely from anywhere
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?