Each student will develop a 15% spreadsheet to analyze the target price of a firm. This spreadsheet will estimate a target buy price for a firm in order to yield an average annual rate of return of 15%. Use the above example template and check figures to complete this spreadsheet.

Help with excel?

Nike NKE Price EPS Current P/E Current Year Projected Growth Average P/E Dividend Payout Target Price E(Rate of Return) Price