用微软Excel创立金融模型：投资专业人员指南Building Financial Models with Microsoft Excel
点此进入淘宝搜索页搜索分类: 图书,进口原版书,经管与理财 Business & Investing ,
作者： K. Scott Proctor 著
出 版 社： 吉林长白山
出版时间： 2004-12-1字数：版次： 1页数： 347印刷时间： 2004/12/01开本：印次：纸张： 胶版纸I S B N ： 9780471661030包装： 精装编辑推荐
作者简介：K. SCOTT PROCTOR, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider. Mr. Proctor was also a founding Principal of Vawter Capital, a private equity investment firm that focuses primarily on early- to mid-stage, entrepreneurial, privately held, technology-oriented enterprises in the healthcare, communications, and financial services industries. Mr. Proctor also served as the acting 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.
内容简介
A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table.
K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.
目录
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 Features and Functionality
About the CD-ROM
Index
