SEMESTER: Fall 2019

COURSE NUMBER: EWMBA236G.10B

COURSE TITLE: Designing Financial Models that Work

Please note the unorthodox nature of this course, which meets on 4 Sundays.

UNITS OF CREDIT: 1 unit

INSTRUCTOR: Jenny Herbert-Creek

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

MEETING DAY(S)/TIME: 

Course dates: 11/3, 11/17, 12/1, 12/8

• 10A (morning section) meets 9am – 1pm, except December 8th when the final quiz will be held from 11am -1pm (quiz may be taken remotely or in person during that window).
• 11A (afternoon section) meets 2pm – 6pm, except except December 8th when the final quiz will be held from 2pm - 4pm (quiz may be taken remotely or in person during that window).

PREREQUISITE(S): Intermediate Excel skills

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 236H: Financial Statement Modeling instead of / in addition to this course. 

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, class participation, final (choice of exam or project)

ABSTRACT OF COURSE'S CONTENT AND OBJECTIVES:

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, non-profits 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.