Please make a 2-way data table (using the attached excel data) that calculates the value per share
Question:
Please make a 2-way data table (using the attached excel data) that calculates the value per share that varies the terminal growth rate and WACC. Please explain the steps on excel for how to make this data table (i do not know how to make a 2-way data table).
Additional info that may be helpful: Sales will grow by 2% each year • All recurring operating expenses and depreciation are a percent of sales based on 2019 levels. • The tax rate is 21%.; After year 3 of the forecast, free cash flows will grow by 2%. Assume that working capital is a constant percent of sales based on 2019 levels and capital spending equals depreciation each year. Assume that they will use 50% debt financing and use WACC = 7.40%. There are 40 million shares outstanding.
Here is the excel data from which you will make the table:
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw