Principles of Finance with Excel Includes CD

by Benninga, Simon

• ISBN13: 9780195301502
• ISBN10: 0195301501
• Format: Hardcover
• Copyright: 2006-01-05
• Publisher: Oxford University Press

Summary

Principles of Finance with Excel is the first textbook that comprehensively integrates Excel into the teaching and practice of finance. This book provides exceptional resources to the instructor and student, combining classroom-tested pedagogy with the full potential of Excel's powerfulfunctions. In today's business world, computation is done almost wholly in Excel. Excel's ability to combine graphics with computation and perform complex sensitivity analysis with ease provides potent insights into financial problems. Despite this, most finance texts rely heavily on hand-held calculators andignore Excel. As a result, many students find that after they enter the professional environment, they have to relearn both finance and Excel. Principles of Finance with Excel is ideal for undergraduate courses in introductory finance or as a reference for finance professionals. A Free In-Text CD for students contains electronic versions of all spreadsheets in the book. A Companion Website -- http://www.oup.com/us/benninga -- containslecture notes, PowerPoint Slides, and a Test Bank for instructors.

Author Biography

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.

Table of Contents

Preface	x
PART ONE INTRODUCTORY CHAPTERS	1	(72)
Introduction to Finance	3	(8)
Business Organization and Taxes	11	(18)
An Accounting Primer	29	(24)
Cash Management With Excel	53	(20)
PART TWO CAPITAL BUDGETING AND VALUATION	73	(236)
The Time Value of Money	75	(53)
What Does It Cost? Applications of the Time Value of Money	128	(30)
Introduction to Capital Budgeting	158	(35)
Issues in Capital Budgeting	193	(44)
Choosing a Discount Rate	237	(31)
Using Financial Planning Models for Valuation	268	(41)
PART THREE PORTFOLIO ANALYSIS AND THE CAPITAL ASSET PRICING MODEL	309	(184)
What Is Risk?	311	(26)
Statistics for Portfolios	337	(40)
Portfolio Returns and the Efficient Frontier	377	(30)
The Capital Asset Pricing Model (CAPM) and the Security Market Line (SML)	407	(35)
Using the Security Market Line (SML) to Measure Investment Performance	442	(23)
The Security Market Line (SML) and the Cost of Capital	465	(28)
PART FOUR VALUING SECURITIES	493	(86)
Efficient Markets---Some General Principles of Security Valuation	495	(25)
Bond Valuation	520	(33)
Valuing Stocks	553	(26)
PART FIVE CAPITAL STRUCTURE AND DIVIDEND POLICY	579	(82)
Capital Structure and the Value of a Firm	581	(45)
The Evidence on Capital Structure	626	(16)
Dividend Policy	642	(19)
PART SIX OPTIONS AND OPTION VALUATION	661	(104)
Introduction to Options	663	(39)
Option Pricing Facts	702	(19)
Option Pricing---The Black--Scholes Formula	721	(24)
The Binomial Option Pricing Model	745	(20)
PART SEVEN EXCEL BACKGROUND	765	(132)
Introduction to Excel	767	(25)
Graphs and Charts in Excel	792	(21)
Excel Functions	813	(28)
Data Tables	841	(11)
Working With Dates in Excel	852	(12)
Using Goal Seek and Solver	864	(8)
Data Manipulation in Excel	872	(19)
Using Excel Information in Word Documents	891	(6)
Index	897