Fin350 Week 7 Module 7 Practice Problems

In: Business and Management

Submitted By Laynebaril
Words 1400
Pages 6
Fin350 Week 7 Module 7 Practice Problems Click Link Below To Buy: http://hwcampus.com/shop/fin350-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
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?

P8–14 Portfolio analysis…...

Similar Documents

Chapter 7 Practice Problems Psy/315

...PSY/315 March 18, 2013 Chapter 7 14.) Evolutionary theory often emphasizes that human have adapted to their physical environment. One such theory hypothesizes that people should spontaneously follow a 24-hour cycle of sleeping and waking-even though they are not exposed to the usual pattern of sunlight. To test this notion, eight paid volunteers were placed (individually) in a room in which there were no light from outside and no clocks or other indications of time. They could turn the lights on and off is they wish. After a month in the room, each individual tended to develop a study cycle. Their cycles at the end of the study were as follows: 25, 27, 25, 23, 24, 25, 26, and 25. Using the 0 .5 level of significance, what should we conclude about the theory that 24 hours is the natural cycle? (That is, does the average cycling under these conditions differ significantly from 24-hour?) (a) Use the steps of hypothesis testing. (b) Sketch the distributions involved, (c) explain yourself to someone who has never had a course in statistics. (a) Steps of hypothesis testing 1. Restate the question as a research hypothesis and a null hypothesis about the populations. There are two populations Population 1: people who are given the experimental test for 24 hours is the natural cycle. Population 2: people who are given the experimental test in less than 24 hours is the natural cycle. The null hypothesis: µ = 24 The alternative hypothesis: µ ≠ 24 2. Define......

Words: 1742 - Pages: 7

Module 7

...I would like to hear more about UNV 103 and what it offers. What does UNV 103 offer in helping me complete my work on time? I would start out with doing your discussion questions at the beginning of the week, and work on your paper s throughout the week. Make sure you give yourself time to complete the assignments so that you have time to check your work. What if I am having trouble prioritizing my time? I would make out a schedule at the beginning of the class of what you need to do each week for UNV 103. Then, stick to your schedule so that you are not turning in your assignment late and losing the points. Keep focused on the work and never procrastinate. How do you study for classes at GCU and take notes? I usually read the assignment, write questions, answer the questions, and make an outline of the readings. There are many different techniques of studying do what works best for you. What do I do if I run into a technical problem, or I am having trouble in the class? First, you see if you can solve the problem yourself. If you are still having a technical problem call the tech support, and have them fix it. If you need to submit an assignment that is due call your instructor, and let her know that you are having problems. If you are having problems in the class consider talking to your instructor maybe she can give you advice on how to succeed at UNV 103. If you are really struggling maybe you should get a tutor. Kristen my best advice to you for......

Words: 1050 - Pages: 5

Module 7

...Module 7 Writing Assignment July 26, 2015 1. In response to the prosecutor’s questions, a lay witness who is a high school graduate testifies as follows: “I measured the defendant’s skid marks, and I believe he was driving at least 65 miles per hour.” “In my opinion, anyone who drinks two beers becomes intoxicated.” “When I saw the defendant right after the accident, his face appeared flushed and he staggered as he walked.” “My sister told me that the defendant did a lot of drinking at the nearby bar.” What, if any, objections should the defense make to each one of the witness’s statements? For the statement of “I measured the defendant’s skid marks, and I believe he was driving at least 5 miles per hour”, the defense should make a specific objection on the ground that the question calls for an opinion from the witness. Lay witnesses cannot give opinions on matters beyond the common experience and understanding of an ordinary person. The witness must be qualified as an expert to be permitted to testify as to the speed of a car based on the observation of the car’s skid marks on the pavement. For the witness’s statement, “In my opinion, anyone who drinks two beers becomes intoxicated”, the defense should also make a specific objection on the ground that the question calls or an opinion from the witness. The witness’s first words from that statement is “In my opinion”, and it is exactly that; an opinion. Rule 701 of the Federal Rules of Evidence limits lay......

Words: 614 - Pages: 3

Fin350 Week 1 Module 1 Dq1 & Dq 2

...Fin350 Week 1 Module 1 DQ1 & DQ 2 Click Link Below To Buy: http://hwcampus.com/shop/fin350-full-courses/ GCU Module 1 DQ1 Identify a party (other than stockholders) that can be classified as a stakeholder for a corporation. What obligation does the corporation have to this party? Describe a situation where stockholder claims on the organization might conflict with the claims of this stakeholder group. If you were CEO, how would you resolve these conflicts Module 1 DQ2 During the summer and fall of 2008, the U.S. financial system and financial systems around the world appeared to be on the verge of collapse. How did we get into this condition? What did we do to get out of it? How can we prevent another such scenario in the future? Grand canyon Fin350 Week 2 Module 2 DQ1 & DQ 2 Latest 2015 modul 2 DQ1 Individuals performing ratio analysis include (1) banks evaluating potential loan applications from small businesses, (2) investment analysts evaluating the investment quality of a firm’s stock, and (3) internal management, assessing the firm’s current strengths and weaknesses. Select one of the three parties above, and for that party, identify which of the five ratio groups (liquidity, activity, debt, profitability, or market) would be of most value and which would probably be of least value. Explain the reasons behind your choices. modul 2 DQ2 Who are the major policy makers for the Federal Reserve System and how do they rise to such an influential......

Words: 2175 - Pages: 9

Fin350 Week 3 Module 3 Practice Problems

...Fin350 Week 3 Module 3 Practice Problems Click Link Below To Buy: http://hwcampus.com/shop/fin350-week-3-module-3-practice-problems/ P4–5 Classifying inflows and outflows of cash Classify each of the following items as an inflow (I) or an outflow (O) of cash, or as neither (N). P4–6 Finding operating and free cash flows Consider the following balance sheets and selected data from the income statement of Keith Corporation. a. Calculate the firm’s net operating profit after taxes (NOPAT) for the year ended December 31, 2015, using Equation 4.1. b. Calculate the firm’s operating cash flow (OCF) for the year ended December 31, 2015, using Equation 4.3. c. Calculate the firm’s free cash flow (FCF) for the year ended December 31, 2015, using Equation 4.4. d. Interpret, compare, and contrast your cash flow estimates in parts b and c. P4–9 Cash budget: Basic Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. (2) The firm receives other income of $2,000 per month. (3) The firm’s actual or expected purchases,......

Words: 724 - Pages: 3

Fin350 Week 7 Module 7 Practice Problems

...Fin350 Week 7 Module 7 Practice Problems Click Link Below To Buy: http://hwcampus.com/shop/fin350-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 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......

Words: 1400 - Pages: 6

Finc600 Week 7 Practice Quiz

...FINC600 Week 7 Practice Quiz Click Link Below To Buy: http://hwcampus.com/shop/finc600-week-7-practice-quiz/ Corporate Finance Week 7 Practice Quiz Part 1 of 1 - 12.0/ 15.0 Points Question 1 of 15 1.0/ 1.0 Points Assets are listed on the balance sheet in order of: I) Decreasing liquidity II) Decreasing size III) Increasing size IV) Relative life A.I only B.III and IV only C.II only D.IV only Question 2 of 15 0.0/ 1.0 Points The difference between Total Assets of a firm and its Total Liabilities is called. A.Net working capital B.Net current assets C.Net worth D.None of the above Question 3 of 15 1.0/ 1.0 Points The difference between Current Assets of a firm and its Current Liabilities is called. A.Net worth B.Net working capital C.Gross working capital D.None of the above Question 4 of 15 1.0/ 1.0 Points Which of the following is an example of leverage ratios? A.Debt-Equity ratio B.Quick ratio C.Payout ratio D.Return on equity Question 5 of 15 1.0/ 1.0 Points Which of the following is an example of liquidity ratios? A.Times interest earned (TIE) B.P/E ratio C.Return on equity D.Quick ratio Question 6 of 15 1.0/ 1.0 Points Given the following data: Current assets = 500 Current liabilities = 250 Inventory = 200 Account receivables =......

Words: 697 - Pages: 3

Fin350 Week 1 Module 1 Dq1 & Dq 2

...Fin350 Week 1 Module 1 DQ1 & DQ 2 Click Link Below To Buy: http://hwcampus.com/shop/fin350-full-courses/ GCU Module 1 DQ1 Identify a party (other than stockholders) that can be classified as a stakeholder for a corporation. What obligation does the corporation have to this party? Describe a situation where stockholder claims on the organization might conflict with the claims of this stakeholder group. If you were CEO, how would you resolve these conflicts Module 1 DQ2 During the summer and fall of 2008, the U.S. financial system and financial systems around the world appeared to be on the verge of collapse. How did we get into this condition? What did we do to get out of it? How can we prevent another such scenario in the future? Grand canyon Fin350 Week 2 Module 2 DQ1 & DQ 2 Latest 2015 modul 2 DQ1 Individuals performing ratio analysis include (1) banks evaluating potential loan applications from small businesses, (2) investment analysts evaluating the investment quality of a firm’s stock, and (3) internal management, assessing the firm’s current strengths and weaknesses. Select one of the three parties above, and for that party, identify which of the five ratio groups (liquidity, activity, debt, profitability, or market) would be of most value and which would probably be of least value. Explain the reasons behind your choices. modul 2 DQ2 Who are the major policy makers for the Federal Reserve System and how do they rise to such an influential......

Words: 2175 - Pages: 9

Fin350 Week 1 Module 1 Dq1 & Dq 2

...Fin350 Week 1 Module 1 DQ1 & DQ 2 Click Link Below To Buy: http://hwcampus.com/shop/fin350-full-courses/ GCU Module 1 DQ1 Identify a party (other than stockholders) that can be classified as a stakeholder for a corporation. What obligation does the corporation have to this party? Describe a situation where stockholder claims on the organization might conflict with the claims of this stakeholder group. If you were CEO, how would you resolve these conflicts Module 1 DQ2 During the summer and fall of 2008, the U.S. financial system and financial systems around the world appeared to be on the verge of collapse. How did we get into this condition? What did we do to get out of it? How can we prevent another such scenario in the future? Grand canyon Fin350 Week 2 Module 2 DQ1 & DQ 2 Latest 2015 modul 2 DQ1 Individuals performing ratio analysis include (1) banks evaluating potential loan applications from small businesses, (2) investment analysts evaluating the investment quality of a firm’s stock, and (3) internal management, assessing the firm’s current strengths and weaknesses. Select one of the three parties above, and for that party, identify which of the five ratio groups (liquidity, activity, debt, profitability, or market) would be of most value and which would probably be of least value. Explain the reasons behind your choices. modul 2 DQ2 Who are the major policy makers for the Federal Reserve System and how do they rise to such an influential......

Words: 2175 - Pages: 9

Finc600 Week 7 Practice Quiz

...FINC600 Week 7 Practice Quiz Click Link Below To Buy: http://hwcampus.com/shop/finc600-week-7-practice-quiz/ Corporate Finance Week 7 Practice Quiz Part 1 of 1 - 12.0/ 15.0 Points Question 1 of 15 1.0/ 1.0 Points Assets are listed on the balance sheet in order of: I) Decreasing liquidity II) Decreasing size III) Increasing size IV) Relative life A.I only B.III and IV only C.II only D.IV only Question 2 of 15 0.0/ 1.0 Points The difference between Total Assets of a firm and its Total Liabilities is called. A.Net working capital B.Net current assets C.Net worth D.None of the above Question 3 of 15 1.0/ 1.0 Points The difference between Current Assets of a firm and its Current Liabilities is called. A.Net worth B.Net working capital C.Gross working capital D.None of the above Question 4 of 15 1.0/ 1.0 Points Which of the following is an example of leverage ratios? A.Debt-Equity ratio B.Quick ratio C.Payout ratio D.Return on equity Question 5 of 15 1.0/ 1.0 Points Which of the following is an example of liquidity ratios? A.Times interest earned (TIE) B.P/E ratio C.Return on equity D.Quick ratio Question 6 of 15 1.0/ 1.0 Points Given the following data: Current assets = 500 Current liabilities = 250 Inventory = 200 Account receivables =......

Words: 697 - Pages: 3

Fin350 Week 3 Module 3 Practice Problems

...Fin350 Week 3 Module 3 Practice Problems Click Link Below To Buy: http://hwcampus.com/shop/fin350-week-3-module-3-practice-problems/ P4–5 Classifying inflows and outflows of cash Classify each of the following items as an inflow (I) or an outflow (O) of cash, or as neither (N). P4–6 Finding operating and free cash flows Consider the following balance sheets and selected data from the income statement of Keith Corporation. a. Calculate the firm’s net operating profit after taxes (NOPAT) for the year ended December 31, 2015, using Equation 4.1. b. Calculate the firm’s operating cash flow (OCF) for the year ended December 31, 2015, using Equation 4.3. c. Calculate the firm’s free cash flow (FCF) for the year ended December 31, 2015, using Equation 4.4. d. Interpret, compare, and contrast your cash flow estimates in parts b and c. P4–9 Cash budget: Basic Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. (2) The firm receives other income of $2,000 per month. (3) The firm’s actual or expected purchases,......

Words: 724 - Pages: 3

Fin350 Week 1 Module 1 Dq1 & Dq 2

...Fin350 Week 1 Module 1 DQ1 & DQ 2 Click Link Below To Buy: http://hwcampus.com/shop/fin350-full-courses/ GCU Module 1 DQ1 Identify a party (other than stockholders) that can be classified as a stakeholder for a corporation. What obligation does the corporation have to this party? Describe a situation where stockholder claims on the organization might conflict with the claims of this stakeholder group. If you were CEO, how would you resolve these conflicts Module 1 DQ2 During the summer and fall of 2008, the U.S. financial system and financial systems around the world appeared to be on the verge of collapse. How did we get into this condition? What did we do to get out of it? How can we prevent another such scenario in the future? Grand canyon Fin350 Week 2 Module 2 DQ1 & DQ 2 Latest 2015 modul 2 DQ1 Individuals performing ratio analysis include (1) banks evaluating potential loan applications from small businesses, (2) investment analysts evaluating the investment quality of a firm’s stock, and (3) internal management, assessing the firm’s current strengths and weaknesses. Select one of the three parties above, and for that party, identify which of the five ratio groups (liquidity, activity, debt, profitability, or market) would be of most value and which would probably be of least value. Explain the reasons behind your choices. modul 2 DQ2 Who are the major policy makers for the Federal Reserve System and how do they rise to such an influential......

Words: 2175 - Pages: 9

Fin350 Week 1 Module 1 Dq1 & Dq 2

...Fin350 Week 1 Module 1 DQ1 & DQ 2 Click Link Below To Buy: http://hwcampus.com/shop/fin350-full-courses/ GCU Module 1 DQ1 Identify a party (other than stockholders) that can be classified as a stakeholder for a corporation. What obligation does the corporation have to this party? Describe a situation where stockholder claims on the organization might conflict with the claims of this stakeholder group. If you were CEO, how would you resolve these conflicts Module 1 DQ2 During the summer and fall of 2008, the U.S. financial system and financial systems around the world appeared to be on the verge of collapse. How did we get into this condition? What did we do to get out of it? How can we prevent another such scenario in the future? Grand canyon Fin350 Week 2 Module 2 DQ1 & DQ 2 Latest 2015 modul 2 DQ1 Individuals performing ratio analysis include (1) banks evaluating potential loan applications from small businesses, (2) investment analysts evaluating the investment quality of a firm’s stock, and (3) internal management, assessing the firm’s current strengths and weaknesses. Select one of the three parties above, and for that party, identify which of the five ratio groups (liquidity, activity, debt, profitability, or market) would be of most value and which would probably be of least value. Explain the reasons behind your choices. modul 2 DQ2 Who are the major policy makers for the Federal Reserve System and how do they rise to such an influential......

Words: 2175 - Pages: 9

Finc600 Week 7 Practice Quiz

...FINC600 Week 7 Practice Quiz Click Link Below To Buy: http://hwcampus.com/shop/finc600-week-7-practice-quiz/ Corporate Finance Week 7 Practice Quiz Part 1 of 1 - 12.0/ 15.0 Points Question 1 of 15 1.0/ 1.0 Points Assets are listed on the balance sheet in order of: I) Decreasing liquidity II) Decreasing size III) Increasing size IV) Relative life A.I only B.III and IV only C.II only D.IV only Question 2 of 15 0.0/ 1.0 Points The difference between Total Assets of a firm and its Total Liabilities is called. A.Net working capital B.Net current assets C.Net worth D.None of the above Question 3 of 15 1.0/ 1.0 Points The difference between Current Assets of a firm and its Current Liabilities is called. A.Net worth B.Net working capital C.Gross working capital D.None of the above Question 4 of 15 1.0/ 1.0 Points Which of the following is an example of leverage ratios? A.Debt-Equity ratio B.Quick ratio C.Payout ratio D.Return on equity Question 5 of 15 1.0/ 1.0 Points Which of the following is an example of liquidity ratios? A.Times interest earned (TIE) B.P/E ratio C.Return on equity D.Quick ratio Question 6 of 15 1.0/ 1.0 Points Given the following data: Current assets = 500 Current liabilities = 250 Inventory = 200 Account receivables =......

Words: 697 - Pages: 3

Practice Quiz Week 7 Statistics

...Math 221 Quiz Review for Weeks 5 and 6 1. Find the area under the standard normal curve between z = 1.6 and z = 2.6. 2. A business wants to estimate the true mean annual income of its customers. It randomly samples 220 of its customers. The mean annual income was $61,400 with a standard deviation of $2,200. Find a 95% confidence interval for the true mean annual income of the business’ customers. 3. IQ test scores are normally distributed with a mean of 100 and a standard deviation of 15. An individual's IQ score is found to be 120. Find the z-score corresponding to this value. 4. Two high school students took equivalent language tests, one in German and one in French. The student taking the German test, for which the mean was 66 and the standard deviation was 8, scored an 82, while the student taking the French test, for which the mean was 27 and the standard deviation was 5, scored a 35. Compare the scores. 5. A business wants to estimate the true mean annual income of its customers. The business needs to be within $250 of the true mean. The business estimates the true population standard deviation is around $2,400. If the confidence level is 90%, find the required sample size in order to meet the desired accuracy. 6. The distribution of cholesterol levels in teenage boys is approximately normal with mean = 170 and standard deviation = 30 (Source: U.S. National Center for Health Statistics). Levels above 200 warrant attention. Find the probability......

Words: 1999 - Pages: 8