Search results
Results From The WOW.Com Content Network
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 NPV(rate,value1,[value2],...)
NPV determines whether a project earns more or less than a desired rate of return (also called the hurdle rate) and is good at finding out whether a project is going to be profitable. IRR goes one step further than NPV to determine a specific rate of return for a project.
XNPV (rate, values, dates) The XNPV function syntax has the following arguments: Rate Required. The discount rate to apply to the cash flows. Values Required. A series of cash flows that corresponds to a schedule of payments in dates.
Description. Returns the price per $100 face value for a Treasury bill. Syntax. TBILLPRICE (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 day of May, 2008. Problems can occur if dates are entered as text.
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. ODDFPRICE function. Returns the price per $100 face value of a security with an odd first period. ODDFYIELD function.
Returns the discount rate for a security. Syntax. DISC(settlement, maturity, pr, redemption, [basis])
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 NPV(rate,value1,[value2],...)
Returns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate. Syntax. NPV(rate, values ()) The NPV function syntax has these arguments:
Returns the interest rate for a fully invested security. Syntax. INTRATE(settlement, maturity, investment, redemption, [basis])
Syntax. 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 day of May, 2008. Problems can occur if dates are entered as text.
FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. Use the Excel Formula Coach to find the future value of a series of payments.