View the step-by-step solution to:

Exhibit 1: AT&T Inc.

FINACE help
I need summary report (2 pages), based on the attached excel document (income statement, balance sheet, noplat, cash flow, invested capital)

Exhibit 1: AT&T Inc. Historical Income Statement ($MM) 2007 2008 2009 2010 2011 2012 2013 2014 2015 Sales (net) 118,928.00 124,028.00 123,018.00 124,280.00 126,723.00 128,148.00 128,822.90 130,841.72 132,330.13 Cost of Goods Sold 46,055.00 49,895.00 50,405.00 52,263.00 57,374.00 58,700.20 61,101.26 64,317.61 67,102.16 30,892.00 31,187.00 31,407.00 33,065.00 34,663.00 35,068.80 36,384.04 37,704.93 38,677.43 Depreciation 21,577.00 19,883.00 19,714.00 19,379.00 18,377.00 17,714.80 17,311.54 16,558.53 15,856.26 20,404.00 23,063.00 21,492.00 19,573.00 16,309.00 16,664.20 14,026.06 12,260.65 10,694.29 Interest Expense 3,678.00 4,049.00 4,119.00 3,766.00 3,697.00 3,788.30 3,600.84 3,490.02 3,474.00 Nonoperating Income (expense) 1,088.00 1,150.00 1,686.00 1,773.00 1,098.00 1,551.90 1,516.52 1,357.07 1,335.29 Interest Income - - - - - - - - - Special Items 586.00 - (60.00) 658.00 (6,994.00) (5,512.60) (7,769.48) (10,412.48) (12,881.05) Pretax Income 18,400.00 20,164.00 18,999.00 18,238.00 6,716.00 8,915.20 4,172.26 (284.79) (4,325.46) Income Taxes (6,449.00) (7,297.00) (6,464.00) 1,626.00 (2,772.00) 611.90 2,993.92 4,569.69 4,901.89 Net Income 11,951.00 12,867.00 12,535.00 19,864.00 3,944.00 9,527.10 7,166.18 4,284.89 576.43 Av tax rate (0.35) (0.36) (0.34) 0.09 (0.41) 0.07 0.72 (16.05) (1.13) Selling, General, and Administrative Expenses Operating Income (before Interest and Taxes) FINACE help I need summary report (2 pages), based on this excel document (income statement, balance sheet, noplat, cash flow, invested capital, valuation). See other taps as well.
Background image of page 1
2007 2008 2009 2010 2011 2012 2013 2014 2015 Cash and Short-term Investments 1,970.00 1,792.00 3,802.00 1,437.00 3,334.00 3,178.90 3,400.52 3,312.17 4,077.57 Cash 1,970.00 - 3,802.00 1,437.00 3,185.00 3,238.90 4,090.82 3,864.61 4,891.57 Short-term Investments - 1,792.00 - - 149.00 (60.00) (690.30) (552.44) (814.00) Receivables (Trade) 16,185.00 16,047.00 14,978.00 13,610.00 13,606.00 12,606.70 11,693.76 11,027.36 10,385.51 Prepaid Expense - - - - - - - - - Deffered Income Tax - - - - - - - - - Inventories 1,119.00 862.00 885.00 1,303.00 1,188.00 1,245.10 1,417.38 1,509.75 1,525.51 Current Assets -- Other 5,412.00 3,855.00 4,669.00 3,601.00 4,899.00 4,103.20 4,443.36 4,358.39 4,598.73 Total Current Assets 24686.0000 22556.0000 24334.0000 19951.0000 23027.0000 24,312.80 24,355.54 23,519.83 24,664.90 Net Fixed Assets 95,890.00 99,088.00 100,093.00 103,196.00 107,087.00 109,021.40 111,755.32 114,975.56 117,675.28 Intangibles 129,115.00 135,541.00 135,082.00 134,121.00 130,185.00 133,024.80 130,611.94 129,594.05 128,919.27 Investment and Advances In Equity 2,270.00 2,332.00 2,921.00 4,515.00 3,718.00 4,674.90 5,277.02 5,682.77 5,941.90 Deferred Charges - - - - - - - - - Other Assets Excluding deferred Charges 23,683.00 5,728.00 6,322.00 6,705.00 6,327.00 (367.50) 1,287.10 (1,087.97) (3,615.03) Total Assts #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 270,666.40 273,286.92 272,684.24 273,586.33 Notes Payable Debt Due in One Year 6,860.00 14,119.00 7,361.00 7,196.00 3,453.00 3,676.70 (276.64) (1,356.36) (3,711.77) Accounts Payable 7,059.00 6,921.00 7,514.00 7,437.00 8,593.00 8,580.00 9,128.10 9,561.78 10,095.37 Income taxes Payable 5,027.00 1,874.00 1,696.00 72.00 1,003.00 (1,020.60) (1,219.78) (1,971.12) (2,520.01) Other Current Liabilities 20,328.00 19,376.00 20,134.00 19,246.00 17,745.00 17,777.00 17,179.50 16,202.90 15,634.57 Current Liabilities 39,274.00 42,290.00 36,705.00 33,951.00 30,794.00 29,013.10 24,811.18 22,437.19 19,498.17 Long-Term Debt 57,255.00 60,872.00 64,720.00 58,971.00 61,300.00 62,480.30 61,607.64 61,001.16 62,382.41 Other Liabilities 38,659.00 46,404.00 41,199.00 41,546.00 46,705.00 46,272.80 45,998.44 48,641.95 49,878.44 Deferred Taxes 24,939.00 19,196.00 23,803.00 22,070.00 25,748.00 24,498.80 26,828.34 27,133.47 28,617.91 Total Liabilities 160,127.00 168,762.00 166,427.00 156,538.00 164,547.00 162,265.00 159,245.60 159,213.78 160,376.92 Common Stock 6,495.00 6,495.00 6,495.00 6,495.00 6,495.00 6,495.00 6,495.00 6,495.00 6,495.00 Treasury Stock (15,683.00) (21,410.00) (21,260.00) (21,083.00) (20,750.00) (22,979.30) (22,285.04) (22,855.38) (23,514.49) Capital Surplus 91,638.00 91,728.00 91,707.00 91,731.00 91,156.00 91,303.70 91,105.26 90,911.36 90,734.46 Non Controlling interest 150.00 136.00 425.00 303.00 263.00 373.30 393.84 354.02 407.30 Retained Earnings 32,917.00 19,534.00 24,958.00 34,504.00 28,633.00 30,029.80 34,931.74 35,253.29 35,009.56 Shareholder's Equity 115,517.00 96,483.00 102,325.00 111,950.00 105,797.00 105,222.50 110,640.80 110,158.29 109,131.83 Total 275,644.00 265,245.00 268,752.00 268,488.00 270,344.00 267,487.50 269,886.40 269,372.07 269,508.76 Net Income 11,951.00 12,867.00 12,535.00 19,864.00 3,944.00 9,527.10 7,166.18 4,284.89 576.43 Addition to R.E. (13,383.00) 5,424.00 9,546.00 (5,871.00) 1,396.80 4,901.94 321.55 (243.73) Dividends 26,250.00 7,111.00 10,318.00 9,815.00 8,130.30 2,264.24 3,963.34 820.15 Cash/sales 0.02 - 0.03 0.01 0.03 0.03 0.03 0.03 0.04 Exhibit2 2: AT&T Inc. Historical Balance Sheet ($MM)
Background image of page 2
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question