.

The syntax of the Excel function that reburns the number of periads for an investment based on a periadic, constant payments at a certain rabe of interest Which of the arguments in the function to solve for number of periads are relevantand required? Check all that apply is: time text O TIMEVALUE (time_text) O NPER (rate, pmt, pv, [fv], [type]) O NPV(rate, value1, [value2]...) O LOOKUP(look_value, lookup_vector, result_vector]) type rate ing the functions to derive desired values Suppose yoget a job offer from one of your dream com panies 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 com pany would help you grow and charter a career path that you would like you pursue. You are curious to know that is your salary increases at the rate of9.0% per year, how many years would it take to double your salary? 2 Salary $45,000 3 Growth rate 9.0% 4 Future salary Caculate number of years In addition to your dream job, suppose you also took up freelance work which helped you eam an additional $7,000 would it now take you to reach to the salary level you desire to eam? per year. How many years 7 Same data as above 8 Additional income per year $7,000 ber of years with additional