Building Financial Models with Microsoft Excel : A Guide for Business Professionals,9780471693208

Building Financial Models with Microsoft Excel : A Guide for Business Professionals

by
ISBN13: 9780471693208
ISBN10: 0471693200
Format: eBook
Pub. Date: 2004-11-01
Publisher(s): WILEY
Availability: This title is currently not available.
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $57.75

Rent Book

Select for Price
Add to Cart
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

A comprehensive guide to building financial models Building Financial Models with Microsoft Excel + CD-ROM provides beginning or intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow readers to build their own financial models. This comprehensive resource also covers important topics such as the concept of valuation, the concept of sensitivity analysis, the concepts of contribution margin and financial ratios and the basics of building and using a Capitalization Table. K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.

Author Biography

K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial

Table of Contents

Foreword.
Preface.
Acknowledgments.
PART ONE: THE MASTER BUDGET.
Chapter 1. Overview of Budgets and Financial Models.
Chapter 2. Operating Budget—Assumptions, Sales, and Collections.
Chapter 3. Operating Budget—Cost of Goods Sold, Inventory, and Purchases.
Chapter 4. Operating Budget—Operating Expenses.
Chapter 5. Operating Budget—Income Statement.
Chapter 6. Financial Budget—Capital Budget and Cash Budget.
Chapter 7. Financial Budget—Balance Sheet.
PART TWO: FINANCIAL STATEMENTS AND FREE CASH FLOWS.
Chapter 8. Consolidated Financial Statements.
Chapter 9. Free Cash Flows and Dashboard.
PART THREE: ANALYSIS OF A FINANCIAL MODEL.
Chapter 10. Sensitivity Analysis.
Chapter 11. Contribution Margin Analysis.
Chapter 12. Financial Ratios Analysis.
Chapter 13. Valuation.
Chapter 14. Capitalization Chart.
Answers to Chapter Questions.
Appendix: General Overview of Microsoft Excel Features and Functionality.
About the CD-ROM.
Index.

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.