Revised edition of Principles of finance with Excel, 2011.

Includes index.

Machine generated contents note: -- <strong>Part One: Capital Budgeting and Valuation </strong> -- 1. Introduction to Finance -- 2. The Time Value of Money -- Appendix 2.1. Algebraic Present Value Formulas -- Appendix 2.2. Annuity Formulas in Excel -- 3. Measures for Evaluation of Investment Opportunities -- 4. Loans and Amortization Tables -- 5. Effective Interest Rates -- 6. Capital Budgeting: Valuing Business Cash Flows -- <strong>Part Two: Portfolio Analysis and the Capital Asset Pricing Model </strong> -- 7. What is Risk? -- 8. Statistics for Portfolios -- Appendix 8.1. Downloading Data from Yahoo -- 9. Portfolio Diversification and Market Risk -- 10. Risk Diversification and the Efficient Frontier -- Appendix 10.1. Deriving the Formula for the Minimum Variance Portfolio -- Appendix 10.2. Portfolios with Three and More Assets -- 11. The Capital Asset Pricing Model (CAPM) and the Security Market Line (SML) -- 12. Measuring Investment Performance -- 13. The Security Market Line (SML) and the Cost of Capital -- <strong>Part Three: Valuing Securities </strong> -- 14. Efficient Markets--Some General Principles of Security Valuation -- 15. Bond Valuation -- 16. Stock Valuation -- <strong>Part Four: Options </strong> -- 17. Introduction to Options -- 18. Option Pricing Facts and Arbitrage -- 19. Option pricing: The Black-Scholes Formula -- Appendix 19.1 Getting Option Information from Yahoo -- 20.The Binomial Option Pricing Model -- <strong>Part Five: Excel Skills </strong> -- 21. Introduction to Excel -- 22. Graphs and Charts in Excel -- 23. Excel Functions -- 24. Using Data Tables -- 25. Using Goal Seek and Solver -- 26. Working with Dates in Excel.

" 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--and can therefore be used in any introductory course. In addition, it introduces Excel software as it applies to finance students and practitioners. Throughout the book, the implementation of finance concepts with Excel software is demonstrated and explained. A separate section of PFE provides thorough coverage of all Excel software topics used in the book: 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. "--

"Principles of Finance with Excel comprehensively integrates Excel into the teaching and practice of finance. Simon Benninga's name is synonymous with financial modeling, and on full display here is the author's experience teaching undergraduates, graduate students, and executives how to use spreadsheets to gain deeper insights into financial decision making. The book is chock full of concrete instructions, helpful tips, illustrative examples, and numerous practice problems"--