Project Milestone Assignment: Company Overview And Financial History
The Company of choice will be AT&T
Specifically, the following critical elements must be addressed in this milestone:
I. Overview: This section of your report will be devoted to providing a thorough overview of the background of the corporation you selected and setting the foundation for your later discussion of the challenges financial managers face. Specifically, you must address the following:
A. Describe the market to which your corporation belongs, identifying the products or services your corporation sells, and the share of the market it has.
B. Describe the customer base of your corporation and the top competitors for this customer base. Be sure to consider what motivates the customers and the challenges the organization faces in retaining the customer base.
C. Describe the key inputs and sources of those inputs used to create the products or services as well as the key resources for corporate operation (such as staff, facilities, technologies, etc.) and the extent to which attaining all these resources presents a challenge to the particular organization.
D. Analyze key market trends and issues within the industry for potential risks to the organization.
II. Financial History: The next section of your report should focus on the financial history and capital structure of your organization.
A. Quantitatively analyze three years of the corporation's finances using the provided Excel template. You will submit this template along with your report, and may embed pieces of the Excel template into your report to show key financial highlights for the following section. Note that, for this assignment, you only need to complete the "Financial History" tab in the spreadsheet.
B. Summarize the financial highlights you determined from the analysis in the Excel template, explaining the significance of the key ratios for the overall financial health of the organization.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Spreadsheet-Template.rar