Whatif Analysis "Microcomputer Applications Discussion"
Computer Science

Tutor: None Selected  Time limit: 1 Day 
What role would the PMT function and the VLOOKUP function play in whatif analysis? Include in your answer an explanation of what whatif analysis and how those functions fit in with it. If you don't think these functions are really suited to whatif 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:
1. Rate
2. Number of payments
3. Present value of the loan
to see the effect on repayment amounts.
VLookup
VLookup function is an excel function that
is used in ifwhat 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).
Reference
PMT function. Retrieved from https://support.office.com/.../PMTfunction0214da649a634996bc20
VLookup fuction. Retrieved from https://support.office.com/enin/article/VLOOKUPfunction0bbc808326fe49638ab893a18ad188a1
Please let me know if you need any clarification. I'm always happy to answer your questions.
Secure Information
Content will be erased after question is completed.