D076 Minny's Excel Functions
=FV(rate, nper, pmt, [pv], [type]) - Returns future value, or cash balance you want after last payment is made. =IRR(values,[guess]) - Returns internal rate of return of series of future payments. =NPER(RATE, PMT, PV, [FV], [type]) - Returns number of payments that will be made to pay an annuity =NPV(rate,value1,[value2],...) - Returns net Present Value of a series of future payments with given rates. Used when payments are uneven. =PMT(rate,nper,pv,[fv],[type]) - Returns payment amount made each period =PV(RATE, NPER, PMT, [FV], [type]) - Returns present value, or lump sum amount that a series of future payments is worth NOW.
Written for
- Institution
- D076 WGU
- Course
- D076 WGU
Document information
- Uploaded on
- February 7, 2024
- Number of pages
- 1
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
d076 minnys excel functions
Also available in package deal