Summer Reading Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lisa Howorth: IMG So Many Books, So Many Writers



I'm not a bookseller, but I'm married to one, and Square Books is a family. And we all know about families and how hard it is to disassociate... Continue »

spacer
Qualifying orders ship free.
$150.00
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
2 Remote Warehouse Business- Accounting and Finance
7 Remote Warehouse Business- Accounting and Finance

Other titles in the Wiley Finance series:

Financial Analysis and Modeling Using Excel and VBA [With CDROM] (Wiley Finance)

by

Financial Analysis and Modeling Using Excel and VBA [With CDROM] (Wiley Finance) Cover

 

Synopses & Reviews

Publisher Comments:

Praise for the first edition of Financial Analysis and Modeling Using Excel and VBA

"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."
Tim Koller, Partner, McKinsey & Company, Inc.

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

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—to find solutions.

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.

Written in a straightforward and accessible style, the Second Edition of Financial Analysis and Modeling Using Excel and VBA:

  • Includes 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
  • Teaches financial analysis and modeling, and illustrates advanced features of Excel and VBA, using a learn-by-doing approach
  • Contains comprehensive new chapters on writing formulas that can make decisions, answering what-if questions,finding iterative solutions to problems, and much more

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

Synopsis:

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

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.

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.

About the CD-ROM.

Index.

Product Details

ISBN:
9780470275603
Author:
Sengupta, Chandan
Publisher:
John Wiley & Sons
Subject:
Finance
Subject:
Finance -- Mathematical models.
Subject:
Investments -- Mathematical models.
Subject:
Business-Accounting and Finance
Subject:
Institutional & Corporate Finance
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA,
Subject:
financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financial statements, financial statements modeling, financial statements forecasting, corporate finance, in
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Subject:
financial modeling, financial models, financial modeling using excel, financial modeling using VBA, financial modeling using excel and VBA, visual basic for applications, pivot tables, pivot tables, financial modeling using C++, Chandan Sengupta, financia
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Wiley Finance
Series Volume:
456
Publication Date:
20091109
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
784
Dimensions:
234 x 190 x 42 mm 48.096 oz

Related Subjects

Business » Accounting and Finance
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Transportation » General

Financial Analysis and Modeling Using Excel and VBA [With CDROM] (Wiley Finance) New Trade Paper
0 stars - 0 reviews
$150.00 In Stock
Product details 784 pages John Wiley & Sons - English 9780470275603 Reviews:
"Synopsis" by , 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 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.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.