Spreadsheet_Modeling_in_Corporate_Finance
介绍
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
|
下载地址
------分隔线----------------------------