xuebaunion@vip.163.com

3551 Trousdale Rkwy, University Park, Los Angeles, CA

留学生论文指导和课程辅导

无忧GPA：https://www.essaygpa.com

工作时间：全年无休-早上8点到凌晨3点

扫码添加客服微信

扫描添加客服微信

程序代写案例-STAT3038/6045

时间：2021-02-06

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 1 of 4

Research School of Finance, Actuarial Studies & Statistics

FINAL EXAMINATION

Semester 2 – End of Semester, 2020

STAT3038/6045 Actuarial Techniques

Writing Time: 150 minutes

Reading Time: nil

Exam Conditions:

Central Examination

Students access this exam paper via a link from a Wattle quiz invigilated by Proctorio

This examination paper is not available to the ANU Library archives

Materials Permitted In The Exam:

Computer utilizing only Wattle, Excel, Word, Adobe PDF Reader (and email if required – see below)

Files saved locally on the computer may be accessed during the exam

Paper-based Dictionary

Calculator (programmable allowed)

Instructions to Students:

• The exam contains one question only which you must answer. Your submission must consist

of a maximum of one Excel file and a maximum of one Word file.

• You MUST use “Final Exam Template” on Wattle as the starting point for the Excel work

required in this question. Marks will be deducted from the final exam score for not following

this instruction.

• You MUST start your Word work in this question from a blank document. Marks will be

deducted from the final exam score for not following this instruction.

• Students have been previously advised in Lesson 1.7 and Lesson 2.6 of the Proctorio

requirements of this exam and have been given an opportunity to download the necessary

software and practice submission via Proctorio before this exam.

• You have 150 minutes to upload your solution to the exam. This time starts from when you

have completed the Proctorio pre-checking and are able to access the exam. A countdown

timer can be found in the activity from which you access the exam. Make sure you leave

sufficient time to upload your solutions within the 150 minute period. It is strongly

recommended you finish the exam 10 minutes before the end of the 150-minute period to

give yourself sufficient time.

• The latest possible time to submit the exam is 160 minutes after the scheduled start of the

exam, although the 150 minute time limit described above still applies. Hence you have 10

minutes from the scheduled start of the exam to complete the Proctorio pre-checking and

access the exam. If you take longer than 10 minutes to complete the pre-checking you will

have less than 150 minutes to upload your solution to the exam.

• The course convener will be available on Zoom and by email if required during the exam. A

link to the Zoom meeting is available in the Proctorio examination area.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 2 of 4

Instructions to Students (continued):

• If the course convener needs to contact all students they will do so via a forum post linked in

the Proctorio examination area as “Messages to all students from course convener”. Make

sure to check this document occasionally during the exam, and click on the link at least once

every two hours to ensure you are not logged out of Wattle before uploading your solution.

• For any technical issues during the exam, you can contact Wattle help via +61 2 6125 4321

(opt 1, opt 5) or wattle.support@anu.edu.au.

• When you have completed your attempt, you must upload both your Excel and Word files to

the quiz activity from which you accessed this exam paper. After this, you must also

immediately upload your Excel file to the “Upload Final Exam Solution Excel Submission”

assignment activity on Wattle and your Word file to the “Upload Final Exam Solution Word

Submission” Turnitin activity on Wattle. In the unlikely event of an issue with uploading

solutions you will be able to submit a soft copy of your Excel and Word work by email to the

course convener. Ensure that any submission occurs before the completion of your 150

minute time limit. Late submissions will not be accepted.

• Ensure that you save your work regularly. This is your responsibility and no allowance will be

made for forgetting to save your work.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 3 of 4

Question

BMZ is investigating entering into an arrangement with another financial services institution,

Eastcap, where Eastcap would share some of the obligations of the BMZ Superannuation

Scheme. How this arrangement would work is as follows:

Option 1

• At the start of each year (1 July), the Scheme would pay Eastcap a premium of $(Z%

x Expected Withdrawal Payments).

• The Expected Withdrawal Payments are calculated by aggregating the following

across all active members of the Scheme:

Leaving Service Benefit of the member at that 1 July; multiplied by the probability

that the member will withdraw at the next 30 June.

• Upon voluntary departure of a member, the Scheme would pay (1 – Z%) of the

withdrawal benefits payable, with Eastcap paying the remaining Z% of the withdrawal

benefits payable.

Option 2

• At the start of each year (1 July), the Scheme would pay Eastcap a premium of $(Y%

x Expected Death Payments).

• The Expected Death Payments are calculated by aggregating the following across all

remaining members of the Scheme:

Death Payment that the member is eligible for at the next 31 December; multiplied by

the probability that the member will die at the next 31 December.

• Upon death of a member, the Scheme would pay (1 – Y%) of the death benefits

payable, with Eastcap paying the remaining Y% of the death benefits payable.

You are the actuarial consultant to the Scheme. The Chief Finance Officer (CFO) of BMZ

would like some analysis of the potential effect of these arrangements on the funding level

of the Scheme for the next 10 years.

Prepare a note to the CFO, of no more than 3 pages in Word, which includes the following:

• A brief scope of your task.

• A graphical comparison of the median and 15th/85th percentile Funding Level over

each of the next 10 years, for Z% = 0%, 50% and 100%. Keep Y = 0%.

• A graphical comparison of the median and 15th/85th percentile Funding Level over

each of the next 10 years, for Y% = 0%, 50% and 100%. Keep Z = 0%.

• Descriptions and reasons for the results of the above comparisons, including any

additional analysis that assists in explaining the results.

The document is not required to have any details on the underlying model used and must be

able to be read on its own without reference to the Excel workbook.

Note that the premium paid by the Scheme is not to be included in the Funding Level

calculation at the same 1 July. For example, the Funding Level at 1 July 2020 is unchanged

at 120.2%, with the premium being deducted from the Scheme Assets after the Funding

Level is calculated.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 4 of 4

Question…continued

Recall that the benefits of the Scheme are calculated as follows:

Reason for departure

Benefit paid

Leaving service (voluntarily)

0.015 x (65 – Age at date of leaving service) x Member

Account;

plus

(1 – 0.015 x (65 – Age at date of leaving service)) x 23% x

Years of membership at date of leaving service x Annual

Salary at the date of leaving service

Death (paid to dependents)

23% x (65 – Age at date joined the scheme) x Annual Salary

at the date of death

Further instructions

Use “Final Exam Template” as a starting point for the Excel work required in this question.

You may assume that all assumptions and other components in “Final Exam Template” are

correct and do not require any updating beyond any requirements described in the question.

You should do the following when creating the revised Excel workbook:

• Output from different scenarios that are needed for graphing purposes should be

pasted in the “Key Results” worksheet as values. Any graphs you generate to

answer the question should be placed in this worksheet.

• Any new worksheets you create should have their worksheet tabs highlighted in light

blue.

• Any worksheets that have additions or changes made to them should have their

worksheet tabs highlighted in light blue. Any cells in these worksheets that have

been created or changed should be highlighted in light blue.

• You should design the changes in such a way that the Options and Z/Y values to be

compared in the question can easily be switched between by changing as few cells

as possible. Your submitted Excel workbook should include the calculations from the

revised cash flow structure with Z = 50% and Y = 0%.

The weighting of each component of this task towards the mark for this question is as

follows:

• Calculation of output elements required by the question in Excel = 40%

• Following the instructions above in designing the Excel workbook = 5%

• Appropriate description of scope of task in Word document = 5%

• Presentation of results given the requirements of the stakeholder = 20%

• Description and reasons for the results in the Word document = 25%

• General structure and coherence of the Word document = 5%

END OF EXAMINATION

学霸联盟

Page 1 of 4

Research School of Finance, Actuarial Studies & Statistics

FINAL EXAMINATION

Semester 2 – End of Semester, 2020

STAT3038/6045 Actuarial Techniques

Writing Time: 150 minutes

Reading Time: nil

Exam Conditions:

Central Examination

Students access this exam paper via a link from a Wattle quiz invigilated by Proctorio

This examination paper is not available to the ANU Library archives

Materials Permitted In The Exam:

Computer utilizing only Wattle, Excel, Word, Adobe PDF Reader (and email if required – see below)

Files saved locally on the computer may be accessed during the exam

Paper-based Dictionary

Calculator (programmable allowed)

Instructions to Students:

• The exam contains one question only which you must answer. Your submission must consist

of a maximum of one Excel file and a maximum of one Word file.

• You MUST use “Final Exam Template” on Wattle as the starting point for the Excel work

required in this question. Marks will be deducted from the final exam score for not following

this instruction.

• You MUST start your Word work in this question from a blank document. Marks will be

deducted from the final exam score for not following this instruction.

• Students have been previously advised in Lesson 1.7 and Lesson 2.6 of the Proctorio

requirements of this exam and have been given an opportunity to download the necessary

software and practice submission via Proctorio before this exam.

• You have 150 minutes to upload your solution to the exam. This time starts from when you

have completed the Proctorio pre-checking and are able to access the exam. A countdown

timer can be found in the activity from which you access the exam. Make sure you leave

sufficient time to upload your solutions within the 150 minute period. It is strongly

recommended you finish the exam 10 minutes before the end of the 150-minute period to

give yourself sufficient time.

• The latest possible time to submit the exam is 160 minutes after the scheduled start of the

exam, although the 150 minute time limit described above still applies. Hence you have 10

minutes from the scheduled start of the exam to complete the Proctorio pre-checking and

access the exam. If you take longer than 10 minutes to complete the pre-checking you will

have less than 150 minutes to upload your solution to the exam.

• The course convener will be available on Zoom and by email if required during the exam. A

link to the Zoom meeting is available in the Proctorio examination area.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 2 of 4

Instructions to Students (continued):

• If the course convener needs to contact all students they will do so via a forum post linked in

the Proctorio examination area as “Messages to all students from course convener”. Make

sure to check this document occasionally during the exam, and click on the link at least once

every two hours to ensure you are not logged out of Wattle before uploading your solution.

• For any technical issues during the exam, you can contact Wattle help via +61 2 6125 4321

(opt 1, opt 5) or wattle.support@anu.edu.au.

• When you have completed your attempt, you must upload both your Excel and Word files to

the quiz activity from which you accessed this exam paper. After this, you must also

immediately upload your Excel file to the “Upload Final Exam Solution Excel Submission”

assignment activity on Wattle and your Word file to the “Upload Final Exam Solution Word

Submission” Turnitin activity on Wattle. In the unlikely event of an issue with uploading

solutions you will be able to submit a soft copy of your Excel and Word work by email to the

course convener. Ensure that any submission occurs before the completion of your 150

minute time limit. Late submissions will not be accepted.

• Ensure that you save your work regularly. This is your responsibility and no allowance will be

made for forgetting to save your work.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 3 of 4

Question

BMZ is investigating entering into an arrangement with another financial services institution,

Eastcap, where Eastcap would share some of the obligations of the BMZ Superannuation

Scheme. How this arrangement would work is as follows:

Option 1

• At the start of each year (1 July), the Scheme would pay Eastcap a premium of $(Z%

x Expected Withdrawal Payments).

• The Expected Withdrawal Payments are calculated by aggregating the following

across all active members of the Scheme:

Leaving Service Benefit of the member at that 1 July; multiplied by the probability

that the member will withdraw at the next 30 June.

• Upon voluntary departure of a member, the Scheme would pay (1 – Z%) of the

withdrawal benefits payable, with Eastcap paying the remaining Z% of the withdrawal

benefits payable.

Option 2

• At the start of each year (1 July), the Scheme would pay Eastcap a premium of $(Y%

x Expected Death Payments).

• The Expected Death Payments are calculated by aggregating the following across all

remaining members of the Scheme:

Death Payment that the member is eligible for at the next 31 December; multiplied by

the probability that the member will die at the next 31 December.

• Upon death of a member, the Scheme would pay (1 – Y%) of the death benefits

payable, with Eastcap paying the remaining Y% of the death benefits payable.

You are the actuarial consultant to the Scheme. The Chief Finance Officer (CFO) of BMZ

would like some analysis of the potential effect of these arrangements on the funding level

of the Scheme for the next 10 years.

Prepare a note to the CFO, of no more than 3 pages in Word, which includes the following:

• A brief scope of your task.

• A graphical comparison of the median and 15th/85th percentile Funding Level over

each of the next 10 years, for Z% = 0%, 50% and 100%. Keep Y = 0%.

• A graphical comparison of the median and 15th/85th percentile Funding Level over

each of the next 10 years, for Y% = 0%, 50% and 100%. Keep Z = 0%.

• Descriptions and reasons for the results of the above comparisons, including any

additional analysis that assists in explaining the results.

The document is not required to have any details on the underlying model used and must be

able to be read on its own without reference to the Excel workbook.

Note that the premium paid by the Scheme is not to be included in the Funding Level

calculation at the same 1 July. For example, the Funding Level at 1 July 2020 is unchanged

at 120.2%, with the premium being deducted from the Scheme Assets after the Funding

Level is calculated.

Semester 2 – End of Semester, 2020 STAT3038/6045 Actuarial Techniques

Page 4 of 4

Question…continued

Recall that the benefits of the Scheme are calculated as follows:

Reason for departure

Benefit paid

Leaving service (voluntarily)

0.015 x (65 – Age at date of leaving service) x Member

Account;

plus

(1 – 0.015 x (65 – Age at date of leaving service)) x 23% x

Years of membership at date of leaving service x Annual

Salary at the date of leaving service

Death (paid to dependents)

23% x (65 – Age at date joined the scheme) x Annual Salary

at the date of death

Further instructions

Use “Final Exam Template” as a starting point for the Excel work required in this question.

You may assume that all assumptions and other components in “Final Exam Template” are

correct and do not require any updating beyond any requirements described in the question.

You should do the following when creating the revised Excel workbook:

• Output from different scenarios that are needed for graphing purposes should be

pasted in the “Key Results” worksheet as values. Any graphs you generate to

answer the question should be placed in this worksheet.

• Any new worksheets you create should have their worksheet tabs highlighted in light

blue.

• Any worksheets that have additions or changes made to them should have their

worksheet tabs highlighted in light blue. Any cells in these worksheets that have

been created or changed should be highlighted in light blue.

• You should design the changes in such a way that the Options and Z/Y values to be

compared in the question can easily be switched between by changing as few cells

as possible. Your submitted Excel workbook should include the calculations from the

revised cash flow structure with Z = 50% and Y = 0%.

The weighting of each component of this task towards the mark for this question is as

follows:

• Calculation of output elements required by the question in Excel = 40%

• Following the instructions above in designing the Excel workbook = 5%

• Appropriate description of scope of task in Word document = 5%

• Presentation of results given the requirements of the stakeholder = 20%

• Description and reasons for the results in the Word document = 25%

• General structure and coherence of the Word document = 5%

END OF EXAMINATION

学霸联盟

- 留学生代写
- Python代写
- Java代写
- c/c++代写
- 数据库代写
- 算法代写
- 机器学习代写
- 数据挖掘代写
- 数据分析代写
- Android代写
- html代写
- 计算机网络代写
- 操作系统代写
- 计算机体系结构代写
- R代写
- 数学代写
- 金融作业代写
- 微观经济学代写
- 会计代写
- 统计代写
- 生物代写
- 物理代写
- 机械代写
- Assignment代写
- sql数据库代写
- analysis代写
- Haskell代写
- Linux代写
- Shell代写
- Diode Ideality Factor代写
- 宏观经济学代写
- 经济代写
- 计量经济代写
- math代写
- 金融统计代写
- 经济统计代写
- 概率论代写
- 代数代写
- 工程作业代写
- Databases代写
- 逻辑代写
- JavaScript代写
- Matlab代写
- Unity代写
- BigDate大数据代写
- 汇编代写
- stat代写
- scala代写
- OpenGL代写
- CS代写
- 程序代写
- 简答代写
- Excel代写
- Logisim代写
- 代码代写
- 手写题代写
- 电子工程代写
- 判断代写
- 论文代写
- stata代写
- witness代写
- statscloud代写
- 证明代写
- 非欧几何代写
- 理论代写
- http代写
- MySQL代写
- PHP代写
- 计算代写
- 考试代写
- 博弈论代写
- 英语代写
- essay代写
- 不限代写
- lingo代写
- 线性代数代写
- 文本处理代写
- 商科代写
- visual studio代写
- 光谱分析代写
- report代写
- GCP代写
- 无代写
- 电力系统代写
- refinitiv eikon代写
- 运筹学代写
- simulink代写
- 单片机代写
- GAMS代写
- 人力资源代写
- 报告代写
- SQLAlchemy代写
- Stufio代写
- sklearn代写
- 计算机架构代写
- 贝叶斯代写
- 以太坊代写
- 计算证明代写
- prolog代写
- 交互设计代写
- mips代写
- css代写
- 云计算代写
- dafny代写
- quiz考试代写
- js代写
- 密码学代写
- ml代写
- 水利工程基础代写
- 经济管理代写
- Rmarkdown代写
- 电路代写
- 质量管理画图代写
- sas代写
- 金融数学代写
- processing代写
- 预测分析代写
- 机械力学代写
- vhdl代写
- solidworks代写
- 不涉及代写
- 计算分析代写
- Netlogo代写
- openbugs代写
- 土木代写
- 国际金融专题代写
- 离散数学代写
- openssl代写
- 化学材料代写
- eview代写
- nlp代写
- Assembly language代写
- gproms代写
- studio代写
- robot analyse代写
- pytorch代写
- 证明题代写
- latex代写
- coq代写
- 市场营销论文代写
- 人力资论文代写
- weka代写
- 英文代写
- Minitab代写
- 航空代写
- webots代写
- Advanced Management Accounting代写
- Lunix代写
- 云基础代写
- 有限状态过程代写
- aws代写
- AI代写
- 图灵机代写
- Sociology代写
- 分析代写
- 经济开发代写
- Data代写
- jupyter代写
- 通信考试代写
- 网络安全代写
- 固体力学代写
- spss代写
- 无编程代写
- react代写
- Ocaml代写
- 期货期权代写
- Scheme代写
- 数学统计代写
- 信息安全代写
- Bloomberg代写
- 残疾与创新设计代写
- 历史代写
- 理论题代写
- cpu代写
- 计量代写
- Xpress-IVE代写
- 微积分代写
- 材料学代写
- 代写
- 会计信息系统代写
- 凸优化代写
- 投资代写
- F#代写
- C#代写
- arm代写
- 伪代码代写
- 白话代写
- IC集成电路代写
- reasoning代写
- agents代写
- 精算代写
- opencl代写
- Perl代写
- 图像处理代写
- 工程电磁场代写
- 时间序列代写
- 数据结构算法代写
- 网络基础代写
- 画图代写
- Marie代写
- ASP代写
- EViews代写
- Interval Temporal Logic代写
- ccgarch代写
- rmgarch代写
- jmp代写
- 选择填空代写
- mathematics代写
- winbugs代写
- maya代写
- Directx代写
- PPT代写
- 可视化代写
- 工程材料代写
- 环境代写
- abaqus代写
- 投资组合代写
- 选择题代写
- openmp.c代写
- cuda.cu代写
- 传感器基础代写
- 区块链比特币代写
- 土壤固结代写
- 电气代写
- 电子设计代写
- 主观题代写
- 金融微积代写
- ajax代写
- Risk theory代写
- tcp代写
- tableau代写
- mylab代写
- research paper代写
- 手写代写
- 管理代写
- paper代写
- 毕设代写
- 衍生品代写
- 学术论文代写
- 计算画图代写
- SPIM汇编代写
- 演讲稿代写
- 金融实证代写
- 环境化学代写
- 通信代写
- 股权市场代写
- 计算机逻辑代写
- Microsoft Visio代写
- 业务流程管理代写
- Spark代写
- USYD代写
- 数值分析代写
- 有限元代写
- 抽代代写
- 不限定代写
- IOS代写
- scikit-learn代写
- ts angular代写
- sml代写
- 管理决策分析代写
- vba代写
- 墨大代写
- erlang代写
- Azure代写
- 粒子物理代写
- 编译器代写
- socket代写
- 商业分析代写
- 财务报表分析代写
- Machine Learning代写
- 国际贸易代写
- code代写
- 流体力学代写
- 辅导代写
- 设计代写
- marketing代写
- web代写
- 计算机代写
- verilog代写
- 心理学代写
- 线性回归代写
- 高级数据分析代写
- clingo代写
- Mplab代写
- coventorware代写
- creo代写
- nosql代写
- 供应链代写
- uml代写
- 数字业务技术代写
- 数字业务管理代写
- 结构分析代写
- tf-idf代写
- 地理代写
- financial modeling代写
- quantlib代写
- 电力电子元件代写
- atenda 2D代写
- 宏观代写
- 媒体代写
- 政治代写
- 化学代写
- 随机过程代写
- self attension算法代写
- arm assembly代写
- wireshark代写
- openCV代写
- Uncertainty Quantificatio代写
- prolong代写
- IPYthon代写
- Digital system design 代写
- julia代写
- Advanced Geotechnical Engineering代写
- 回答问题代写
- junit代写
- solidty代写
- maple代写
- 光电技术代写
- 网页代写
- 网络分析代写
- ENVI代写
- gimp代写
- sfml代写
- 社会学代写
- simulationX solidwork代写
- unity 3D代写
- ansys代写
- react native代写
- Alloy代写
- Applied Matrix代写
- JMP PRO代写
- 微观代写
- 人类健康代写
- 市场代写
- proposal代写
- 软件代写
- 信息检索代写
- 商法代写
- 信号代写
- pycharm代写
- 金融风险管理代写
- 数据可视化代写
- fashion代写
- 加拿大代写
- 经济学代写
- Behavioural Finance代写
- cytoscape代写
- 推荐代写
- 金融经济代写
- optimization代写
- alteryxy代写
- tabluea代写
- sas viya代写
- ads代写
- 实时系统代写
- 药剂学代写
- os代写
- Mathematica代写
- Xcode代写
- Swift代写
- rattle代写
- 人工智能代写
- 流体代写
- 结构力学代写
- Communications代写
- 动物学代写
- 问答代写
- MiKTEX代写
- 图论代写
- 数据科学代写
- 计算机安全代写
- 日本历史代写
- gis代写
- rs代写
- 语言代写
- 电学代写
- flutter代写
- drat代写
- 澳洲代写
- 医药代写
- ox代写
- 营销代写
- pddl代写
- 工程项目代写
- archi代写
- Propositional Logic代写
- 国际财务管理代写
- 高宏代写
- 模型代写
- 润色代写
- 营养学论文代写
- 热力学代写
- Acct代写
- Data Synthesis代写