Financial Analysis and Modeling Using Excel and VBA
Home > Business and Economics > Finance and accounting > Finance and the finance industry > Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)
Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)

Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)

|
     0     
5
4
3
2
1




International Edition


About the Book

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.

Table of Contents:
About This Book xix CHAPTER 1 Introduction to Financial Analysis and Modeling 1 Steps in Creating a Model 5 How This Book Is Organized 9 Part One Excel for Financial Analysis and Modeling CHAPTER 2 Excel 2007 and the Previous Versions 15 The New Features in Excel 2007 15 The New User Interface 16 Other New Features 19 New File Formats in Excel 2007 23 CHAPTER 3 Excel Basics 25 Improving Your Excel Skills 26 The Basic Excel Features 32 Naming Workbooks and Worksheets 33 Finding the Commands You Need 33 Working with Worksheets 33 Working with Rows, Columns, and Cells 34 Using the Toolbars 34 Using Keyboard Shortcuts 34 Navigating the Worksheet 36 Formatting 36 Entering and Working with Formulas 37 Using Paste Special 37 Controlling the Worksheet View 38 Using Undo and Redo 38 Customizing the Excel Work Environment 38 Controlling When Formulas Are Calculated 39 Printing 39 Creating Charts 40 Working with More Than One Workbook 40 Using the Scroll Lock 41 CHAPTER 4 Advanced Excel Features 43 Copying Formulas Using Absolute and Relative Cell References 46 Using Names in Formulas 56 A1 and R1C1 Reference Styles 57 Using Comments in Cells 58 Data Validation 60 Controls 62 Custom Number Formats 65 Hiding and Protecting 67 Custom Views 71 Arrays and Array Formulas 72 Outline 75 CHAPTER 5 Making Decisions and Looking Up Values 77 Making Decisions 78 Looking Up Values 97 Conditional Formatting 103 CHAPTER 6 Analyzing Databases 109 Sorting 112 Filtering 120 Tables 124 PivotTable 135 CHAPTER 7 Answering What-If Questions 161 Data Tables 162 Scenario Manager 166 CHAPTER 8 Finding Iterative Solutions 171 Circular Reference 171 Goal Seek 174 Solver 177 CHAPTER 9 Doing Statistical Analysis 185 Descriptive Statistics 187 Frequency Distributions and Histograms 192 Counting, Ranking, and Calculating Quantiles 195 Normal Probability Distributions 203 Random Numbers 207 Statistical Tests 218 CHAPTER 10 Using the Financial Functions 221 Annuity Functions 221 Investment Analysis Functions 228 Bond Functions 232 Depreciation Functions 237 CHAPTER 11 Other Useful Excel Functions 243 Mathematical Functions 243 Date and Time Functions 248 Text Functions 251 Information Functions 254 Part Two Financial Modeling Using Excel CHAPTER 12 Building Good Excel Models and Debugging Them 257 Attributes of Good Excel Models 257 Documenting Excel Models 260 Debugging Excel Models 262 Using Formula Auditing Tools for Debugging 265 Learning Modeling Using Excel 267 CHAPTER 13 Financial Statements Forecasting 271 Review of Theory and Concepts 271 Modeling Examples 281 CHAPTER 14 Time Value of Money 327 Review of Theory and Concepts 327 Modeling Examples 341 CHAPTER 15 Financial Planning and Investments 365 Review of Theory and Concepts 365 Some Basic Issues 365 Saving and Investing for Retirement 368 Structuring Portfolios 371 Modeling Examples 372 Model 1: Return with Changing Reinvestment Rates 372 Model 2: Saving for Retirement 376 Model 3: Retirement Planning in Real Dollars 379 Model 4: Retirement Planning in Nominal Dollars 380 Model 5: Portfolio Structuring 385 CHAPTER 16 Analyzing Market History 389 Review of Theory and Concepts 389 Modeling Examples 394 CHAPTER 17 Bond Pricing and Duration 409 Review of Theory and Concepts 409 Modeling Examples 416 CHAPTER 18 Simulating Stock Prices 427 Review of Theory and Concepts 427 Modeling Examples 438 CHAPTER 19 Options and Option Portfolios 449 Review of Theory and Concepts 449 Modeling Examples 460 CHAPTER 20 Binomial Option Pricing 487 Review of Theory and Concepts 487 Modeling Examples 491 Model 1: European Options on Stocks with Known Dividend Yield 491 Model 2: American Options on Stocks Paying No Dividend 495 Model 3: American Options on Stocks with Known Dividend Yields 498 Model 4: American Options on Stocks with Known Dollar Dividends 500 Part Three VBA for Financial Modeling CHAPTER 21 Introduction to VBA 505 Example of a VBA Model 510 Recording Macros 520 Using VBA’s Help 524 The Strategy to Learn VBA Efficiently 526 CHAPTER 22 VBA Essentials 529 The Visual Basic Editor 530 Some Basics 535 Variables, Constants, and Arrays 545 Objects, Properties, and Methods 557 Branching 561 Looping 567 Using Built-In Functions 574 CHAPTER 23 Sub and Function Procedures 577 Sub Procedures 577 Function Procedures 582 CHAPTER 24 Debugging VBA Codes 589 The Four Basic Types of Bugs 590 The VBA Debugging Tools 591 Part Four Financial Modeling Using VBA CHAPTER 25 How to Build Good VBA Models 597 Attributes of Good VBA Models 597 Documenting VBA Models 601 Learning Modeling Using VBA 603 CHAPTER 26 Time Value of Money 607 Review of Theory and Concepts 607 Modeling Examples 611 CHAPTER 27 Financial Planning and Investments 663 Modeling Examples 663 CHAPTER 28 Analyzing Market History 691 Modeling Examples 691 CHAPTER 29 Simulating Stock Prices 717 Modeling Examples 717 CHAPTER 30 Options and Option Portfolios 725 Modeling Examples 725 CHAPTER 31 Binomial Option Pricing 741 Modeling Examples 741 APPENDIX A Keyboard Shortcuts for Excel 755 APPENDIX B VBA Quick Reference 757 APPENDIX C Excel and VBA Built-In Functions 759 About the CD-ROM 777 Index 781


Best Sellers


Product Details
  • ISBN-13: 9780470275603
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: John Wiley & Sons Inc
  • Height: 234 mm
  • No of Pages: 816
  • Returnable: N
  • Spine Width: 43 mm
  • Width: 191 mm
  • ISBN-10: 047027560X
  • Publisher Date: 24 Nov 2009
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Series Title: Wiley Finance
  • Weight: 1429 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)
John Wiley & Sons Inc -
Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Financial Analysis and Modeling Using Excel and VBA: (Wiley Finance)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!