A proven guide to building financial models from scratch The
"Second Edition "of "Building Financial Models with Microsoft Excel
+ CD-ROM" provides beginning and intermediate level computer users
with step-by-step instructions on building financial models using
Microsoft Excel 2007-the most popular spreadsheet program
available. The accompanying CD-ROM contains Excel worksheets that
track the course of the book and allow you to build your own
financial models. This comprehensive resource also covers important
topics such as the concepts of valuation, sensitivity analysis, and
contribution margin. Offers accessible guidance on building
financial models using Excel 2007 Illustrates how to integrate
financial statements such as the balance sheet, income statement,
and statement of cash flows Covers the basics of building and using
a Capitalization Table Discusses how to best present a financial
model Incorporating financial models into business decisions has
become an essential element of good business practice, and this
book will show you how to excel at this endeavor.
關於作者:
K. Scott Proctor, CFA, is Executive Director at AstraZeneca
Pharmaceuticals, a leading global pharmaceutical company. He has
experience across the fields of information technology, finance,
and science. Prior to his role at AstraZeneca, Proctor was Chief
Information Officer 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 firm, and
the Director of Investment Analytics at SNL Financial, a financial
information provider. Prior to that, Proctor was the acting Chief
Financial Officer 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 Certified in ITIL V3 IT
Service Management.
目錄:
Foreword. Preface. Acknowledgments. PART ONE: The Master Budget.
CHAPTER 1. Overview of Budgets and Financial Models. CHAPTER 2.
Operating Budget-Assumptions, Sales, and Collections. CHAPTER 3.
Operating Budget-Cost of Goods Sold, Inventory, and Purchases.
CHAPTER 4. Operating Budget-Operating Expenses. CHAPTER 5.
Operating Budget-Income Statement. CHAPTER 6. Financial
Budget-Capital Budget and Cash Budget. CHAPTER 7. Financial
Budget-Balance Sheet. PART TWO: Financial Statements and Free Cash
Flows. CHAPTER 8. Consolidated Financial Statements. CHAPTER 9.
Free Cash Flows and Dashboard. PART THREE: Analysis of a Financial
Model. CHAPTER 10. Sensitivity Analysis. CHAPTER 11. Contribution
Margin Analysis. CHAPTER 12. Financial Ratios Analysis. CHAPTER 13.
Valuation. CHAPTER 14. Capitalization Chart. Answers to Chapter
Questions. APPENDIX. General Overview of Microsoft Excel 2007
Features and Functionality. About the CD-ROM. About the Author.
Index.