USING EXCEL FOR PRESENT VALUE CALCULATIONS

Compare your estimate to Mondavi’s actual stock price. Why might your estimate be different than the actual stock price? What assumptions have the greatest effect on your estimate of the Mondavi’s stock price? (Again, Exhibit 3 contains an Excel template that uses a 5-year forecast horizon.) Finding the Company on Yahoo Finance. ................
................