Ch财务管理以EXCEL为分析工具(表样)_07_Cost_of_Capital.xls
《Ch财务管理以EXCEL为分析工具(表样)_07_Cost_of_Capital.xls》由会员分享,可在线阅读,更多相关《Ch财务管理以EXCEL为分析工具(表样)_07_Cost_of_Capital.xls(81页珍藏版)》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、COST OF CAPITALStatic CAPM Using Fama-MacBeth MethodInputsMarket PortfolioBenchmark2Asset Type2StockStockStockStockStockStockBarrickHansonIBMNokiaTelefonosYPFMonthly ReturnsDec 2006-3.50%-0.24%2.06%8.76%8.63%0.50%Nov 2006-2.37%4.88%5.69%0.51%9.01%-0.95%Oct 20061.79%3.78%-0.12%1.70%-1.08%3.49%Sep 200
2、60.92%-3.49%12.69%0.93%3.14%7.02%Aug 2006-8.23%14.36%1.20%-5.68%6.76%-3.83%Jul 20068.68%3.72%5.00%5.20%3.02%2.00%Jun 20064.06%0.88%0.78%-2.02%12.51%9.98%May 2006-3.30%-0.32%-3.86%-5.67%6.23%0.03%Apr 20060.80%-8.40%-2.61%-5.23%-9.99%-17.69%Mar 200611.90%3.92%-0.16%9.38%-2.17%-3.07%Feb 2006-0.48%7.12%
3、2.78%13.88%1.21%-2.81%Jan 2006-13.00%5.15%-1.05%1.08%-5.72%0.89%Dec 200512.90%5.55%-1.09%0.46%-3.81%3.63%Nov 20054.72%7.22%-7.54%7.16%10.88%-11.58%Oct 20055.80%1.22%8.83%1.55%11.10%-0.88%Sep 2005-13.06%-2.72%2.07%-0.56%-5.09%-11.61%Aug 200510.78%-0.94%-0.49%7.22%11.77%8.89%Jul 20057.01%5.52%-3.17%-1
4、.11%-0.33%12.07%Jun 2005-2.11%5.30%12.48%-4.14%1.97%1.06%May 20058.89%3.30%-1.78%-1.30%2.18%8.57%Apr 20053.48%0.39%-0.82%5.49%10.11%-0.65%Mar 2005-6.82%0.32%-16.42%6.55%-1.86%3.40%Feb 2005-3.78%-3.28%-1.29%-4.39%-11.23%-14.72%Jan 200513.88%4.21%-0.72%5.63%5.28%31.78%Dec 2004-9.74%8.86%-5.23%-2.47%-2
5、.82%6.38%Nov 2004-1.50%6.76%4.61%-3.12%10.45%2.83%Oct 20049.71%8.98%5.20%4.88%2.23%6.99%Sep 20047.02%-0.26%4.68%12.37%6.07%0.00%Aug 20045.18%7.96%1.24%15.57%0.61%5.71%Jul 20044.62%-1.00%-2.53%2.22%4.84%-2.81%Jun 2004-3.22%1.37%-1.22%-20.10%-7.14%3.53%May 2004-4.42%-9.22%-0.50%5.79%-0.26%0.31%Apr 200
6、48.05%-0.35%0.68%-1.92%-1.43%-1.54%Mar 2004-19.13%1.67%-3.99%-30.90%-2.22%6.90%Feb 200416.30%-4.69%-4.83%-5.08%3.62%4.45%Jan 20043.82%9.27%-2.59%5.41%-1.30%1.86%Dec 2003-13.27%1.93%7.07%21.52%4.20%1.03%Nov 20031.66%4.11%2.36%-5.48%0.68%10.29%Oct 200315.28%2.08%1.37%5.87%2.95%1.67%Sep 20033.41%7.41%1
7、.31%8.92%5.24%23.16%Aug 2003-6.82%-1.78%7.70%-4.24%1.73%8.96%Jul 200318.05%12.95%1.14%6.44%-1.77%-4.87%SPDR ETFCRSP VWMRDJ World StockMarket Portfolio BenchmarkStockUS PortCountry PortAsset TypeJun 2003-4.35%3.25%-1.52%-6.87%-1.74%0.82%May 20032.37%-2.30%-6.30%-8.93%4.63%7.96%Apr 200317.66%3.24%3.90
8、%8.86%0.30%25.69%Mar 2003-3.89%18.50%8.25%18.30%1.70%14.65%Feb 2003-3.50%4.25%0.62%8.02%3.11%19.28%Jan 2003-2.03%6.93%-0.13%-8.00%-2.87%14.21%Dec 20026.77%-0.70%0.90%-7.21%-6.39%13.27%Nov 20025.80%-11.97%-10.84%-19.31%0.07%8.24%Oct 2002-2.65%9.99%10.31%15.60%5.68%24.30%Sep 2002-3.11%-10.94%35.38%25.
9、49%8.31%-4.27%Aug 2002-3.20%-15.58%-22.64%-0.34%-4.07%-14.01%Jul 20024.87%-1.47%7.31%7.21%2.53%21.49%Jun 2002-19.31%-12.19%-2.22%-14.43%-9.94%-4.42%May 2002-12.87%-7.43%-10.51%4.35%-6.92%-4.52%Apr 20029.10%5.21%-3.76%-14.64%-8.07%-26.09%Mar 20028.13%-2.57%-19.47%-21.61%-6.32%-17.48%Feb 20022.87%14.6
10、6%5.99%0.81%6.21%5.53%Jan 20025.56%1.65%-8.94%-11.41%-0.25%-2.09%Dec 20017.22%-2.13%-10.81%-4.42%9.67%-11.52%Nov 20015.37%0.33%4.65%6.62%5.27%23.08%Oct 2001-2.18%-2.12%7.09%12.16%-1.63%8.78%Sep 2001-10.18%-2.32%17.83%31.07%5.55%-0.34%Aug 20018.30%-9.69%-8.23%-0.57%-10.83%-16.65%Jul 20017.57%9.15%-4.
11、87%-27.83%5.28%-9.18%Jun 2001-1.69%-3.67%-7.31%-1.73%-1.18%-5.23%May 2001-8.19%5.01%1.52%-24.11%1.70%-20.64%Apr 20011.64%5.40%-2.78%-14.46%-0.28%3.51%Mar 200114.31%20.00%19.70%42.45%9.67%-2.51%Feb 2001-11.76%-11.36%-3.72%10.21%-1.45%-4.61%Jan 20014.71%1.39%-10.70%-35.94%-1.35%1.94%Dec 2000-5.56%-6.4
12、2%31.76%-21.04%20.25%0.19%Nov 20009.21%27.73%-9.09%1.76%-3.15%-3.05%Oct 200012.98%2.14%-4.96%0.00%-13.09%1.11%Sep 2000-12.31%-5.60%-12.53%4.57%1.47%-3.10%Aug 2000-4.39%-5.55%-14.70%-8.66%-1.97%-11.04%Jul 20000.07%2.26%17.74%1.71%4.10%-3.34%Jun 2000-12.28%-17.19%2.46%-12.87%-8.57%-4.37%May 20000.30%0
13、.70%2.10%-2.89%18.03%16.06%Apr 20008.46%-4.28%-3.64%-7.24%-17.18%4.03%Mar 20007.12%5.89%-5.81%1.01%-11.75%-8.81%Feb 2000-3.79%10.99%15.20%12.24%1.64%-0.16%Jan 2000-0.40%-11.46%-8.37%7.30%23.48%1.87%Dec 1999-7.42%-10.69%4.06%-3.16%-5.32%-4.91%Nov 1999-1.75%-2.60%4.67%36.48%21.98%-4.06%Oct 1999-0.66%7
14、.14%5.04%21.15%8.29%-0.25%Sep 1999-15.78%-0.17%-18.80%28.56%19.88%-0.30%Aug 199912.22%-8.64%-2.86%7.50%-3.61%-0.79%Jul 19994.37%-4.57%-0.80%-1.72%-1.44%-2.69%Jun 1999-4.19%1.39%-2.76%-7.10%-6.54%6.73%May 199912.33%-2.05%11.42%28.52%1.58%-9.82%Apr 1999-13.24%-6.93%11.03%-3.95%5.57%1.31%Mar 199917.88%
15、12.46%18.02%-4.76%14.69%32.44%Feb 1999-3.51%8.31%4.41%15.55%16.17%8.86%Jan 1999-7.22%24.04%-7.24%-5.88%11.77%-8.31%Dec 1998-2.22%-16.02%-0.61%19.65%5.05%14.08%Nov 1998-2.50%5.04%11.66%22.93%5.51%-6.11%Oct 1998-5.65%5.15%11.36%5.35%-11.69%3.58%Sep 19986.88%13.89%15.56%18.82%19.84%11.26%Aug 199853.92%
16、27.70%14.10%17.24%24.46%17.55%Jul 1998-20.64%-4.41%-14.86%-23.44%-28.42%-23.59%Jun 1998-14.94%-15.04%15.41%19.87%3.59%-2.74%May 19980.00%2.53%-2.28%12.06%2.20%-3.36%Apr 1998-13.39%-0.61%1.59%-2.89%-16.15%-10.21%Mar 19983.76%0.66%11.54%23.89%0.46%2.62%Feb 199812.00%19.98%-0.53%8.52%11.94%7.49%Jan 199
17、8-0.35%13.76%5.97%32.68%3.03%4.62%Dec 19974.00%-3.28%-5.62%9.12%-12.21%-10.97%Nov 199712.48%-11.51%-4.46%-16.37%14.11%1.70%Oct 1997-18.69%1.96%11.39%-5.71%14.75%5.77%Sep 1997-16.72%5.73%-7.06%-5.96%-16.44%-13.10%Aug 19978.52%2.17%4.55%21.20%13.84%13.04%Jul 1997-0.30%-5.15%-3.96%-9.59%-17.26%1.47%Jun
18、 19974.33%1.22%17.19%16.20%15.67%5.11%May 1997-13.37%-2.43%4.32%11.58%9.16%2.90%Apr 199713.54%5.68%7.78%2.31%7.44%8.97%Mar 1997-5.80%6.56%16.94%10.90%7.03%4.24%Feb 1997-15.92%2.28%-4.51%-0.32%-0.93%-0.47%Jan 19975.12%-58.44%-8.15%-12.57%3.36%-3.76%Monthly Excess ReturnsDec 2006Nov 2006Oct 2006Sep 20
19、06Aug 2006Jul 2006Jun 2006May 2006Apr 2006Mar 2006Feb 2006Jan 2006Dec 2005Nov 2005Oct 2005Sep 2005Aug 2005Jul 2005Jun 2005May 2005Apr 2005Mar 2005Feb 2005Jan 2005Dec 2004Nov 2004Oct 2004Sep 2004Aug 2004Jul 2004Jun 2004May 2004Apr 2004Mar 2004Feb 2004Jan 2004Dec 2003Nov 2003Oct 2003Sep 2003Aug 2003Ju
20、l 2003Jun 2003May 2003Apr 2003Mar 2003Feb 2003Jan 2003Dec 2002Nov 2002Oct 2002Sep 2002Aug 2002Jul 2002Jun 2002May 2002Apr 2002Mar 2002Feb 2002Jan 2002Dec 2001Nov 2001Oct 2001Sep 2001Aug 2001Jul 2001Jun 2001May 2001Apr 2001Mar 2001Feb 2001Jan 2001Dec 2000Nov 2000Oct 2000Sep 2000Aug 2000Jul 2000Jun 20
21、00May 2000Apr 2000Mar 2000Feb 2000Jan 2000Dec 1999Nov 1999Oct 1999Sep 1999Aug 1999Jul 1999Jun 1999May 1999Apr 1999Mar 1999Feb 1999Jan 1999Dec 1998Nov 1998Oct 1998Sep 1998Aug 1998Jul 1998Jun 1998May 1998Apr 1998Mar 1998Feb 1998Jan 1998Dec 1997Nov 1997Oct 1997Sep 1997Aug 1997Jul 1997Jun 1997May 1997Ap
22、r 1997Mar 1997Feb 1997Jan 1997CAPM Beta from the First Pass,Time-Series Regression5 Yr Estimation Per:Beg Mon-End MonBarrickHansonIBMNokiaTelefonosYPFDec 2001-Nov 2006Nov 2001-Oct 2006Oct 2001-Sep 2006Sep 2001-Aug 2006Aug 2001-Jul 2006Jul 2001-Jun 2006Jun 2001-May 2006May 2001-Apr 2006Apr 2001-Mar 2
23、006Mar 2001-Feb 2006Feb 2001-Jan 2006Jan 2001-Dec 2005Dec 2000-Nov 2005Nov 2000-Oct 2005Oct 2000-Sep 2005Sep 2000-Aug 2005Aug 2000-Jul 2005Jul 2000-Jun 2005Jun 2000-May 2005May 2000-Apr 2005Apr 2000-Mar 2005Mar 2000-Feb 2005Feb 2000-Jan 2005Jan 2000-Dec 2004Dec 1999-Nov 2004Nov 1999-Oct 2004Oct 1999
24、-Sep 2004Sep 1999-Aug 2004Aug 1999-Jul 2004Jul 1999-Jun 2004Jun 1999-May 2004May 1999-Apr 2004Apr 1999-Mar 2004Mar 1999-Feb 2004Feb 1999-Jan 2004Jan 1999-Dec 2003Dec 1998-Nov 2003Nov 1998-Oct 2003Oct 1998-Sep 2003Sep 1998-Aug 2003Aug 1998-Jul 2003Jul 1998-Jun 2003Jun 1998-May 2003May 1998-Apr 2003Ap
25、r 1998-Mar 2003Mar 1998-Feb 2003Feb 1998-Jan 2003Jan 1998-Dec 2002Dec 1997-Nov 2002Nov 1997-Oct 2002Oct 1997-Sep 2002Sep 1997-Aug 2002Aug 1997-Jul 2002Jul 1997-Jun 2002Jun 1997-May 2002May 1997-Apr 2002Apr 1997-Mar 2002Mar 1997-Feb 2002Feb 1997-Jan 2002Jan 1997-Dec 2001Average BetaRisk Premium and I
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Ch 财务管理 EXCEL 分析 工具 表样 _07_Cost_of_Capital
限制150内