Printer: Yet to Come

Part One covers the steps involved in building 
the master budget—detailing its two key ele-
ments, the operating budget and fi nancial bud-
get. You’ll learn the fundamentals of the bud-
geting process and how various components 
of a master budget relate to one another—
from sales, inventory, and operating expenses 
to capital budgets, cash budgets, and balance 
sheets. Part Two explains consolidated fi nancial 
statements and free cash fl ows, providing 
a guide to building these statements from 
scratch. Part Three tackles the various ways to 
analyze a fi nancial model, including sensitivity 
analysis, contribution margin analysis, and 
fi nancial ratios analysis. The book also includes 
a companion CD-ROM, which contains sample 
Excel worksheets that allow you to follow the 
examples illustrated within the book or build 
your own fi nancial models according to your 
specifi c situation.
Filled with in-depth insights and easy-to-
understand instructions, this fully revised 
Second Edition
 
of
 Building Financial Models 
with Microsoft Excel
is a readable, practical 
guide to understanding and creating fully 
functioning fi nancial models.
K. SCOTT PROCTOR, CFA,
is Executive Di-
rector at AstraZeneca Pharmaceuticals, a lead-
ing global pharmaceutical company. He has 
experience across the fi elds of information 
technology, fi nance, and science. Prior to his 
role at AstraZeneca, Proctor was Chief Infor-
mation Offi cer (CIO) of General Electric (GE) 
Healthcare Life Sciences, based in Uppsala, 
Sweden. Proctor was also a founding Principal 
of Vawter Capital, a private equity investment 
fi rm, and the Director of Investment Analyt-
ics at SNL Financial, a fi nancial information 
provider. Prior to that, Proctor was the acting 
Chief Financial Offi cer (CFO) of Illuminis, an 
Intel- and MCI-funded healthcare information 
systems company. He earned his BA, MBA, 
and MS (Management Information Systems) 
from the University of Virginia. Proctor is also 
Foundation Level Certifi ed in ITIL V3 IT Service 
Management.
Jacket Design: Diane Chin
Jacket Photograph: © Getty Images
EAN: 9780470481745 
ISBN 978-0-470-48174-5
( c o n t i n u e d o n b a c k f l a p )
( c o n t i n u e d f r o m f r o n t f l a p )