Excel Modeling in the Fundamentals of Corporate Finance Book and CD-ROM
2nd Edition
Published on 26. July 2004
Book
Mixed media product
158 pages
978-0-13-151343-3 (ISBN)
Description
For undergraduate courses in corporate finance.
Excel Modeling in the Fundamentals of 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 undergraduate corporate finance textbook, including textbooks by Brealey, Brigham, Gitman, Keown, Ross, and Van Horne.
Excel Modeling in the Fundamentals of 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 undergraduate corporate finance textbook, including textbooks by Brealey, Brigham, Gitman, 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: 276 mm
Thickness: 10 mm
Weight
472 gr
ISBN-13
978-0-13-151343-3 (9780131513433)
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
€48.10
Article is exhausted; no reprint
Craig W. Holden
Excel Modeling and Estimation in the Fundamentals of Corporate Finance and Student CD Package
Book
04/2008
3rd Edition
Prentice Hall
Unfortunately, price unknown
Article exhausted; check for reprint
Previous edition
Book
07/2002
Pearson
€23.55
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. U.S. Yield Curve Dynamics.
Dynamic Chart. Problems.
III. CAPITAL BUDGETING.
9. Project NPV.
Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems.
10. Break-Even Analysis.
Based on Accounting Profit. Based on NPV. Problems.
IV. FINANCIAL PLANNING.
11. Corporate Financial Planning.
Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems.
12. Life-Cycle Financial Planning.
Basics. Problems.
V. OPTIONS AND CORPORATE FINANCE.
13. Binomial Option Pricing.
Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.
14. Black Scholes Option Pricing.
Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.
15. 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. U.S. Yield Curve Dynamics.
Dynamic Chart. Problems.
III. CAPITAL BUDGETING.
9. Project NPV.
Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems.
10. Break-Even Analysis.
Based on Accounting Profit. Based on NPV. Problems.
IV. FINANCIAL PLANNING.
11. Corporate Financial Planning.
Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems.
12. Life-Cycle Financial Planning.
Basics. Problems.
V. OPTIONS AND CORPORATE FINANCE.
13. Binomial Option Pricing.
Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.
14. Black Scholes Option Pricing.
Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.
15. Real Options.
Using Black-Scholes. Using the Binomial Model. Sensitivity to Standard Deviation. Problems.