Building financial models with Microsoft Excel [electronic resource] : a guide for business professionals / by K. Scott Proctor.
By: Proctor, K. Scott.
Material type: BookSeries: Wiley finance series: Publisher: Hoboken, N.J. : Wiley, c2010Edition: 2nd edition.Description: online resource (xix, 356 pages) : illustrations.Content type: text Media type: computer Carrier type: online resourceISBN: 9780470481745 (hardback); 9780470561430 (e-book).Subject(s): Microsoft Excel (Computer file) | Corporations -- Finance -- Computer programsAdditional physical formats: Print version:.: Building financial models with Microsoft Excel : a guide for business professionals.DDC classification: 658.150285554 Online resources: E-book Also available in print format.Item type | Current library | Call number | Status | Date due | Barcode | Item holds |
---|---|---|---|---|---|---|
e-BOOK | MTU Bishopstown Library eBook | 658.150285554 (Browse shelf(Opens below)) | Not for loan |
Enhanced descriptions from Syndetics:
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 modelIncorporating 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.
Includes index
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.
Building Financial Models with Microsoft Excel, Second Edition offers a detailed and easy-to-understand guide for anyone who needs to build or analyze financial models using Microsoft Excel 2007. Written in a straightforward and accessible manner, it is a comprehensive resource for business professionals with a beginner or intermediate level of experience in both Microsoft Excel, and finance or accounting. K. Scott Proctor provides a thoughtful and coherent link between financial/accounting theory and common Wall Street practice by addressing key questions in financial modeling like what to build, how to build, and how to analyze.--BOOK JACKET
Also available in print format.
Electronic reproduction.: ProQuest LibCentral. Mode of access: World Wide Web.
Table of contents provided by Syndetics
- Foreword (p. xi)
- Preface (p. xiii)
- Acknowledgments (p. xix)
- Part 1 The Master Budget
- Chapter 1 Overview of Budgets and Financial Models (p. 3)
- Chapter 2 Operating Budget-Assumptions, Sales, and Collections (p. 20)
- Chapter 3 Operating Budget-Cost of Goods Sold, Inventory, and Purchases (p. 41)
- Chapter 4 Operating Budget-Operating Expenses (p. 61)
- Chapter 5 Operating Budget-Income Statement (p. 77)
- Chapter 6 Financial Budget-Capital Budget and Cash Budget (p. 96)
- Chapter 7 Financial Budget-Balance Sheet (p. 126)
- Part 2 Financial Statements and Free Cash Rows
- Chapter 8 Consolidated Financial Statements (p. 147)
- Chapter 9 Free Cash Flows and Dashboard (p. 165)
- Part 3 Analysis of a Financial Model
- Chapter 10 Sensitivity Analysis (p. 187)
- Chapter 11 Contribution Margin Analysis (p. 201)
- Chapter 12 Financial Ratios Analysis (p. 220)
- Chapter 13 Valuation (p. 244)
- Chapter 14 Capitalization Chart (p. 287)
- Answers to Chapter Questions (p. 279)
- Appendix: General Overview at Microsoft Excel 2007 Features and Functionality (p. 315)
- About the CD-ROM (p. 339)
- About the Author (p. 343)
- Index (p. 345)