感谢大家支持,我现在有钱了,共三个文件。都是配合原书的全部Excel建模,希望对大家理解有帮助。目录不在多说。
SPREADSHEET MODELING IN CORPORATE FINANCE
To accompany Principles of Corporate Finance by Brealey and Myers
和
SPREADSHEET MODELING IN CORPORATE FINANCE
To accompany Corporate Finance by Ross, Westerfield, and Jaffe
和
SPREADSHEET MODELING IN CORPORATE FINANCE
To accompany Financial Management Theory and Practice by Brigham, Gapenski, and Ehrhardt
and Intermediate Financial Management by Brigham, Gapenski, and Daves
第一本书主要是配合“公司财务原理”的全部Excel建模,讲解十分详细,对实际操作十分有用。
其余书籍相同。
给大家看一个例子:Dynamic Chart of Portfolio Optimization
An "animated" chart illustrates the Mean-Variance comparative statics. That is, how changes in the inputs (means, standard deviations, and correlations) effect the efficient frontier and the weights of the tangent portfolio.
以下为文件信息:
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
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
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
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
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
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