Excel 2007 Tutorial: What If Analysis

http://www.GCFLearnFree.org

The real power in Excel comes in its ability to perform multiple mathematical calculations for you. One of the tools in Excel that you can use to perform these calculations is a Data tool called What-If Analysis. What-If analysis allows you to see the effect that different values have in formulas. Have you ever thought, "What interest rate do I need to qualify for to have a car payment of $400 on the car I want?" This question can be answered using What-If Analysis.

In this lesson, you will learn how to use a What-If Analysis tool called Goal Seek.

You need a loan to buy a new car. You know how much money you want to borrow, how long of a period you want to take to pay off the loan (the term), and what payment you can afford to make each month. But what you need to know is what interest rate you need to qualify for to make the payment $400 a month. In the image below, you can see that if you didn't have interest and just divided this $20,000 into 60 monthly payments, you would pay $333.33 a month. The What-If Analysis tool will allow you to easily calculate the interest rate.

Category:

Education

Tags:

• Microsoft Excel
• MS Excel
• tutorials
• spreadsheet
• workbooks
• Excel
• formulas
• how to
• Excel 2007
• computer help
• video tutorials
• Excel tutorials
• Office 2007
• What If Analysis

[MovieCriticAko]

I tried this but it doesn't work for me, I also tried the PMT formula and it isn't the same like what is shown in this video.. what does this means =PMT(B4/12,B2,B3)?

[milanista3ksa]

this is cool , i really like it ! thanks