Building Financial Models with Microsoft Excel: A Guide for Business Professionals

 
9780471661030: Building Financial Models with Microsoft Excel: A Guide for Business Professionals
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

From the Inside Flap:

A financial model is a quantitative representation of a company’s past, present, and future business operations. Companies of all types and sizes use financial models every day to analyze and plan their business activities. Financial models serve as the foundation and basis of standard financial accounting reports, including the balance sheet, the income statement, and the statement of cash flows.

While many business professionals are familiar with the "output" of financial models, namely consolidated financial statements, few are truly adept at building an accurate and effective financial model from the ground up. Building Financial Models with Microsoft Excel addresses this real, immediate, and significant issue like no other book. Written in a straightforward and accessible manner, it is a comprehensive resource for business professionals with a beginner or intermediate level of experience in both Microsoft Excel and finance or accounting.

Building a financial model is a logical, step-by-step process, where each component builds upon or feeds into another component. Building Financial Models with Microsoft Excel–organized to closely follow this process–is divided into three major parts and includes a companion CD-ROM, which contains sample Excel worksheets that allow you to follow the examples illustrated within the book or build your own financial models according to your specific situation.

Part One of Building Financial Models with Microsoft Excel introduces the concepts of budgets and financial models, and covers the steps involved in building the master budget –as well as its two key elements, the operating budget and financial budget. You’ll learn the fundamentals of the budgeting process and how various components of a master budget relate to one another. The master budget template provided in this part of the book serves as a road map for building each individual component of the financial model.

Part Two of this book deals with a company’s consolidated financial statements and free cash flows. It provides you with a guide to building these statements from scratch, based upon the operating and financial budgets of a company. The final part of Building Financial Models with Microsoft Excel–Part Three–deals with several important topics, including: various ways to analyze a financial model; the concept of valuation; and capitalization, or ownership, charts.

Filled with in-depth insights and easy-to-understand instructions, Building Financial Models with Microsoft Excel is a practical guide to understanding and creating fully functioning financial models.

From the Back Cover:

Praise for Building Financial Models with Microsoft Excel

"Scott Proctor offers a comprehensive and easy-to-understand guide to constructing and using financial models; I recommend this book as a tutorial and a reference for business professionals, entrepreneurs, venture capitalists, and angel investors."
–Jack M. Gill, PhD, Vanguard Ventures

"This book is about making good decisions. . . . The modeling tools described in this book establish an analytical framework which adds much needed clarity to effective decision-making. This in-depth guide should well serve experienced professionals as a reference and business students and entrepreneurs as a tutorial."
–Eugene V. Fife, Retired Chairman, Goldman Sachs International

"Excel has become a critical element for decision-making in the modern business environment. Mr. Proctor’s book is a solid introduction to utilizing this complex tool."
–William Polk Carey, Chairman and Founder, W.P. Carey & Co. LLC

"Readable, comprehensive, and engaging–buy this book; study it; and thereby build your capacity to harness the computer in the solution of real-world business problems."
–Robert F. Bruner, Distinguished Professor of Business Administration and Executive Director of the Batten Institute, Darden Graduate Business School, University of Viginia

"Proctor provides a thoughtful and coherent link between financial/accounting theory and common Wall Street practice by addressing key questions in financial modeling like what to build, how to build, and how to analyze."
–Reid Nagle, Chairman and Founder, SNL Financial LC

"This book offers an excellent guide to building financial models. Proctor guides readers through the many interrelated steps involved in constructing and using financial models, a vital skill in today’s business world."
–Jeffrey Nuechterlein, Managing Partner, Isis Capital

"Building Financial Models with Microsoft Excel takes a complex but critical subject and presents it in a concise, easy-to-follow fashion. This book is an indispensable reference guide for anyone who needs to build or analyze financial models using Microsoft Excel."
–Michael R. Lincoln, Partner, Cooley Godward LLP

"A get-serious, get-gritty modeling enabler that is thoughtfully written and executed."
–Robert Albertson, Principal and Chief Strategist, Sandler O’Neill & Partners, LP

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Proctor, K. Scott
Published by Wiley
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Hardcover Quantity Available: 8
International Edition
Seller:
WFL
(Holtsville, NY, U.S.A.)
Rating
[?]

Book Description Wiley. Hardcover. Condition: New. 0471661031 New ,International Edition , Paperback , Same text as US edition , ISBN /Cover may be different , Ready to ship, Express 5-8 business days worldwide delivery. Seller Inventory # INFHRA1057

More information about this seller | Contact this seller

Buy New
US$ 12.89
Convert Currency

Add to Basket

Shipping: US$ 4.90
Within U.S.A.
Destination, Rates & Speeds

2.

Proctor, K. Scott
Published by John Wiley & Sons Inc (2004)
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Hardcover Quantity Available: 1
Seller:
Revaluation Books
(Exeter, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons Inc, 2004. Hardcover. Condition: Brand New. hardback/cd-rom edition. 347 pages. 9.25x6.25x1.50 inches. In Stock. Seller Inventory # zk0471661031

More information about this seller | Contact this seller

Buy New
US$ 23.24
Convert Currency

Add to Basket

Shipping: US$ 8.37
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

K. Scott Proctor (SNL Financial)
Published by John Wiley and Sons
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description John Wiley and Sons. Condition: New. Brand New. Seller Inventory # 0471661031

More information about this seller | Contact this seller

Buy New
US$ 31.69
Convert Currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, Rates & Speeds

4.

Proctor, K. Scott
Published by Wiley (2004)
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Hardcover Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Wiley, 2004. Hardcover. Condition: New. Never used!. Seller Inventory # P110471661031

More information about this seller | Contact this seller

Buy New
US$ 38.24
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

5.

K. Scott Proctor
Published by John Wiley and Sons Ltd, United States (2004)
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description John Wiley and Sons Ltd, United States, 2004. CD-ROM. Condition: New. Language: English . Brand New. 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. Seller Inventory # BZV9780471661030

More information about this seller | Contact this seller

Buy New
US$ 49.24
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Scott Proctor, K.:
Published by John Wiley & Sons, (2004)
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Quantity Available: 1
Seller:
Memorah.Book
(Basel-Stadt, Switzerland)
Rating
[?]

Book Description John Wiley & Sons, 2004. Gebundene Ausgabe. Condition: Neu. 384 Seiten 43680 Sprache: Englisch Gewicht in Gramm: 567. Seller Inventory # 78956

More information about this seller | Contact this seller

Buy New
US$ 33.61
Convert Currency

Add to Basket

Shipping: US$ 17.87
From Switzerland to U.S.A.
Destination, Rates & Speeds

7.

K. Scott Proctor
Published by John Wiley and Sons Ltd, United States (2004)
ISBN 10: 0471661031 ISBN 13: 9780471661030
New Quantity Available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description John Wiley and Sons Ltd, United States, 2004. CD-ROM. Condition: New. Language: English . Brand New. 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. Seller Inventory # BZV9780471661030

More information about this seller | Contact this seller

Buy New
US$ 64.01
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds