Option #1: Financial Statement Analysis
COMPANY IS TMOBILE AND VERIZON
As a financial statement analyst, select TWO organizations VERIZON AND T-MOBILE.
Analyze their financial statements over time. The financial analysis period must be, at a minimum, the three most recent years. Since you will be spending a considerable amount of time on the project, ensure that you pick organizations that interest you.
The Form 10-K reports, which the organizations filed with the SEC, may be the best place to learn about a particular industry, organization, and organizational strategy, and to obtain reported financial statements. The reports are accessible at http://www.sec.gov/edgar.shtml . (Links to an external site.) An alternative means to obtain the report is by clicking on the SEC filings link on an organization’s website to obtain the latest Form 10-K filings. You can also find current stock valuation and other relevant stock information from financial portals such as Yahoo finance, Google finance, and Reuters.
Your Portfolio Project must include the following for the two organizations (see below for more detail):
· Executive Summary
· Ratio Calculation
· Ratio Analysis
· Projected financial statements including income statements, balance sheets, and statements of cash flows
· Your opinion on the overall financial health of each company
The executive summary should include an explanation of the business itself, background information on each company, including product lines, geographical locations and the company’s position in the industry.
The Ratio Calculations should be done in a table in Excel and included with your submission . The following ratios should be included for each company and for 2 years :
· Working Capital
· Current Ratio
· Total Debt to Total Equity Ratio
· Times Interest Earned
· RNOA
· ROCE
The ratio analysis should include an explanation of the importance of each ratio, what the ratio tells you about each company, how the ratio changes from year to year, and which company appears better based on each ratio.
The Projected financial statements should be done in Excel and included with your submission. * You will need to make necessary adjustments for material non-recurring or unusual income or expenses as well as off-balance sheet assets or liabilities, among others as covered in the course. The adjustment will improve comparability and ensure accurate representation of the organization’s’ economic performance. Be sure to identify important assumptions regarding the companies, industry and business environment, and other important assumptions for estimates and forecasts, including their business strategies.
Your opinion of the overall financial health of the company should reflect everything you have learned throughout the course as to the analysis of financial reporting.
Your submission should include:
· The financial statements from the companies you analyzed
· The Excel Ratio Table Calculations
· The Excel Projected Financial Statements
· An 8 page paper covering the information listed above
· Include the financial statements you analyzed and other information used as exhibits after the reference page.
Your project must be formatted according to APA
10 SOURCES MUST BE USED
THE OUTLINE HAS BEEN INCLUDED FOR YOU TO WRITE THE PAPER
Running head: PORTFOLIO PROJECT 2
PORTFOLIO PROJECT 2
Portfolio Project
FIN 520: Financial Reporting and Analysis
Professor
December 20, 2020
Portfolio Project
T-Mobile AND Verizon is the company that I have chosen to write about and use as my project company. I have outlined the portfolio for you.
T-Mobile
Introduction goes here.
T-Mobile
Vision
This is where the vision of the company will go and I will write about.
Mission
I will speak about the mission of the company and why they are in business.
Objectives
I will speak of the objectives of the company and what they are trying to achieve.
Executive Summary
Company Services
This is where information will go about the company and the services they offer. The types of products that they may offer to the public and the sector they are participating in.
Target Market
Here will be discussed the projected target market for the company. If the market is changing and what needs to be worked on with the company.
Competition
This will explain all about the competition that they face as a company and will indicate how they work with competition to all achieve a common goal.
Ratio Calculation (Will be on Excel Sheets, Not Here)
Working Capital – EXCEL
Current Ratio – EXCEL
Total Debt to Total Equity Ratio– EXCEL
Times Interest Earned – EXCEL
RNOA – EXCEL
ROCE – EXCEL
Ratio Analysis
Working Capital
Here will be discussed the working capital and the ratios of the analysis.
Current Ratio
Current Ratios will be discussed.
Total Debt to Total Equity Ratio
Debt and Equity will be discussed.
Times Interest Earned
Interest Earned will be discussed.
RNOA
Return on net operating assets will be discussed.
ROCE
Return on common equity will be discussed.
Financial Overview
Income Statements
Here I will discuss the financial overview of the company and talk about the income statements and what it going on with them. I will discuss the overall health of the company.
Balance Sheets
I will speak about the balance sheets and debt and discuss where the cash is going and why.
Statement of Cash Flows
Here I will speak about the cash flow. How it is affecting the company and where the cash is going and if it is helping to reinvest in the company.
Organizational Health
Overall Health
This area will discuss the overall health of the organization financially and not.
Strengths
I will discuss the strengths of the company.
Weakness
I will talk about the weaknesses of the company and what is bringing them down.
Room for Improvement
This will speak of how the company can improve.
Conclusion
References
Appendix A