Prepare a stock valuation model of MATTEL (MAT). The assignment requires a cooy of your company's latest annual report (10-K). You will need to use the financial statemerts portion to complete the assignment, which can be obtained through several sources. Some major sources include: 1) The company's Investor Relations Department. 2) A business library, such as the Baruch College Library or the Business and Science Library in New York City. 3) The company's website, where a copy can usually be downloaded directly. 4) A website that accesses EDGAR, the SEC's corporate filing center. This can be accessed from Yahoo (under the company's profile) or through sites such as Free EDGAR (www.freeedgar.com) and EDGAR Online (www.edgar-online.com). 5) An annual report service or site, which is provided by major financial information companies such as Dow Jones or Bloomberg. -A pro forma Income Statement must be prepared in MS Excel, using a minimum projection of three years based on pro forma projections discussed in Chapter 18. You need to include your company's most recent income statement which is part of the 10-K. This information can then be used to calculate the fair value of the company's stock price, based on the stock valuation formulas discussed in Chapters 7 and 10. All assumptions and formulas used for the pro forma projections and the company's fair value must be included at the end of your model. A separate attachment provides an example of how this model should be constructed. -Once a fair value is reached, this can be compared to a recent quote of the company's stock price to determine whether or not the company is fairly valued at its most recent trading price.