Financial Functions in Excel

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

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

View Full Document Right Arrow Icon
Financial Functions in Excel IRR Description: Returns the internal rate of return for a series of cash flows Syntax: =IRR(values) Example: 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 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:
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online