This hands-on course focuses on the skills required to design and create a powerful model to analyze the impact of a merger or acquisition.Issues related to combining two companies will be reviewed and discussed. The course will be taught from the perspective of finance professionals who need to quickly assess the impact of a merger […]
This hands-on course is intended for anyone who uses Excel extensively and who is already comfortable with the skills that are taught in Data Manipulation with Excel – Part 1. This session covers advanced level Excel topics that are required to manage and analyze data.
This hands‐on seminar focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During this seminar, participants will build a financial model. The course material includes model design, logic, construction, financial concepts and accounting treatment. Using switches to create effective scenarios and […]
This advanced hands-on course reviews real estate project development concepts and focuses on the skills required to design and create a model to help finance professionals evaluate a real estate development investment. Using a mixed-use development case study, the course reviews concepts including model design, logic, project timing and various financing structures. Who Will Benefit […]
This hands‐on seminar focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During this seminar, participants will build a financial model. The course material includes model design, logic, construction, financial concepts and accounting treatment. Using switches to create effective scenarios and […]
This hands-on course is focused on the practical implementation of a Discounted Cash Flow (“DCF”) valuation analysis. There will be a discussion of various valuation methodologies and the appropriateness of using a DCF methodology to value a company. Participants will incorporate a DCF analysis into the financial model that was created on the first day. […]
This advanced hands-on course focuses on the skills needed to harness the power of macros to help automate worksheet processes. Participants will learn to design, build and error check macros that are robust and easy to use. Participants will be introduced to best practices using VBA (Visual Basic – the programming language for macros) and […]
This hands‐on course focuses on the skills required to build and incorporate a complex capital structure into a financial model. Participants will recapitalize a company’s balance sheet and then forecast specific pieces of debt and equity so that the model can be used for credit purposes or as a Leveraged Buyout (“LBO”) model. Who Will […]
This hands-on course focuses on the skills required to design and create a powerful model to analyze the impact of a merger or acquisition.Issues related to combining two companies will be reviewed and discussed. The course will be taught from the perspective of finance professionals who need to quickly assess the impact of a merger […]
This multi-day course reviews the unique modeling and valuation requirement of banks. In the course we review a case study for a bank with a diversified loan portfolio and investment strategy. Other operations such as credit cards will be explored as well as regulatory requirements and their influence on the bank’s financial performance. Key accounting […]
This course provides an introduction on how to transform, analyze and visualize data with Power BI Desktop. A corporate data set is used to build a rich and interactive report with a number of different visualizations. The relationships between various data sources are defined to create a relational data model. This model forms a foundation […]
This hands‐on seminar focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During this seminar, participants will build a financial model. The course material includes model design, logic, construction, financial concepts and accounting treatment. Using switches to create effective scenarios and […]
This hands-on course is an intensive program that will transform participants into Excel “Power Users”. The course is focused on the pertinent Excel tools that are required in a business environment to efficiently analyze and manipulate data and to create compelling financial analyses. Who Will Benefit This seminar is designed for anyone who wish to […]
This hands-on course is intended for anyone who uses Excel extensively and who is already comfortable with the skills that are taught in Data Manipulation with Excel – Part 1. This session covers advanced level Excel topics that are required to manage and analyze data. Who Will Benefit This seminar is designed for anyone who […]
This hands‐on seminar focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During this seminar, participants will build a financial model. The course material includes model design, logic, construction, financial concepts and accounting treatment. Using switches to create effective scenarios and […]
This hands‐on seminar focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. During this seminar, participants will build a financial model. The course material includes model design, logic, construction, financial concepts and accounting treatment. Using switches to create effective scenarios and […]