Reference no: EM131146954
For this section of your employment exam, you will select two companies. The first company needs to come from your TDAU thinkorswim portfolio. The second needs to be a competitor of the first company from the same industry. You will be responsible for collecting, synthesizing, and making decisions regarding both companies. After evaluating these companies' financial data, you will then decide which company's stock is the better investment.
This section of your employment examination must be submitted in two parts. Part A will contain the workbooks that house all of your quantitative data and formulas, along with any of the information that is relevant for your chosen companies. Part B will contain your answers to the questions asked below,composed in a cohesive manner.
If you are referring to data that is found within the workbooks in Part A, be sure to include a citation-for example,"rate of return is 3.570 USD (E64, WB2)," whereE64 is the cell that the calculation took place in and WB2 is designating "workbook 2." This ensures that your instructor can quickly and accurately check data entry, formula use, and financial calculations. Your submission must address the following critical elements:
I. Preparing the Workbooks
A.Download the annual income statements, balance sheets, and cash flow statements for the last three completed fiscal years for your chosen companies. This information must be included in your final submission.
B.Prepare a worksheet for each of the companies to display their financial data for the last three fiscal years. Ensure your data is accurate and organized. Include these worksheets as a workbook in your final submission.
C.Find historical stock prices for both companies and add this information to the respective spreadsheets. Consider the appropriate date range you should use.
II.Three-Year Returns
A.What is the three-year return on the stock price of the first company (Company A)? How is the stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on the given company's stock price.
B.What is the three-year return on the stock price of the second company (Company B)? How is this stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on your chosen company's stock price.
C.How do these two stocks compare in terms of three-year returns? What does this indicate about these two companies?
Company A= Netflix
Company B= Hulu
|
Is this a one-tailed or two-tailed hypothesis
: What does it mean to set alpha at .05? What is your null hypothesis? Alternate hypothesis? Is this a one-tailed or two-tailed hypothesis? What is the critical z?
|
|
Camft code of ethics
: Provide the specific ideas of how to honor the seventh standard outlined in the CAMFT Code of Ethics
|
|
What is the firm net float
: Charlies' writes 135 checks a day for an average amount of $480 each. These checks generally clear the bank in 3 days. In addition, the firm generally receives an average of $159,000 a day in checks that are deposited immediately. Deposited funds are..
|
|
Control the amount of hiv viruses in an infected person
: Draw a block diagram of a feedback system designed to control the amount of HIV viruses in an infected person.
|
|
Decide which companys stock is the better investment
: After evaluating these companies' financial data, you will then decide which company's stock is the better investment.
|
|
Who are the primary facilitators of the group
: Who are the primary facilitators of the group? What subject or issues did the group members examine during the meeting? What types of information did members exchange in their group? What were the group's norms, roles, status hierarchy, or communicat..
|
|
Compute the payback for both projects and choose better one
: Compute the payback for both projects and choose better one. Compute net present value and recommend betterproject.
|
|
Make any journal entries you consider necessary
: Prepare any journal entries you consider necessary, including year-end entries (December 31), assuming these are available-for-sale securities.
|
|
Provide an overview of the biological and psychological
: Proceed with this week's Discussion by addressing the following about the nature of substance use disorders: Provide an overview of the biological, psychological, sociocultural theories surrounding the causes of substance use disorders.
|