FIN 350 Week 7 Complete
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 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 below 0.90.
Mike has obtained the following price information for the period 2012 through
2015. Hi-Tech stock, being growth-oriented, did not pay any dividends during these
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 FIN 350 Week 7 Complete 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 FIN 350 Week 7 Complete the security.
e. Given the calculation in d, what should be Mike’s decision regarding the inclusion
of Hi-Tech here 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
Il Garmin Vivoactive ha la capacità di vibrare ma non quella di emettere suoni. L’utente ha la facoltà di impostare degli avvisi vibranti for each i passi, for every la…
Jun 27, 2017
To start out binary options investing course of action, traders really need to deposit bare minimum level of $10 and acquire a complete usage of all buying and selling…
Jun 25, 2017
Some of the primary thing that you must make a decision is the site of gate, as well as the purpose this is mosting likely to provide. A gate with a two-way walk-throug…
Jun 21, 2017
Choosing a good web host is undoubtedly a important part of one's website, think about how much traffic you'll loose if web site were down for 50% of the time. There ar…
Jun 09, 2017
May many people who run their particular businesses, but everyone is not equally successful because they do not know of the right path to success. With the advent of th…
Jun 03, 2017