Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Complete the following analyses of P1, P2, and P3. A. Return of investment B. Expected rate of return C. Variance D. Standard deviation E. Risk

1.Complete the following analyses of P1, P2, and P3.

A. Return of investment

B. Expected rate of return

C. Variance

D. Standard deviation

image text in transcribedE. Risk return analysis

POLICY Active Active Active Active Random Random Random Random Passive Passive Passive Passive OWNER STYLE TOTAL SHARES P1 Large Cap 100 Lowes P1 Large Cap 100 FedEx P1 Large Cap 100 Global Payments P1 Large Cap 100 Huntsman Subtotal 400 Subtotal P2 Large Cap 100 Costco Wholesale P2 100 Large Cap # Coca Cola P2 Mega Cap 100 Walmart P2 Large Cap 100 Celsius Holdings Subtotal 400 Subtotal P3 Micro Cap 100 MKS Instruments P3 Small Cap 100 MSA Safety P3 Micro Cap 100 Lithia Motors P3 Micro Cap 100 B&G Foods Subtotal Grand Total 400 1,200 Subtotal Grand Total NAME OF SECURITY TICKER SYMBOL Low Total Transaction (Sell) Gain/Loss $19,692.00 ($2,932.00) $20,506.00 ($1,533.00) $13,429.00 ($18.00) $3,402.00 ($530.00) $57,029.00 ($5,013.00) FDX GPN HUN COST KO DIVIDEND Total PRICE PAYOUT PRICE PRICE PRICE PRICE WEEK PRICE PRICE WEEK EXPECTED Wk 7 Price vs Transaction WEEK #1 RATIO WEEK #2 WEEK #3 WEEK #4 #5 WEEK #6 #7 ENDING PRICE Wk 6 Price Shares Price Transaction Fee (Buy) Selling Price Transaction Fee $226.09 24.92% $212.92 $202.40 $204.87 $201.28 $197.07 $201.00 $224.73 ($3.93) $22,609.00 $15.00 $22,624.00 $19,707.00 $15.00 $220.24 15.73% $226.56 $221.25 $203.38 $205.74 $205.21 $201.86 $218.87 $3.35 $22,024.00 $15.00 $22,039.00 $20,521.00 $15.00 $134.32 27.05% $136.19 $139.78 $136.26 $139.95 $134.44 $140.31 $133.58 ($5.87) $13,432.00 $15.00 $13,447.00 $13,444.00 $15.00 $39.17 15.36% $35.98 $37.61 $34.87 $34.04 $34.17 $34.25 $37.01 ($0.08) $3,917.00 $15.00 $3,932.00 $3,417.00 $15.00 $619.82 $611.65 $601.04 $579.38 $581.01 $570.89 $577.42 ($6.53) $61,982.00 $60.00 $62,042.00 $57,089.00 $60.00 $15.00 $55,351.00 $57,170.00 $15.00 $57,155.00 $1,804.00 $15.00 $6,052.00 $6,525.00 $15.00 $6,510.00 $15.00 $14,407.00 $15,686.00 $15.00 $15,671.00 $15.00 $5,903.00 $5,246.00 $15.00 $5,231.00 $60.00 $81,713.00 $84,627.00 $60.00 $84,567.00 $15.00 $15,269.00 $11,958.00 $15.00 $11,943.00 ($3,326.00) $15.00 $13,684.00 $12,715.00 $15.00 $12,700.00 ($984.00) $15.00 $33,534.00 $28,932.00 $15.00 $28,917.00 ($4,617.00) $15.00 $2,700.00 $2,869.00 $15.00 $2,854.00 $154.00 $60.00 $65,187.00 $56,474.00 $60.00 $54,414.00 ($8,773.00) $180.00 $208,942.00 $198,190.00 $180.00 $196,010.00 ($10,932.00) $553.36 25.46% $555.71 $575.57 $588.83 $60.37 74.67% $61.53 $62.87 $63.99 $143.92 45.17% $143.45 $151.01 $155.79 $58.88 0.00% $55.63 $58.66 $49.81 $816.53 $816.32 $848.11 $858.42 $590.39 $571.70 $544.28 $65.02 $65.25 $65.13 $157.08 $156.86 $153.74 $53.78 $52.46 $52.71 $866.27 $846.27 $815.86 $552.80 $57.44 $142.38 N/A WMT $27.42 $55,336.00 $0.12 $6,037.00 $3.12 $14,392.00 ($0.25) $5,888.00 $30.41 $81,653.00 $458.00 $1,264.00 CELH ($672.00) $2,854.00 MKSI MSA LAD $152.54 8.69% $155.61 $141.21 $121.94 $136.69 324.07% $134.06 $137.38 $131.19 $335.19 3.72% $321.67 $300.54 $308.37 $26.85 186.27% $27.34 $26.84 $27.56 $651.27 $638.68 $605.97 $589.06 $2,066.65 $2,055.12 | ######## $114.52 $119.58 $115.93 $126.40 $127.15 $120.72 $290.64 $289.32 $285.78 $27.61 $28.69 $26.90 $559.17 $564.74 $549.33 $2,006.45 $1,981.90 $1,942.61 $151.97 $135.40 $334.78 $19.93 $3.65 $15,254.00 $6.43 $13,669.00 $3.54 $33,519.00 $1.79 $2,685.00 $15.41 $65,127.00 $39.29 $208,762.00 BGS $2,087.62 POLICY Active Active Active Active Random Random Random Random Passive Passive Passive Passive OWNER STYLE TOTAL SHARES P1 Large Cap 100 Lowes P1 Large Cap 100 FedEx P1 Large Cap 100 Global Payments P1 Large Cap 100 Huntsman Subtotal 400 Subtotal P2 Large Cap 100 Costco Wholesale P2 100 Large Cap # Coca Cola P2 Mega Cap 100 Walmart P2 Large Cap 100 Celsius Holdings Subtotal 400 Subtotal P3 Micro Cap 100 MKS Instruments P3 Small Cap 100 MSA Safety P3 Micro Cap 100 Lithia Motors P3 Micro Cap 100 B&G Foods Subtotal Grand Total 400 1,200 Subtotal Grand Total NAME OF SECURITY TICKER SYMBOL Low Total Transaction (Sell) Gain/Loss $19,692.00 ($2,932.00) $20,506.00 ($1,533.00) $13,429.00 ($18.00) $3,402.00 ($530.00) $57,029.00 ($5,013.00) FDX GPN HUN COST KO DIVIDEND Total PRICE PAYOUT PRICE PRICE PRICE PRICE WEEK PRICE PRICE WEEK EXPECTED Wk 7 Price vs Transaction WEEK #1 RATIO WEEK #2 WEEK #3 WEEK #4 #5 WEEK #6 #7 ENDING PRICE Wk 6 Price Shares Price Transaction Fee (Buy) Selling Price Transaction Fee $226.09 24.92% $212.92 $202.40 $204.87 $201.28 $197.07 $201.00 $224.73 ($3.93) $22,609.00 $15.00 $22,624.00 $19,707.00 $15.00 $220.24 15.73% $226.56 $221.25 $203.38 $205.74 $205.21 $201.86 $218.87 $3.35 $22,024.00 $15.00 $22,039.00 $20,521.00 $15.00 $134.32 27.05% $136.19 $139.78 $136.26 $139.95 $134.44 $140.31 $133.58 ($5.87) $13,432.00 $15.00 $13,447.00 $13,444.00 $15.00 $39.17 15.36% $35.98 $37.61 $34.87 $34.04 $34.17 $34.25 $37.01 ($0.08) $3,917.00 $15.00 $3,932.00 $3,417.00 $15.00 $619.82 $611.65 $601.04 $579.38 $581.01 $570.89 $577.42 ($6.53) $61,982.00 $60.00 $62,042.00 $57,089.00 $60.00 $15.00 $55,351.00 $57,170.00 $15.00 $57,155.00 $1,804.00 $15.00 $6,052.00 $6,525.00 $15.00 $6,510.00 $15.00 $14,407.00 $15,686.00 $15.00 $15,671.00 $15.00 $5,903.00 $5,246.00 $15.00 $5,231.00 $60.00 $81,713.00 $84,627.00 $60.00 $84,567.00 $15.00 $15,269.00 $11,958.00 $15.00 $11,943.00 ($3,326.00) $15.00 $13,684.00 $12,715.00 $15.00 $12,700.00 ($984.00) $15.00 $33,534.00 $28,932.00 $15.00 $28,917.00 ($4,617.00) $15.00 $2,700.00 $2,869.00 $15.00 $2,854.00 $154.00 $60.00 $65,187.00 $56,474.00 $60.00 $54,414.00 ($8,773.00) $180.00 $208,942.00 $198,190.00 $180.00 $196,010.00 ($10,932.00) $553.36 25.46% $555.71 $575.57 $588.83 $60.37 74.67% $61.53 $62.87 $63.99 $143.92 45.17% $143.45 $151.01 $155.79 $58.88 0.00% $55.63 $58.66 $49.81 $816.53 $816.32 $848.11 $858.42 $590.39 $571.70 $544.28 $65.02 $65.25 $65.13 $157.08 $156.86 $153.74 $53.78 $52.46 $52.71 $866.27 $846.27 $815.86 $552.80 $57.44 $142.38 N/A WMT $27.42 $55,336.00 $0.12 $6,037.00 $3.12 $14,392.00 ($0.25) $5,888.00 $30.41 $81,653.00 $458.00 $1,264.00 CELH ($672.00) $2,854.00 MKSI MSA LAD $152.54 8.69% $155.61 $141.21 $121.94 $136.69 324.07% $134.06 $137.38 $131.19 $335.19 3.72% $321.67 $300.54 $308.37 $26.85 186.27% $27.34 $26.84 $27.56 $651.27 $638.68 $605.97 $589.06 $2,066.65 $2,055.12 | ######## $114.52 $119.58 $115.93 $126.40 $127.15 $120.72 $290.64 $289.32 $285.78 $27.61 $28.69 $26.90 $559.17 $564.74 $549.33 $2,006.45 $1,981.90 $1,942.61 $151.97 $135.40 $334.78 $19.93 $3.65 $15,254.00 $6.43 $13,669.00 $3.54 $33,519.00 $1.79 $2,685.00 $15.41 $65,127.00 $39.29 $208,762.00 BGS $2,087.62

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions