Overview

Finance is a topic that requires much computation, and in today’s business world that computation is almost entirely done using Microsoft Excel. Despite this, existing finance textbooks continue to rely heavily on hand calculators, and business school students find that when they leave the academic environment they have to relearn finance using 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. The second edition covers the same topics as standard financial textbooks, including portfolios, capital asset pricing models, stock and bond valuation, capital structure, and dividend and optional policy, and can therefore be used in any introductory course. However, this text also introduces Excel as it applies to finance students, demonstrating and explaining the implementation of finance concepts with Excel, and providing thorough coverage of all Excel topics including graphs, function data tables, dates in Excel, Goal Seek, and Solver. Combining classroom-tested pedagogy with the powerful functions of Excel, Simon Benninga, one of the most recognised names in financial modelling, shows students how spreadsheets can provide new and deeper insights into financial decision making.    

Full Product Details

Author:   Simon Benninga (Tel Aviv University; University of Pennsylvania)
Publisher:   Oxford University Press Inc
Imprint:   Oxford University Press Inc
Edition:   2nd Revised edition
Dimensions:   Width: 19.60cm , Height: 4.20cm , Length: 23.70cm
Weight:   1.625kg
ISBN:  

9780199755479

ISBN 10:   0199755477
Pages:   816
Publication Date:   25 November 2010
Audience:   College/higher education ,  Postgraduate, Research & Scholarly
Format:   Hardback
Publisher's Status:   Active
Availability:   To order  
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

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

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions