9780470275603

Financial Analysis and Modeling Using Excel and VBA

by
  • ISBN13:

    9780470275603

  • ISBN10:

    047027560X

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 11/9/2009
  • Publisher: Wiley
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $150.00 Save up to $42.00
  • Buy New
    $108.00
    Add to Cart Free Shipping

    USUALLY SHIPS IN 3-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

Summary

An updated look at the theory and practice of financial analysis and modeling - 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. 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 reference. This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.

Author Biography

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.

Table of Contents

About This Book
Introduction to Financial Analysis and Modeling
Excel for Financial Analysis and Modeling
Excel 2007 and Previous Excel Versions
Excel Basics
Advanced Excel Features
Making Decisions and Looking Up Values
Analyzing Data
Answering What-If Questions
Finding Iterative Solutions
Doing Statistical Analysis
Using Excel's Financial Functions
Other Useful Excel Functions
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
VBA for Financial Modeling
Introduction to VBA
VBA Essentials
Sub and Function Procedures
Debugging VBA Codes
Pat IV: 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
Keyboard shortcuts for Excel
VBA Quick Reference
Excel and VBA Built-In Functions
About the CD-ROM
Index
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review