Building Financial Models with Microsoft Excel : A Guide for Business Professionals
by Proctor, K. ScottEdition: 1st
Format: Hardcover
Pub. Date: 2004-10-04
Publisher(s): WILEY
Other versions by this Author
List Price: $55.00
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
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, a financial information provider. Mr. Proctor was also a founding Principal of Vawter Capital, a private equity investment firm that focuses primarily on early- to mid-stage, entrepreneurial, privately held, technology-oriented enterprises in the healthcare, communications, and financial services industries. Mr. Proctor also served as the acting CFO of Illuminis, an Intel- and MCI-funded healthcare information systems company. He earned his BA, MBA, and MS (Management Information Systems) from the University of Virginia.
Table of Contents
| Foreword | p. xi |
| Preface | p. xiii |
| Acknowledgments | p. xix |
| The Master Budget | |
| Overview of Budgets and Financial Models | p. 3 |
| Operating Budget--Assumptions, Sales, and Collections | p. 20 |
| Operating Budget--Cost of Goods Sold, Inventory, and Purchases | p. 40 |
| Operating Budget--Operating Expenses | p. 60 |
| Operating Budget--Income Statement | p. 76 |
| Financial Budget--Capital Budget and Cash Budget | p. 95 |
| Financial Budget--Balance Sheet | p. 125 |
| Financial Statements and Free Cash Flows | |
| Consolidated Financial Statements | p. 147 |
| Free Cash Flows and Dashboard | p. 165 |
| Analysis of a Financial Model | |
| Sensitivity Analysis | p. 187 |
| Contribution Margin Analysis | p. 201 |
| Financial Ratios Analysis | p. 220 |
| Valuation | p. 244 |
| Capitalization Chart | p. 267 |
| Answers to Chapter Questions | p. 279 |
| General Overview of Microsoft Excel Features and Functionality | p. 313 |
| About the CD-ROM | p. 337 |
| Index | p. 341 |
| Table of Contents provided by Rittenhouse. 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.