Financial Analysis and Modeling Using Excel and VBA, 2nd Edition

Finance › Corporate Finance

Financial Analysis and Modeling Using Excel and VBA, 2nd Edition

By Chandan Sengupta
John Wiley & Sons November 2009

Specifications

ISBN-13
9780470275603
Publisher
John Wiley & Sons
Publication
November 2009
Format
Paperback , 793 pages
Jurisdiction
International or US ? Countri(es) for reference only

Details

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.

Table of Contents

About This Book.

Chapter 1 Introduction to Financial Analysis and Modeling.

Part One: Excel for Financial Analysis and Modeling.

Chapter 2 Excel 2007 and Previous Excel Versions.

Chapter 3 Excel Basics.

Chapter 4 Advanced Excel Features.

Chapter 5 Making Decisions and Looking Up Values.

Chapter 6 Analyzing Databases.

Chapter 7 Answering What-If Questions.

Chapter 8 Finding Iterative Solutions.

Chapter 9 Doing Statistical Analysis.

Chapter 10 Using Excel's Financial Functions.

Chapter 11 Other Useful Excel Functions.

Part Two: Financial Modeling Using Excel.

Chapter 12 Building Good Excel Models and Debugging Them.

Chapter 13 Financial Statements Forecasting.

Chapter 14 Time Value of Money.

Chapter 15 Financial Planning and Investments.

Chapter 16 Analyzing Market History.

Chapter 17 Bond Pricing and Duration.

Chapter 18 Simulating Stock Prices.

Chapter 19 Options and Option Portfolios.

Chapter 20 Binomial Option Pricing.

Part Three: VBA for Financial Modeling.

Chapter 21 Introduction to VBA.

Chapter 22 VBA Essentials.

Chapter 23 Sub and Function Procedures.

Chapter 24 Debugging VBA Codes.

Pat Four: Financial Modeling Using VBA.

Chapter 25 How to Build Good VBA Models.

Chapter 26 Time Value of Money.

Chapter 27 Financial Planning and Investments.

Chapter 28 Analyzing Market History.

Chapter 29 Simulating Stock Prices.

Chapter 30 Options and Option Portfolios.

Chapter 31 Binomial Option Pricing.

Appendix A Keyboard Shortcuts for Excel.

Appendix B VBA Quick Reference.

Appendix C Excel and VBA Built-In Functions.

Index.

About the Author

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.
 

 

Out of stock
This title is currently unavailable for purchase.
  • Free HK shipping over HK$1,000
  • International shipping to 35+ countries
Save

Recommended

You may also be interested in these books:

More titles from Corporate Finance

View all
Corporate Controller's Handbook of Financial Management (2017-2018)
CCH U.S.

Corporate Controller's Handbook of Financial Management (2017-2018)

Jae K. Shim Ph.D., M.B.A.; Joel G. Siegel PhD, CPA; Nick Dauber MS, CPA
HKD 992.00
Inventory Accounting
John Wiley & Sons

Inventory Accounting

Steven M. Bragg
HKD 950.00
Controller as Business Manager
John Wiley & Sons_

Controller as Business Manager

James Lindell
HKD 374.00
Corporate Finance, 9th Edition
McGraw Hill Higher Education

Corporate Finance, 9th Edition

David; Ross, Stephen; Westerfield, Randolph; Jaffe, Jeffrey; Jordan, Br Hillier
HKD 357.00
Corporate Controller's Handbook of Financial Management (2020-2021)
CCH U.S.

Corporate Controller's Handbook of Financial Management (2020-2021)

Jae K. Shim; Joel G. Siegel; Nick Dauber; Marc H. Levine
HKD 2,835.00
NASD Arbitration Solution
John Wiley & Sons

NASD Arbitration Solution

Thomas J. Hine; John K. Brubaker
HKD 500.00