文章类型:High School Assignment 高中essay
字数要求:3500
补充要求和说明:用excel计算 并写明计算过程
The major project is to be done on groups of four. Each group will choose a set of three Australian Commonwealth Government Securities and one Short-term security (Bank Bill or T-Note) Singapore Government bill with maturity of no more than 6 months. Collect the key characteristics of each of the bonds and the bill. Bond yield data will be collected at the end of June 2010 and at the end of December 2010. The data bond data can be found on the RBA (
http://www.ukthesis.org/scxzy/) (you will have to do some exploration of the site to find and understand what you are looking for). 四组的主要项目是必须要做的。每个小组将选择一组三个澳洲联邦政府证券和短期安全(银行汇票或T-注)新加坡政府法案到期日不超过6个月。收集各债券及该法案的主要特征。在2010年6月底和2010年12月底,债券收益率的数据将被收集。数据键数据可以发现澳洲联储的(找到并理解你正在寻找什么,你将不得不做一些探索的网站)。
Required需要
1。计算脏和干净的政府债券的价格,而该法案于2010年6月2010年12月结束。 (4分)
2。计算债券的久期和凸,该法案于2010年6月和2010年12月结束。 (6分)
(提示:一起做1&2)
3。计算每三个债券,该法案在2010年6月至2010年12月期间的持有期收益率。 (4分)
4。计算两日的债券和票据为使用同样的加权组合的久期和凸。 (4分)
5。比较和对比组合和单独的债券,该法案的回报和波动性。 (2分)
6。使用债券和票据数据构建一个收益率曲线,现货曲线和远期曲线在2010年6月底,并于2010年12月底。 2010年6月的产量预测为2010年12月的6个月期利率?评论这个预测的准确性,2010年12月收益率曲线。 (6分)
7。查看收益率曲线随参考期刊文章和网站的预测能力。讨论收益率曲线估计参考这些文献。 (4分)
(总分4 6 44 256789104=30)
1. Calculate the dirty and clean prices of the Government bonds and the bill as at the end of June 2010 and December 2010. (4 marks)
2. Calculate the duration and convexity of the bonds and the bill as at the end of June 2010 and December 2010. (6 marks)
(hint: do 1 & 2 together)
3. #p#分页标题#e#Calculate the holding period return for each of the three bonds and the bill over the period from June 2010 to December 2010. (4 marks)
4. Calculate the duration and convexity using an equally weighted portfolio of the bonds and the bill for both dates. (4 marks)
5. Compare and contrast the return and volatility of the portfolio and the separate bonds and the bill. (2 marks)
6. Use the bond and bill data to construct a yield curve, spot curve and forward curve as at the end of June 2010 and also at the end of December 2010. Does the June 2010 yield predict the 6 month rate for December 2010? Comment on the accuracy of this prediction given your December 2010 yield curve. (6 marks)
7. Review the predictive ability of the yield curve with reference to journal articles and web sites. Discuss the yield curves that you have estimated with reference to this literature. (4 marks)
(Total marks 4+6+4+4+2+6+4 = 30)