Excel Modeling in Corporate Finance Book and CD-ROM
2nd Edition
Published on 6. August 2004
Book
Mixed media product
978-0-13-132165-6 (ISBN)
Description
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.
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.
More details
Edition
2nd edition
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Dimensions
Width: 277 mm
Thickness: 12 mm
Weight
447 gr
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 Classification
Other editions
New editions
Book
05/2008
3rd Edition
Pearson
€36.48
Article exhausted; check for reprint
Content
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.
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.