Financial Modeling & Valuation

The Investment Banking & Financial Markets Club would like to see our members become experts in building financial models using Microsoft Excel.  A financial model is a quantitative representation of a company's past, present, and future business operations.  Firms of all industries utilize financial models daily to analyze and plan their business activities.  Financial models act as the foundation of standard financial accounting reports, including the balance sheet, the income statement, and the statement of cash flows.  Microsoft Excel is the ideal tool for building financial models.  We hope to increase your financial modeling skills during your diligent effort in completing the assignments. 

Our Valuation assignments will cover a broad range including estimating the value of alternative corporate and business strategies and the value of specific programs within those strategies.  We will assess major transactions such as mergers, acquisitions, divestitures, recapitalizations, and share repurchases.  We will use value-based management to review and target the performance of business operations.  We will learn how to communicate with key stakeholders and how to value the business.  The fundamental premise is that the value of a company derives from its ability to generate cash flows.