Excel for Personal Financial Decisions
PV and FV
Excel has several financial functions:
A) The PV (Present Value) function calculates the total present (current) value of an investment with a fixed rate, specified number of payment periods, and a series of identical payments that will be made in the future.
B) The FV (Future Values) function calculates the future value of an investment, given a fixed interest rate, term, and identical periodic payments.
C) The NPV (Net Present Value) function calculates the net present value of an investment, given a fixed rate (rate of return) and future payments that may be identical or different.
Internal Rate of Return (IRR)
This returns the internal rate of return for a series of cash flows ...
Get MS Excel, Second Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
