Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition by K. Scott Proctor

Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition by K. Scott Proctor
Item# 11052011536
Retail price: US$45.99
Sale price: US$7.50

all items in this store are to be sent to your email within 24 hours after cleared payment. PDF eBooks are sent to you as email attachments. as for mp3 audiobook, a download link from ONEDRIVE will be sent to your email for you to download.

1. This item is an E-Book in PDF format.

2. Shipping & Delivery: Send to you by E-mail within 24 Hours after cleared payment. Immediately Arrival!!!

3. Shipping ( by email) + Handling Fee = US$0.00

4. Time-Limited Offer, Order Fast.


Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition

by K. Scott Proctor


Adobe E-Book 352 pages November 2009


A proven guide to building financial models from scratch

The 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 model Incorporating 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.


Foreword. Preface.


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.


General Overview of Microsoft Excel 2007 Features and Functionality.

About the CD-ROM.

About the Author.



K. Scott Proctor, CFA, is Executive Director at AstraZeneca Pharmaceuticals, a leading global pharmaceutical company. He has experience across the fields of information technology, finance, and science. Prior to his role at AstraZeneca, Proctor was Chief Information Officer (CIO) of General Electric (GE) Healthcare Life Sciences, based in Uppsala, Sweden. Proctor was also a founding Principal of Vawter Capital, a private equity investment firm, and the Director of Investment Analytics at SNL Financial, a financial information provider. Prior to that, Proctor was the acting Chief Financial Officer (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. Proctor is also Foundation Level Certified in ITIL V3 IT Service Management.