Principles of Finance with Excel

Principles of Finance with Excel

4.17 (39 ratings by Goodreads)
By (author) 

List price: US$98.99

Currently unavailable

Add to wishlist

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

Try AbeBooks

Description

Principles of Finance with Excel is the first finance text that comprehensively integrates Excel into the teaching and practice of finance. Finance is inherently a topic requiring lots of computation and in today's business world this computation is almost wholly carried out in Excel. Despite this, many books rely heavily on hand calculators, and business school students often find that when they leave the academic environment they have to relearn both finance and Excel. The Excel-based approach of Principles of Finance with Excel gives better tools to the instructor and the student and integrates the educational message with the most useful financial tool available. There are no financial calculator examples in Principles of Finance with Excel, just Excel. The resulting message is clear: The Practice of Finance goes hand-in-hand with Excel. As every Excel user knows, a spreadsheet is not just a "computational tool", a slightly more sophisticated twist on the calculator. Using a spreadsheet gives new and deeper insights into financial decision making. The ability to combine graphics with computation, the powerful functions incorporated into the spreadsheet, and the ease with which sensitivity analysis can be done-all these give potent insights into financial problems.show more

Product details

  • Hardback | 924 pages
  • 188 x 240 x 42mm | 1,601.17g
  • Oxford University Press Inc
  • New York, United States
  • English
  • 0195301501
  • 9780195301502
  • 339,363

Review quote

"You have done an excellent job. I can't find a book with the applications you've included in here and I think it's great. I have an honors degree in Economics from University of Western Ontario and sat the CFA level one exam this year. Both bodies of studies are great but I believe where they lack is in the application dept. The majority of the content that I've looked at so far from your book was covered in level one CFA but the texts never explained applications with Excel which is a huge downfall. I believe your book compliments and fits perfectly into what I've learned in theory."--Rob Lee, Trader"You have transformed me, an IT person, into someone who now knows QUITE a bit about financial management, and who can now quote, debate and discuss with the best of them! I still cannot thank you enough. I could not have done this without the knowledge imparted by Principles of Finance with Excel."--Zubin Garda, Deloite-Touche"I am a Finance Division Manager at Allstate and use Excel quite a bit. It has been my experience in hiring over the past five or so years that most students today coming out of school lack skills and knowledge of Excel. Most of what I learned while in graduate school was related to the financial (i.e. banking) industry. Very little related to anything outside of that, nor were there any real life exercises in many of the books that I had. I liked your book because it showed how to use many of the features of Excel."--Charlyn Foust, Allstate"Principles of Finance with Excel by Simon Benninga is truly a unique and important new Excel based corporate finance text. Many students contact me after graduation and tell me how their ability to use Excel in financial modeling has opened doors to many interesting career opportunities. However, it is not simply the ability to use Excel that has opened these doors. The key is that Principles of Finance with Excel promotes a sound understanding of the principles of value creation and of financial decision making under uncertainty, which allows individuals to make immediate contributions to their firms."--Glen A. Larsen Jr., Finance Department, Indiana University"Finally, a 'Principles of Finance textbook' that uses the tool that our students will 'do finance with' once they graduate. In this book, Dr. Benninga pairs his authoritative treatment of finance with Excel and a thorough study of the finance basics. Excel is used, not as a black box, but rather as an implement to further understanding of the topics. Even a seasoned Finance professional can learn new tricks and gain new insights from this book."--Timo Korkeamaki, Finance Department, Gonzaga University"Microsoft Excel continues to be an absolutely critical piece of the tools and language of applied personal and corporate finance at all levels. Bankers, CFOs, investors, accountants, lawyers, entrepreneurs, and even proactive consumers need to be adept at using this platform. Principles of Finance with Excel fills a gaping hole in the market by applying an effective teaching methodology to financial applications of Excel in a self-contained text."--Alex Gould, Department of Economics, Stanford University"Professor Benninga's Principles of Finance with Excel masterfully integrates theory with practice. By working through learning-by-doing examples and practical applications, the reader's knowledge and understanding of both finance and Excel are enhanced. Furthermore, it accomplishes this in an engaging and entertaining manner. This book will be a valuable resource for anyone interested in learning finance. I highly recommend it" --Tom McCurdy, Bonham Chair in International Finance, University of Toronto"In Principles of Finance with Excel, Professor Benninga skillfully interweaves financial theory with applications to real-world data. Basic financial concepts are presented with unusual clarity in an intuitive manner. This book offers a nice blend of concepts and Excel applications and is easy to follow. Readers will find the exercises in the book fun and interesting, as many of my students and I have."-- Youngsoo Kim, University of Regina, Canadashow more

Table of contents

Preface; SECTION 1: INTRODUCTORY CHAPTERS; 1. Introduction to Finance; 2. Business Organization and Taxes; 3. Basic Accounting Concepts; 4. Cash Management; SECTION 2: CAPITAL BUDGETING AND VALUATION; 5. Time Value of Money; 6. What does it cost?; 7. Basics of Capital Budgeting; 8. More Issues in Capital Budgeting; 9. The Weighted Average Cost of Capital (WACC); 10. Using Financial Planning Models for Valuation; SECTION 3: PORTFOLIO ANALYSIS AND THE CAPITAL ASSET PRICING MODEL; 11. What is Risk?; 12. An Introduction to Portfolio Statistics; 13. Portfolio Returns and the Efficient Frontier; 14. The Capital Asset Pricing Model (CAPM) and the Security Market Line (SML); 15. Using the SML to Measure Performance; 16. Using the SML for Cost of Capital Calculations; SECTION 4: VALUING SECURITIES; 17. Market Efficiency; 18. Bond Valuation; 19. Share Valuation; SECTION 5: CAPITAL STRUCTURE AND DIVIDEND POLICY; 20. Capital Structure and the Value of the Firm-Theory; 21. Capital Structure and the Value of the Firm-Practical Implications; 22. Dividend Policy; SECTION 6: OPTIONS AND OPTION VALUATION; 23. Introduction to Options; 24. Properties of Option Prices; 25. Valuing Options-The Black-Scholes Formula; 26. Valuing Options-The Binomial Model; SECTION 7: BACKGROUND TO EXCEL; 27. Starting Off in Excel; 28. Graphing in Excel; 29. Common Excel Functions; 30. Using Data Tables; 31. Dates in Excel; 32. Goal Seek and Solver; 33. Data Manipulation in Excel; 34. Word and Excelshow more

About Simon Benninga

Simon Benninga is professor of finance at the Wharton School of the University of Pennsylvania and at Tel Aviv University. He is the author of numerous academic articles and three previous books. His books on financial modeling and valuation are now standards in the field of finance and have been translated into Japanese, Chinese, Polish, and Italian.show more

Rating details

39 ratings
4.17 out of 5 stars
5 41% (16)
4 38% (15)
3 18% (7)
2 3% (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