Financial Modeling Using Excel and VBA (Wiley Finance)

✍ Scribed by Chandan Sengupta

• Publisher: Wiley
• Year: 2004
• Tongue: English
• Leaves: 670
• Series: Wiley Finance
• Category: Library

✦ Synopsis

I must agree with the other reviewers of Sengupta's very weak effort. This book is overly simplistic and of very little use to any true financial professional. For an excellent overview of financial modeling in general, look at Ragsdale 5e or The Art of Modeling with Spreadsheets by Powell of the Tuck School. For excellent treatment of robust financial statement analysis and valuation, look at Penman 4e, McKinsey 4e, or Damordaran on Valuation. For utilizing Excel for general Corporate Finance applications, look at Financial Modeling Benninga 3e or Benninga's Principles of Finance with Excel. For an excellent treatment of how powerfully VBA can be utilized in general financial modeling, look at A Fast Track to Structured Finance by William Preinitz or Evan Tick's similar title. In my opinion, both are an excellent value and provide a tremendous learning experience for the serious student or practionier.There are many far more useful texts than Sengupta's. Save your money and do not purchase this title unless you are a true novice and very new to financial statements and/or Excel.

✦ Table of Contents

Financial Modeling Using Excel and VBA......Page 3
Contents......Page 9
About This Book......Page 13
CHAPTER 1 Introduction to Financial Modeling......Page 17
Part One: Excel for Financial Modeling......Page 27
CHAPTER 2 Excel Basics......Page 29
Improving Your Excel Skills......Page 30
The Basic Excel Features......Page 36
CHAPTER 3 Advanced Excel Features......Page 45
CHAPTER 4 Excel’s Built-In Functions and Analysis Tools......Page 87
Financial Functions......Page 89
Statistical Functions......Page 102
Mathematical and Trigonometric Functions......Page 113
Lookup and Reference Functions......Page 117
Date and Time Functions......Page 123
Text Functions......Page 126
Information Functions......Page 128
The Analysis ToolPak......Page 129
Part Two: Financial Modeling Using Excel......Page 133
Attributes of Good Excel Models......Page 135
Documenting Excel Models......Page 138
Debugging Excel Models......Page 140
Using Formula Auditing Tools for Debugging......Page 143
Learning Modeling Using Excel......Page 144
Review of Theory and Concepts......Page 147
Modeling Examples......Page 157
Review of Theory and Concepts......Page 201
Modeling Examples......Page 215
Review of Theory and Concepts......Page 239
Modeling Examples......Page 246
Review of Theory and Concepts......Page 263
Modeling Examples......Page 268
Review of Theory and Concepts......Page 283
Modeling Examples......Page 290
Review of Theory and Concepts......Page 301
Modeling Examples......Page 311
Review of Theory and Concepts......Page 323
Modeling Examples......Page 333
Review of Theory and Concepts......Page 361
Modeling Examples......Page 365
Part Three: VBA for Financial Modeling......Page 377
CHAPTER 14 Introduction to VBA......Page 379
Example of a VBA Model......Page 384
Recording Macros......Page 394
Using VBA’s Help......Page 398
The Strategy to Learn VBA Efficiently......Page 400
CHAPTER 15 VBA Essentials......Page 401
The Visual Basic Editor......Page 402
Some Basics......Page 406
Variables, Constants, and Arrays......Page 417
Objects, Properties, and Methods......Page 429
Branching......Page 433
Looping......Page 439
Using Built-In Functions......Page 446
Sub Procedures......Page 449
Functions Procedures......Page 454
CHAPTER 17 Debugging VBA Models......Page 461
Part Four: Financial Modeling Using VBA......Page 467
Attributes of Good VBA Models......Page 469
Documenting VBA Models......Page 473
Learning Modeling Using VBA......Page 475
Review of Theory and Concepts......Page 479
Modeling Examples......Page 483
Modeling Examples......Page 535
Modeling Examples......Page 565
Modeling Examples......Page 591
Modeling Examples......Page 599
Modeling Examples......Page 615
Appendix A Keyboard Shortcuts for Excel......Page 629
Appendix B VBA Quick Reference......Page 631
Appendix C Excel and VBA Built-In Functions......Page 633
Index......Page 651

✦ Subjects

Финансово-экономические дисциплины;Финансовая математика;