Phoenix Corp. faltered in the recent recession but is recovering. Free cash flow has grown rapidly. Forecasts made in 2019 are as follows: ($ millions) 2020 2021 2022 2023 2024 Net income 1.0 2.3 3.8 4.30 4.6 Investment 1.0 1.3 1.5 1.7 Free cash flow. 0 1.0 2.3 2.6 1.7 2.9 Phoenix's recovery will be complete by 2024, and there will be no further growth in net income or free cash flow. a. Calculate the PV of free cash flow, assuming a cost of equity of 10%. (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

**Please solve using Excel and explain all the formulas**

 

### Phoenix Corp. Financial Forecast Analysis

Phoenix Corp. faltered in the recent recession but is recovering. Free cash flow has grown rapidly. Forecasts made in 2019 are as follows:

| ($ millions)  | 2020 | 2021 | 2022 | 2023 | 2024 |
|---------------|------|------|------|------|------|
| Net income    | 1.0  | 2.3  | 3.8  | 4.30 | 4.6  |
| Investment    | 1.0  | 1.3  | 1.5  | 1.7  | 1.7  |
| Free cash flow| 0    | 1.0  | 2.3  | 2.6  | 2.9  |

Phoenix’s recovery will be complete by 2024, and there will be no further growth in net income or free cash flow. 

#### a. Present Value Calculation
Calculate the PV of free cash flow, assuming a cost of equity of 10%. 
*Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.*

**Answer:**

**Present value:**  __ million

#### b. Price Per Share Calculation
Assume that Phoenix has 10 million shares outstanding. What is the price per share? 
*Do not round intermediate calculations. Round your answer to 2 decimal places.*

**Answer:**

**Price per share:**  __ 

#### c. Rate of Return Confirmation
Confirm that the expected rate of return on Phoenix stock is exactly 10% in each of the years from 2020 to 2024. 
*Hint: First, calculate the PV of all future cash flows starting in each year. Round your answer to 2 decimal places.*

| Years | Present Value | Rate of Return |
|-------|----------------|----------------|
| 2020  | __             | __ %           |
| 2021  | __             | __ %           |
| 2022  | __             | __ %           |
| 2023  | __             | __ %           |

*Please fill in the blanks with your calculations and analysis.*
Transcribed Image Text:### Phoenix Corp. Financial Forecast Analysis Phoenix Corp. faltered in the recent recession but is recovering. Free cash flow has grown rapidly. Forecasts made in 2019 are as follows: | ($ millions) | 2020 | 2021 | 2022 | 2023 | 2024 | |---------------|------|------|------|------|------| | Net income | 1.0 | 2.3 | 3.8 | 4.30 | 4.6 | | Investment | 1.0 | 1.3 | 1.5 | 1.7 | 1.7 | | Free cash flow| 0 | 1.0 | 2.3 | 2.6 | 2.9 | Phoenix’s recovery will be complete by 2024, and there will be no further growth in net income or free cash flow. #### a. Present Value Calculation Calculate the PV of free cash flow, assuming a cost of equity of 10%. *Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.* **Answer:** **Present value:** __ million #### b. Price Per Share Calculation Assume that Phoenix has 10 million shares outstanding. What is the price per share? *Do not round intermediate calculations. Round your answer to 2 decimal places.* **Answer:** **Price per share:** __ #### c. Rate of Return Confirmation Confirm that the expected rate of return on Phoenix stock is exactly 10% in each of the years from 2020 to 2024. *Hint: First, calculate the PV of all future cash flows starting in each year. Round your answer to 2 decimal places.* | Years | Present Value | Rate of Return | |-------|----------------|----------------| | 2020 | __ | __ % | | 2021 | __ | __ % | | 2022 | __ | __ % | | 2023 | __ | __ % | *Please fill in the blanks with your calculations and analysis.*
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education