Building Financial Models with Microsoft Excel and over one million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
More Buying Choices
Have one to sell? Sell yours here
or
Get a £14.75 Amazon.co.uk Gift Card
Building Financial Models with Microsoft Excel: A Guide for Business Professionals (Wiley Finance)
 
 
Start reading Building Financial Models with Microsoft Excel on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Building Financial Models with Microsoft Excel: A Guide for Business Professionals (Wiley Finance) [Hardcover]

K. Scott Proctor
1.0 out of 5 stars  See all reviews (2 customer reviews)
RRP: £47.50
Price: £35.24 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £12.26 (26%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 2 left in stock--order soon (more on the way).
Want guaranteed delivery by Wednesday, May 30? Choose Express delivery at checkout. See Details

Formats

Amazon Price New from Used from
Kindle Edition £25.08  
Hardcover £35.24  
Trade In this Item for up to £14.75
Trade in Building Financial Models with Microsoft Excel: A Guide for Business Professionals (Wiley Finance) for an Amazon.co.uk gift card of up to £14.75, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

Frequently Bought Together

Building Financial Models with Microsoft Excel: A Guide for Business Professionals (Wiley Finance) + Mastering Financial Modelling in Microsoft Excel: A Practitioner's Guide to Applied Corporate Finance (Financial Times Series) + Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level (Wiley Desktop Editions)
Price For All Three: £119.99

Show availability and delivery details

Buy the selected items together


Product details

  • Hardcover: 384 pages
  • Publisher: John Wiley & Sons; 2nd Edition edition (12 Jan 2010)
  • Language English
  • ISBN-10: 0470481749
  • ISBN-13: 978-0470481745
  • Product Dimensions: 23.7 x 17.2 x 3.1 cm
  • Average Customer Review: 1.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 365,190 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

K. Scott Proctor
Discover books, learn about writers, and more.

Visit Amazon's K. Scott Proctor Page

Product Description

Product Description

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.

From the Inside Flap

Microsoft Excel has become a critical element for decision–making in the modern business environment. It is particularly effective in the logical, step–by–step process of building a financial model—the quantitative representation of a company′s past, present, and future business operations—where each component builds upon or feeds into another component. These financial models serve as the foundation and basis of today′s standard financial accounting reports. But while many business professionals are familiar with consolidated financial statements, few are truly proficient at building an accurate and effective financial model from the ground up.

Building Financial Models with Microsoft Excel, Second Edition offers a detailed and easy–to–understand guide for anyone who needs to build or analyze financial models using Microsoft Excel 2007. 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. K. Scott 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.

Part One covers the steps involved in building the master budget—detailing 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—from sales, inventory, and operating expenses to capital budgets, cash budgets, and balance sheets. Part Two explains consolidated financial statements and free cash flows, providing a guide to building these statements from scratch. Part Three tackles the various ways to analyze a financial model, including sensitivity analysis, contribution margin analysis, and financial ratios analysis. The book also 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.

Filled with in–depth insights and easy–to–understand instructions, this fully revised Second Edition of Building Financial Models with Microsoft Excel is a readable, practical guide to understanding and creating fully functioning financial models.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 


Customer Reviews

5 star
0
4 star
0
3 star
0
2 star
0
Most Helpful Customer Reviews
7 of 8 people found the following review helpful
Format:Hardcover
This book is little more than a paint by numbers exercise in filling out pre-made excel worksheets. The "questions" at the end of each chapter provide no feedback as to what progress you are making. In addition - there is very little analysis or understanding of the financial models presented to the reader. The author simply regurgitates the superficial aspects of each financial model. I'm very disappointed in this book - it claims to be much more than it is. I'm willing to wager my house on the fact that the professors and various luminaries who provide glowing reports on the back cover did not even read it. I know what I am talking about too - I purchased this book as prep for the MBA programme I am about to start at one of the world's top 10 business schools.

I do NOT recommend this book, not even for beginners.
Was this review helpful to you?
2 of 3 people found the following review helpful
Don't Buy It 19 April 2011
Format:Hardcover
This book tries to teach a method of modelling that breaks best practice in the industry. For example its use of names is stupid and doesn't conform to the single formula per row best practice. The idea that you would put 4 columns of quarterly calculation and then annual calculation next to it on the same row is beyond belief.
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:  7 reviews
55 of 58 people found the following review helpful
Hardly a Guide for any Professional in Finance 27 Sep 2006
By S. Shaikh - Published on Amazon.com
Format:Hardcover
Chances are that if you are even thinking about financial modeling you have at least a basic understanding of excel and accounting. If that is the case, this book will prove to be almost completely useless. The modeling examples used within the book are so simplistic that if you have had half a semester in an accounting class you will have a more indepth understanding than what the book provides. Financial valuation is almost non existant as is sensitivity analysis, with each getting a short token chapter. The use of excel is at such a beginner level that I feel as if I did more indepth work with excel attempting to figure out my student loan payments. I have read the book from front to back and feel as if it has provided me with no useful manner in which to conduct any sort of modeling other than in an imaginary world where companies only sell one product, have almost no expenses, collect all their recievables within the next pay period and other such ludicrious assumptions. In addition there are several errors in the examples provided in the book. These made me chuckle since anyone who could catch them would not need the book and anyone who actually needs the book for its rudimentary "guidance" would be left bewildered and confused as to why they got the answers wrong.
25 of 25 people found the following review helpful
goes somewhat beyond introductory Excel 18 Mar 2007
By W Boudville - Published on Amazon.com
Format:Hardcover
The book has some merit to a reader new to Excel, and who wants something a bit more indepth than the Idiots or Dummy's books on Excel. Proctor gives examples that do more with the spreadsheets, and you get to appreciate what Excel can provide.

But, as other reviewers have cogently pointed out, the book really is not for business professionals, despite what the title says. An accountant or businessperson should already have more background on financial modelling with spreadsheets that the level provided here.
26 of 28 people found the following review helpful
WAY too Basic for Most 13 Mar 2007
By Joe Bruce - Published on Amazon.com
Format:Hardcover
This work lacks substance for anyone remotely likely to have to do any real financial analysis. The examples are too simplistic to be of much practical value. If you have virtually no training or experience in Excel or accounting or finance then this book might be worth borrowing from a library to get you up to speed. If you have more than a week of experience in this area then it will sit on the shelf.
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges