Actuarial Outpost
 
Go Back   Actuarial Outpost > Exams - Please Limit Discussion to Exam-Related Topics > SoA > Modules 1-5
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 09-14-2016, 11:00 AM
koudai8 koudai8 is offline
SOA
 
Join Date: Feb 2015
Posts: 23
Default EOM 3 Task 5 (Excel help)

Task 5 asks us to assess whether 12/17 contribution plan is appropriate, and if not, provide our own estimate.

I have a couple of questions:

1. the 12/17 refers to the 12% "up to covered earnings" and 17% "in excess of covered earnings", right?

2. When I was trying to find the rate for certain employee so that he/she could have replacement ratio of 70%, I used goal seek by selecting "By changing cells" to be the cells containing 12% and 17%, only the first cell gets changed. For example, if I select 17% first then 12%, only the 17% would change. What am I doing wrong?

3. I tried a different approach using Solver. I selected the target cell and chose "set it to" 0.7, and the cells containing 12% and 17% to "by changing cells". However, the solver returned that it could not find a solution, with all three methods of equation solving. What is wrong in this case?

4. Lastly, both "up to" and "in excess" rates are capped by 15% in total right? In other words, "up to percentage" * covered + "in excess percentage" * (pensionable - covered) must be less than 15% of earned income. Is that correct?

Thanks!
__________________
ASA ERM Mods
ILALPM ILALFM DMAC FAC
Reply With Quote
  #2  
Old 09-14-2016, 11:52 AM
SirCountador's Avatar
SirCountador SirCountador is offline
Member
Non-Actuary
 
Join Date: Aug 2012
Posts: 500
Default

1-yes
2-goal seek only allows 1 cell at a time as you saw. you're looking for scenario manager or solver.
3-is there something wrong?
4-if you're not sure about something just assume and defend the assumption. what you said seems reasonable but i forget the wording they used
Reply With Quote
  #3  
Old 09-15-2016, 12:34 AM
koudai8 koudai8 is offline
SOA
 
Join Date: Feb 2015
Posts: 23
Default

Quote:
Originally Posted by SirCountador View Post
1-yes
2-goal seek only allows 1 cell at a time as you saw. you're looking for scenario manager or solver.
3-is there something wrong?
4-if you're not sure about something just assume and defend the assumption. what you said seems reasonable but i forget the wording they used
Thank you so much!
__________________
ASA ERM Mods
ILALPM ILALFM DMAC FAC
Reply With Quote
Reply

Tags
eom3

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 12:20 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.13273 seconds with 11 queries