Building financial models with Microsoft Excel : a guide for business professionals
著者
書誌事項
Building financial models with Microsoft Excel : a guide for business professionals
Wiley, c2004
- (cloth)
大学図書館所蔵 件 / 全3件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
System requirements for accompanying CD-ROM: IMB-compatible PC; Windows 9x, Windows 2000, Windows NT4 (witht SP 4 or later), Windows ME, or Windows XP; or Macintosh; OS 7.6 or later
HTTP:URL=http://www.loc.gov/catdir/description/wiley042/2004005515.html Information=Publisher description
HTTP:URL=http://www.loc.gov/catdir/toc/wiley041/2004005515.html Information=Table of contents
収録内容
- Overview of budgets and financial models
- Operating budget : assumptions, sales, and collections
- Operating budget : cost of goods sold, inventory, and purchases
- Operating budget : operating expenses
- Operating budget : income statement
- Financial budget : capital budget and cash budget
- Financial budget : balance sheet
- Consolidated financial statements
- Free cash flows and dashboard
- Sensitivity analysis
- Contribution margin analysis
- Financial ratios analysis
- Valuation
- Capitalization chart
内容説明・目次
内容説明
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.
「Nielsen BookData」 より