Lab Exercise Essay

1339 words - 6 pages

The company I pick from S&P 500 is Google Inc., which is a multinational corporation specializing in internet-related service and products. Google has been estimated to be a rapidly growing global technology leader focused on improving the way people connect with information, and its trading stock price is remained really high and still on the rise.
The expected sales are given by Capital IQ from year 2014 to year 2018, and their values are listed below in the table. By calculating the average growth rate of sales over next five years, which is 12.8%, and have it compared with the one from the previous three years, which is 25.8%, it can be concluded that the projected sales value ...view middle of the document...

4%, and 15.7% respectively. So, I use the average value, which is 18.7% as the anticipated tax rate for the future calculation because Google is a mature and stable company that its tax rate will not fluctuate significantly on an annually basis. In addition, the depreciation and capital expenditure given by Capital IQ are reasonable because they use the average margin from the previous three years values to predict future. The change in net working capital from year 2014 to 2018 are also reasonable and in a decreasing trend due to a decrease in income tax rate. By applying those values in the table, we can get the anticipated free cash flows over the next five years for Google (Appendix B). The results are very similar to what Capital IQ calculated so its validity can be verified.
Table3. Free Cash Flow
| 2014 | 2015 | 2016 | 2017 | 2018 |
FCFs | 18174 | 28792 | 32624 | 36432 | 40365 |

In order to get the long run growth rate of free cash flows, I calculated the constant decreasing rate from year 2015 to 2018, which is 1.3%. Then, I assume Google is not able to maintain the high growth rate in the long run perspective. Instead, the expected long term growth rate is calculated by assuming that the growth rate will continue to decrease for five more years at a 1.3% constant until reach 2%, if we see 12 year as a reasonable long run term (Appendix C). The equity beta found on Yahoo!Finance is 0.89, and market risk premium is found on Bloomberg. The risk free rate of 2.775% is given by Capital IQ which is referred to a yield of 10 year Treasury bond. It is reasonable to use the long term yield as a risk free rate in calculating cost of capital for Google who have long term and stable inventories. Using CAPM, we can get equity cost of capital, which is 2.775%+0.89*7.28%=9.254%. The cost of debt of 2.776% is calculated by deducting the tax margin from the pre-tax cost which is calculated based on risk free rate and credit spread (obtained from Moody’s KMV CreditEdge product) (Appendix C). With the cost of equity capital and effective cost of debt capital, we can calculated WACC using formula E*re/V+D*rd/V, which is 98.36%*9.254%+1.64*2.776%=9.15% (Appendix D). After getting long run growth rate and WACC, we can find the terminal value: Vn=40365*(1+2%)9.15%-2%=550,766
Then, the present value of free cash flows can be calculated based on the discount rate (Appendix B). According to Appendix E, the market value of equity is $484,185 million and the stock price is $1,183.04, while its intrinsic value of stock is $1,440.81.
I choose the mean of TEV/EBITDA and the median of TEV/Revenue as multiples to estimate Google’s stock price (Appendix F). By applying the mean value of TEV/EBITDA to find...

Other Essays Like Lab Exercise

Physioex Exercise 11 Activity 5 Essay

518 words - 3 pages Exercise 11: Blood Analysis: Activity 5: Blood Cholesterol Lab Report Pre-lab Quiz Results You scored 100% by answering 4 out of 4 questions correctly. 1. Cholesterol is a lipid substance that You correctly answered: e. is all of the above. 2. LDLs have been identified as You correctly answered: c. a potential source of damage to the interior of arteries. 3. A desirable level of total cholesterol per deciliter of blood is You correctly answered

Cardiovascular System Essay

551 words - 3 pages Experiment CardiovasCular system Blood Cardiovascular System: Blood Laszlo Vass, Ed.D. Version 42-0007-02-01 Lab RepoRt assistant This document is not meant to be a substitute for a formal laboratory report. The Lab Report Assistant is simply a summary of the experiment’s questions, diagrams if needed, and data tables that should be addressed in a formal lab report. The intent is to facilitate students’ writing of lab reports by

Nt1210 Lab 1 Reviews

814 words - 4 pages NT1210 INTRODUCTION TO COMPUTER DATA LAB 1.1: READING BINARY Exercise: 1.1.1 Create a mapping for decimal number 2931. 10^3 | 10^2 | 10^1 | 10^0 | 1000 | 100 | 10 | 1 | 2 | 9 | 3 | 1 | x | x | x | = 2931 = 2931 x | 2000 + | 900 + | 30 + | 1 | Exercise: 1.1.2 Create a mapping for binary number 110 subscript 2. 2^2 | 2^1 | 2^0 | 4 | 2 | 1 | x | x | x | 1 | 1 | = 6 = 6 0 | 4

Microbiology

1664 words - 7 pages HOW TO WRITE AN UNKNOWN LAB REPORT IN MICROBIOLOGY GENERAL Unknown reports in microbiology are written in scientific format. Scientific writing is written differently from other types of writing. The results of the exercise or experiment are what are being showcased, not the writing. The purpose of scientific writing is not to entertain, but to inform. The writing should be simple and easy to understand. There is a specific style that must be

Chemistry

754 words - 4 pages Laboratory Techniques and Measurements Hands-On Labs, Inc. Version 42-0165-00-02 Lab Report Assistant This document is not meant to be a substitute for a formal laboratory report. The Lab Report Assistant is simply a summary of the experiment’s questions, diagrams if needed, and data tables that should be addressed in a formal lab report. The intent is to facilitate students’ writing of lab reports by providing this information in an

Bio102 Lab

1035 words - 5 pages ., Boulton_Lab1). I will be posting the answer key under Study Groups, then Lab 1 - Answer Key after I have graded all the labs. You will gain access to the answer key and associated Lab 1 Discussion if you submit a complete lab on time. You must submit your document in a Word (.doc or .docx) or Rich Text Format (.rtf) to receive credit. I cannot open Works or WordPerfect files. Exercise 1: 1. Based on this

Physiox 9.0 Lab 6

592 words - 3 pages Exercise 6: Cardiovascular Physiology: Activity 5: Examining the Effects of Various Ions on Heart Rate Lab Report Pre-lab Quiz Results You scored 100% by answering 4 out of 4 questions correctly. 1. Which organelle in the cardiac muscle cell stores calcium? You correctly answered: b. sarcoplasmic reticulum 2. Verapamil is a calcium-channel blocker. Its effects could be described as You correctly answered: d. negative chronotropic and negative

Science Stuff

557 words - 3 pages Name: Tess Bartell PSY 250 Fall 2014 Lab 1 Visual Search Our ability to recognize complex patterns requires attention. For example in the demonstration of Infinite Maze by Mathôt and Danes (2014) at the Best Illusion of the Year Contest, the maze that the pac-man travels is always changing after the pac-man moves past that region. People do not notice this if they are focused on directing the pac

Patient Health and Technology

659 words - 3 pages medical history, lab results/diagnostic results, problem list, clinical notes, and treatment notes. The medical history includes patient demographics, chief complaint (reason why patient is seeking care), history of present illness, past medical history, family history, social history, allergies, medications, review of systems and physical exam information. Patient demographics information consist of name, birth date, address, phone number, gender

Environmental and Food Microbiology Repor

3263 words - 14 pages Introduction: The microbiology of food and the environment are two very important fields in the large scope of microbiological research. Because microorganisms exist almost everywhere, it is important to determine the influences that they place on the food we depend on for survival, and the environment in which we humans call home. In this lab, we conducted five experiments in these two fields, and in doing so gained a better understanding of

Respiration and Circulatory Lab

1395 words - 6 pages Respiration and Circulatory Lab Introduction Cellular respiration is a chemical reaction that involves the breakdown of glucose to provide ATP energy for the cell (Rogers, 2010, October 12). This process occurs in mitochondria between blood and the air in alveoli. The waste products of cellular respiration are carbon dioxide and water. Carbon dioxide is a gas that is released from the cells during exhalation. In order to determine the

Related Papers

Networking Labs For Unit 6 Essay

590 words - 3 pages Brandon Hellbach Unit 6 Labs Lab 6.1: Wireless Broadcast Domains Exercise 6.1.1 – A Basic Service Set does exactly what its name says; basic wireless service, one and only one AP creates the wireless LAN. Extended Service Set extends the wireless functions of a Basic Service Set. The difference is that in a BBS uses one AP to create one wireless LAN while an ESS uses more than one AP to create one wireless LAN. Exercise 6.1.2 – IEEE

Sc4730 Assignments

5263 words - 22 pages environmental problems by completing Problem Set 3 on pp. 163-169 in the Lab Manual. Answer questions 1-10 in Exercise Set I. Answer questions 1-10 in Exercise Set II. Answer questions 1-10 in Exercise Set III. Answer questions 1-10 in Exercise Set IV. Submission Requirements Microsoft Word 1-2 pages Use Microsoft Excel for Exercise Set IV. Submit the electronic version (.xls or .xlsx) Unit 2 Exercise 1: Environmental Health Course

Nt1210 Chapter 2 Essay

1044 words - 5 pages Kbps: Kilobits per second LAN: Local-Area Network MBps: Megabytes per second Mbps: Megabits per second NIC: Network Interface Card OS: Operating System telco: telephone company URL: Uniform Resource Locator WAN: Wide-Area Network WWW: World Wide Web Unit 2 Lab Exercise 2.1.1: The data

Ecet 370 Week 5 Lab 5

805 words - 4 pages This work of ECET 370 Week 5 Lab 5 shows the solutions to the following problems: Exercise 1 Exercise 2 Exercise 3/2 Exercise 4 General Instructions Exercise 1 uses the programs in DocSharing labeled "Search algorithms." Exercise 1: Review of the Lecture Content Create a project using the ArrayList class and the Main class provided in DocSharing. The ArrayList class contains implementations of the first three