What-if 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 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.

Aug 15th, 2015

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 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).

Reference

PMT function. 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

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Aug 15th, 2015
...
Aug 15th, 2015
Dec 3rd, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer