Transcribed Image Text
Angel Enterprise was going public in2018. You were wondering whether the $30 per share offer price is afair price. You decided to use discounted cash flow approach tovalue the company’s stock. You gathered the following data:YearFCFOther Data2019$600,000Growth rate of FCF beyond 2023 = 3%2020$900,000Weighted Average Cost of Capital (WACC) = 10%2021$1,400,000The firm has no debt20222023$1,800,000$2,500,000Number of common shares outstanding = 1,000,000a. Based on your valuation, what isthe common stock per share? Is the stock worth buying?b. What is the common stock per shareif the terminal growth rate (growth rate beyond 2023) were 5%instead of 3%?Please cut and paste your Excel spreadsheet here.** I need help with the equations