Name |
Description |
Syntax |
|---|---|---|
Returns the internal rate of return on an investment based on a series of periodic cash flows |
IRR(cashflow_amounts, [rate_guess]) |
|
Returns the last coupon payment date |
COUPPCD(settlement, maturity, frequency, [calculation_method]) |
|
Returns the periodic payment amount for a loan or investment based on a constant interest rate per period and unchanging payment amounts |
PMT(rate, number_of_payments, present_value, [future_value], [end_or_beginning]) |
|
Returns the present value of a loan or investment based on a constant interest rate per period and unchanging payment amounts |
PV(rate, number_of_payments, payment_amount, [future_value], [end_or_beginning]) |
|
Returns the fractional price as a decimal number |
DOLLARDE(fractional_price, unit) |
|
Returns a decimal number as a fractional price |
DOLLARFR(decimal_price, unit) |
|
Calculates the net present value of an investment for irregular cash flows |
XNPV(discount, cashflow_amounts, dates) |
|
Returns the net present value of an investment for regular cash flows |
NPV(discount, cashflow1, [cashflow2, ...]) |