Excel: What-if Analysis and Array von eduCBA Global Online Training Experts

Dozent des Vortrages Excel: What-if Analysis and Array

eduCBA Global Online Training Experts

EduCorporateBridge is a globally recognized training firm, providing blend of instructor-led and online financial training programs in Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis Investment banking, Private Equity, Fundamental Analysis, Investment Research and Credit Research as well as preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Trainings etc.

The Corporate Bridge Online training Learning Management System provides access to high end excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.
www.educorporatebridge.com

Kundenrezensionen

Auszüge aus dem Begleitmaterial

... Data tables - One dimensional & two dimensional tables. A data table is a range of cells that shows how changing certain values in your formulas affects the results of the formulas. Data tables are especially useful when a person is doing price sensitivity analysis or valuation sensitivity ...

... while calculating share price from discounted cash flow analysis. Enterprise value vs. WACC and growth ...

... What-If-Functions Learning Objectives: Goal-seek command what-if functions are especially useful for doing price sensitivity analysis or valuation sensitivity analysis. Sensitivity analysis helps us do stress testing of our modeled assumptions and leads to value added insights. Goal-Seek: The goal-seek command is used to bring one formula to a specific value. It does this by changing one of ...

... Finally, click inside the by changing cell box and either type or click on the cell whose value can be changed to achieve the desired result. Click the OK button and the spreadsheet will ...

... selling price of the product. We may compare the above table with crude oil (Price range from $20/barrel to $80/barrel). The upstream oil and gas companies like (Exxon, BP, ONGC) sell crude oil to oil refining and marketing companies. It is but obvious that if they charge higher prices for crude, the cash flows generated will be higher. The above table can be sent to the clients directly. ...

... maximum valuation of Rs50/-. If we use DCF, the pessimistic and aggressive valuation will be Rs30/- and Rs45/-. The above data can be neatly summarized in the form of range charts as shown below. What are range charts? ...

... of capital and uses of capital. The sources of capital is coming from various projects: IPO, debt and internal funding. The usage of capital is for three projects: Project 1, Project 2 and Project 3 ...

... is $/barrel. What are two-axis graphs? The operating cash flows generated from the products is read from the left hand side (primary axis) and the unit cost of raw material crude oil ($/barrel) is read from the right hand side (secondary axis) ...

... the most expected scenario. However, the company may be exposed to various external events which may result in increase or decrease of fair valuations. The above table provides a sample of such pessimistic and optimistic events. What are scenario graphs? In the above graph it is very easy for us to visualize the exact impact of the downsides and the upside. ...