Question
Please help The company is AT&T...... Continuing with your Week 2 Project, now your CEO after reviewing your earlier Week 2 PowerPoint submission has asked
Please help The company is AT&T......
Continuing with your Week 2 Project, now your CEO after reviewing your earlier Week 2 PowerPoint submission has asked your team to complete an additional benchmark analysis task, before the upcoming Board Meeting. For this part of the project your team needs to do an analysis of the market and operational characteristics of your company and its financial profile. For this project, your team will need to select four companies that are direct competitors of your company.This sample selection should be based on revenue, profitability, market capitalization, market segment and product characteristics.
This project is an additional benchmark data analytics project. The objective of this part of the project will be to do a comparative financial analysis of your company with the averages of the sample of four companies that will form your comparative group.
The project deliverables will be another PowerPoint presentation to the CEO explaining the financial performance of your company compared to the sample of four comparable companies. The analysis should include the following deliverables:
1. An explanation of the logic of the selection of the four comparable group companies. Why were these companies selected?
2.Your team?s data extraction strategy, process and methodology.
3. A financial comparison of your company to the average of the comparator group on the following financial factors.
a. Profitability
b. Debt Management
c. Liquidity
d. Asset Management
e. Value Creation ? based on a the 3-year trend in Free
Cash Flow
In order to complete this project, your team has to select which ratios you are going to use in each of the five categories given above. In addition to that, your team will have to briefly explain why you are selecting the ratios you are using in your benchmark study.
Then your team will have to collect the financial data for your company and the financial data of the four competitor companies. The data can be collected from two financial data bases such as, Yahoo Finance, Lexis Nexis, Plunkett, or bizstats.com. Your team will then have to collect and calculate the averages of the four competitor companies. (Please note that no ratio calculations are required for each company, the ratios should be readily available on the websites noted above. You will only need to calculate the average ratios for the four companies combined.)
Your team will proceed to developing a PowerPoint presentation presenting the comparison and your team?s commentary of what your team discerns from the comparison. PowerPoint should not have more than ten slides. Just like the previous project your team should use Webex or Voicethread, and prepare an oral presentation that presents your PowerPoint presentation. Each team member must participate in this presentation.
FIN515Week 3 Project: Financial Statement Analysis (continued) Continuing with your Week 2 Project, now your CEO after reviewing your earlier Week 2 PowerPoint submission has asked your team to complete an additional benchmark analysis task, before the upcoming Board Meeting. For this part of the project your team needs to do an analysis of the market and operational characteristics of your company and its financial profile. For this project, your team will need to select four companies that are direct competitors of your company. This sample selection should be based on revenue, profitability, market capitalization, market segment and product characteristics. This project is an additional benchmark data analytics project. The objective of this part of the project will be to do a comparative financial analysis of your company with the averages of the sample of four companies that will form your comparative group. The project deliverables will be another PowerPoint presentation to the CEO explaining the financial performance of your company compared to the sample of four comparable companies. The analysis should include the following deliverables: 1. An explanation of the logic of the selection of the four comparable group companies. Why were these companies selected? 2.Your team's data extraction strategy, process and methodology. 3. A financial comparison of your company to the average of the comparator group on the following financial factors. a. Profitability b. Debt Management c. Liquidity d. Asset Management e. Value Creation - based on a the 3-year trend in Free Cash Flow In order to complete this project, your team has to select which ratios you are going to use in each of the five categories given above. In addition to that, your team will have to briefly explain why you are selecting the ratios you are using in your benchmark study. Then your team will have to collect the financial data for your company and the financial data of the four competitor companies. The data can be collected from two financial data bases such as, Yahoo Finance, Lexis Nexis, Plunkett, or bizstats.com. Your team will then have to collect and calculate the averages of the four competitor companies. (Please note that no ratio calculations FIN515Week 3 Project: Financial Statement Analysis (continued) are required for each company, the ratios should be readily available on the websites noted above. You will only need to calculate the average ratios for the four companies combined.) Your team will proceed to developing a PowerPoint presentation presenting the comparison and your team's commentary of what your team discerns from the comparison. PowerPoint should not have more than ten slides. Just like the previous project your team should use Webex or Voicethread, and prepare an oral presentation that presents your PowerPoint presentation. Each team member must participate in this presentation. FIN515Week 3 Project: Financial Statement Analysis (continued) Rubric: Second Project FIN515 Possible Points Criteria and Point Range 0-3 4-6 7-9 10-12 No referent Some ratios Ratios mostly Ratios and provided. questionable. appropriate. referent Ratios selected 12 Insufficient orInappropriate Appropriateappropriate. incorrect ratios referent selected. referent used. selected. 0-2 3-4 5-6 7-8 Ratio Extraction 8 & . . . Average Calculation 0-3 4-6 7-9 10-12 Evaluation generally correct. Minimal or incorrect May be not Evaluation No evaluation, or Evaluation 12 Evaluation, orcompletely fully evaluation not evaluation notsupported by supported by ratios are based on findings Ratios are not findings orSome original. findings. incorrect, and provided, and insufficient in referencing is minimal. referencing wasquantity. not 0-2 3-4 5-6 7-8 provided. SignificantMinor problemsWriting with andVirtually no Form 8problems with writing or presentation.. presentationerrors in presentation or format. correct with awriting few or generally exceptions.presentation. Ratios generally reflect the data source and are properly referenced. Ratios accurately reflect the data source and are properly referenced
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started