Assignment 4 007 Spring 2015
MNGT 475 Spring 2015
Assignment #4
Note: This assignment is worth 25 points and is due on Thursday, April 23rd.
You will turn in a total of three documents (four total pages) for this assignment.
Hardcopy is required:
1. The answers to the questions asked in Part 1. This should be no longer than one page of single-spaced text. Please keep your answers focused and to-thepoint.
2. The data worksheet containing the data for Part 1.
3. A Briefing Memo described in Part 2. This should be no longer than two pages and should follow the format for a professional business memorandum.
Part 1: Review and Interpretation of Financial and Operational Data
You can use MSN Money http://moneycentral.msn.com as your primary source for the data necessary to answer sections B & C:
i.
Enter your trading symbol into the “Name or symbols” dialog box and click on
“Get Quote.” ii. The initial screen is the “Quote” screen. You will see menu tabs below the stock price along with other information options. The menu selections change according to which screen you are on, but you can always get back to this “Quotes” screen by choosing the “Quotes” option on the menu.
iii.
If you need to look up a definition or how an item is calculated, please refer to
Investopedia.com: http://www.investopedia.com/dictionary
A worksheet has been provided on Blackboard to facilitate the collection of the data needed to answer sections B & C. Please download and complete the data collection worksheet and turn in a printout of it along with your assignment. (The worksheet on Blackboard is a protected Excel workbook file. Enter data only in the blank spaces; calculations will occur automatically. Further specific instructions are provided below.) You do not need to repeat the raw data in your answers to the questions. A: Your name, company name, exchange and trading symbol as before.
B: Valuation Analysis Data
From “Quote” page, click on “Financial Highlights” under “Fundamentals” in the menu selections along
Assignment #4
Note: This assignment is worth 25 points and is due on Thursday, April 23rd.
You will turn in a total of three documents (four total pages) for this assignment.
Hardcopy is required:
1. The answers to the questions asked in Part 1. This should be no longer than one page of single-spaced text. Please keep your answers focused and to-thepoint.
2. The data worksheet containing the data for Part 1.
3. A Briefing Memo described in Part 2. This should be no longer than two pages and should follow the format for a professional business memorandum.
Part 1: Review and Interpretation of Financial and Operational Data
You can use MSN Money http://moneycentral.msn.com as your primary source for the data necessary to answer sections B & C:
i.
Enter your trading symbol into the “Name or symbols” dialog box and click on
“Get Quote.” ii. The initial screen is the “Quote” screen. You will see menu tabs below the stock price along with other information options. The menu selections change according to which screen you are on, but you can always get back to this “Quotes” screen by choosing the “Quotes” option on the menu.
iii.
If you need to look up a definition or how an item is calculated, please refer to
Investopedia.com: http://www.investopedia.com/dictionary
A worksheet has been provided on Blackboard to facilitate the collection of the data needed to answer sections B & C. Please download and complete the data collection worksheet and turn in a printout of it along with your assignment. (The worksheet on Blackboard is a protected Excel workbook file. Enter data only in the blank spaces; calculations will occur automatically. Further specific instructions are provided below.) You do not need to repeat the raw data in your answers to the questions. A: Your name, company name, exchange and trading symbol as before.
B: Valuation Analysis Data
From “Quote” page, click on “Financial Highlights” under “Fundamentals” in the menu selections along