Principles of Finance with Excel

Principles of Finance with Excel

4.11 (43 ratings by Goodreads)
By (author) 

List price: US$148.95

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


Finance is a topic that requires much computation, and in today's business world that computation is done almost entirely using Excel. Despite this, existing finance textbooks continue to rely heavily on hand calculators. Business school students-whose background in Excel is often weak when they come into finance courses-find that when they leave the academic environment they have to relearn both finance and Excel. Addressing this issue, Principles of Finance with Excel is the only introductory finance text that comprehensively integrates Excel into the teaching and practice of finance. Offering exceptional resources for students and instructors, the book combines classroom-tested pedagogy with the powerful functions of Excel. Author Simon Benninga-one of the most recognized names in financial modeling-shows students how spreadsheets provide new and deeper insights into financial decision making.
The second edition of Principles of Finance with Excel covers the same topics as standard financial textbooks-including portfolios, capital asset pricing models, stock and bond valuation, capital structure and dividend policy, and option pricing-and can therefore be used in any introductory course. However, it also introduces Excel as it applies to finance students and practitioners. Throughout Principles of Finance with Excel, the implementation of finance concepts with Excel is demonstrated and explained. A separate section of PFE provides thorough coverage of all Excel topics used in the book: graphs, function data tables, dates in Excel, Goal Seek and Solver.
New to this Edition * Offers a streamlined structure that allows students to dive right into the heart of finance: time value of money and discounting * Provides updated examples, most of which refer to the post-2008-crash financial world * Uses Excel 2007 throughout (all examples and spreadsheets are compatible with previous versions of Excel) * The free in-text CD-ROM includes electronic spreadsheets for the entire book Principles of Finance with Excel, Second Edition, is ideal for undergraduate courses in introductory finance and graduate courses in finance and business, or as a reference for finance professionals. An author-maintained companion website ( contains lecture notes, PowerPoint-based slides, and a test bank for instructors.
show more

Product details

  • Hardback | 816 pages
  • 196 x 237 x 42mm | 1,625g
  • New York, United States
  • English
  • Revised
  • 2nd Revised edition
  • 0199755477
  • 9780199755479
  • 235,342

Table of contents

PrefaceSection 1: Capital Budgeting and ValuationChapter 1: Introduction to financeChapter 2: The time value of moneyChapter 3: What does it cost? IRR and the time value of moneyChapter 4: Introduction to capital budgetingChapter 5: Issues in capital budgetingChapter 6: Choosing a discount rateChapter 7: Using financial planning models for valuationSection 2: Portfolio Analysis and the Capital Asset Pricing ModelChapter 8: What is risk?Chapter 9: Statistics for portfoliosChapter 10: Portfolio returns and the efficient frontierChapter 11: The capital asset pricing model (CAPM) and the security market line (SML)Chapter 12: Using the security market line (SML) to measure performanceChapter 13: The security market line (SML) and the cost of capital
Section 3: Valuing SecuritiesChapter 17: Efficient markets-some general principles of security valuationChapter 15: Bond valuationChapter 16: Share valuation
Section 4: Capital Structure and Dividend PolicyChapter 17: Capital structure and the value of the firmChapter 18: The evidence on capital structureChapter 19: Dividend policySection 5: Options and Option ValuationChapter 20: Introduction to optionsChapter 21: Option pricing factsChapter 22: Option pricing-the Black-Scholes formulaChapter 23: The binomial option pricing modelSection 6: Background to ExcelChapter 24: Introduction to ExcelChapter 25: Graphs and charts in ExcelChapter 26: Excel functionsChapter 27: Using Data TablesChapter 28: Using Goal Seek and SolverChapter 29: Working with dates in Excel
show more

About Simon Benninga

Simon Benninga is Professor of Finance at Tel Aviv University and Visiting Professor of finance at the Wharton School of the University of Pennsylvania. His books on financial modeling and valuation are standards in the field of finance and have been translated into Japanese, Chinese, Russian, Polish, and Italian.
show more

Rating details

43 ratings
4.11 out of 5 stars
5 37% (16)
4 40% (17)
3 21% (9)
2 2% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X