• # 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 ...

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