Financial Modelling within Business

Washington, D.C. campuses

GA D.C. (Northern Virginia)
2231 Crystal Drive - 10th Floor
Arlington VA 22202

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

Past Locations for this Workshop

Financial Modelling within Business

Washington, D.C.

Washington, D.C. campuses

GA D.C. (Northern Virginia)
2231 Crystal Drive - 10th Floor
Arlington VA 22202

GA D.C., 1776
1133 15th Street NW, 8th Floor
Washington D.C. 20005

Past Locations for this Workshop

About this workshop

Understanding financial model increases your knowledge of a business and your ability to impact it by determining the levers and understanding the sensitivity of the levers to your general business outputs, profits and cash flow.

The value of a company is solely determined by the projected cash flows a company can deliver Everything that can be done for a business can be explained using financial statements, which is why WS models their projections to determine the value of a business and hence the price per share of the business

In this very hands-on workshop students will get an overview of financial terms, ratios, and financial statements. Then, they will walk through a case study to apply those newly learned concepts and those business inputs to build the model. Using an excel financial model template (incomplete and completed) students will learn the ins and outs of excel financial modeling.

Takeaways

  • A better understanding of financial statements and what the value drivers of a business can be.
  • A better understanding how to navigate and build a model in excel.
  • A better understanding of how to evaluate the outputs in relative perspectives.

Prereqs & Preparation

  • Must have working version of Microsoft Excel (2007 or newer)
  • Working knowledge of excel and how to use basic functions
  • Some understanding of how a company makes profit (i.e. what are sales? What are profits?)

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.