| 所在主题： | |
| 文件名: FINAL EXAM_MS6000.pdf | |
| 资料下载链接地址: https://bbs.pinggu.org/a-1826949.html | |
| 附件大小: | |
|
Problem: Suppose an employee starts working after completing her MBA at age 30 at a starting salary of
$50,000. She expects an annual salary increase to be at minimum 1%, at maximum 5%, with a uniform distribution. Her retirement plan requires that she contribute 8% of her salary, and her employer matches that by adding an additional 35% of her contribution. She anticipates an annual return on her retirement portfolio (i.e., return on investment) to be a normal distribution with a mean of 4% and standard deviation of 3.5%. She plans to retire at age 60. Create a spreadsheet model to forecast her average return on investment (i.e., retirement account balance) when she retires at age 60 based on 5,000 simulation trials. 1) What is the expected average balance of her retirement account when she retires at age 60? 2) What is the probability that her ending retirement balance at age 60 will be over $450k? Generate a histogram or density chart that shows this. 最近更新： 只需要做这一道题，就是试卷中的SECTION C ， 100论坛币就到手了！！！！！！！！但是发答案的时候EXCEL文件也要发过来！！ |
|
熟悉论坛请点击新手指南
|
|
| 下载说明 | |
|
1、论坛支持迅雷和网际快车等p2p多线程软件下载，请在上面选择下载通道单击右健下载即可。 2、论坛会定期自动批量更新下载地址,所以请不要浪费时间盗链论坛资源,盗链地址会很快失效。 3、本站为非盈利性质的学术交流网站,鼓励和保护原创作品，拒绝未经版权人许可的上传行为。本站如接到版权人发出的合格侵权通知，将积极的采取必要措施；同时，本站也将在技术手段和能力范围内，履行版权保护的注意义务。 (如有侵权，欢迎举报) |
|
京ICP备16021002号-2 京B2-20170662号
京公网安备 11010802022788号
论坛法律顾问：王进律师
知识产权保护声明
免责及隐私声明
