1 Free Cash Flow Valuation Model 2 3 INPUTS (In millions) 4 5 6 Free cash flow 7 Marketable securities 8 Notes payable 9 Long-term bonds 10 Preferred stock 11 WACC 12 Number of shares of stock 13 B Current 0 $40 $120 $360 $60 13.00% 25 1 D E F Year Projected 2 3 4 -$15.0 $15.0 $50.0 $54.0 14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast 15 period immediately after the Year-4 free cash flow) 16 Constant long-term growth rate 17 Horizon value at Year 4 18 million Formulas #N/A #N/A 19 b. Calculating the present value of the horizon value, the present value of the free cash flows, 20 and the estimated Year-0 value of operations 21 Present value of HV 22 Present value of FCF 23 Value of operations 24 million #N/A million million #N/A #N/A 25 c. Calculating the estimated Year-0 price per share of common equity 26 Value of operations 27 + Value of marketable securities 28 Total intrinsic value 29 Value of total debt 30 - Value of preferred stock 31 Intrinsic value of equity 32 Number of shares 33 Intrinsic stock price 34 35 million #N/A million #N/A million #N/A million #N/A million #N/A million #N/A million #N/A #N/A

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
1 Free Cash Flow Valuation Model
2
3 INPUTS (In millions)
4
5
6 Free cash flow
7 Marketable securities
8 Notes payable
9 Long-term bonds
10 Preferred stock
11 WACC
12 Number of shares of stock
13
B
Current
0
$40
$120
$360
$60
13.00%
25
1
D
E
F
Year
Projected
2
3
4
-$15.0
$15.0
$50.0
$54.0
14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast
15 period immediately after the Year-4 free cash flow)
16 Constant long-term growth rate
17 Horizon value at Year 4
18
million
Formulas
#N/A
#N/A
19 b. Calculating the present value of the horizon value, the present value of the free cash flows,
20 and the estimated Year-0 value of operations
21 Present value of HV
22 Present value of FCF
23 Value of operations
24
million
#N/A
million
million
#N/A
#N/A
25 c. Calculating the estimated Year-0 price per share of common equity
26 Value of operations
27 + Value of marketable securities
28 Total intrinsic value
29 Value of total debt
30 - Value of preferred stock
31 Intrinsic value of equity
32 Number of shares
33 Intrinsic stock price
34
35
million
#N/A
million
#N/A
million
#N/A
million
#N/A
million
#N/A
million
#N/A
million
#N/A
#N/A
Transcribed Image Text:1 Free Cash Flow Valuation Model 2 3 INPUTS (In millions) 4 5 6 Free cash flow 7 Marketable securities 8 Notes payable 9 Long-term bonds 10 Preferred stock 11 WACC 12 Number of shares of stock 13 B Current 0 $40 $120 $360 $60 13.00% 25 1 D E F Year Projected 2 3 4 -$15.0 $15.0 $50.0 $54.0 14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast 15 period immediately after the Year-4 free cash flow) 16 Constant long-term growth rate 17 Horizon value at Year 4 18 million Formulas #N/A #N/A 19 b. Calculating the present value of the horizon value, the present value of the free cash flows, 20 and the estimated Year-0 value of operations 21 Present value of HV 22 Present value of FCF 23 Value of operations 24 million #N/A million million #N/A #N/A 25 c. Calculating the estimated Year-0 price per share of common equity 26 Value of operations 27 + Value of marketable securities 28 Total intrinsic value 29 Value of total debt 30 - Value of preferred stock 31 Intrinsic value of equity 32 Number of shares 33 Intrinsic stock price 34 35 million #N/A million #N/A million #N/A million #N/A million #N/A million #N/A million #N/A #N/A
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education