Building financial models with Microsoft Excel : a guide for business professionals / K. Scott Proctor.

Format:

Book

Author/Creator:

Proctor, K. Scott.

Series:

Wiley Finance

Wiley Finance ; v.532

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Corporations--Finance--Computer programs.

Corporations.

Physical Description:

1 online resource (381 p.)

Edition:

2nd ed.

Place of Publication:

Hoboken, NJ : Wiley, 2010.

Language Note:

English

System Details:

text file

Summary:

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, an

Contents:

Building Financial Models with Microsoft® Excel®, Second Edition: A Guide for Business Professionals; Contents; Foreword; Preface; PURPOSE OF THIS BOOK; NEED FOR THIS BOOK; TARGET AUDIENCE FOR THIS BOOK; SUMMARY OF CONTENTS; A FINAL NOTE; 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 BudgetChapter 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 2007 Features and Functionality; BASIC FUNCTIONALITY; FORMATTING

FORMULAS AND FUNCTIONSADVANCED FEATURES; About the CD-ROM; About the Author; Index

Notes:

Includes index.

ISBN:

9786612380112

9781282380110

1282380117

9780470561430

0470561432

OCLC:

503050482