Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

This Portfolio Project has two parts: calculations and a 4- to 6-page essay. While the computations requirements of this assignment are significant, equally significant are your discussion and analysis of quantitative results of AT&T financial statement. You have to create two files:1) a spreadsheet containing AT&T’s horizontal and vertical analysis (and perhaps AT&T ratios) and 2) a word document containing your essay.

Select publicly traded company (AT&T, Inc) and carry out the expanded analysis on financial statements. Use the most current 10K statements available on www.sec.gov http://www.sec.gov or annual statements in finance.yahoo.com http://finance.yahoo.com.

Part 1: Complete following for your selected firm in the Excel spreadsheet:

1. Horizontal and vertical analysis of Income Statements for the past three years (all yearly balances set as a percentage of total revenues for that year).

2. Horizontal and vertical analysis of Balance Sheets for the past three years (all yearly balances set as a percentage of total assets for that year).

3. Ratio analysis (eight ratios of your choosing) for past three years PLUS a measurement for the credit worthiness of your firm as measured by Altman’s Z-score.  Note that if you used your chosen firm for our ratio-related discussion posts, then you must also present industry-average ratios or current year competitor ratios for your ratio analysis. Comparing your firm’s ratios to a close competitor or an industry-average ratio makes your analysis much more meaningful.

Part 2: The Paper:

• 4-6 pages in length.

• Include a proper introduction and conclusion.

• Include a reference page.

• Your paper must provide your reader with the overall understanding of the financial health of your chosen firm including the following:

i) Discussion of the ratio analysis results, including rationale for the ratios chosen.

ii) Discussion of all horizontal and vertical analysis.

iii) Discussion of four items from the management discussion of the firm that support the conclusion formed in your discussion of the financial results.

Much of this course has concentrated on learning financial statements, mainly as there was not an accounting prerequisite. Because of this concentration, you may find this assignment challenging. Though, if you understand the financial statements, then the horizontal and vertical analysis must (hopefully) be rather intuitive. Such as, if you see sales rise by 20%, then should not you also see net income rise by 20% or more if the managers are effective at controlling costs?  If you see sales rise by 20% and assets rise by 40%, we have to ask why this is happening. It would appear that assets have risen too far given the sales that are generated from those assets—why did this occur?  You may have to research that type of problem and discuss it in your analysis.

You have had some experience with financial ratios through Discussion Board.  I’d suggest that you start your ratio analysis with four ratios found in DuPont equation. If you discover the weakness in one component of DuPont ratios, then it would make sense to look at ratios which are closely related to troublesome ratio. Such as, if you discover that the asset turnover is declining over time, then take a look at some related ratios like the inventory turnover rate or the average collection period. If you discover that the equity multiplier is increasing (indicating greater reliance on debt), then look at some related ratios such as the debt ratio or Times Interest Earned.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M96229

Have any Question? 


Related Questions in Basic Finance

Choose three of the stocks - two within the same industry

Choose three of the stocks - two within the same industry plus one additional stock - from the Company Selection and Stock Watch completed in module 03 and then locate interest rates on two other investments that are not ...

You need a 35-year fixed-rate mortgage to buy a new home

You need a 35-year, fixed-rate mortgage to buy a new home for $245,000. Your mortgage bank will lend you the money at an APR of 5.4 percent for this 420-month loan. However, you can afford monthly payments of only $850, ...

Annual report projectyou will be analyzing the following

Annual Report Project You will be analyzing the following firms whose SIC code is 1311: - Anadarko Petroleum - EOG Resources For these firms, download the most recent 10-K report for 2014, 2013, and 2012. You can downloa ...

Using the same graph as that described in given problem

Using the same graph as that described in given Problem, show how the central bank could use its control over the quantity of money to target a particular level of interest rate in the face of changes in velocity. Proble ...

Essaytext book graham r j smart s b amp megginson w l 2010

Essay Text book Graham R. J., Smart, S. B., & Megginson, W. L. (2010). Corporate finance: Linking theory to what companies do (3rd ed.). Mason, OH: South-Western Three pages in length, double spaced, using APA style guid ...

How is the failure of an fi different from the failure of a

How is the failure of an FI different from the failure of a video rental store? What do these differences imply about the need for regulation?

A firm is expected to pay a dividend of 355 next year and

A firm is expected to pay a dividend of $3.55 next year and $3.85 the following year. Financial analysts believe the stock will be at their price target of $120 in two years. Compute the value of this stock with a requir ...

Why did the mexican government establish a controlled

Why did the Mexican government establish a controlled foreign-exchange market, and why did that market differ from the free market?

Discuss some of the reasons managers manipulate reported

Discuss some of the reasons managers manipulate reported earnings. Explain why earnings smoothing, one form of earnings manipulation, could be justified and why ethical analysts might avoid stocks from corporations that ...

Suppose instead of waiting for the economy described in

Suppose, instead of waiting for the economy described in given Problem to return to long-run equilibrium, the central bank opted to use the positive supply shock as an opportunity to move to a lower inflation target. Ill ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate