What is IPMT function in Excel? IPMT function is one of the Financial functions in Microsoft Excel that returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. Syntax of IPMT function IPMT(rate, per, nper, pv, [fv], [type]) The IPMT function syntax has the following …
What is FVSCHEDULE function in Excel? FVSCHEDULE function is one of the Financial functions in Microsoft Excel that returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate. Syntax of FVSCHEDULE function FVSCHEDULE(principal, schedule) …
What is INTRATE function in Excel? INTRATE function is one of the Financial functions in Microsoft Excel that returns the interest rate for a fully invested security. Syntax of INTRATE function INTRATE(settlement, maturity, investment, redemption, [basis]) The INTRATE function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is the date …
What is IRR function in Excel? IRR function is one of the Financial functions in Microsoft Excel that returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash …
What is ISPMT function in Excel? ISPMT function is one of the Financial functions in Microsoft Excel that calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. Syntax of ISPMT function ISPMT(rate, per, nper, pv) The ISPMT function syntax has the following arguments: Argument Description Rate …
What is MDURATION function in Excel? MDURATION function is one of the Financial functions in Microsoft Excel that returns the modified Macauley duration for a security with an assumed par value of $100. Syntax of MDURATION function MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) The MDURATION function syntax has the following arguments: Settlement: The security’s settlement date. …
What is MIRR function in Excel? MIRR function is one of the Financial functions in Microsoft Excel that returns the modified internal rate of return for a series of periodic cash flows. MIRR considers both the cost of the investment and the interest received on reinvestment of cash. Syntax of MIRR function MIRR(values, finance_rate, reinvest_rate) The …
What is NPER function in Excel? NPER function is one of the Financial functions in Microsoft Excel that returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. Syntax of NPER function NPER(rate,pmt,pv,[fv],[type]) The NPER function syntax has the following arguments: Rate: The interest rate per period. Pmt: …
What is NPV function in Excel? NPV function is one of the Financial functions in Microsoft Excel that calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Syntax of NPV function NPV(rate,value1,[value2],…) The NPV function syntax has the following arguments: …
What is ODDFPRICE function in Excel? ODDFPRICE function is one of the Financial functions in Microsoft Excel that returns the price per $100 face value of a security having an odd (short or long) first period. Syntax of ODDFPRICE function ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) The ODDFPRICE function syntax has the following …
What is NOMINAL function in Excel? NOMINAL function is one of the Financial functions in Microsoft Excel that returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. Syntax of NOMINAL function NOMINAL(effect_rate, npery) The NOMINAL function syntax has the following arguments: Effect_rate: The effective interest rate. Npery: …
What is ODDFYIELD function in Excel? ODDFYIELD function is one of the Financial functions in Microsoft Excel that returns the yield of a security that has an odd (short or long) first period. Syntax of ODDFYIELD function ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) The ODDFYIELD function syntax has the following arguments: Settlement: The …
What is ODDLPRICE function in Excel? ODDLPRICE function is one of the Financial functions in Microsoft Excel that returns the price per $100 face value of a security having an odd (short or long) last coupon period. Syntax of ODDLPRICE function ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) The ODDLPRICE function syntax has the following …
What is ODDLYIELD function in Excel? ODDLYIELD function is one of the Financial functions in Microsoft Excel that returns the yield of a security that has an odd (short or long) last period. Syntax of ODDLYIELD function ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) The ODDLYIELD function syntax has the following arguments: Settlement: The security’s …
What is DISC function in Excel? DISC function is one of the Financial functions in Microsoft Excel that returns the discount rate for a security. Syntax of DISC function DISC(settlement, maturity, pr, redemption, [basis]) The DISC function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is the date after the …
What is PPMT function in Excel? PPMT function is one of the Financial functions in Microsoft Excel that returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. Syntax of PPMT function PPMT(rate, per, nper, pv, [fv], [type]) The PPMT function syntax has …
What is PRICE function in Excel? PRICE function is one of the Financial functions in Microsoft Excel that returns the price per $100 face value of a security that pays periodic interest. Syntax of PRICE function PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) The PRICE function syntax has the following arguments: Settlement: The security’s settlement date. …
What is PMT function in Excel? PMT function is one of the Financial functions in Microsoft Excel that calculates the payment for a loan based on constant payments and a constant interest rate.Use the Excel Formula Coach to figure out a monthly loan payment. At the same time, you’ll learn how to use the PMT function in a …
What is PRICEDISC function in Excel? PRICEDISC function is one of Financial functions in Microsoft Excel that returns the price per $100 face value of a discounted security. Syntax of PRICEDISC function PRICEDISC(settlement, maturity, discount, redemption, [basis]) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, …
What is PRICEMAT function in Excel? PRICEMAT function is one of Financial functions in Microsoft Excel that returns the price per $100 face value of a security that pays interest at maturity. Syntax of PRICEMAT function PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) Important: Dates should be entered by using the DATE function, or as results of other …
What is PV function in Excel? PV function is one of the Financial functions in Microsoft Excel that calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s …
What is RATE function in Excel? RATE function is one of Financial functions in Microsoft Excel that returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns …
What is RRI function in Excel? RRI function is one of the Financial functions in Microsoft Excel that returns an equivalent interest rate for the growth of an investment. Syntax of RRI function RRI(nper, pv, fv) The RRI function syntax has the following arguments. Nper Required. Nper is the number of periods for the investment. Pv …
What is RECEIVED function in Excel? RECEIVED function is one of Financial functions in Microsoft Excel that returns the amount received at maturity for a fully invested security. Syntax of RECEIVED function RECEIVED(settlement, maturity, investment, discount, [basis]) The RECEIVED function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is the …
What is SLN function in Excel? SLN function is one of Financial functions in Microsoft Excel that returns the straight-line depreciation of an asset for one period. Syntax of SLN function SLN(cost, salvage, life) The SLN function syntax has the following arguments: Cost: The initial cost of the asset. Salvage: The value at the end of …
What is SYD function in Excel? SYD function is one of Financial functions in Microsoft Excel that returns the sum-of-years’ digits depreciation of an asset for a specified period. Syntax of SYD function SYD(cost, salvage, life, per) The SYD function syntax has the following arguments: Cost: The initial cost of the asset. Salvage: The value at …
What is TBILLEQ function in Excel? TBILLEQ function is one of Financial functions in Microsoft Excel that returns the bond-equivalent yield for a Treasury bill. Syntax of TBILLEQ function TBILLEQ(settlement, maturity, discount) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd …
What is VDB function in Excel? VDB function is one of Financial functions in Microsoft Excel that returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance. Syntax of VDB function VDB(cost, salvage, life, start_period, …
What is XIRR function in Excel? XIRR function is one of Financial functions in Microsoft Excel that returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the IRR function. Syntax of XIRR function …
What is XNPV function in Excel? XNPV function is one of Financial functions in Microsoft Excel that returns the net present value for a schedule of cash flows that is not necessarily periodic. To calculate the net present value for a series of cash flows that is periodic, use the NPV function. Syntax of XNPV function …
What is YIELD function in Excel? YIELD function is one of Financial functions in Microsoft Excel that returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. Syntax of YIELD function YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) Important: Dates should be entered by using the DATE function, or as results …
What is YIELDDISC function in Excel? YIELDDISC function is one of Financial functions in Microsoft Excel that returns the annual yield for a discounted security. Syntax of YIELDDISC function YIELDDISC(settlement, maturity, pr, redemption, [basis]) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for …
What is PDURATION function in Excel? PDURATION function is one of the Financial functions in Microsoft Excel that returns the number of periods required by an investment to reach a specified value. Syntax of PDURATION function PDURATION(rate, pv, fv) The PDURATION function syntax has the following arguments. Rate: Rate is the interest rate per period. Pv: …
What is TBILLYIELD function in Excel? TBILLYIELD function is one of the Financial functions in Microsoft Excel that returns the yield for a Treasury bill. Syntax of TBILLYIELD function TBILLYIELD(settlement, maturity, pr) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd …
What is TBILLPRICE function in Excel? REPT function is one of Financial functions in Microsoft Excel that returns the price per $100 face value for a Treasury bill. Syntax of TBILLPRICE function TBILLPRICE(settlement, maturity, discount) The TBILLPRICE function syntax has the following arguments: Settlement: The Treasury bill’s settlement date. The security settlement date is the date after …
What is BAHTTEXT function in Excel? BAHTTEXT function is one of TEXT functions in Microsoft Excel that converts a number to Thai text and adds a suffix of “Baht.” You can change the Baht format to a different style in the Excel desktop application by using Regional and Language Options (Windows Start menu, Control Panel). Syntax of BAHTTEXT function BAHTTEXT(number) The …
What is ASC function in Excel? ASC function is one of TEXT functions in Microsoft Excel that changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax of ASC function ASC(text) The ASC function syntax has the following arguments: Text Required. The text or a reference to a cell that contains the text you want to change. If …
What is CLEAN function in Excel? CLEAN function is one of TEXT functions in Microsoft Excel that removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that …
What is CODE function in Excel? CODE function is one of TEXT functions in Microsoft Excel that returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. Operating environment Character set Macintosh Macintosh character set Windows ANSI Syntax of CODE function CODE(text) …
What is CONCAT function in Excel? CONCAT function is one of TEXT functions in Microsoft Excel that combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments. Tip: To include delimiters (such as spacing or ampersands (&) between the texts you want to combine and to remove empty arguments …