Making educated decisions today by forecasting operating and financial performance is a critical exercise for owners, managers, consultants, investment bankers,...More >>
Making educated decisions today by forecasting operating and financial performance is a critical exercise for owners, managers, consultants, investment bankers, creditors, equity and credit analysts, and investors such as private equity groups, hedge funds, institutional investors and individuals. As we are ineluctably constrained by our inability to predict the future, financial projections are rarely perfect. Nonetheless, we endeavor to model several scenarios predicated on historical and anticipated results to derive various conclusions. There are myriad variables, which can certainly be incorporated into projections. However, the best financial model is always the one that is stable and robust, yet simple and easy to build, navigate and audit.
The goal of this course is to instruct step-by-step how to build a comprehensive, multi-purpose projection model in Excel and subsequently interpret selective operating, credit and equity valuation data. Based on this information, you will learn how to (i) evaluate a company's operating and financial performance, and (ii) develop an appropriate capital structure by structuring debt and equity transactions which not only protect both the creditors and shareholders, but also create an appropriate risk and reward equilibrium.