Determine the discount factor for each year, including the terminal year. Enter the discount rate and perpetual growth rate in the spreadsheet. Calculate the terminal value.
The goal of this analysis is to determine a financial valuation of the fair market value of 100% of The Duke’s Sporting Goods Store (“Duke’s”), by using two of the three approaches to valuation . The valuation date is December 31 of the current year. The following Excel file containing two spreadsheets: Duke’s Discounted Cash […]