楼主: sparksong
4620 6

[资料] 配合三本财务管理经典的_SPREADSHEET MODELING IN CORPORATE FINANCE [推广有奖]

  • 2关注
  • 0粉丝

大专生

31%

还不是VIP/贵宾

-

威望
0
论坛币
321 个
通用积分
0.9000
学术水平
0 点
热心指数
0 点
信用等级
0 点
经验
468 点
帖子
27
精华
0
在线时间
57 小时
注册时间
2007-3-3
最后登录
2024-6-14

相似文件 换一批

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币

167580.pdf (1.48 MB)


178731.pdf (1.48 MB)

178733.pdf (1.49 MB)

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

168012.rar (7.97 KB) 本附件包括:

  • Portfolio Optimization - Dynamic Chart.xls

以下为文件信息:

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

二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Spreadsheet Corporate Modeling Spreads Finance Finance Modeling 财务管理 Corporate Spreadsheet

沙发
justin520 发表于 2008-1-29 06:40:00 |只看作者 |坛友微信交流群
thanks

使用道具

藤椅
xiangxu 发表于 2008-1-29 08:17:00 |只看作者 |坛友微信交流群

我灌水

使用道具

板凳
xiangxu 发表于 2008-1-29 08:38:00 |只看作者 |坛友微信交流群
顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶的顶顶顶顶

使用道具

报纸
gaowq 在职认证  发表于 2008-2-17 12:09:00 |只看作者 |坛友微信交流群
我有其中一本,现有收进另两本,高兴,谢谢

使用道具

地板
parismeng 发表于 2011-4-26 09:41:18 |只看作者 |坛友微信交流群
很好的东东!谢谢楼主

使用道具

7
zhanglingyu99 发表于 2018-12-12 19:22:54 |只看作者 |坛友微信交流群
太感谢了!!!!!!!!!!!!!!

使用道具

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2024-11-5 17:25