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).
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.
Content will be erased after question is completed.