Question
Reizenstein Technologies (RT) has just developed a solar panel capable of generating 200% more electricity than any solar panel currently on the market. As a
Reizenstein Technologies (RT) has just developed a solar panel capable of generating 200% more electricity than any solar panel currently on the market. As a result, RT is expected to experience a 19% annual growth rate for the next 5 years. By the end of 5 years, other firms will have developed comparable technology, and RT's growth rate will slow to 8% per year indefinitely. RT has a 15% weighted average cost of capital. The most recent annual free cash flow (FCF0) was $3.80 million.
-
Calculate RT's expected FCFs for t = 1, t = 2, t = 3, t = 4, and t = 5. Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to three decimal places.
FCF1 = $ million
FCF2 = $ million
FCF3 = $ million
FCF4 = $ million
FCF5 = $ million
-
What is the horizon value at t = 5 (HV5)? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to two decimal places.
$ million
-
What is the present value of the horizon value (HV5)? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to two decimal places.
$ million
-
What is the present value of the free cash flows expected at t = 1, t = 2, t = 3, t = 4,and t = 5? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to two decimal places.
$ million
-
What is the value of operations at t = 0? Do not round intermediate calculations. Enter your answer in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to two decimal places.
$ million
can someone show me how to do this in excel? I keep getting incorrect answers and I do not know how.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started