Actuarial Outpost > SoA EOM 3 Task 1 & 2
 Register Blogs Wiki FAQ Calendar Search Today's Posts Mark Forums Read
 FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

 Not looking for a job? Tell us about your ideal job, and we'll only contact you when it opens up. https://www.dwsimpson.com/register

#31
10-08-2018, 04:35 PM
 jonniemarko SOA Join Date: Aug 2018 College: Baruch College, 2017; Auburn University, 2008 Posts: 9

I know that this is an old thread, but hope that I'm not the only one working on this right now.

I'm curious if anyone has any thoughts on using gender as an input for task 2? It doesn't affect the DB portion, but the annuity factors are broken down by gender. It seems from the threads that most folks are trying to solve for just one formula that will apply to (almost) everyone. Given the different prices for annuities, though, male and female replacement ratios will be different, all else being equal.

Has anyone else considered giving more formulas that take that into account?
#32
05-06-2019, 10:08 PM
 windsowe Member SOA Join Date: Feb 2011 Location: Nashville Studying for MLC College: Vanderbilt Alum Favorite beer: Lucky Bucket IPA Posts: 205

I'm working on EOM 3 and had a similar question to a previous poster. Several combos of up to CPP and above CPP yield 70%. I know we're limited to the "up to CPP" being no lower than 7 percentage points below the "above CPP" amount (for example, up to CPP can be 11%, but above CPP can be no higher than 18%). What about the other way around? Could have the "up to CPP" be 7 percentage points higher than the "above CPP" amount?

Quote:
 Originally Posted by jonniemarko I know that this is an old thread, but hope that I'm not the only one working on this right now. I'm curious if anyone has any thoughts on using gender as an input for task 2? It doesn't affect the DB portion, but the annuity factors are broken down by gender. It seems from the threads that most folks are trying to solve for just one formula that will apply to (almost) everyone. Given the different prices for annuities, though, male and female replacement ratios will be different, all else being equal. Has anyone else considered giving more formulas that take that into account?
__________________

___________
P FM MFE C LTAM PA
FNCE ECON STAT

FAP: 1 2 3 4 5 IA 6 7 8 FA
APC
#33
05-09-2019, 03:11 PM
 chable SOA AAA Join Date: Jan 2016 Location: Minneapolis,MN Studying for LTAM College: University of Wisconsin-River Falls Posts: 25
So Confused

I thought I knew what I was doing but after reading everyone else's responses I think I am completely lost.

I don't get different values for cells F12 and F15 on the 'Results' tab when I plug in the 50,000/100,000/200,000 values in the inputs... I have no idea what I'm doing wrong or what I am not understanding for these tasks.

For task 1, all I tweaked was the input in cell G18 and for task 2 all I tweaked was the input in cell G21.

Can anyone give advice on this?
__________________
P FM IFM STAM LTAM PA SRM

VEE

Modules 1-5, IA
Modules 6-8, FA

APC
#34
05-09-2019, 03:21 PM
 windsowe Member SOA Join Date: Feb 2011 Location: Nashville Studying for MLC College: Vanderbilt Alum Favorite beer: Lucky Bucket IPA Posts: 205

You need to input the salary for each EE. For task 1, the DB rates are already populated and don't need any adjustment. You should get different %'s in F12 of the Results tab if you use different salaries.

Quote:
 Originally Posted by chable I thought I knew what I was doing but after reading everyone else's responses I think I am completely lost. I don't get different values for cells F12 and F15 on the 'Results' tab when I plug in the 50,000/100,000/200,000 values in the inputs... I have no idea what I'm doing wrong or what I am not understanding for these tasks. For task 1, all I tweaked was the input in cell G18 and for task 2 all I tweaked was the input in cell G21. Can anyone give advice on this?
__________________

___________
P FM MFE C LTAM PA
FNCE ECON STAT

FAP: 1 2 3 4 5 IA 6 7 8 FA
APC
#35
05-13-2019, 01:59 PM
 Master_of_my_domain Member SOA Join Date: May 2018 College: University of Colorado Posts: 196

This might seem like a silly question but do we have to include Tasks 1-4 in the memo? It seems like they are intended to help us figure out how to use the spreadsheets and formulas but the ultimate deliverable is the memo, which is mostly tied to Task 7.

Thoughts?
__________________
Exams: P FM IFM STAM LTAM SRM PA
VEE: Econ Stat CF
FAP: M1-5 IA M6-8 FA
ERM Module
APC
#36
05-13-2019, 03:33 PM
 windsowe Member SOA Join Date: Feb 2011 Location: Nashville Studying for MLC College: Vanderbilt Alum Favorite beer: Lucky Bucket IPA Posts: 205

Probably not in the memo as such, but I plan to include mine separately.
__________________

___________
P FM MFE C LTAM PA
FNCE ECON STAT

FAP: 1 2 3 4 5 IA 6 7 8 FA
APC

 Tags eom3