{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Financial Functions in Excel

# Financial Functions in Excel - Financial Functions in Excel...

This preview shows pages 1–4. Sign up to view the full content.

Financial Functions in Excel IRR Description: Returns the internal rate of return for a series of cash flows Syntax: =IRR(values) Example: 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
NPV Description: Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values). Syntax: =NPV(rate, value1) Rate: is the rate of discount over the length of one period. Value1: is 1 to 29 payments and income, equally spaced in time and occurring at the end of each period. Example: 2
PMT Description: Calculates the payment for a loan based on constant payments and a constant interest rate. Syntax: =PMT(rate, nper, pv, fv, type) Rate: is the interest rate per period for the loan. For example, use 6%/4 for quarterly payments at 6% APR Nper: is the total # of payments for the loan Pv: is the present value, the total amount that a series of future payments is worth now. Fv:

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

Financial Functions in Excel - Financial Functions in Excel...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online