增加新内容：SPREADSHEET MODELING IN CORPORATE FINANCE   [推广有奖]

文件已经转到 Excel 版。

感谢大家支持，我现在有钱了，再加入两个新文件，共三个文件。都是配合原书的全部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.

我是为了下载CRYSTALBALL相关资料才出售的，钱还不够，望大家和版主多多支持。

以下为文件信息：

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

[此贴子已经被作者于2007-12-3 10:53:55编辑过]