Excel Chapter 4 Financial Functions, Data

Document Sample
Excel Chapter 4 Financial Functions, Data Powered By Docstoc
More information from http://www.researchandmarkets.com/reports/1205726/

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

Description:    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

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

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.


Ordering:   Order Online - http://www.researchandmarkets.com/reports/1205726/

            Order by Fax - using the form below

            Order by Post - print the order form below and sent to

                         Research and Markets,
                         Guinness Centre,
                         Taylors Lane,
Dublin 8,
                                                           Page 1 of 2

Fax Order Form
To place an order via fax simply print this form, fill in the information below and fax the completed form to 646-607-
1907 (from USA) or +353-1-481-1716 (from Rest of World). If you have any questions please visit


Order Information
Please verify that the product information is correct.

               Product Name:           Financial Analysis and Modeling Using Excel and VBA, 2nd Edition
               Web Address:            http://www.researchandmarkets.com/reports/1205726/
               Office Code:            OC8HNQPOOTOVR

Product Format
Please select the product format and quantity you require:


               Hard Copy:                EURO €116.00 + Euro €25.00 Shipping/Handling

Contact Information
Please enter all the information below in BLOCK CAPITALS

      Title:                  Mr              Mrs            Dr          Miss             Ms         Prof

      First Name:                                                  Last Name:

      Email Address: *

      Job Title:




      Postal / Zip Code:


      Phone Number:

      Fax Number:

     * Please refrain from using free email accounts when ordering (e.g. Yahoo, Hotmail, AOL)
                                                              Page 2 of 2

Payment Information
Please indicate the payment method you would like to use by selecting the appropriate box.

          Pay by credit card:                     American Express

                                                  Diners Club

                                                  Master Card

                                           Cardholder's Name

                                           Cardholder's Signature

                                           Expiry Date

                                           Card Number

                                           CVV Number

                                           Issue Date
                                           (for Diners Club only)

          Pay by check:                    Please post the check, accompanied by this form, to:

                                           Research and Markets,
                                           Guinness Center,
                                           Taylors Lane,
                                           Dublin 8,

                                           Please transfer funds to:
          Pay by wire transfer:
                                           Account number                   833 130 83
                                           Sort code                        98-53-30
                                           Swift code                       ULSBIE2D
                                           IBAN number                      IE78ULSB98533083313083
                                           Bank Address                 Ulster Bank,
                                                                        27-35 Main Street,
                                                                        Co. Dublin,

     If you have a Marketing Code please enter it below:

           Marketing Code:

      Please note that by ordering from Research and Markets you are agreeing to our Terms and Conditions at

                                              Please fax this form to:
                                  (646) 607-1907 or (646) 964-6609 - From USA
                          +353 1 481 1716 or +353 1 653 1571 - From Rest of World

Shared By:
Description: Excel Chapter 4 Financial Functions, Data document sample