We use cookies to enhance your experience on our website. By continuing to use our website, you are agreeing to our use of cookies. You can change your cookie settings at any time. Find out more

Cover

Principles of Finance with Excel

Second Edition

Simon Benninga

Publication Date - September 2010

ISBN: 9780199755479

816 pages
Hardcover
8 x 10 inches

In Stock

Retail Price to Students: $117.95

Now in its second edition, Simon Benninga provides what is still the only introductory finance text that comprehensively integrates Excel into the teaching and practice of finance

Description

Finance is a topic that requires much computation, and in today's business world that computation is done almost entirely using Excel software. Despite this, existing finance textbooks continue to rely heavily on hand calculators. Business school students--whose background in Excel software is often weak when they come into finance courses--find that when they leave the academic environment they have to relearn both finance and the software. Addressing this issue, Principles of Finance with Excel is the only introductory finance text that comprehensively integrates the program 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 software. 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 software as it applies to finance students and practitioners. Throughout the book, the implementation of finance concepts with Excel software is demonstrated and explained. A separate section of PFE provides thorough coverage of all Excel software topics used in the book: graphs, function data tables, dates, Goal Seek, and Solver.

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 (http://www.simonbenninga.com) contains lecture notes and PowerPoint-based slides.

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 Microsoft Excel 2007 throughout (all examples and spreadsheets are compatible with previous versions of the program)
  • The free in-text CD-ROM includes electronic spreadsheets for the entire book

About the Author(s)

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.

Previous Publication Date(s)

January 2006

Table of Contents

    Preface

    PART 1: CAPITAL BUDGETING AND VALUATION

    Chapter 1.
    Introduction to Finance
    Chapter 2.
    The Time Value of Money
    Chapter 3:
    What Does It Cost? IRR and the Time Value of Money
    Chapter 4.
    Introduction to Capital Budgeting
    Chapter 5.
    Issues in Capital Budgeting
    Chapter 6.
    Choosing a Discount Rate
    Chapter 7.
    Using Financial Planning Models for Valuation

    PART 2: PORTFOLIO ANALYSIS AND THE CAPITAL ASSET PRICING MODEL

    Chapter 8.
    What is Risk?
    Chapter 9.
    Statistics for Portfolios
    Chapter 10.
    Portfolio Returns and the Efficient Frontier
    Chapter 11.
    The Capital Asset Pricing Model (CAPM) and the Security Market Line (SML)
    Chapter 12.
    Using the Security Market Line (SML) to Measure Investment Performance
    Chapter 13.
    The Security Market Line (SML) and the Cost of Capital

    PART 3: VALUING SECURITIES

    Chapter 14.
    Efficient Markets-Some General Principles of Security Valuation
    Chapter 15.
    Bond Valuation
    Chapter 16.
    Valuing Stocks

    PART 4. CAPITAL STRUCTURE AND DIVIDEND POLICY

    Chapter 17.
    Capital Structure and the Value of the Firm
    Chapter 18.
    The Evidence on Capital Structure
    Chapter 19.
    Dividend Policy

    PART 5. OPTIONS AND OPTION VALUATION

    Chapter 20.
    Introduction to Options
    Chapter 21.
    Option Pricing Facts
    Chapter 22.
    Option Pricing - The Black-Scholes Formula
    Chapter 23.
    The Binomial Option-Pricing Model

    SECTION 6. BACKGROUND TO EXCEL

    Chapter 24.
    Introduction to Excel
    Chapter 25.
    Graphs and Charts in Excel
    Chapter 26.
    Excel Functions
    Chapter 27.
    Data Tables
    Chapter 28.
    Using Goal Seek and Solver
    Chapter 29.
    Working with Dates in Excel