Question: The syntax of the Excel function that returns the number of periods for an investment based on a periodic, constant payments at a certain rate
The syntax of the Excel function that returns the number of periods for an investment based on a periodic, constant payments at a certain rate of interest is:
NPER rate pmt pvfvtype
LOOKUPlookvalue, lookupvector, resultvector
TIMEVALUE timetext
NPVrate valuevalue
Which of the arguments in the function to solve for number of periods are relevant and required?
Check all that apply.
timetext
rate
pmt
value
pv
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
