He incorporates 21st-century tools that classic textbooks predate, such as the "Goal Seek
" function in Excel, computer animations of basic open channel phenomena, and surface water profiles as modeled using both spreadsheet applications and the US Army Corps of Engineers Hydrologic Engineering Center River Analysis System program.
* Using "Goal Seek
" to determine the pump curve system curve intersection point
In order to solve this problem, three Microsoft Excel functions can be used: Goal Seek
, Yield, and PV.
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.) and learning sensitivity analysis and the margin of safety principle.
* Using "Goal Seek
" to determine the pump curve-system curve intersection point
Financial Modelling & Valuation Course 17-18 June This course will enable delegates to build a financial model to value a GCC public company through a step-by-step approach using advanced financial analysis and Excel tools including Data Tables, Goal Seek
, NestedIfs, Correlation/Regression and the globally recognised FAST standards for financial modelling.
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.orapub.
* 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.
Instructors may wish to add the simple extension of the "Goal Seek
" feature in Excel when ABKY covers the What-If analyses.
The Excel tool Goal Seek
can answer this question in a flash (see exhibit 18, at left).