Building Financial Models with Microsoft Excel

A Guide for Business Professionals - Includes CD-ROM with Financial Model Spreadsheets

K. Scott Proctor - Collection Wiley Finance

347 pages, parution le 15/11/2004

Ajouter à une liste

Indisponible

Résumé

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.

L'auteur - K. Scott Proctor

K. Scott Proctor, CFA, is the Director of Investor Analytics at SNL Financial, a financial information provider.

Sommaire

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 Features and Functionality
About the CD-ROM
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	K. Scott Proctor
Collection	Wiley Finance
Parution	15/11/2004
Nb. de pages	347
Format	16 x 23,5
Couverture	Relié
Poids	594g
Intérieur	Noir et Blanc
EAN13	9780471661030
ISBN13	978-0-471-66103-0