Question

In: Finance

Using the schedule of cash flows and other information below, estimate the firm's value of operations...

Using the schedule of cash flows and other information below, estimate the firm's value of operations
by discounting the cash flows back to the present (time value of money formula)
Compute the value of operations a second way by using the NPV formula in Excel
FCFF See cash flow schedule
WACC 18%
Debt 75 million
Number of shares 100 million
show excel formulas
Time FCFF, millions
0
1 -2
2 10
3 18
4 30
5 52
6 56
7 59
8 61 growing at 2% per year
9
10

Solutions

Expert Solution

Present value of operations $149.58 million
Time FCFF, millions Present value Horizon value Net CF
0
1 -2 -1.69 -1.69
2 10 7.18 7.18
3 18 10.96 10.96
4 30 15.47 15.47
5 52 22.73 22.73
6 56 20.74 20.74
7 59 18.52 18.52
8 61 16.23 388.88 405.10
9 0
10 0
Present value of operations $149.58


Related Solutions

Estimate the firm's stock price using the information below You may use the time value of...
Estimate the firm's stock price using the information below You may use the time value of money formula or the Excel NPV function Beta 1.24 rf 1% MRP 5% SHOW EQUATIONS USED IN EXCEL Time Dividend ($) Div growth (g) 0 5.00 1 0% 2 9% 3 7% 4 5% 5 3% 6 2% per year, forever 7 8 9 10
Prepare a statement of cash flows for 2020 using the indirect method using the information below....
Prepare a statement of cash flows for 2020 using the indirect method using the information below. Pennant Corporation's end of year comparative balance sheets are presented below. Pennant Corporation Comparative Balance Sheets December 31                                                                                                                 2020                                                                                                                 2019                                                                                                                                    Cash                                                                            $ 15,200 $ 17,700                         Accounts receivable                                                       25,200     22,300                         Investments                                                                    20,000     16,000                         Equipment                                                                      60,000     70,000                         Accumulated depreciation                                          (14,000) (10,000)                              Total                                                                       $106,400 $116,000                         Accounts payable                                                       $ 14,600 $11,100                         Bonds payable                                                               ...
Calculate the Net Present Value of the cash flows depicted in the table below using a...
Calculate the Net Present Value of the cash flows depicted in the table below using a cost of capital of {r81d}percent. year Cash Flow 0 -60 1 40 2 40 3 0
Find the present value of the following stream of cash flows, assuming that the firm's opportunity...
Find the present value of the following stream of cash flows, assuming that the firm's opportunity cost is 12 percent. What would be the future value of those cash flows? Year Amount 1 $10,000 2 35,000 3 24,000 4 53,000
Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations...
Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual 2016 2017 Projected 2018 2019 Free cash flow $602.40 $663.08 $703.13 $759.38 (millions of dollars) Growth is expected to be constant after 2018, and the weighted average cost of capital is 11.55%. What is the horizon (continuing) value at 2019 if growth from 2018 remains constant? Round your answer to the nearest dollar. Round intermediate calculations to two decimal places.
The DCF can be used to estimate the value of future cash flows and the impact...
The DCF can be used to estimate the value of future cash flows and the impact upon the current value of the stock price. As reported in Morningstar, Visa reported FCF of 11,995 (million) in 2018. To perform this calculation, we first calculate the Discounted Free Cash Flow. Using this information, we project the future cash flows based upon a fixed growth rate. Assumptions for Calculations Assumptions FCF Annual Growth 15% Discount Rate 8.0% Shares outstanding 2231 Debt 16630 Cash...
Changes in the spot rates can: a. affect a firm's present value of future cash flows,...
Changes in the spot rates can: a. affect a firm's present value of future cash flows, posing economic risk. b. impose translation risk on a firm. c. impose accounting risk on a firm. d. affect the value of a company's future cash transactions, posing transaction risk.
Given the following information, estimate the cash flows of this project and then compute the NPV...
Given the following information, estimate the cash flows of this project and then compute the NPV of this project. Estimated Sales: 50,000 units per year for each of the next 3 years Estimate Sale Price: $1,050 per unit Variable Cost: $1,000 per unit Fixed Costs: $1,500,000 per year Initial Investment in Plant and Machinery: $1,500,000 to be depreciated to a salvage value of $0 over the next three years. We sell the machine at $45000 in the market at the...
Classifications of Cash Flows. A company's statement of cash flows and the accompanying schedule of investing...
Classifications of Cash Flows. A company's statement of cash flows and the accompanying schedule of investing and financing activities not affecting cash may contain the following major sections: Operating Activities Investing Activities Financing Activities Investing and Financing Activities Not Affecting Cash The following is a list of items that might appear on a company's statement of cash flows or in the accompanying schedule. Required: Using the letters A through D, indicate in which section of the statement of cash flows...
6. The table below shows the projected free cash flows of an acquisition target. Estimate the...
6. The table below shows the projected free cash flows of an acquisition target. Estimate the following: a) Terminal value at the end of 2025 based on the perpetual growth equation with a 4% perpetual growth rate b) Maximum acquisition price (MAP) as of the end of 2020 at a 9% discount rate YEAR                                                               2021    2022   2023   2024   2025 FREE CASH FLOW ($ thousands)                  -$500      $83    $87    $89     $92 The Present Value of $1 Table (Table 3)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT