Principles of finance with Excel - Simon Benninga

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 Financewith 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 themost 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 withExcel 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 bookPrinciples 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.