CHANDAN SENGUPTA . in all major areas of finance using both Excel and VBA. I will teach you VBA and modeling with VBA using a simple class-tested. Buy Financial Analysis and Modeling Using Excel and VBA (Wiley Finance) 2nd by Chandan Sengupta (ISBN: ) from Amazon’s Book Store. Praise for Financial 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.

Author: Tygodal Gasho
Country: Kuwait
Language: English (Spanish)
Genre: Love
Published (Last): 12 January 2018
Pages: 270
PDF File Size: 3.10 Mb
ePub File Size: 14.26 Mb
ISBN: 588-8-36457-545-8
Downloads: 12139
Price: Free* [*Free Regsitration Required]
Uploader: Doular

The Bisection Method chanean Attributes of Good Excel Models Most programs come with installers; for those, simply open the program’s folder on the CD and double-click the Install or Installer icon. Sumedha Academics marked it as to-read Dec 02, Interest Rate Risk If you do not have autorun enabled, or if the autorun window does not appear, follow these steps to access the CD: A Few Cautionary Notes 8.

Return with Changing Reinvestment Rates Model 2: Chapter 13 Financial Statements Forecasting. Christine Ayers rated it it was ok Jan 02, This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.


Functions to Determine Type of Data 2. Frequency of Compounding and Effective Rates Functions for Other Price and Yield Calculations The Intelligent Investor Benjamin Graham.

An Important Restriction Debugging Excel Models Grouping Text Fields 6. Scope of Arrays A companion website includes several useful modeling tools and fully working usig of all the models discussed in the book.

Financial Analysis and Modeling Using Excel and VBA

Creating Names Manually 4. Just a moment while we sign you in to your Goodreads account. Hiding and Unhiding Rows and Columns 4. Adding a Spinner in Earlier Versions of Excel 4. Leaving Selected Cells Unprotected 4. What’s on the CD C. Chapter 23 Sub and Function Procedures. Stay ahead with the world’s most comprehensive technology and business learning platform.

The Importance of the Sorting Order 6. The Buy Side Turney Duff. Editing a Multiple Sort 6.

Financial Analysis and Modeling Using Excel and VBA : Chandan Sengupta :

Enhancing Trader Performance Brett N. Some Limitations of Goal Seek 8. Assumptions, Inputs and Outputs Forcing Variable Declaration To install some programs, just drag the program’s folder from the CD window and drop it on your hard drive icon. A Note at Caution 4.


Saving for Retirement Model 3: Other Ways to Mmodeling Help Copying Using Relative Cell Reference 4. Investment Valuation Aswath Damodaran.

Using Functions from Other Workbooks Linking Finance and Quality. Anil Tulsiram marked it as to-read Feb 18, The Three Categories of Cash Flaws Two Important Points Chapter 15 Financial Planning and Investments.

Inserting a Column or Row 6. Installing and Accessing the Analysis ToolPak 4. Working with Numbers Tilson, Milton Chen Foreword by. Advantages and Disadvantages This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks financizl 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.