Please see attached: Excel Template YOU MUST USE to complete this assignment and Instructions.
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. Please 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.
Guidelines for Submission:
Your Overview and Financial History should be 3–4 pages in length, not including the Excel template you use to address section II.A, above. The written submission should use 12-point Times New Roman font, double spacing, one-inch margins, and APA formatting. Be sure to submit both your written response and the completed Excel template when submitting this assignment. Any citations should follow APA guidelines.