Read more
Informationen zum Autor CHANDAN SENGUPTA teaches finance in the MBA program at the Fordham University Graduate School of Business, specializing in financial modeling, business valuation, corporate finance, and investment management. Formerly, he was vice president at the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for ten years. He is also the author of the first edition of this book as well as Financial Modeling Using C++ and The Only Proven Road to Investment Success, all of which are published by Wiley. Klappentext An updated look at the theory and practice of financial analysis and modelingFinancial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion CD-ROM includes several useful modeling tools and fully working versions of all the models discussed in the book.* Teaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach* Contains detailed coverage of the powerful features of Excel 2007 essential for financial analysis and modeling, such as the Ribbon interface, PivotTables, data analysis, and statistical analysis* Other titles by Sengupta: Financial Modeling Using C++ and The Only Proven Road to Investment Success* Designed for self-study, classroom use, and referenceThis comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models. Zusammenfassung * Designed for self-study, classroom use, and reference, this is a comprehensive approach to developing both simple and sophisticated financial models in all major areas of finance using both Excel 2007 and VBA. Inhaltsverzeichnis About This Book xix CHAPTER 1 Introduction to Financial Analysis and Modeling 1 Steps in Creating a Model 5 How This Book Is Organized 9 Part One Excel for Financial Analysis and Modeling CHAPTER 2 Excel 2007 and the Previous Versions 15 The New Features in Excel 2007 15 The New User Interface 16 Other New Features 19 New File Formats in Excel 2007 23 CHAPTER 3 Excel Basics 25 Improving Your Excel Skills 26 The Basic Excel Features 32 Naming Workbooks and Worksheets 33 Finding the Commands You Need 33 Working with Worksheets 33 Working with Rows, Columns, and Cells 34 Using the Toolbars 34 Using Keyboard Shortcuts 34 Navigating the Worksheet 36 Formatting 36 Entering and Working with Formulas 37 Using Paste Special 37 Controlling the Worksheet View 38 Using Undo and Redo 38 Customizing the Excel Work Environment 38 Controlling When Formulas Are Calculated 39 Printing 39 Creating Charts 40 Working with More Than One Workbook 40 Using the Scroll Lock 41 CHAPTER 4 Advanced Excel Features 43 Copying Formulas Using Absolute and Relative Cell References 46 Using Names in Formulas 56 A1 and R1C1 Reference Styles 57 Using Comments in Cells 58 Data Validation 60 Controls 62 Custom Number Formats 65 Hiding and Protecting 67 Custom Views 71 Arrays and Array Formulas 72 Outline 75 CHAPTER 5 Making Decisions and Looking Up Values 77 Making Decisions 78 Looking Up Val...
