Actuarial Outpost > SoA EOM 4 Investment return analysis
 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

US HEALTH ACTUARIAL JOBS

#1
08-07-2010, 01:07 PM
 star000 Join Date: Mar 2007 Posts: 24
EOM 4 Investment return analysis

I am currently on the investment analysis tab and I have trouble with the overall average. It says "An estimate for the overall estimated yield for all years can be found as the weighted average of the annual yield and the value of assets at the beginning of the year". So what is the formula should i use for cell K18:N18.
My formula gave me overall yield 4.61% which is not correct i think.
Any help would be highly appreciated!
#2
08-09-2010, 12:49 PM
 surdahl Member SOA Join Date: Apr 2007 Location: Florida Posts: 193

I don't know the exact cell references, but the formula should be:

SUMPRODUCT(Asset value beginning of year for all years , return on assets for each year for all years) / SUM(Asset value beginning of year for all years)
#3
08-09-2010, 02:17 PM
 star000 Join Date: Mar 2007 Posts: 24

Quote:
 Originally Posted by surdahl I don't know the exact cell references, but the formula should be: SUMPRODUCT(Asset value beginning of year for all years , return on assets for each year for all years) / SUM(Asset value beginning of year for all years)
Got it. Thank you so much!
#4
05-20-2012, 08:09 AM
 its_me Member Join Date: Jan 2003 Location: AO Posts: 1,771

For those doing the prior version of FAP,for Task1 Part 3, I am thinking that we weight the Asset Values @ Beginning Of Year and Investment Incomes by 0.5,0.3 and 0.2 to get the Total ( Columns F J & N).
Am I right?
__________________
Everyone dreams. Some people are just more active participants.
#5
05-21-2012, 04:27 PM
 Anitha Desai Member SOA Join Date: Jul 2007 Studying for DP ILA Posts: 8,265

Quote:
 Originally Posted by its_me For those doing the prior version of FAP,for Task1 Part 3, I am thinking that we weight the Asset Values @ Beginning Of Year and Investment Incomes by 0.5,0.3 and 0.2 to get the Total ( Columns F J & N). Am I right?
I don't think you use weighting to calculate totals in columns F, J and N.
You only use it to calculate avergae yields in columnds K, L, M and N, row 18.
__________________
Life results from the non-random survival of randomly generated replicators. - Richard Dawkins
#6
05-21-2012, 10:33 PM
 its_me Member Join Date: Jan 2003 Location: AO Posts: 1,771

Quote:
 Originally Posted by Anitha Desai I don't think you use weighting to calculate totals in columns F, J and N. You only use it to calculate avergae yields in columnds K, L, M and N, row 18.
1. where have they mentioned that the values given in tab 8 is already weighted?

i thought col F & J is the result of weighting the prev 3 columns
the formulas apply for the total

2. the avg yeild is sumproduct( estimated yields & Asset Values)/Sum( asset values)
__________________
Everyone dreams. Some people are just more active participants.

 Tags eom4

 Thread Tools Display Modes Linear Mode

 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 06:45 AM.

 -- Default Style - Fluid Width ---- Default Style - Fixed Width ---- Old Default Style ---- Easy on the eyes ---- Smooth Darkness ---- Chestnut ---- Apple-ish Style ---- If Apples were blue ---- If Apples were green ---- If Apples were purple ---- Halloween 2007 ---- B&W ---- Halloween ---- AO Christmas Theme ---- Turkey Day Theme ---- AO 2007 beta ---- 4th Of July Contact Us - Actuarial Outpost - Archive - Privacy Statement - Top