Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer the following: Find Changes in NWC Year 1 Year 2 Year 3 Year 4 Year 5 Current Assets, other than Cash and Marketable Securities

Answer the following:

Find Changes in NWC

Year 1 Year 2 Year 3 Year 4 Year 5
Current Assets, other than Cash and Marketable Securities
Current Liabilities, excluding Debt
Net Working Capital
Change in NWC (NWC Investment)
Find capital expenditure
Year 1 Year 2 Year 3 Year 4 Year 5
Net Property, Plant & Equipment
Depreciation and amortization
Capex
Estimate free cash flow
Tax Rate (assume tax rate of 35%)
Year 1 Year 2 Year 3 Year 4 Year 5
EBIT
EBIT(1-T) = NOPAT
Plus: Depreciation Expense
Less: CAPEX
Less: Working Capital Investment
Firm Free Cash Flow
Balance Sheet
(In millions except per share data)
Year 1 Year 2 Year 3 Year 4 Year 5
Assets
Current Assets
Cash & cash equivalents $8,442 $10,414 $8,958 $7,309 $8,555
Short-term Investments $5,017 $6,707 $9,052 $8,322 $9,595
Marketable securities $3,092 $3,147 $3,665 $4,269 $4,051
Total Cash $16,551 $20,268 $21,675 $19,900 $22,201
Trade accounts receivable $4,759 $4,873 $4,466 $3,941 $3,856
Inventories $3,264 $3,277 $3,100 $2,902 $2,675
Prepaid expense and other assets $2,781 $2,886 $3,066 $2,752 $2,481
Assets held for sale $2,973 $0 $679 $3,900 $2,797
Total current assets $30,328 $31,304 $32,986 $33,395 $34,010
Non-current assets
Gross property, plant and equipment $23,486 $25,032 $25,258 $22,354 $21,256
Accumulated Depreciation ($9,010) ($10,065) ($10,625) ($9,783) ($10,621)
Net property, plant and equipment $14,476 $14,967 $14,633 $12,571 $10,635
Equity and other investments $10,448 $11,512 $13,625 $15,788 $17,249
Goodwill $12,255 $12,312 $12,100 $11,289 $10,629
Intangible assets $15,082 $15,299 $14,272 $12,843 $10,499
Other long-term assets $3,585 $4,661 $4,407 $4,207 $4,248
Total non-current assets $55,846 $58,751 $59,037 $56,698 $53,260
Total Assets $86,174 $90,055 $92,023 $90,093 $87,270
Liabilities
Current liabilities
Short-term debt $17,874 $17,925 $22,682 $15,806 $16,025
Accounts payable $1,969 $1,933 $2,089 $2,795 $2,682
Deferred income taxes $0 $0 $0 $0 $692
Taxes payable $471 $309 $400 $331 $307
Accrued liabilities $6,711 $7,644 $7,145 $6,865 $6,116
Other current liabilities $796 $0 $58 $1,133 $710
Total current liabilities $27,821 $27,811 $32,374 $26,930 $26,532
Non-current liabilities
Long-term debt $14,736 $19,154 $19,063 $28,407 $29,684
Deferred taxes liabilities $4,981 $6,152 $5,636 $4,691 $3,753
Minority interest $378 $267 $241 $210 $158
Other long-term liabilities $5,468 $3,498 $4,389 $4,301 $4,081
Total non-current liabilities $25,563 $29,071 $29,329 $37,609 $37,676
Total Liabilities $53,384 $56,882 $61,703 $64,539 $64,208
Stockholder's Equity
Common stock $1,760 $1,760 $1,760 $1,760 $1,760
Additional paid-in capital $11,379 $12,276 $13,154 $14,016 $14,993
Retained earnings $58,045 $61,660 $63,408 $65,018 $65,502
Accumulated other comprehensive income ($3,385) ($3,432) ($5,777) ($10,174) ($11,205)
Treasury stock ($35,009) ($39,091) ($42,225) ($45,066) ($47,988)
Total stockholders equity $32,790 $33,173 $30,320 $25,554 $23,062
Total Liabilities & Shareholder's Equity $86,174 $90,055 $92,023 $90,093 $87,270
Year ended December 31
(In millions except per share data)
Income Statement Year 1 Year 2 Year 3 Year 4 Year 5
Revenue
Net operating revenues $48,017 $46,854 $45,998 $44,294 $41,863
Cost of Goods Sold $19,053 $18,421 $17,889 $17,482 $16,465
Gross Profit $28,964 $28,433 $28,109 $26,812 $25,398
Operating expenses
General, administrative and other $17,738 $17,310 $17,218 $10,237 $9,439
Other operating charges $447 $895 $1,183 $7,847 $7,333
Total operating expense $18,185 $18,205 $18,401 $18,084 $16,772
Operating income $10,779 $10,228 $9,708 $8,728 $8,626
Interest expense $397 $463 $483 $856 $733
Other income (expense) $1,427 $1,712 $100 $1,733 $243
Income before taxes $11,809 $11,477 $9,325 $9,605 $8,136
Provision for income taxes $2,723 $2,851 $2,201 $2,239 $1,586
Net income from continuing operations $9,086 $8,626 $7,124 $7,366 $6,550
Other net income ($67) ($42) ($26) ($15) ($23)
Net Income $9,019 $8,584 $7,098 $7,351 $6,527
Net Income available to common shareholders $9,019 $8,584 $7,098 $7,351 $6,527
Earnings per share
Basic $2.00 $1.94 $1.62 $1.69 $1.51
Diluted $1.97 $1.90 $1.60 $1.67 $1.49
Weighted average shares outstanding
Basic $4,504 $4,434 $4,387 $4,352 $4,317
Diluted $4,584 $4,509 $4,450 $4,405 $4,367
Depreciation and amortization $1,982 $1,977 $1,976 $1,970 $1,787
EBITDA $14,188 $13,917 $11,784 $12,431 $10,656

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_2

Step: 3

blur-text-image_3

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: Jonathan Berk, Peter DeMarzo, Jarrod Harford, David Stangeland, Andras Marosi

3rd Canadian Edition

0135418178, 978-0135418178

More Books

Students also viewed these Finance questions