week 4

Using the valuation models from your assigned readings this week, along with the stock and bond selected that you selected in previous modules, determine the value of each commodity. After you have determined value, look up each securities current market price. How does your value determination compare to market price? (Hint: Prior to your stock valuation you will need to determine the investor "required rate of return".) Deduce if your stock and bond is undervalued or overvalued in relation to market price.

Show any formulas used in your valuations and cite all referenced sources. You may include the formulas in your narrative or provide a separate formula worksheet. Your report should be a minimum of 2 written pages.

 The company must be on Vale, calculate market price using excel.