What is the three-year return on the stock price

Assignment Help Financial Management

Reference no: EM13996555

Company Amazon.com, Inc.

Competitor Apple Inc. (AAPL)

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.

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)," where E64 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.

Overview

For this part of the final project, you will be given a scenario in which you are asked to illustrate your financial computation and analysis skills.

This part of the assessment addresses the following course outcomes:
• Compute financial ratios, time value, variables, and returns using industry standard tools for optimizing financial success
• Analyze corporate financial data for multiple companies in evaluating past and future financial performances

Part II Prompt

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)," where E64 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?

Reference no: EM13996555

Questions Cloud

Calculate the surface temperature of the sun : The sun radiates like a perfect blackbody with an emissivity of exactly 1. Calculate the surface temperature of the sun, given it is a sphere with a 7.00 x 108 m radius that radiates 3.80x1026W into 3 K space.

How new trends might affect their marketing plan : Why is it important for a marketing firm to be able to anticipate new trends or changes in the environment? Why is it important for a marketing firm to be able to anticipate how new trends might affect their marketing plan

Determine the marginal benefit and marginal cost : How do you determine the marginal benefit and marginal cost of the decision? You should illustrate your answer with a numerical example. Why do economists believe that managers should use marginal analysis to make optimal business decisions?

Customers arrive at gilley''s ice cream shop : When customers arrive at gilley's ice cream shop, they take a number and wait to be called to purchase ice cream from one of the three counter serves. on summer days between 3-10pm, customers arrive at the rate 36 per hour - poisson distributed. it t..

What is the three-year return on the stock price : Find historical stock prices for both companies and add this information to the respective spreadsheets. Consider the appropriate date range you should use.

What is the diameter of the sun : The sun subtends an angle of 0.00928 rad when viewed from the surface of the earth, and its distance from Earth is 1.5 x 1011 m. What is the diameter of the sun?

Find the speed of the block immediately after bullet stop : A 3.7kg block of wood sits on a frictionless table. A 3.0 gbullet, fired horizontally at a speed of 350m/s, goes completely through the block, emerging at a speed of 230m/s. What is the speed of the block immediately after the bullet exits?

By how much must y have outscored x : On a scale of 1 to 100 (with 100 being the best), location X is scored at 84 and 91 on two of the three factors in play in a location decision. Location Y is scored at 82 and 89 on these factors. Assuming that an unweighted rating approach is being u..

Tpp agreement between these two countries : To what extent does the H-O-S theory and the Stolper-Samuelson theorem contribute and/or fail to contribute to our understanding of the impact of trade?

User Account

All Pages