Principles of Finance with Excel is simply the best book available for teaching financial principles using Excel. Its main competitors don't even come close.

Steve Slezak, Cal Poly

I use Principles of Finance with Excel because I am really convinced that Excel is an extraordinary tool to teach finance. First, it helps painlessly solve problems that involve tedious computations. Second, it forces students to frame a problem in a way that fits with Excel. The major strength of this text is that it allows students to understand finance almost effortlessly.

Fabrice Riva, Université Lille 1, France

This text provides students with an introduction to Excel skills and a good review on finance. It also helps them prepare for job markets. The third edition is more organized and focused.

Lei Gao, University of Memphis

Offering exceptional resources for students and instructors, Principles of Finance with Excel, Third Edition, combines classroom-tested pedagogy with the powerful functions of Excel software. Authors Simon Benninga and Tal Mofkadi show students how spreadsheets provide new and deeper insights into financial decision making. The third 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. For each topic, the authors provide step-by-step instruction on how to use Excel functions to help with relevant decision-making. A separate section of PFE (Chapters 21-26) reviews all Excel functions used in the book, including graphs, function data tables, dates, Goal Seek, and Solver. Visit www.oup.com/us/benninga for student and instructor resources, including all the spreadsheets used as examples in the text and in the end-of-chapter problems.
Les mer
Part One: Capital Budgeting and Valuation1. Introduction to Finance2. The Time Value of MoneyAppendix 2.1. Algebraic Present Value FormulasAppendix 2.2. Annuity Formulas in Excel3. Measures for Evaluation of Investment Opportunities4. Loans and Amortization Tables5. Effective Interest Rates6. Capital Budgeting: Valuing Business Cash FlowsPart Two: Portfolio Analysis and the Capital Asset Pricing Model7. What is Risk?8. Statistics for PortfoliosAppendix 8.1. Downloading Data from Yahoo9. Portfolio Diversification and Market Risk10. Risk Diversification and the Efficient FrontierAppendix 10.1. Deriving the Formula for the Minimum Variance PortfolioAppendix 10.2. Portfolios with Three and More Assets11. The Capital Asset Pricing Model (CAPM) and the Security Market Line (SML)12. Measuring Investment Performance13. The Security Market Line (SML) and the Cost of CapitalPart Three: Valuing Securities14. Efficient Markets--Some General Principles of Security Valuation15. Bond Valuation16. Stock ValuationPart Four: Options17. Introduction to Options18. Option Pricing Facts and Arbitrage19. Option pricing: The Black-Scholes FormulaAppendix 19.1 Getting Option Information from Yahoo20.The Binomial Option Pricing ModelPart Five: Excel Skills21. Introduction to Excel22. Graphs and Charts in Excel23. Excel Functions24. Using Data Tables25. Using Goal Seek and Solver26. Working with Dates in Excel
Les mer
"Principles of Finance with Excel is simply the best book available for teaching financial principles using Excel. Its main competitors don't even come close." – Steve Slezak, Cal Poly"I use Principles of Finance with Excel because I am really convinced that Excel is an extraordinary tool to teach finance. First, it helps painlessly solve problems that involve tedious computations. Second, it forces students to frame a problem in a way that fits with Excel. The major strength of this text is that it allows students to understand finance almost effortlessly." – Fabrice Riva, Université Lille 1, France"This text provides students with an introduction to Excel skills and a good review on finance. It also helps them prepare for job markets. The third edition is more organized and focused." – Lei Gao, University of Memphis
Les mer

Produktdetaljer

ISBN
9780190296384
Publisert
2017
Utgave
3. utgave
Utgiver
Oxford University Press Inc
Vekt
1746 gr
Høyde
196 mm
Bredde
236 mm
Dybde
41 mm
Aldersnivå
U, 05
Språk
Product language
Engelsk
Format
Product format
Innbundet
Antall sider
792

Biografisk notat

The late Simon Benninga was Professor of Finance and Director of the Sofaer International MBA program at the Faculty of Management at Tel Aviv University, a program he founded. Tal Mofkadi is Lecturer at Tel Aviv University and Co-Founder of Numerics Economic and Financial Consulting. He is also a Visiting Professor at the University of Amsterdam, Vienna University of Economics and Business, and Nagoya University of Commerce and Business.