Suppose that BKE has the following: Revenue Year + 1 $1,223.50 Year +2 $ 1,323.46 Year + 3 $1,456.00 Net Cash Flow from operations Interest Expense After Tax Net cash flows for investing activities Net cash flows from debt financing Net cash flows into financial assets Net cash flows-preferred stock and noncontrolling interests Year +4 $ 1,529.77 Year + 5 $1,700.45 Year +6 $1,785.45 Year + 1 Year +2 Year + 3 Year +4 Year + 5 Year +6 99.25 121.33 132.78 144.98 152.44 170.220 18.55 12.45 16.77 17.87 21.33 15.89 $ 24.00 $ (12.00) $ (33.50) $ (12.44) $ 10.45 $ 22.34 $ 25.11 $ 26.23 $ 2.40 $ 11.30 $ (12.44) $ (25.33) ՄԴ $ $ $ $ ՄԴ $ en $ $ $ WACC 9.50% = Cost of equity = 10.23% Long run growth rate = 2.8% Number of shares of stock = 42 M The number of days of cash required to be held is 35 The fair value of debt is $1,092.33 The amount of cash required the last year of actuals was $109.34 There is no interest income. There is no preferred stock. They have no non-controlling interest in another firm. There are no financial assets in the capital structure.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter11: The Statement Of Cash Flows
Section: Chapter Questions
Problem 27BE
Question

How do you solve this on excel  with formulas ?

Suppose that BKE has the following:
Revenue
Year + 1
$1,223.50
Year +2
$ 1,323.46
Year + 3
$1,456.00
Net Cash Flow from operations
Interest Expense After Tax
Net cash flows for investing activities
Net cash flows from debt financing
Net cash flows into financial assets
Net cash flows-preferred stock and
noncontrolling interests
Year +4
$ 1,529.77
Year + 5
$1,700.45
Year +6
$1,785.45
Year + 1
Year +2
Year + 3
Year +4
Year + 5
Year +6
99.25
121.33
132.78
144.98
152.44
170.220
18.55
12.45
16.77
17.87
21.33
15.89
$
24.00 $
(12.00) $
(33.50) $
(12.44) $ 10.45 $ 22.34
$
25.11 $
26.23 $
2.40
$
11.30 $ (12.44) $
(25.33)
ՄԴ
$
$
$
$
ՄԴ
$
en
$
$
$
WACC 9.50%
=
Cost of equity = 10.23%
Long run growth rate = 2.8%
Number of shares of stock = 42 M
The number of days of cash required to be held is 35
The fair value of debt is $1,092.33
The amount of cash required the last year of actuals was $109.34
There is no interest income.
There is no preferred stock.
They have no non-controlling interest in another firm.
There are no financial assets in the capital structure.
Transcribed Image Text:Suppose that BKE has the following: Revenue Year + 1 $1,223.50 Year +2 $ 1,323.46 Year + 3 $1,456.00 Net Cash Flow from operations Interest Expense After Tax Net cash flows for investing activities Net cash flows from debt financing Net cash flows into financial assets Net cash flows-preferred stock and noncontrolling interests Year +4 $ 1,529.77 Year + 5 $1,700.45 Year +6 $1,785.45 Year + 1 Year +2 Year + 3 Year +4 Year + 5 Year +6 99.25 121.33 132.78 144.98 152.44 170.220 18.55 12.45 16.77 17.87 21.33 15.89 $ 24.00 $ (12.00) $ (33.50) $ (12.44) $ 10.45 $ 22.34 $ 25.11 $ 26.23 $ 2.40 $ 11.30 $ (12.44) $ (25.33) ՄԴ $ $ $ $ ՄԴ $ en $ $ $ WACC 9.50% = Cost of equity = 10.23% Long run growth rate = 2.8% Number of shares of stock = 42 M The number of days of cash required to be held is 35 The fair value of debt is $1,092.33 The amount of cash required the last year of actuals was $109.34 There is no interest income. There is no preferred stock. They have no non-controlling interest in another firm. There are no financial assets in the capital structure.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage