Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using year 2018 data, what was the common dividends paid per share? b.) The price of the stock at the beginning of 2018 was $54.81

Using year 2018 data, what was the common dividends paid per share?

b.) The price of the stock at the beginning of 2018 was $54.81 and you sold the stock at $88.14 at the end of the year. What is the dividend yield (use your answer from 3a above), capital gain(loss), and total percentage return?

c.) If the dividend calculated in 3a above is expected to grow by 2.5% in perpetuity and the expected return on the stock is 13%, what is the intrinsic value of the stock?image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

2014 2015 2016 2017 2018 Balance Sheet ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments 1,708.4 135,4 1,843.8 1,530.1 81.3 1,611.4 2.128.8 134,4 2,263.2 2,462.3 228.6 2,690.9 8,756.3 181.5 8,937.8 631.0 719.0 768.8 Accounts Receivable Other Receivables Total Receivables 870.4 68.0 693.1 955.4 1,648.5 631.0 719.0 768.8 938.4 1,306.4 283.4 1,378.5 319.7 1,364.0 276.7 1,400.5 482.9 Inventory Prepaid Exp. Deferred Tax Assets, Curr. Other Current Assets Total Current Assets 1,090.9 256.9 317.4 28.7 4,168.7 50.8 3,971.0 27.7 4,757.9 13.4 5,283.4 24.5 12,494.2 8,581.1 Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment (5,062.1) 9,641.8 (5,553.5) 4,088.3 10,573.3 (6.039.5) 4,533.8 11,584.0 (6,664.5) 4,919.5 13,197.1 (7.268.0) 5,929.1 3,519.0 Long-term Investments Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets 833.3 856.2 273.5 903.3 198.9 10.752.9 664.5 1,575.4 520.4 1,180.8 415.9 12.416.3 1,496.2 1,719.6 516.3 885.4 403.3 14,312.5 1,023.9 1,539.2 441.4 795.4 362.8 14,365.6 602.4 3,541.6 1,042.2 134.7 412.2 24.156.4 533.7 1,198.7 684.2 884.3 730.6 894.3 782.5 891.0 1,179.3 1,034.7 LIABILITIES Accounts Payable Accrued Exp. Short-term Borrowings Curr. Port of LT Debt Curr. Income Taxes Payable Unearned Revenue, Current Other Current Liabilities Total Current Liabilities 272.0 794.5 239.8 3,038.7 259.0 983.8 836.8 3,648.1 399.9 368.4 1,171.2 982.4 4,546.8 226.6 1,288.5 1,032.1 4,220.7 349.9 286.6 1,642.9 1,190.8 5,684.2 2.048.3 2,347.5 3,185.3 3,932.6 Long-Term Debt Capital Leases Unearned Revenue, Non-Current Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities 9,090.2 53.6 6,775.7 270.2 1,106.7 22,980.6 6.9 385.3 5,479.2 43.4 557.5 6,596.5 14.7 675.0 8,421.8 4.4 6.3 744.6 8,908.6 0.7 39.4 5,206.6 1.5 41.1 5,974.8 1.5 41.1 5,949.8 1.4 41.1 5,563.2 1.3 41.1 1,457.4 Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Inc. and Other Total Common Equity (330.3) 25.3 5,272.0 (199.4) 5,818.0 (108.4) 5,884.0 (155.6) 5,450.1 1,169.5 Minority Interest 1.7 1.8 6.7 6.9 6.3 Total Equity 5,273.7 5,819.8 5.890.7 5,457.0 1.175.8 Total Liabilities And Equity 10.752.9 12,416.3 14.312.5 14,365.6 24.156.4 Supplemental Items Total Shares Outon Balance Sheet Date 1,499.1 1,485.1 1,460.5 1,431.6 1,309.1 Date Close Stock Price 12/31/2016 55.22 1/31/2017 56.87 2/28/2017 58.39 3/31/2017 60.06 4/30/2017 63.61 5/31/2017 58.31 6/30/2017 53.98 7/31/2017 54.86 8/31/2017 53.71 9/30/2017 54.84 10/31/2017 57.82 11/30/2017 57.43 12/31/2017 56.81 1/31/2018 57.10 2/28/2018 57.89 3/31/2018 57.57 4/30/2018 56.67 5/31/2018 48.85 6/30/2018 52.39 7/31/2018 53.45 8/31/2018 56.84 9/30/2018 58.27 10/31/2018 66.72 11/30/2018 64.40 12/31/2018 68.14 Income Statement For the Fiscal Period Ending 12 months Sep-28-2014 Reclassified 12 months Reclassified 12 months Reclassified 12 months 12 months Sep-30-2018 16,447.8 19,162.7 Revenue Other Revenue Total Revenue 18,998.3 2,317.6 21,315.9 20,005.7 2,381.1 22,386.8 22,342.5 2,377.0 24,719.5 16,447.8 19,162.7 Cost Of Goods Sold Gross Profit 11,497.0 4,950.8 13,198.6 5,964.1 14,573.3 6,742.6 15,527.6 6,859.2 17,367.7 7,351.8 1,107.9 1,196.7 1,408.9 1,450.7 1,755.4 Selling General & Admin Exp. R & D Exp. Depreciation & Amort. Other Operating Expense/Income) 709.6 340.7 893.9 522.4 980.8 499.2 1,011.4 500.3 1,247.0 539.3 Other Operating Exp., Total 2,158.2 2,613.0 2,888.9 2,962.4 3,541.7 Operating Income 2,792.6 3,351.1 3,853.7 3,896.8 3,810.1 (70.5) (92.5) Interest Expense Interest and Invest. Income Net Interest Exp. (64.1) 35.4 (28.7) (81.3) 153.0 71.7 (170.3) 32.7 (137.6) (70.5) (92.5) 268.3 Income/(Loss) from Affiliates Currency Exchange Gains (Loss) Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items 249.9 73.3 (24.2) 3,579.6 318.2 (106.8) 54.8 4,191.6 391.4 61.8 82.5 4,340.0 301.2 6.8 157.2 4,137.7 39.5 3,071.7 (153.5) (224.4) (3.6) 67.8 Restructuring Charges Merger & Related Restruct. Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. Gain (Loss) On Sale Of Assets Legal Settlements Other Unusual Items EBT Incl. Unusual Items 391.6 (7.1) 1.6 5.4 36.9 94.1 1,372.8 497.5 20.2 (61.1) 3,903.0 3,159.7 4,198.6 4,317.5 5,780.0 Income Tax Expense Earnings from Cont. Ops. 1,092.0 2,067.7 1,143.7 2,759.3 1,379.7 2,818.9 1,432.6 2,884.9 1,262.0 4,518.0 Earnings of Discontinued Ops. Extraord. Item & Account Change Net Income to Company 2,067.7 2,759.3 2,818.9 2,884.9 4,518.0 Minority Int. in Earnings Net Income 0.4 2,068.1 (1.9) 2.757.4 (1.2) 2,817.7 (0.2) 2,884.7 0.3 4,518.3 Cash Flow For the Fiscal Period Ending Net Income Depreciation & Amort. Amort of Goodwill and Intangibles Depreciation & Amort., Total 12 months Sep-28-2014 2,068.1 739.7 8.7 748.4 12 months Sep-27-2015 2,757.4 883.8 50.0 933.8 Restated 12 months 2,817.7 972.8 57.3 1,030.1 Restated 12 months 2,884.7 1,009.6 57.5 1,067.1 12 months Sep-30-2018 4,518.3 1,119.4 186.5 1,305.9 (6.1) (93.5) (3.7) (390.6) (70.2) (499.2) (1,376.4) 37.6 (16.0) 250.3 87.2 (123.6) 176.0 (26.9) 218.1 (Gain) Loss From Sale Of Assets (Gain) Loss On Sale Of Invest. Asset Writedown & Restructuring Costs (Income) Loss on Equity Invest. Stock-Based Compensation Tax Benefit from Stock Options Other Operating Activities Change in Acc. Receivable Change In Inventories Change in Acc. Payable Change in Unearned Rev. Change in Other Net Operating Assets Cash from Ops. (43.5) 183.2 (114.4) 46.0 (79.7) 14.3 60.4 140.8 (2,345.6) 607.8 (42.0) 209.8 (132.4) 138.0 (82.8) (207.9) 137.7 170.3 261.5 3,749.1 312.0 (55.6) (67.5) 46.9 180.4 248.8 4,697.9 164.2 (96.8) 14.0 46.4 130.8 (4.7) 4,251.8 803.6 131.0 (41.2) 391.6 7,109.4 (677.1) 11,937.8 (1,160.9) (1,440.3) (1,519.4) (1,303.7) (284.3) Capital Expenditure Cash Acquisitions Divestitures Invest in Marketable & Equity Securt. Net (Inc.) Dec. in Loans Originated/Sold Other Investing Activities Cash from Investing (1,976.4) (1,311.3) 608.2 312.4 69.6 (877.1) 85.4 529.7 362.3 60.9 (19.1) (817.7) 6.8 (1,520.3) 24.9 (2,222.9) 54.3 (850.0) 5.6 (2,361.5) 748.5 748.5 848.5 848.5 1,254.5 1,254.5 750.2 750.2 5,584.1 5,584.1 Short Term Debt Issued Long-Term Debt Issued Total Debt Issued Short Term Debt Repaid Long-Term Debt Repaid Total Debt Repaid (610.1) (610.1) (400.0) (400.0) Issuance of Common Stock Repurchase of Common Stock 139.7 (835.9) 191.8 (1,511.6) 160.7 (2,101.6) 150.8 (2,125.3) 153.9 (7,196.2) Common Dividends Paid Total Dividends Paid (783.1) (783.1) (928.6) (928.6) (1,178.0) (1,178.0) (1.450.4) (1,450.4) (1,743.4) (1,743.4) Special Dividend Paid Other Financing Activities Cash from Financing 107.5 (623.3) (246.5) (2,256.5) (4.4) (8.4) (1,872.8) (41.2) (3,242.8) (3,079.1) Foreign Exchange Rate Adj. Net Change in Cash (34.1) (867.3) (150.6) (178.3) (3.5) 598.7 10.8 333.5 (39.5) 6,294.0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Corporate Finance

Authors: David W Blackwell, Robert Parrino, David S Kidwell

1st Edition

0471270563, 9780471270560

More Books

Students also viewed these Finance questions

Question

How can a designer ensure models in a DSS are integrated?

Answered: 1 week ago

Question

Armed conflicts.

Answered: 1 week ago

Question

Pollution

Answered: 1 week ago