COURSE NUMBER: MBA236G.2B
COURSE TITLE: Designing Financial
Models that Work
UNITS OF CREDIT: 1
INSTRUCTOR: Jenny Herbert-Creek
E-MAIL ADDRESS: herbert@haas.berkeley.edu
MEETING DATES: Spring B Tuesdays,
3/13-5/1
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, group project
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.
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,
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.