{"product_id":"financial-analysis-and-modeling-using-excel-and-vba-isbn-9780470275603","title":"Financial Analysis and Modeling Using Excel and VBA","description":"\u003cb\u003eAn updated look at the theory and practice of financial analysis and modeling\u003c\/b\u003e \u003cp\u003e\u003ci\u003eFinancial Analysis and Modeling Using Excel and VBA, Second Edition\u003c\/i\u003e 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 website includes several useful modeling tools and fully working versions of all the models discussed in the book.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTeaches financial analysis and modeling and illustrates advanced features of Excel and VBA, using a learn-by-doing approach\u003c\/li\u003e \u003cli\u003eContains 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\u003c\/li\u003e \u003cli\u003eOther titles by Sengupta: \u003ci\u003eFinancial Modeling Using C++\u003c\/i\u003e and \u003ci\u003eThe Only Proven Road to Investment Success\u003c\/i\u003e\n\u003c\/li\u003e \u003cli\u003eDesigned for self-study, classroom use, and reference\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThis comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.\u003c\/p\u003e \u003cp\u003eAbout This Book xix\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 1 Introduction to Financial Analysis and Modeling 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSteps in Creating a Model 5\u003c\/p\u003e \u003cp\u003eHow This Book Is Organized 9\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart One Excel for Financial Analysis and Modeling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 2 Excel 2007 and the Previous Versions 15\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe New Features in Excel 2007 15\u003c\/p\u003e \u003cp\u003eThe New User Interface 16\u003c\/p\u003e \u003cp\u003eOther New Features 19\u003c\/p\u003e \u003cp\u003eNew File Formats in Excel 2007 23\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 3 Excel Basics 25\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eImproving Your Excel Skills 26\u003c\/p\u003e \u003cp\u003eThe Basic Excel Features 32\u003c\/p\u003e \u003cp\u003eNaming Workbooks and Worksheets 33\u003c\/p\u003e \u003cp\u003eFinding the Commands You Need 33\u003c\/p\u003e \u003cp\u003eWorking with Worksheets 33\u003c\/p\u003e \u003cp\u003eWorking with Rows, Columns, and Cells 34\u003c\/p\u003e \u003cp\u003eUsing the Toolbars 34\u003c\/p\u003e \u003cp\u003eUsing Keyboard Shortcuts 34\u003c\/p\u003e \u003cp\u003eNavigating the Worksheet 36\u003c\/p\u003e \u003cp\u003eFormatting 36\u003c\/p\u003e \u003cp\u003eEntering and Working with Formulas 37\u003c\/p\u003e \u003cp\u003eUsing Paste Special 37\u003c\/p\u003e \u003cp\u003eControlling the Worksheet View 38\u003c\/p\u003e \u003cp\u003eUsing Undo and Redo 38\u003c\/p\u003e \u003cp\u003eCustomizing the Excel Work Environment 38\u003c\/p\u003e \u003cp\u003eControlling When Formulas Are Calculated 39\u003c\/p\u003e \u003cp\u003ePrinting 39\u003c\/p\u003e \u003cp\u003eCreating Charts 40\u003c\/p\u003e \u003cp\u003eWorking with More Than One Workbook 40\u003c\/p\u003e \u003cp\u003eUsing the Scroll Lock 41\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 4 Advanced Excel Features 43\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCopying Formulas Using Absolute and Relative Cell References 46\u003c\/p\u003e \u003cp\u003eUsing Names in Formulas 56\u003c\/p\u003e \u003cp\u003eA1 and R1C1 Reference Styles 57\u003c\/p\u003e \u003cp\u003eUsing Comments in Cells 58\u003c\/p\u003e \u003cp\u003eData Validation 60\u003c\/p\u003e \u003cp\u003eControls 62\u003c\/p\u003e \u003cp\u003eCustom Number Formats 65\u003c\/p\u003e \u003cp\u003eHiding and Protecting 67\u003c\/p\u003e \u003cp\u003eCustom Views 71\u003c\/p\u003e \u003cp\u003eArrays and Array Formulas 72\u003c\/p\u003e \u003cp\u003eOutline 75\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 5 Making Decisions and Looking Up Values 77\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMaking Decisions 78\u003c\/p\u003e \u003cp\u003eLooking Up Values 97\u003c\/p\u003e \u003cp\u003eConditional Formatting 103\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 6 Analyzing Databases 109\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSorting 112\u003c\/p\u003e \u003cp\u003eFiltering 120\u003c\/p\u003e \u003cp\u003eTables 124\u003c\/p\u003e \u003cp\u003ePivotTable 135\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 7 Answering What-If Questions 161\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Tables 162\u003c\/p\u003e \u003cp\u003eScenario Manager 166\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 8 Finding Iterative Solutions 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCircular Reference 171\u003c\/p\u003e \u003cp\u003eGoal Seek 174\u003c\/p\u003e \u003cp\u003eSolver 177\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 9 Doing Statistical Analysis 185\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDescriptive Statistics 187\u003c\/p\u003e \u003cp\u003eFrequency Distributions and Histograms 192\u003c\/p\u003e \u003cp\u003eCounting, Ranking, and Calculating Quantiles 195\u003c\/p\u003e \u003cp\u003eNormal Probability Distributions 203\u003c\/p\u003e \u003cp\u003eRandom Numbers 207\u003c\/p\u003e \u003cp\u003eStatistical Tests 218\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 10 Using the Financial Functions 221\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAnnuity Functions 221\u003c\/p\u003e \u003cp\u003eInvestment Analysis Functions 228\u003c\/p\u003e \u003cp\u003eBond Functions 232\u003c\/p\u003e \u003cp\u003eDepreciation Functions 237\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 11 Other Useful Excel Functions 243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMathematical Functions 243\u003c\/p\u003e \u003cp\u003eDate and Time Functions 248\u003c\/p\u003e \u003cp\u003eText Functions 251\u003c\/p\u003e \u003cp\u003eInformation Functions 254\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Two Financial Modeling Using Excel\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 12 Building Good Excel Models and Debugging Them 257\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAttributes of Good Excel Models 257\u003c\/p\u003e \u003cp\u003eDocumenting Excel Models 260\u003c\/p\u003e \u003cp\u003eDebugging Excel Models 262\u003c\/p\u003e \u003cp\u003eUsing Formula Auditing Tools for Debugging 265\u003c\/p\u003e \u003cp\u003eLearning Modeling Using Excel 267\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 13 Financial Statements Forecasting 271\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 271\u003c\/p\u003e \u003cp\u003eModeling Examples 281\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 14 Time Value of Money 327\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 327\u003c\/p\u003e \u003cp\u003eModeling Examples 341\u003c\/p\u003e \u003cp\u003eCHAPTER 15 Financial Planning and Investments 365\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 365\u003c\/p\u003e \u003cp\u003eSome Basic Issues 365\u003c\/p\u003e \u003cp\u003eSaving and Investing for Retirement 368\u003c\/p\u003e \u003cp\u003eStructuring Portfolios 371\u003c\/p\u003e \u003cp\u003eModeling Examples 372\u003c\/p\u003e \u003cp\u003eModel 1: Return with Changing Reinvestment Rates 372\u003c\/p\u003e \u003cp\u003eModel 2: Saving for Retirement 376\u003c\/p\u003e \u003cp\u003eModel 3: Retirement Planning in Real Dollars 379\u003c\/p\u003e \u003cp\u003eModel 4: Retirement Planning in Nominal Dollars 380\u003c\/p\u003e \u003cp\u003eModel 5: Portfolio Structuring 385\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 16 Analyzing Market History 389\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 389\u003c\/p\u003e \u003cp\u003eModeling Examples 394\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 17 Bond Pricing and Duration 409\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 409\u003c\/p\u003e \u003cp\u003eModeling Examples 416\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 18 Simulating Stock Prices 427\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 427\u003c\/p\u003e \u003cp\u003eModeling Examples 438\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 19 Options and Option Portfolios 449\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 449\u003c\/p\u003e \u003cp\u003eModeling Examples 460\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 20 Binomial Option Pricing 487\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 487\u003c\/p\u003e \u003cp\u003eModeling Examples 491\u003c\/p\u003e \u003cp\u003eModel 1: European Options on Stocks with\u003c\/p\u003e \u003cp\u003eKnown Dividend Yield 491\u003c\/p\u003e \u003cp\u003eModel 2: American Options on Stocks Paying\u003c\/p\u003e \u003cp\u003eNo Dividend 495\u003c\/p\u003e \u003cp\u003eModel 3: American Options on Stocks with\u003c\/p\u003e \u003cp\u003eKnown Dividend Yields 498\u003c\/p\u003e \u003cp\u003eModel 4: American Options on Stocks with\u003c\/p\u003e \u003cp\u003eKnown Dollar Dividends 500\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Three VBA for Financial Modeling\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 21 Introduction to VBA 505\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExample of a VBA Model 510\u003c\/p\u003e \u003cp\u003eRecording Macros 520\u003c\/p\u003e \u003cp\u003eUsing VBA’s Help 524\u003c\/p\u003e \u003cp\u003eThe Strategy to Learn VBA Efficiently 526\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 22 VBA Essentials 529\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Visual Basic Editor 530\u003c\/p\u003e \u003cp\u003eSome Basics 535\u003c\/p\u003e \u003cp\u003eVariables, Constants, and Arrays 545\u003c\/p\u003e \u003cp\u003eObjects, Properties, and Methods 557\u003c\/p\u003e \u003cp\u003eBranching 561\u003c\/p\u003e \u003cp\u003eLooping 567\u003c\/p\u003e \u003cp\u003eUsing Built-In Functions 574\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 23 Sub and Function Procedures 577\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSub Procedures 577\u003c\/p\u003e \u003cp\u003eFunction Procedures 582\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 24 Debugging VBA Codes 589\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Four Basic Types of Bugs 590\u003c\/p\u003e \u003cp\u003eThe VBA Debugging Tools 591\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Four Financial Modeling Using VBA\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 25 How to Build Good VBA Models 597\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAttributes of Good VBA Models 597\u003c\/p\u003e \u003cp\u003eDocumenting VBA Models 601\u003c\/p\u003e \u003cp\u003eLearning Modeling Using VBA 603\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 26 Time Value of Money 607\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReview of Theory and Concepts 607\u003c\/p\u003e \u003cp\u003eModeling Examples 611\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 27 Financial Planning and Investments 663\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling Examples 663\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 28 Analyzing Market History 691\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling Examples 691\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 29 Simulating Stock Prices 717\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling Examples 717\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 30 Options and Option Portfolios 725\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling Examples 725\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCHAPTER 31 Binomial Option Pricing 741\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModeling Examples 741\u003c\/p\u003e \u003cp\u003eAPPENDIX A Keyboard Shortcuts for Excel 755\u003c\/p\u003e \u003cp\u003eAPPENDIX B VBA Quick Reference 757\u003c\/p\u003e \u003cp\u003eAPPENDIX C Excel and VBA Built-In Functions 759\u003c\/p\u003e \u003cp\u003eAbout the CD-ROM 777\u003c\/p\u003e \u003cp\u003eIndex 781\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eCHANDAN SENGUPTA\u003c\/b\u003e 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 \u003ci\u003eFinancial Modeling Using C++\u003c\/i\u003e and \u003ci\u003eThe Only Proven Road to Investment Success,\u003c\/i\u003e all of which are published by Wiley.    \u003c\/p\u003e\u003cp\u003e\u003cb\u003ePRAISE FOR THE FIRST EDITION OF FINANCIAL ANALYSIS AND MODELING USING EXCEL AND VBA\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003e\"Excel and VBA have vast capabilities, yet until this book, users were on their own to figure out just how to use these tools for both single and complex financial problems. Financial Modeling fills the gaps with practical guidance to modeling a wide range of finance problems.\" \u003cb\u003e—TIM KOLLER,\u003c\/b\u003e Partner, McKinsey \u0026amp; Company, Inc.  \u003c\/p\u003e\u003cp\u003eALTHOUGH MANY PEOPLE think that financial analysis and financial modeling are different activities, they are actually the two sides of a coin. The skills associated with these disciplines are essential for today's financial professional as well as students in this field—and Excel and its built-in programming language Visual Basic for Applications (VBA) remain the premier tools for the job.  \u003c\/p\u003e\u003cp\u003e\u003ci\u003eFinancial Analysis and Modeling Using Excel and VBA, Second Edition\u003c\/i\u003e 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—to find solutions.  \u003c\/p\u003e\u003cp\u003eThis 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 website includes several useful modeling tools and fully working versions of all the models discussed in the book.  \u003c\/p\u003e\u003cp\u003eWritten in a straightforward and accessible style, the \u003ci\u003eSecond Edition of Financial Analysis and Modeling Using Excel and VBA:\u003c\/i\u003e  \t\u003c\/p\u003e\u003cul\u003e \u003cli\u003eIncludes 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\u003c\/li\u003e \u003cli\u003eTeaches financial analysis and modeling, and illustrates advanced features of Excel and VBA, using a learn-by-doing approach\u003c\/li\u003e \u003cli\u003eContains comprehensive new chapters on writing formulas that can make decisions, answering what-if questions, finding iterative solutions to problems, and much more\u003c\/li\u003e \t\t\u003c\/ul\u003e  \u003cp\u003eEqually useful to both those who are interested in financial analysis and those who are interested in financial modeling, this reliable resource will help you make the most of Excel and VBA as you navigate the complex terrain of today's modern financial world.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989209301221,"sku":"NP9780470275603","price":157.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470275603.jpg?v=1761783216","url":"https:\/\/k12savings.com\/es\/products\/financial-analysis-and-modeling-using-excel-and-vba-isbn-9780470275603","provider":"K12savings","version":"1.0","type":"link"}