Tài liệu Phân tích tài chính bằng excel

PHÂN TÍCH TÀI CHÍNH BẰNG EXCEL

SPREADSHEET MODELING IN CORPORATE FINANCE


To accompany Principles of Corporate Finance by Brealey and Myers


CRAIG W. HOLDEN
Richard G. Brinkman Faculty Fellow and Associate Professor
Kelley School of Business
Indiana University


Prentice Hall, Upper Saddle River, New Jersey 07458
CONTENTS


Preface


PART 1 TIME VALUE OF MONEY


Chapter 1 Single Cash Flow
1.1 Present Value
1.2 Future Value
Problems
Chapter 2 Annuity
2.1 Present Value
2.2 Future Value
2.3 System of Four Annuity Variables
Problems
Chapter 3 Net Present Value
3.1 Constant Discount Rate
3.2 General Discount Rate
Problems
Chapter 4 Real and Inflation
4.1 Constant Discount Rate
4.2 General Discount Rate
Problems
Chapter 5 Loan Amortization
5.1 Basics
5.2 Sensitivity Analysis
Problems


PART 2 VALUATION


Chapter 6 Bond Valuation
6.1 Basics
6.2 By Yield To Maturity
6.3 System Of Five Bond Variables
6.4 Dynamic Chart
Problems
Chapter 7 Stock Valuation
7.1 Two Stage
7.2 Dynamic Chart
Problems
Chapter 8 The Yield Curve
8.1 Obtaining It From Bond Listings
8.2 Using It To Price A Coupon Bond
8.3 Using It To Determine Forward Rates
Problems
Chapter 9 U.S. Yield Curve Dynamics
9.1 Dynamic Chart
Problems
PART 3 CAPITAL BUDGETING


Chapter 10 Project NPV
10.1 Basics
10.2 Forecasting Cash Flows
10.3 Working Capital
10.4 Sensitivity Analysis
Problems
Chapter 11 Cost-Reducing Project
11.1 Basics
11.2 Sensitivity Analysis
Problems
Chapter 12 Break-Even Analysis
12.1 Based On Accounting Profit
12.2 Based On NPV
Problems
Chapter 13 Three Valuation Methods
13.1 Adjusted Present Value
13.2 Flows To Equity
13.3 Weighted Average Cost of Capital
Problems


PART 4 FINANCIAL PLANNING


Chapter 14 Corporate Financial Planning
14.1 Actual
14.2 Forecast
14.3 Cash Flow
14.4 Ratios
14.5 Sensitivity
14.6 Full-Scale Real Data
Problems
Chapter 15 Du Pont System of Ratio Analysis
15.1 Basics
Problems
Chapter 16 Life-Cycle Financial Planning
16.1 Basics
Problems
PART 5 OPTIONS AND CORPORATE FINANCE


Chapter 17 Binomial Option Pricing
17.1 Single Period
17.2 Multi-Period
17.3 Risk Neutral
17.4 Full-Scale Real Data
Problems
Chapter 18 Black Scholes Option Pricing
18.1 Basics
18.2 Dynamic Chart
18.3 Continuous Dividend
18.4 Implied Volatility
Problems
Chapter 19 Debt and Equity Valuation
19.1 Two Methods
19.2 Impact of Risk
Problems
Chapter 20 Real Options
20.1 Using Black-Scholes
20.2 Using The Binomial Model
20.3 Sensitivity to Standard Deviation
Problems