Use completed Table 3 values and notes under Table 3 to complete...
Question
Answered step-by-step
Asked by Fkschool666 on coursehero.com
Use completed Table 3 values and notes under Table 3 to complete...
Use completed Table 3 values and notes under Table 3 to complete Table 4 (Mark Smith is an example).
Age
Risk
Number
Name
Gender
Income
Score
Net Worth
Profile
1
Mike Smith
M
Medium
30
Medium
High
2
Ben Johnson
M
low
13
medium
Very High
3
Fran Klien
F
medium
33
medium
Medium
4
William Grouper
M
high
34
medium
High
5
Mary Quinn
F
high
37
low
Low
6
Sam Willard
M
low
58
low
Low
7
Karen Queen
F
high
18
high
Medium
8
Dan Ziggler
M
high
46
high
High
9
Anna Lowe
F
low
57
low
Medium
10
Mike Younger
M
low
2
high
Medium
11
Sally Ringer
F
Medium
46
medium
High
Rules for Table 3
If Income is < $50,000 then Income Category = Low
If Income is = or > $50,000 and < $100,000 then Income Category = Medium
If Income is equal or greater than $100,000 then Income Category = High
Age score = (Mandatory retirement age of 65 - employee age) X 1.5
See example Mike Smith (65-45) X 1.5 = 30 in Table 2
If Net worth is < $300,000 then Net worth category = Low
If Net worth is = or > $300,000 and < $1,000,000 then Net worth category = Medium
If Net worth is = or > $1,000,000 then Net worth category = High
TABLE 4 - EMPLOYEE SCORING
Age
Risk Aversion
Personal risk
Number
Name
Gender
Income
Score
Net Worth
Score
Score (sum)
1
Mike Smith
M
5
30
5
5
45
2
Ben Johnson
M
3
Fran Klien
F
4
William Grouper
M
5
Mary Quinn
F
6
Sam Willard
M
7
Karen Queen
F
8
Dan Ziggler
M
9
Anna Lowe
F
10
Mike Younger
M
11
Sally Ringer
F
Rules for Table 4
If Income is Low the point value = 0, If Income is medium the point value = 5
If Income is high the point value = 10
Copy Age score from Table 3 to Table 4 (round upward if not an integer)
If Net Worth is Low value = 0, If Net Worth is medium the point value = 5
If Net Worth is high the point value = 10
If Table 2 risk profile = Low then Risk aversion score = 20
If Table 2 risk profile = Medium then Risk aversion score = 10
If Table 2 risk profile = High then Risk aversion score = 5
If Table 2 risk profile = Very High then Risk aversion score = 0
Answer & Explanation
Solved by verified expert
Answered by PrivateDragonflyPerson780 on coursehero.com
<p style="margin-left:0px;">sectetur adipiscing elit.</p><p style="margin-left:0px;">sectetur</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulv</p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce d
Unlock access to this and over 10,000 step-by-step explanations
<p style="margin-left:0px;">sectetur adipiscing elit. Nam</p><p style="margin-left:0px;">sectetur</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pul</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet</p><p style="margin-left:0px;">sectetur adipiscin</p><p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus</p><p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pel</p><p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, da</p><p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lo</p><p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapi</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facili</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vita</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec a</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui l</p><p style="margin-left:0px;">sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur</p><p style="margin-left:auto;"> </p><p> </p><p style="margin-left:auto;"><br/> </p>
Get unstuck with a CliffsNotes subscription
Unlock every step-by-step explanation, download literature note PDFs, plus more.Get Access