- From the Data tab, in the Data Tools group, choose the What If Analysis drop down button and select Goal Seek.
- In the Goal Seek dialog box, type 250 in the To value: field, and with your cursor in the By changing cell: field, select the Loan Amount value. Click the OK button.
- Examine the results. It’s telling us that we can borrow $13,247 at the same rate and terms and meet the need to keep our payment at $250. If that loan amount looks good, click OK. If not, click Cancel and try perhaps, setting By changing cell: to the term or interest rate if could vary as well.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/31973/what-if-analysis-in-excel-goal-seek "