Overview of Financial Analysis and Modeling using Excel and VBA Book

Financial 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. Special Features ?ú Completely updated to reflect new changes to Excel in Office 2007 and Vista. Page layouts have changed and the new Excel includes more bells and whistles, particularly to VBA. ?ú Add new coverage of popular statistical analysis and business valuation models; Pivot tables; expanded coverage of The Solver; even more VBA coverage. ?ú Excel 2007 is a great tool but the learning curve may be steep. This new edition will fast track users to make them more efficient and accurate. Table of Content ?ú Introduction to Financial Analysis and Modeling. Part One: Excel for Financial Analysis and Modeling. ?ú Excel 2007 and Previous Excel Versions. ?ú Excel Basics. ?ú Advanced Excel Features. ?ú Making Decisions and Looking Up Values. ?ú Analyzing Databases. ?ú Answering What-If Questions. ?ú Finding Iterative Solutions. ?ú Doing Statistical Analysis. ?ú Using Excel's Financial Functions. ?ú Other Useful Excel Functions. Part Two: Financial Modeling Using Excel. ?ú Building Good Excel Models and Debugging Them. ?ú Financial Statements Forecasting. ?ú Time Value of Money. ?ú Financial Planning and Investments. ?ú Analyzing Market History. ?ú Bond Pricing and Duration. ?ú Simulating Stock Prices. ?ú Options and Option Portfolios. ?ú Binomial Option Pricing. Part Three: VBA for Financial Modeling. ?ú Introduction to VBA. ?ú VBA Essentials. ?ú Sub and Function Procedures. ?ú Debugging VBA Codes. Part Four: Financial Modeling Using VBA. ?ú How to Build Good VBA Models. ?ú Time Value of Money. ?ú Financial Planning and Investments. ?ú Analyzing Market History. ?ú Simulating Stock Prices. ?ú Options and Option Portfolios. ?ú Binomial Option Pricing.

• Book Type :

Programming & SoftwareDevelopment

• Book Binding :

Paperback

• Language :

English

• Number of Pages :

816 pages

• ISBN - 10 :

8126531827

• Financial Analysis and Modeling using Excel and VBA Published On :

14-Jul-11

• Resource:

Computing, Internet & DigitalMedia, Programming & SoftwareDevelopment for Students and Professionals

Disclaimer:

• Brand Wiley
  Reference BKDPHBT_9788126531820
  Condition New product