a. Distilling the key elements of the business case as the building blocks of the model - building a complex model to evaluate the proposed turnaround strategy of a failing company from first principles.
b. Best practice methodology regarding model specifications, structure, and sequence.
c. The importance of and interaction between the input assumptions, the support schedules, the Income Statements, Cash Flow Statement, and Balance Sheet in financial models.
d. Analysing the model output - calculating various ratios, sensitivity analysis, scenarios, and data tables.
e. Calculating Free Cash flows, IRRs, NPV, Cash Flow waterfalls, DSCR, and project ratios.
f. All Excel functions and techniques useful in the building and analysis of a model.
g. Analysing the results of a completed model for the purpose of advising the client and financiers regarding the feasibility of a new product.
h. Building a valuation model (DCF) - completing a 5-year forecast, calculating free cash flow, a terminal value, and a shareholder valuation.
i. Structuring a merger and acquisition model, modeling process recommendation, calculating free cash flows, and valuations, calculating the value of the merger and structuring the offer.
j. Reviewing alternative loan structures and debt sculpting.
k. An introduction to writing macros in VBA.
m. Optimisation models using Excel Solver.