Financial Analysis and Modeling Using Excel and VBA

4 avg rating
( 9 ratings by Goodreads )
 
9780470275603: Financial Analysis and Modeling Using Excel and VBA

Note: This ISBN is the standalone book, does not include CD-ROM.

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Chandan Sengupta
Published by Wiley (2011)
ISBN 10: 047027560X ISBN 13: 9780470275603
New Soft cover Quantity Available: > 20
International Edition
Seller
Books in my Basket
(New Delhi, India)
Rating
[?]

Book Description Wiley, 2011. Soft cover. Book Condition: New. International Edition. 816pp. Book cover and ISBN different from US edition. Territorial Restrictions maybe printed on the book. This is an international edition. Bookseller Inventory # 328061

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 16.40
Convert Currency

Add to Basket

Shipping: US$ 4.81
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

2.

Chandan Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Softcover Quantity Available: > 20
International Edition
Seller
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Book Condition: New. 2nd edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS with tracking number. Choose expedited shipping for superfast delivery 2-4 business days by DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Bookseller Inventory # LPBD31483567

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 20.58
Convert Currency

Add to Basket

Shipping: US$ 3.95
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Soft cover Quantity Available: > 20
International Edition
Seller
LOW COST_FAST SHIP
(Scottsdale, AZ, U.S.A.)
Rating
[?]

Book Description Soft cover. Book Condition: New. NEW - International Edition - ISBN 9788126531820 - Same Contents as in US edition - in english - 2ed - CD-ROM included, - SHRINKwrapped BOXpacked - Printed in Asia - Cover image is different from US edition - There is no CD or Access Code, unless specified above - Ships from various locations - Expedited 2 to 4 day Delivery option available -Standard shipping takes 5 to 10 business days - Tracking number is emailed for every order -You get same study contents at a fraction of US edition cost - Save Hard earned money. Bookseller Inventory # V40

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 18.59
Convert Currency

Add to Basket

Shipping: US$ 5.99
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

4.

Chandan Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Softcover Quantity Available: 5
International Edition
Seller
bookscollection
(Delhi, DELHI, India)
Rating
[?]

Book Description Book Condition: Brand New. PAPERBACK,Book Condition New, International Edition. We Do not Ship APO FPO AND PO BOX. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language.NO CD AND ACCESS CODE. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Bookseller Inventory # ABEADH##3759

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 20.46
Convert Currency

Add to Basket

Shipping: US$ 4.22
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

5.

Sengupta, Chandan
Published by Wiley
ISBN 10: 047027560X ISBN 13: 9780470275603
New Softcover Quantity Available: 2
International Edition
Seller
Sunshine Book Store
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Wiley. Book Condition: New. 047027560X This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Bookseller Inventory # EU_9780470275603

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 26.12
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

6.

CHANDAN SENGUPTA
ISBN 10: 047027560X ISBN 13: 9780470275603
New Quantity Available: 5
International Edition
Seller
firstbookstore
(New Delhi, India)
Rating
[?]

Book Description Book Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Bookseller Inventory # AIND-36929

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.67
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

7.

Chandan Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Softcover Quantity Available: 10
International Edition
Seller
Unique Bookseller
(Delhi, India)
Rating
[?]

Book Description Softcover. Book Condition: Brand New. .. Black & White or color International Edition. ISBN and front cover may be different, but contents are same as the US edition. Book printed in English. Territorial restrictions may be printed on the book. GET IT FAST within 3-5 business days by DHL/FedEx/Aramex and tracking number will be uploaded into your order page within 24-48 hours. Kindly provide day time phone number in order to ensure smooth delivery. No shipping to PO BOX, APO, FPO addresses. 100% Customer satisfaction guaranteed!. . Bookseller Inventory # UBS03076

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.17
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

8.

Chandan Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Paperback Quantity Available: 4
International Edition
Seller
Bookstore99
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. This is an International Edition. Brand New Paperback- Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Delivery within 3-7 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Choose expedited shipping for Express delivery. Tracking number provided for every order. Bookseller Inventory # RU_9780470275603

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 26.12
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

9.

CHANDAN SENGUPTA
ISBN 10: 047027560X ISBN 13: 9780470275603
New Softcover Quantity Available: 5
International Edition
Seller
Romtrade Corp.
(STERLING HEIGHTS, MI, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery. Bookseller Inventory # AUSBNEW-36929

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 30.18
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

10.

Chandan Sengupta
ISBN 10: 047027560X ISBN 13: 9780470275603
New Paperback Quantity Available: 5
International Edition
Seller
PRIORITY BOOKS
(springfield, VA, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 2nd Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 793 Pages with CD-ROM, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Bookseller Inventory # 419751

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.10
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book