0% found this document useful (0 votes)
33 views4 pages

Practice Question FCF

Uploaded by

anasaziz7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
33 views4 pages

Practice Question FCF

Uploaded by

anasaziz7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Income Statement for the Year Ending December 31 (Millions of Dollars)

2016
Net Sales $ 800.0
Costs (except depreciation) $ 576.0
Depreciation $ 60.0
Total operating costs $ 636.0
Earning before int. & tax $ 164.0
Less interest $ 32.0
Earning before taxes $ 132.0
Taxes (40%) $ 52.8
Net income before pref. div. $ 79.2
Preferred div. $ 1.4
Net income avail. for com. div. $ 77.9
Common dividends $ 31.1
Addition to retained earnings $ 46.7

Number of shares (in millions) 10


Dividends per share $ 3.11

Balance Sheets for December 31 (Millions of Dollars)


Assets 2016 Liabilities and Equity
Cash $ 8.0 Accounts Payable
Short-term investments 20.0 Notes payable
Accounts receivable 80.0 Accruals
Inventories 160.0 Total current liabilities
Total current assets $ 268.0 Long-term bonds
Net plant and equipment 600.0 Preferred stock
Common Stock
Total Assets $ 868.0 (Par plus PIC)

Retained earnings
Common equity
Total liabilities and equity

Projected ratios and selected information for the current and projected years are shown below.

Inputs Actual Projected Projected Projected


12/31/2016 12/31/17 12/31/18 12/31/19
Sales Growth Rate 15% 10% 6%
Costs/Sales 72% 72% 72% 72%
Depreciation/(Net PPE) 10% 10% 10% 10%
Cash/Sales 1% 1% 1% 1%
(Acct. Rec.)/Sales 10% 10% 10% 10%
Inventories/Sales 20% 20% 20% 20%
(Net PPE)/Sales 75% 75% 75% 75%
(Acct. Pay.)/Sales 2% 2% 2% 2%
Accruals/Sales 5% 5% 5% 5%
Tax rate 40% 40% 40% 40%
Weighted average cost of capital (WACC) 10.5% 10.5% 10.5% 10.5%

a. Forecast the parts of the income statement and balance sheets necessary to calculate free cash flow.

Partial Income Statement for the Year Ending December 31 (Millions of Dollars)
Actual Projected Projected Projected
Income Statement Items 12/31/2016 12/31/17 12/31/18 12/31/19
Net Sales $800.0 $920.0 $1,012.0 $1,072.7
Costs (except depreciation) $576.0 $662.4 $728.6 $772.4
Depreciation $60.0 $69.0 $75.9 $80.5
Total operating costs $636.0 $731.4 $804.5 $852.8
Earning before int. & tax $164.0 $188.6 $207.5 $219.9

Partial Balance Sheets for December 31 (Millions of Dollars)


Actual Projected Projected Projected
Operating Assets 12/31/2016 12/31/17 12/31/18 12/31/19
Cash $8.0 $9.2 $10.1 $10.7
Accounts receivable $80.0 $92.0 $101.2 $107.3
Inventories $160.0 $184.0 $202.4 $214.5
Net plant and equipment $600.0 $690.0 $759.0 $804.5

Operating Liabilities
Accounts Payable $16.0 $18.4 $20.2 $21.5
Accruals $40.0 $46.0 $50.6 $53.6

b. Calculate free cash flow for each projected year. Also calculate the growth rates of free cash flow each
year to ensure that there is constant growth (i.e., the same as the constant growth rate in sales) by the end of
the forecast period.
Actual Projected Projected Projected
Calculation of FCF 12/31/2016 12/31/17 12/31/18 12/31/19
Operating current assets $248.0 $285.2 $313.7 $332.5
Operating current liabilities $56.0 $64.4 $70.8 $75.1
Net operating working capital $192.0 $220.8 $242.9 $257.5
Net PPE $600.0 $690.0 $759.0 $804.5
Total net operating capital $792.0 $910.8 $1,001.9 $1,062.0
NOPAT $98.4 $113.2 $124.5 $131.9
Investment in total net operating capital na $118.8 $91.1 $60.1
Free cash flow na -$5.6 $33.4 $71.8
Growth in FCF na na -692.1% 115.1%
Growth in sales 15.0% 10.0% 6.0%
8/3/15

2016
$ 16.0
40.0
40.0
$ 96.0
$ 300.0
$ 15.0

$ 257.0
200.0
$ 457.0
$ 868.0

below.

Projected
12/31/20
6%
72%
10%
1%
10%
20%
75%
2%
5%
40%
10.5%

e free cash flow.

Projected
12/31/20
$1,137.1
$818.7
$85.3
$904.0
$233.1

Projected
12/31/20
$11.4
$113.7
$227.4
$852.8

$22.7
$56.9

free cash flow each


n sales) by the end of

Projected
12/31/20
$352.5
$79.6
$272.9
$852.8
$1,125.7
$139.9
$63.7
$76.1
6.0%
6.0%

You might also like