COURSE NUMBER: MBA236G.1B

COURSE TITLE: Designing Financial Models that Work

UNITS OF CREDIT: 1

INSTRUCTOR: Jenny Herbert-Creek

E-MAIL ADDRESS: herbert@haas.berkeley.edu

PREREQUISITE(S): Intermediate Excel skills

CLASS FORMAT: Primarily experiential -- the bulk of class time will be spent on hands-on Excel-based exercises, completed individually or in pairs. Some lectures and case discussions.

REQUIRED READINGS: None

BASIS FOR FINAL GRADE: In-class exercises, homework, quiz, class participation

CAREER FIELD: This is a hands-on, practical course for students pursuing any career path. As this course covers models from a variety of industries, students specifically interested in investment banking models should enroll in Financial Statement Modeling instead of / in addition to this course.

ABSTRACT OF COURSE: Spreadsheet financial models are often too big, complicated, and buggy to help people. In this course, students learn to design financial models that work because they're small (fit on a screen or two), straightforward (involve only basic math), clear (a non-MBA can follow them readily), and fast to build. These simple yet powerful representations of the cash flows for a new product/deal/venture help people share their vision, recognize tradeoffs, brainstorm possibilities and make decisions.

We will focus on creating clear, easy-to-follow financial models for many business situations, including pricing models, start up models, simple valuation models and more. Examples come from industries including retail, real estate, consulting, nonprofits and technology. While Excel is not the primary focus of the course, we will also leverage Excel tools to enhance our models, including efficiency tools (keyboard shortcuts), data analysis tools (like pivot tables), sensitivity analysis tools (like data tables) and data visualization features (like pivot charts and conditional formatting).

BIOGRAPHICAL SKETCH: Jenny Herbert Creek is a lecturer and consultant for programs in financial modeling, Microsoft Excel, technical communication and leadership communication. Her work draws upon more than 15 years of experience in the educational services industry, including serving as CFO of two educationally-focused companies. She is currently a member of the Professional Faculty of the Haas School of Business, where she teaches financial modeling and leadership communications to hundreds of MBA students each year. Jenny has also taught at institutions that include Berkeley Center for Executive Education, Stanford University, UCLA Anderson School of Business, the Olin School of Business and numerous corporations and start-ups. Jenny holds an MBA with honors from the Haas School of Business at UC Berkeley and is an honors graduate of Stanford University, where she earned the Dean's Award for Academic Accomplishment.