What role would the PMT function and the VLOOKUP function play in what-if analysis? Include in your answer an explanation of what what-if analysis and how those functions fit in with it. If you don't think these functions are really suited to what-if analysis, explain why.
Thank you for the opportunity to help you with your question!
PMT function is a tool in What if analysis which is
used to calculate repayments in a loan
based on a stable rate of interest. Therefore we
can change the values of input fields for example:
2. Number of payments
3. Present value of the loan
to see the effect on repayment amounts.
VLookup function is an excel function that
is used in if-what analysis to change values of more than one variables. VLOOKUP, is used when you need to locate things in a
table or a range by row. For instance, look up an employee's last name by her
employee number, or locate her phone number by looking up her last name (just
like a telephone book).The role of VLOOKUP is to arrange your data so
that the value you look up (employee’s last name) is to the left of the return
value you want to locate (employee’s phone number).
Retrieved from https://support.office.com/.../PMT-function-0214da64-9a63-4996-bc20
VLookup fuction. Retrieved from https://support.office.com/en-in/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Please let me know if you need any clarification. I'm always happy to answer your questions.
Aug 15th, 2015
Did you know? You can earn $20 for every friend you invite to Studypool!