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: OTIMEVALUE (time_text) O NPV(rate, value1, [value2]...) ONPER (rate, pmt, pv, [fv], [type]) LOOKUP(look_value, lookup_vector, [result_vector]) Which of the arguments in the function to solve for number of periods are relevant and required? Check all that apply. U pmt U look_value rate O time_text Applying the functions to derive desired values Suppose you get a job offer from one of your dream companies and they are paying you within the range you would want your salary to be. Lets take this amount to be $45,000 per year. You are confident that working in this company would help you grow and charter a career path that you would like Suppose you get a job offer from one of your dream companies and they are paying you within the range you would want your salary to be. Lets take this amount to be $45,000 per year. You are confident that working in this company would help you grow and charter a career path that you would like to pursue. You are curious to know that if your salary increases at the rate of 9.0% per year, how many years would it take to double your salary? B D 1 2 Salary $45,000 3 Growth rate 9.0% 4 Future salary 5 Calculate number of years N 6 In addition to your dream job, suppose you also took up freelance work which helped you earn an additional $7,000 per year. How many years would it now take you to reach to the salary level you desire to earn? B D 7 Same data as above 8 Additional income per year $7,000 9 Number of years with additional income N 10 Grade It Now Save & Continue Continue without saving