Financial Modeling Using Excel and VBA

by ;
Format: eBook
Pub. Date: 2004-04-01
Publisher(s): Wiley
Availability: This title is currently not available.
List Price: $101.65

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

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. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).

Table of Contents

About This Book
Introduction to Financial Modeling
Excel for Financial Modeling.
Excel Basics
Advanced Excel Features
Excel's Built-In Functions and Analysis Tools
Financial Modeling Using Excel.
How to Build Good Excel Models
Financial Statements Forecasting
Time Value of Money
Financial Planning and Investments
Analyzing Market History
Bond Pricing and Duration
Simulating Stock Prices
Options and Option Portfolios
Binomial Option Pricing
VBA for Financial Modeling.
Introduction to VBA
VBA Essentials
Sub and Function Procedures
Debugging VBA Models
Financial Modeling Using VBA.
How to Build Good VBA Models
Time Value of Money
Financial Planning and Investments
Analyzing Market History
Simulating Stock Prices
Options and Option Portfolios
Binomial Option Pricing
Keyboard Shortcuts for Excel
VBA Quick Reference
Excel and VBA Built-In Functions
Index
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.