Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please do solution in Excel Problem 1. A startup company called Luna is being evaluated by its founder Luna at date t = 0, which

image text in transcribed

Please do solution in Excel

Problem 1. A startup company called "Luna" is being evaluated by its founder Luna at date t = 0, which is the beginning of the startups's growth period. Luna expects the growth period to last for 3 years. After the growth period, iLuna will enter into the early- maturity period. The early-maturity period is expected to last for 17 years. After it finishes the early-maturity period, the founder of iLuna expect the company to enter the late-maturity period. The late-maturity period is expected to last forever. In the growth period, the growth rate of invested capital is 80%, the return on invested capital is 10%, and the required rate of return is 20%. In the early-maturity period, the growth rate is 20%, the return on invested capital is 100%, and the required rate of return is 15%. In the late-maturity period, the growth rate decreases to 2.5%, the return on invested capital is 7% and is equal to the required rate of return. The amount of invested capital in iLuna at the beginning of the growth period is $1.5 million. 1. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the growth period? 2. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the early-maturity period? 3. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the late-maturity period? 4. What is the economic value of iLuna at t=0? 5. If the growth rate in the late-maturity period is 5%, compute by how much the eco- nomic value of iLuna at t= 0 changes. Explain the result using one or two sentences. 6. If the return on invested capital in the early-maturity period decreases to 50%, does the value of iLuna at t = 0 change? If it changes, compute the new value and explain why the value changes. If it does not change, please explain why the value does not change. Problem 1. A startup company called "Luna" is being evaluated by its founder Luna at date t = 0, which is the beginning of the startups's growth period. Luna expects the growth period to last for 3 years. After the growth period, iLuna will enter into the early- maturity period. The early-maturity period is expected to last for 17 years. After it finishes the early-maturity period, the founder of iLuna expect the company to enter the late-maturity period. The late-maturity period is expected to last forever. In the growth period, the growth rate of invested capital is 80%, the return on invested capital is 10%, and the required rate of return is 20%. In the early-maturity period, the growth rate is 20%, the return on invested capital is 100%, and the required rate of return is 15%. In the late-maturity period, the growth rate decreases to 2.5%, the return on invested capital is 7% and is equal to the required rate of return. The amount of invested capital in iLuna at the beginning of the growth period is $1.5 million. 1. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the growth period? 2. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the early-maturity period? 3. What is the economic value at t = 0 of the free cash flows iLuna is expected to pro- duce during the late-maturity period? 4. What is the economic value of iLuna at t=0? 5. If the growth rate in the late-maturity period is 5%, compute by how much the eco- nomic value of iLuna at t= 0 changes. Explain the result using one or two sentences. 6. If the return on invested capital in the early-maturity period decreases to 50%, does the value of iLuna at t = 0 change? If it changes, compute the new value and explain why the value changes. If it does not change, please explain why the value does not change

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glencoe Accounting

Authors: McGraw-Hill

1st Edition

0021400881, 9780021400881

More Books

Students also viewed these Accounting questions