Financial analysis and modeling : using excel and VBA 2nd ed

Author

• Sengupta, Chandan

Additional Author(s)

-

Publisher

Hoboken, NJ: John Wiley & Sons , 2010

Language

English

ISBN

9780470275603

Series

Subject(s)

• FINANCE--MATHEMATICAL MODELS
• INVESTMENTS--MATHEMATICAL MODELS
• MICROSOFT VISUAL BASIC FOR APPLICATIONS

Notes

. . Index: p. 781-793

Abstract

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 website 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.

Physical Dimension

Number of Page(s)

xxi, 783 p.

Dimension

24 cm

Other Desc.

ill.

Summary / Review / Table of Content

Introduction to 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

Exemplar(s)

#	Accession No.	Call Number	Location	Status
1.	00171/23	S 332.0285554 Sen F	Library - 5th Floor / 1smt	Available