It is possible to find the points, however, with the spreadsheet's Goal Seek
or Solver feature.
uses an iterative process when finding solutions.
The course aims to educate participants in: learning how to build financial models through stepwise projection of income statement, balance sheet and cash flows; learning how to apply advanced Excel tools - Data Tables, Goal Seek
, Nested Ifs, Correlation & Regression, VLOOKUP, HLOOKUP, Time Value of Money, NPV and IRR; learning how to develop key schedules including debt/interest, depreciation, working capital and equity; mastering DCF Valuation and Trading Comps Valuation (P/E, P/B, EV/EBITDA, etc.
If you are using MS-Excel, you can use the goal seek
function to solve for M, but I have created a simple web application to do this, as well at http://filezone.
Automated tools, such as sensitivity analysis and goal seek
, that let finance staff instantly identify the critical assumptions that drive financial performance.
McFedries also covers building business models through data analysis with the data tables, PivotTables, Goal Seek
, and Solver tools.
alters a set of numbers to achieve desired results.
The Excel tool Goal Seek
can answer this question in a flash (see exhibit 18, at left).
We chose the examples to stimulate awareness and discussion of the many classroom uses for four important Excel spreadsheet tools: three-dimensional (3-D) graphs, iteration, Goal Seek
, and Solver.
CPAs can make good use of three advanced data analysis tools: cross tabulations, goal seek
features and optimizers.