Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - perform a WhatIf analysis

The video tutorial covers advanced Excel techniques for financial analysis, focusing on What-If Analysis tools like PMT formula, Goal Seek, and Scenario Manager. It guides learners through setting up scenarios for cost analysis and creating one and two variable data tables to calculate monthly loan payments under varying conditions.

What is the primary purpose of using the PMT function in What-If Analysis?

• To find the annual interest rate

• To calculate the total loan amount

• To determine the monthly loan payments

• To estimate the loan term in years

In the Scenario Manager, what is the main goal when setting up different scenarios for wedding venues?

• To find the most expensive venue

• To determine the venue with the best reviews

• To identify the most cost-effective venue

• To choose the venue with the largest capacity

When modifying the cost for Venue 2 in Scenario Manager, what is the new venue cost?

• $8,000

• $10,000

• $12,000

• $15,000

What is the key variable in a one-variable data table when analyzing loan payments?

• Loan amount

• Interest rate

• Loan term

• Monthly payment

In a one-variable data table, what is the primary calculation used to determine monthly payments?

• Interest rate multiplied by 12

• Loan term divided by 12

• Loan amount multiplied by 12

• Interest rate divided by 12

What are the two variables used in a two-variable data table for loan payment calculations?

• Interest rate and monthly payment

• Loan amount and loan term

• Interest rate and loan amount

• Loan term and monthly payment

In a two-variable data table, what is the row input cell typically used for?

• Interest rate

• Loan term

• Loan amount

• Monthly payment