How To Perform Goal Seek Analysis In Excel For Mac


show more Performing Goal Seek analysis provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Performing Goal Seek analysis

When you create a formula in Excel, it's easy to ask questions such as, how much is 15% of 200. It's much more difficult to ask a question such as, how much can my business borrow and have a monthly payment of $125,000 or less. Rather than create a complex formula, you can use the Goal Seek feature to find answers to that type of question quickly. In this worksheet, I have information about a loan, the term, interest rate, and monthly payments, and also, I have my target payment of $125,000.

So as these things stand, my loan amount, term of paying off over 10 years, and interest rate of 5.75% will result in a monthly payment of over $164,000. I want to get that payment to $225,000 or less, and the only way that I can do that, at least for the purposes of this exercise, is to change my loan amount. If I want to find out how much you can borrow on these terms and end up with the target payment of $125,000, I can use what's called Goal Seek. To work with Goal Seek, I can go to ...

Performing Goal Seek analysis
Video duration: 2m 31s 6h 32m Beginner

Viewers:

Performing Goal Seek analysis provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...