For graduate courses in corporate finance.
Excel Modeling in Corporate Finance is a supplemental book and CD. It teaches students how to build financial models with step-by-step instructions in Excel. It can accompany any graduate corporate finance textbook, including textbooks by Brealey, Brigham, Keown, Ross, and Van Horne.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Breite: 277 mm
Dicke: 12 mm
Gewicht
ISBN-13
978-0-13-132165-6 (9780131321656)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
I. TIME VALUE OF MONEY.
1. Single Cash Flow.
Present Value. Future Value. Problems.
2. Annuity.
Present Value. Future Value. System of Four Annuity Variables. Problems.
3. Net Present Value.
Constant Discount Rate. General Discount Rate. Problems.
4. Real and Inflation.
Constant Discount Rate. General Discount Rate. Problems.
5. Loan Amortization.
Basics. Sensitivity Analysis. Problems.
II. VALUATION.
6. Bond Valuation.
Annual Payments. APR vs. EAR. By Yield to Maturity. System of Five Bond Variables. Dynamic Chart. Problems.
7. Stock Valuation.
Two Stage. Dynamic Chart. Problems.
8. The Yield Curve.
Obtaining It from Bond Listings. Using It to Price a Coupon Bond. Using It to Determine Forward Rates. Problems.
9. U.S. Yield Curve Dynamics.
Dynamic Chart. Problems.
III. CAPITAL BUDGETING.
10. Project NPV.
Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems.
11. Cost-Reducing Project.
Basics. Sensitivity Analysis. Problems.
12. Break-Even Analysis.
Based on Accounting Profit. Based on NPV. Problems.
13 Three Valuation Methods.
Adjusted Present Value. Flows to Equity. Weighted Average Cost of Capital. Problems.
IV. FINANCIAL PLANNING.
14. Corporate Financial Planning.
Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems.
15. Du Pont System of Ratio Analysis.
Basics. Problems.
16. Life-Cycle Financial Planning.
Basics. Problems.
V. OPTIONS AND CORPORATE FINANCE.
17. Binomial Option Pricing.
Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.
18. Black Scholes Option Pricing.
Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.
19. Debt and Equity Valuation.
Two Methods. Impact of Risk. Problems.
20. Real Options.
Using Black-Scholes. Using the Binomial Model. Sensitivity to Standard Deviation. Problems.
