Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition
by K. Scott Proctor (SNL Financial)Format: eBook
Pub. Date: 2009-11-01
Publisher(s): Wiley
Availability: This title is currently not available.
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $73.50
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
Summary
A proven guide to building financial models from scratchThe Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow you to build your own financial models. This comprehensive resource also covers important topics such as the concepts of valuation, sensitivity analysis, and contribution margin. Offers accessible guidance on building financial models using Excel 2007 Illustrates how to integrate financial statements such as the balance sheet, income statement, and statement of cash flows Covers the basics of building and using a Capitalization Table Discusses how to best present a financial modelIncorporating financial models into business decisions has become an essential element of good business practice, and this book will show you how to excel at this endeavor.
Table of Contents
| Foreword | |
| Preface | |
| Acknowledgments | |
| The Master Budget | |
| Overview of Budgets and Financial Models | |
| Operating Budget-Assumptions, Sales, and Collections | |
| Operating Budget-Cost of Goods Sold, Inventory, and Purchases | |
| Operating Budget-Operating Expenses | |
| Operating Budget-Income Statement | |
| Financial Budget-Capital Budget and Cash Budget | |
| Financial Budget-Balance Sheet | |
| Financial Statements and Free Cash Flows | |
| Consolidated Financial Statements | |
| Free Cash Flows and Dashboard | |
| Analysis of a Financial Model | |
| Sensitivity Analysis | |
| Contribution Margin Analysis | |
| Financial Ratios Analysis | |
| Valuation | |
| Capitalization Chart | |
| Answers to Chapter Questions | |
| Appendix | |
| General Overview of Microsoft Excel 2007 Features and Functionality | |
| About the CD-ROM | |
| About the Author | |
| 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.