所有数据要把计算过程用EXCEL格式发给我。另有5份参考文件。要求：有好的项目（高回报）和分红之间的关系：你如何判断你公司的ROC？计算过去几年（如2013-2017年） The relationship between having GOOD PROJECTS (with high returns) and paying out dividends: How do you judge the ROC of your company?Calculate it over the past years (say 2013-2017)根据2013年至2017年期间使用的过去一年数据，对于IBDM，我们可以看到一个总体模式，即ROC越高，支付的股息越低。一般来说，股息是公司利润的一部分，分配给股东，是公司信心和财务状况的信号。鉴于，资本收益率不仅包括股息，还包括利息、资本收益增加等条款。这两个条款都会给出公司的情况，但都不能给出完整的情况。还有更多的因素需要考虑，如资产负债表、损益表和其他许多因素。它与WACC相比如何（你在上学期的作业中计算了FINC 5000中的WACC）我们计算出Wacc=3%。对比ROC和WACC的表现，我们可以看到IBM在2013-2016年的表现优于WACC，但在2017年的表现低于WACC。基于此，您的结论是，贵公司的投资增加了相当大的价值ROC>>WACC还是？如果是，你认为这会对你公司的股息/回购政策产生影响吗？解释并添加相关数据以证明您的陈述！Based on the past year data used in between 2013 to 2017, for IBDM, we can see a general pattern that the higher the ROC, the lower the Dividend paid. Generally speaking, Dividend, being a portion of the company’s profit, is distributed to stockholders and it is a signal of the confidence of the company and its financial health. Whereas, Return on Capital, accounts for not only the dividend, but also the interests, increase in the capital gain and other terms. Both the two terms would give a picture of the company but neither give a full picture. There are more factors for consideration, like the Balance Sheet, Income Statement and many others.How does it compare to the WACC (you have calculated the WACC in FINC 5000 last semester homework)We have calculated that WACC = 3%. Compare the performance of ROC with WACC, we can see that the company IBM, outperforms WACC for year 2013-2016, but underperforms WACC for year 2017.Based on this is your conclusion that your company’s investments add considerable value ROC>>>WACC or? If so, do you think this has any influence on your company’s dividend/buy back policy? Explain and add relevant data to proof your statements!As WACC is a common measurement of the minimum expected weighted average return given the risk level of the future cash flow, a ROC >> WACC is a rule of thumb. However, we could not claim that we should lower the Dividend to increase ROC so as to follow the above rule of thumb. This is because ROC takes into account the other profitability factor, like the Net Income. A very big reason for ROC to be underperforming WACC for year 2017 is the shrinkage of Net Income. Therefore, we should not claim that the “ROC>>>WACC”statment has a direct influence on the company’s dividend policy.