Questions & AnswersFinancial Accounting

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...

  1. Use completed Table 3 values and notes under Table 3 to complete Table 4 (Mark Smith is an example). 
    Age Risk
NumberNameGenderIncomeScoreNet WorthProfile
1Mike SmithMMedium30MediumHigh
2Ben JohnsonMlow13mediumVery High
3Fran KlienFmedium33mediumMedium
4William GrouperMhigh34mediumHigh
5Mary QuinnFhigh37lowLow
6Sam WillardMlow58lowLow
7Karen QueenFhigh18highMedium
8Dan ZigglerMhigh46highHigh
9Anna LoweFlow57lowMedium
10Mike YoungerMlow2highMedium
11Sally RingerFMedium 46mediumHigh

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 AversionPersonal risk
NumberNameGenderIncomeScoreNet WorthScoreScore (sum)
1Mike SmithM5305545
2Ben JohnsonM     
3Fran KlienF     
4William GrouperM     
5Mary QuinnF     
6Sam WillardM     
7Karen QueenF     
8Dan ZigglerM     
9Anna LoweF     
10Mike YoungerM     
11Sally RingerF     

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
CliffsNotes Logo

Unlock access to this and over
10,000 step-by-step explanations

Unlock Explanation

Have an account? Log In

Step-by-step explanation

<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

Example CliffsNotes Question and Answer
Unlock every step-by-step explanation, download literature note PDFs, plus more.Get Access

Related Q&A