Scribd
Upload
15 views

L04 Function List (With Descriptions)

Excel

Uploaded by

ntuliniongeziwe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
15 views

L04 Function List (With Descriptions)

Excel

Uploaded by

ntuliniongeziwe
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 2
iT eo Future Value (FV) =FV(RATE, NPER, PMT, PV) Present Value (PV) =PV(RATE, NPER, PMT, FV) Number of Interest Periods (NPER) =NPER(RATE, PMT, PV, FV) Payment (PMT) =PMT(RATE, NPER, PV, FV) Portion of Payment towards Principal =PPMT(RATE, PER, NPER, PV, FY) (PPMT) Portion of Payment as Interest (IPMT) =IPMT(RATE, PER, NPER, PV, FV) Preto reise RATE Interest rate per period (effective rate, not the nominal rate). PER Specifies a period and must be in the range 4 to NPER. NPER Total number of payment periods over the lifetime of the investment/loan PMT Size (amount) of the payment made each period. FV Future value—cash balance after last payment. PV Present value—the total amount that a series of future payments are worth now. ot erat) TODAY) Returns the current date. On 3 December 2014 that is the date that will be shawn in the cell; if the worksheet is opened on 10 January 2045, that is the date that will be shown =DATE(year, month, day) Converts the date given by the argument into a serial number, thatis, the number of days since 1 January 1900. =DAY(date) Extracts a day of a month (number) from a date. For example, if the date was the serial value representing 16 September 20114, the result would be 16. =MONTH(date) Extracts a month number from a date. For example, if the date was the serial value representing 4 July 2014, the result would be 7 July is the 7® month). =YEAR(date) Extracts a year (YYYY) from a date. For example, if the date was the serial value representing 6 October 2014, the result would be 2014. =EDATE(start_date, months) Calculates the date a specified number of months from the start date. Months can be negative to calculate a date before the start date. This does not work if you don’t know the exact number of months. Figure Date and Tim: nctions

You might also like