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 (http://www.simonbenninga.com) contains lecture notes, PowerPoint-based slides, and a test bank for instructors.
Les mer
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
Les mer

Produktdetaljer

ISBN
9780199755479
Publisert
2010
Utgave
2. utgave
Utgiver
Vendor
Oxford University Press Inc
Vekt
1625 gr
Høyde
237 mm
Bredde
196 mm
Dybde
42 mm
Aldersnivå
05, UP
Språk
Product language
Engelsk
Format
Product format
Innbundet
Antall sider
816

Forfatter

Biographical note

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.