The actual expected returns can be found on the BlackRock website at 在贝莱德的网站上可以找到真实的预期收益：https://www.blackrock.com/institutions/en-us/insights/portfolio-design/capital-market-assumptionsTo get an appreciation of how risk aversion is gauged, Zac will locate examples of risk aversion surveys used in the industry and evaluate them in the context of this asset allocation exercise.为了了解如何衡量风险厌恶，Zac 会找出行业中有关风险厌恶调查问卷的例子，并以资产配置为背景进行评估。Questions (marks are equally weighted across the Questions)问题（每一道问题的分数都相同）Question 1.第一题。(a) Calculate average monthly excess returns for the seven shares and the equity index in the spreadsheet. Report each share’s arithmetic average monthly excess return and standard deviation of excess return (using the population version of the standard deviation equation).在电子表格中，计算七只股票和股票指数的平均月度超额收益。报告每一只股票的算术平均月度超额收益和超额收益的标准差（采用总体平均的标准差公式）。(b) Regress the monthly excess returns for each share on the monthly excess returns of the equity index and report each share’s: alpha; beta; t-statistics; and R squared. Also calculate and report each share’s tracking error as implied by the betas and standard deviations of excess returns ie from part (a).使用股票指数的月度超额收益作为自变量，对每一只股票的月度超额收益进行回归分析，然后报告股票的 Alpha，Beta，t 统计值和决定系数（R2），同时计算和报告每一只股票的跟踪误差，由 Beta 和超额收益的标准差体现（也就是 a 题中所得的数据）。(c) Run a second pass regression by regressing the average excess returns for the shares from part (a) on their betas and tracking errors (in variance form) from part (b) combined with the data for the additional shares provided in the spreadsheet (refer to BKM section 13.1). Report the gamma 0, gamma 1, gamma 2, standard errors, relevant t-statistics and adjusted R squared.进行第二次回归分析，用（b）中得到的 Beta 和跟踪误差（方差形式）以及电子表格中额外股票的数据（参考 BKM 第 13.1 小节）对（a）中得到股票平均超额收益回归，并报告 gamma 0、gamma 1、gamma 2、标准误差、相关 t 值和调整后的决定系数（adjusted R2）。(d) Run a multi variable regression for each of the seven shares by regressing the share’s monthly excess returns on the monthly excess returns of the equity index and the additional factor data (ie Consumer Sentiment Index and Fama-French HML index. HML = High Minus Low see page 340 for an explanation of this factor) provided in the spreadsheet refer to page 425 for an example of a multi factor model (NB: we’re only running a first pass regression here). Report each share’s alpha, betas; t-statistics; and adjusted R squared.对这七只股票进行多元回归分析，用股票月度超额收益对股票指数月度超额收益和电子表格中额外因子的数据（比如，消费者信心指数和法马-佛伦奇的账面市值比指数。账面市值比（HML） 因子= 高账面市值比  低账面市值比 ，请参考 340 页上有关该因子的解释），请参考 425 页的多因子模型的示例（注意：我们在这里只进行第一部分的回归）。报告每一只股票的 Alpha，Beta，t 值和调整决定系数。Question 2.第二题。Two asset pricing models have been tested in Question 1. Use the results from that question to evaluate these asset pricing models in the context of Ellipse’s equity portfolio construction.在第一题中测试了两种资产定价模型，根据 Ellipse 创建的股票投资组合，评估这些资产定价模型。（字数限制为 450 汉字）。Question 3.第三题。Research two providers of share betas where the betas are estimated differently to the methods used in this assignment. Explain how they estimate beta and evaluate their approaches in contrast to the methods used in this assignment.对股票 Beta 的两家提供机构进行研究，要求这两家机构对 Beta 的估计方法与这份作业中的方法不同。解释他们估计 Beta 的方法，通过与作业中采用的方法进行对比，来评估他们的方法。（字数限制为 600 汉字）Question 4.第四题。Use the results from Question 1 parts (a) and (b) to construct the following share portfolios. Only include the original seven shares in the portfolio ie do not include the equity index or the additional share data used in Question 1 part (c). Assume zero correlation between the shares’ non-systematic returns when calculating portfolio tracking error (ie portfolio non-systematic risk). Calculate total portfolio risk by combining the systematic element and tracking error of the portfolio per equation 8.16 on page 263 of BKM.第四题。用第一题（a）和（b）中的结果构建如下的股票投资组合。仅纳入最初的七只股票在这个投资组合中，也就是不包含股票指数或第一题（c）中额外的股票数据。在计算投资组合跟踪误差（即投资组合的非系统性风险）的时候，假设股票间非系统性收益的相关系数为零。根据 BKM 中第 263 页的公式 8.16，通过结合投资组合的系统性元素和跟踪误差，计算投资组合的总体风险。(a) Use solver to find the portfolio weights for a long-only share portfolio with the maximum amount of alpha. State the portfolio weights, alpha, beta, tracking error, information ratio and Sharpe ratio.用规划求解为一个多头交易股票投资组合寻找投资组合的权重，这个权重要使 Alpha 的数值最大化。写出投资组合的权重、Alpha、Beta、跟踪误差、信息比率和夏普比率。(b) Use solver to find the portfolio weights for a long-only share portfolio with the minimum amount of tracking error. State the portfolio weights, alpha, beta, tracking error, information ratio and Sharpe ratio.用规划求解为一个多头交易股票投资组合寻找投资组合的权重，这个权重要使跟踪误差最小化。写出投资组合的权重、Alpha、Beta、跟踪误差、信息比率和夏普比率。(c) Use solver to find the portfolio weights for a long-only share portfolio with the maximum amount of information ratio plus a beta constrained to a value of one. State the portfolio weights, alpha, beta, tracking error, information ratio and Sharpe ratio.用规划求解为一个多头交易股票投资组合寻找投资组合的权重，这个权重要使信息比率最大化以及限制 Beta 的值为 1。写出投资组合的权重、Alpha、Beta、跟踪误差、信息比率和夏普比率(d) Use solver to find the portfolio weights for a long-only share portfolio with the maximum amount of Sharpe ratio. State the portfolio weights, alpha, beta, tracking error, information ratio and Sharpe ratio.用规划求解为一个多头交易股票投资组合寻找投资组合的权重，这个权重要使夏普比率最大化。写出投资组合的权重、Alpha、Beta、跟踪误差、信息比率和夏普比率Question 5.第五题。(a) Calculate the standard deviation (using the population version of the formula) of annual returns for Australian equities (based on the S P/ASX 200 Index data in the spreadsheet), Australian bonds (based on the S P Australian Bond Index data) and Australian cash (based on the Bloomberg Ausbond Bank Bill Index data) and the correlation of returns between these three asset classes. Combine these risk estimates with BlackRock’s expected returns for Australian equities (use the “Australia large cap Equities Long Term Expected Return”) and the Australian bonds (use the “Australian treasuries (all maturities) long term expected return”) to chart the opportunity set comprised of a wide range of possible “risky portfolios”. Your chart should show standard deviation pa on the horizontal axis, and expected return pa on the vertical axis.计算澳大利亚股票（基于电子表格中的标普澳证 200 指数数据）、澳大利亚债券（基于标普澳大利亚债券指数数据）和澳大利亚现金（基于彭博澳大利亚债券-银行汇票指数数据）年度收益的标准差（采用总体平均的标准差公式），以及这三种资产类别之间收益的相关系数。把这些估计出的风险与贝莱德的澳大利亚股票（采用澳大利亚高市值股票长期预期收益）和澳大利亚债券（采用所有期限澳大利亚国库券的长期预期收益）的预期收益相结合，制作一张机会集的图表，要求这个机会集广泛地包含了可能的“风险投资组合”。你的图表应该在横坐标上显示每年的标准差，并在纵坐标上显示每年的预期收益。(b) Using the return and risk results from the previous question and BlackRock’s expected returns for Australian cash, find the asset class weights for the optimal risky portfolio(assuming cash as a proxy for the risk free asset and using BlackRock’s expected return) and state the portfolio’s weights, expected return, risk and Sharpe ratio.用前面问题中风险和收益的结果以及贝莱德的澳大利亚现金的预期收益，为最优风险投资组合找到各资产类别的权重（假设现金代表了无风险资产并采用贝莱德的预期收益），得出投资组合的权重、预期收益、风险和夏普比率。(c) Based on the optimal risk portfolio from part (b), chart the capital allocation line. 基于（b）的最优风险投资组合，画出资本配置线。(d) Using the capital allocation line from part (c) and potentially the opportunity set from part (a), present asset allocation portfolios for range of risk attitudes (ie three different levels of risk aversion).用（c）中得到的资本配置线和（a）中得到的机会集， 给出一系列风险取向（即三个不同等级的风险厌恶）的资产配置投资组合。Question 6.第六题。Locate two risk aversion surveys used by fund managers or advisors. Evaluate those surveys in the context of the asset allocation exercise in this assignment.找到基金经理或顾问所用的两份风险厌恶调查。根据这份作业做资产配置，评估这些调查。（字数限制为 600 汉字）Appendix A: Notes on data and spreadsheet analysis 附录A：关于数据和电子表格分析的注释Data数据The S P ASX 200 index data presented in the assignment excel file is a cap-weighted, total return index of 200 companies listed on the Australian stock exchange. The S P Australian Bond Index data in the assignment is a total return index of a diversified portfolio of Australian Bonds. The S P and Bloomberg Australian Bank Bill Indices are both intended to measure the performance of typical Australian managed cash portfolios. The monthly data for the individual shares are also total return indices. “Returns” can be calculated for both the Consumer Sentiment Index and the Fama French HML Index in the same way as calculating returns for the other indices – however do not deduct cash returns from their returns.在作业的电子表格中，标普澳证 200 指数的数据是在澳大利亚股票交易所上市的 200 家公司市值加权平均总收益的指数；标普澳大利亚债券指数数据是一个澳大利亚债券分散投资组合的总收益指数；标准普尔和彭博的澳大利亚银行汇票指数都是为了度量澳大利亚典型的现金管理投资组合的业绩。个股的月度数据也是总收益指数。计算消费者信心指数和法马-佛伦奇账面市值比指数的“收益”，与计算其他指数收益的方法相同，只是不要从收益中减去现金收益。Calculating Rates of Return计算收益率The annual holding period returns can be calculated using the following formula:Holding Period Return IndexEND IndexBEGIN 1 通过下面的公式可以计算年度持有收益率：持有期收益率 IndexEND IndexBEGIN 1Spreadsheet Usage使用电子表格You will need to use a spreadsheet like Microsoft Excel to complete this assignment. You may find the built-in statistical functions {eg STDEV.P( ) and CORREL( ) etc} to be useful in addition to the regression analysis tool. Use the Excel HELP to find out how what specific equations these functions are applying.你需要使用像微软 Excel 一样的电子表格软件来完成这份作业。你会发现在这些软件中除回归分析工具外，其自带的统计公式（比如 STDEV.P( ) 和 CORREL( )等）也很实用。可以用电子表格的“帮助”菜单来找出这些公式具体如何应用。Use of Optimiser使用优化器To use the embedded optimiser (entitled “Solver”) in Excel, select the Data tab and look in the analysis section. In your spreadsheet, you can make some initial guesses for the weights of each asset to be included in the portfolio. Calculate the required portfolio return, risk, performance ratio etc… based on these weights. In the pop-up Solver box, set the “set objective” to the cell containing the formula for the objective measure (eg the Sharpe ratio in the context of the optimal risky portfolio etc). Select “max” (or “min” if appropriate etc…). In the “by changing variable cells” field, select the cells containing asset weights. If you click the “solve” key, the optimiser will attempt to optimise the performance measure by adjusting the weights for each asset. It is likely that you will need some constraints for the optimisation (eg by using the “subject to the constraints” component). For example, ensure that the sum of the weights is constrained to equal one. Also, consider adding additional constraints if they prove appropriate in the context of the assignment.如要使用 Excel 内置的优化器（名称为“规划求解”），在数据选项卡的分析组中找到。在电子表格中，你可以先猜测投资组合中每一项资产的权重，然后据此计算要求的投资组合收益、风险和业绩比率等等。在弹出的规划求解对话框中，在“设置目标”框中输入含有目标度量（比如优化风险投资组合的夏普比率等）公式的单元格，选择“最大值”（或“最小值”）。在“可变变量单元格”框中，选择包含资产权重的单元格。如果你单击了“求解”，优化器将尝试通过改变每一项资产的权重来优化业绩度量。你可能需要为优化设置一些约束条件（使用“遵守约束”），比如保证约束权重之和为一。此外如果在作业中适用，还可以考虑增加额外的约束条件。Marking Spreadsheets评分和电子表格We do not mark spreadsheet. Do not submit spreadsheet files or spreadsheet print outs with your assignment answer.我们不对电子表格进行评分。在提交作业时，不要提交电子表格文件或者打印件。Appendix B: Mapping BKM 10th English version and 9th Chinese version附录 B：BKM 课本英文第十版和中文第九版的页码对照BKM 课本英文第十版相关章节 BKM 课本中文第九版相关章节

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。