Chandan Sengupta

Financial Modeling Using Excel and VBA (eBook, PDF)

• Format: PDF

Produktbeschreibung

Comprehensive instruction on developing real-world financial models This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 464
• Erscheinungstermin: 1. April 2004
• Englisch
• ISBN-13: 9780471651093
• Artikelnr.: 38184175

Autorenporträt

CHANDAN SENGUPTA teaches at the Fordham University Graduate School of Business Administration, 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 the author of The Only Proven Road to Investment Success, also published by Wiley.

Inhaltsangabe

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