Got a tricky question? Receive an answer from students like you! Try us!

Portfolio AT&T Horizontal and Vertical Analysis - Essay Example

Only on StudentShare
Finance & Accounting
Pages 4 (1004 words)


The total revenues of AT&T during fiscal year 2012 were $94,220 million. The firm’s revenues increase by 1% in comparison with the previous year. AT&T’s operating expenses in 2012 went down by $111 million. The vertical analysis illustrated that in comparison to its sales operating expenses are 80% in 2012…

Extract of sample
Portfolio AT&T Horizontal and Vertical Analysis

AT&T had a net margin of 11.93%. In comparison with the industry average net margin of 7.8% the firm’s net margin is 4.03% higher (Dun & Bradstreet, 2012). As of September 30, 2012 the total assets of AT&T were $266,849 million dollars. In comparison with fiscal year 2011 the total assets of the firm decreased by 1%. ”Total assets include cash and other items of value that can be converted into cash that are owned by a person or company” (Crutchfield, 2012).The current assets of the company in 2012 were $18,958 million which represents a decline in current assets of $4,069 million in comparison with the previous year. Based on the vertical performed the current assets of the company represent 7% of total assets. The current and total liabilities of the company during 2012 were $30,758 million and $165,575 million respectively. The current ratio shows the ability of the company to pay off its current debt. AT&T’s current ratio during 2012 was 0.62. The current ratio of the company is bad considering the fact that a good current ratio is above the 1.0 threshold. The formula to calculate current ratio is current assets divided by current liabilities. AT&T must improve its current ratio; otherwise the company might face liquidity problems. The return on assets (ROA) metric measures how profitable a company is in relation to its total assets (Investopedia, 2012). ...
Download paper
Not exactly what you need?

Related Essays

Analysis of the 260-day Value at Risk (VAR) of a portfolio of four shares
It is the level of return comprising of a given probability (usually, 5, 2.3, or 1 percent) of experiencing a return of less than that level. Value-at-Risk was first used in the late 1980’s by major financial firms to measure the risk of their trading portfolios. Since then, Value-at-Risk is widely used quantitative tool to measure market risk. According to Hull (2005), “VaR answers the question: how much can one lose with X% probability over a pre-set horizon”. More precisely VaR is an amount (say V dollars), where the probability of losing more than V dollars is over some future time…
14 pages (3514 words)
Financial Modeling Of Value At Risk Portfolio
The report is carried out on a 260-day value-at-risk (VAR) of the portfolio of the shares used to make the report. The shares have been analyzed on a daily basis, to normalize the matching volumes of the traded shares. Various plans, methods and project formulae have been utilized to consider the application to be obtained for a determining process. The data used in the analysis uses closing prices to depict how the entire analysis and procedural VBA analysis operates. The shares and dividends depicted in the data are collected from open sources that have been computerized and processed.…
20 pages (5020 words)
Analysis of the Value at Risk (VaR) of a Portfolio of 4 Shares
This research will begin with the introduction of Value-at-Risk (VaR) as an established method for measuring market risk is an element of the advancement of risk management. The relevance of VaR has been extensive from its early use in security houses to profit-making banks and business and from marketplace risk to credit risk. Subsequent to the foreword in October 1994 by the Risk metrics by JP Morgan, the VaR is an assessment of the worst estimated failure that a firm may bear over a stage of time that has been particular by user, under standard market circumstances and a specific level of…
18 pages (4518 words)
Horizontal and Vertical Financial Analysis - PepsiCo vs Coca-Cola
The structure of this article is framed in such a manner that firstly income statements of both the companies are analyzed on horizontal and then on vertical basis. Next section is based on the analysis of balance sheets for the two companies on horizontal basis and then followed by vertical analysis. The major components of income statements are analyzed for both the companies in respect of cost of goods sold, operating income, income before taxes and finally net income. Cost of sales for PepsiCo is around 43% of the sales whereas the same for Coca-Cola is around 35% of the sales which is…
6 pages (1506 words)
Portfolio Analysis.
Portfolio analysis includes all efforts made by a firm towards the achievement of the best trade off between returns and risk tolerance. Portfolio analysis also involves the quantification of the financial and operational impact of a given portfolio, and it is quite vital as it helps firms to evaluate the performance of their investments and the effective timing of its returns. Each portfolio consists of sub-unit. For example, the financial sector can be made up of several banks or the Airline industry can be made up of several airline companies. The analysis of each portfolio helps an…
13 pages (3263 words)
Causes of the AT&T-BellSouth Takeover
Consequently, the revenues of the company were falling, stock process declining and incurred huge cost price. Things looked even bleaker given the coming of internet phone calls and more serious competition from cable and wireless companies. AT&T, which is a holding company agreed to take-over BellSouth as a strategy to position it as a company committed in enhancing convergence, progressive innovation and competition in the communication and entertainment industry (Reardon, 2006). The take-over guaranteed AT&T Inc the rights to own and manage Cingular Wireless which is a leading provider of…
4 pages (1004 words)
investment and portfolio analysis
On the contrary, Sharpe ratio refers to a measure of risk adjustment measure that utilizes standard deviation when computing portfolio returns and inherent risk associated with a particular portfolio (Ctaff, 2012). Empirical research asserts that if Sharpe ratio is higher it implies returns are better. Therefore, by utilizing standard deviation, Sharp ratio assumes that the relevant risk is total risk unlike Treynor ratio which assumes that the relevant risk is systematic (Ctaff, 2012). Both Treyon and Sharpe ratios are similar; however, the two measures differ in terms of how they determine…
6 pages (1506 words)