Principles of finance with Excel

Includes index.

Includes bibliographical references and index.

Introduction to finance -- The time value of money -- What does it cost? IRR and the time value of money -- Introduction to capital budgeting -- Issues in capital budgeting -- Choosing a discount rate -- Using financial planning models for valuation -- What is risk? -- Statistics for portfolios -- Portfolio returns and the efficient frontier -- The capital asset pricing model and the security market line -- Using the security market line to measure investment performance -- The security market line and the cost of capital -- Efficient markets--some general principles of security valuation -- Bond valuation -- Valuing stocks -- Capital structure and the value of the firm -- The evidence on capital structure -- Dividend policy -- Introduction to options -- Option pricing facts -- Option pricing--the Black-Scholes formula -- The binomial option-pricing model -- Introduction to Excel -- Graphs and charts in Excel -- Excel functions -- Data tables -- Using goal seek and solver -- Working with dates in Excel.