PureVolume

Blog Post

FIN 350 Week 7 Complete

FIN350

FIN 350 Week 7 Module 7 Practice Problems

Follow these instructions for completing and submitting your assignment:

1. Do all work in Excel. Do not submit Word files or *.pdf files.

2. Submit a single spreadsheet file for this assignment. Do not submit multiple files.

3. Place each problem on a separate spreadsheet tab.

4. Label all inputs and outputs and highlight your final answer.

5. Follow the directions in the “Guidelines for Developing Spreadsheets.”

P8–9 Rate of return, standard deviation, and coefficient of variation Mike is searching

for a stock to include in his current stock portfolio. He is interested in Hi-Tech,

Inc.; he has been impressed with the company’s computer products and believes

that Hi-Tech is an innovative market player. However, Mike realizes that more info any

time you consider a technology stock, risk is a major concern. The rule he follows

is to include only securities with a coefficient of variation of returns click here below 0.90.

Mike has obtained the following FIN 350 Week 7 Complete price information for the period 2012 through

2015. Hi-Tech stock, being growth-oriented, did not pay any dividends during these

4 years.

Stock price

Year Beginning End

2012 \$14.36 \$21.55

2013 21.55 64.78

2014 64.78 72.38

2015 72.38 91.80

a. Calculate the rate of return for each year, 2012 through 2015, for Hi-Tech stock.

b. Assume that each year’s return is equally probable, and calculate the average return

over this time period.

c. Calculate the standard deviation of returns over the past 4 years. (Hint: Treat

these data as a sample.)

d. Based on b and c, determine the coefficient of variation of returns for the security.

e. Given the calculation in d, what should be Mike’s decision regarding the inclusion

of Hi-Tech stock in his portfolio?

FIN 350 Grand Canyon Week 7 Complete Work

Tags: FIN 350 Week 7 Complete, FIN350Week7Complete, FIN 350 Week 7, FIN350Week7, FIN 350, FIN350

Posted Feb 20, 2017 at 11:21am

paulftguh69blog

Back to Profile > Posts

Posts (59) See all

• General: Finding Your Perfect House Is Easy With An Experienced Realtor

There are much more wrong ways also, although there are numerous of safe methods in investing your hard earned dollars in property. Read the following tips which can he…

Jun 08, 2017

• General: Best Leading Of Stair Baby Gate With The Widest Opening?

A gate you can put away whenever not in use is the retracting baby gate. In case you are undergoing space restrictions, this particular gate is the best to obtain away…

Jun 06, 2017

• General: The Fundamentals Of Child Safety Gates Disclosed

The pressure-mounted style operates fantastic for spots where there is no danger of the children diminishing such as the area in between pair of rooms. Nonetheless, the…

May 22, 2017

• General: Costzon New Fireplace Fence Youngster Safety Fence Fireplace Gate BBQ Metal Fire Gate Animal Canine

a first support participant which expands a minimum of regarding one stair intensity distance off of mentioned back of the gate at a setting above stated backside from…

May 22, 2017

• General: Childproofing Your House (5).

Baby proofing a rental property, flat or apartment generates its own collection from issues and inquiries, including swimming pool fences, putting up baby gate as well…

May 21, 2017

•

Signup for PureVolume, or Login.