TOTAL WORDS: 3000WORDS. HARVARD STYLE! the firm‘s name is ‘Pepsico Inc.' I give you an example of the report with another company. If U don't know how to do the excel, you can see the example and the lab. The specific requirement is in the ASSIGNMENT 2. You can see the 'objective ',please use the 'methods presented in the second part of the module'. thank you so much.

Please attach a separate copy of your Excel workfile with your submission OR include a copy of your Excel workbook as an appendix to your report. 25% of the coursework mark will be subtracted from submitted assignments that do not include the Excel workbook.

Important details: The "Assigned Firms CW2.xlsx" file provided in the Coursework 2 folder on the Blackboard site of the module assigns a real U.S. firm to each student. Therefore, you should prepare the report for the firm assigned to you. To find the data you need, you should use Yahoo! Finance. A link to each firm's webpage is provided in the above file. The questions are related to the material covered in Lectures 11-17 and Labs 5-7 of the module. You should prepare your report in Microsoft Word or in another word processing software.

In each section of the report, you should also include details about the data you used and the formulas you applied for your computations. However, try to be brief and clear in your answers. The questions should be answered using Microsoft Excel in a single workbook with multiple worksheets. In the workbook, you should include all the data you obtained from Yahoo! Finance. Your submission should include a copy of your Excel workbook as an appendix to your report OR as a separate attachment. 25% of the coursework mark will be subtracted from submitted assignments that do not include a copy of the Excel workbook.

You should present your formulas and models in Word and Excel in a clear manner. You should also use an appropriate format for the Excel cells. All graphs should be included in your report (Word file). Any questions related to the coursework should be submitted to the "Assignment 2 Questions" forum within the Q&A forum on the Blackboard page of the module. The link to the Q&A forum can be found under the Module Documents section. To ask a question, click on Create a New thread and post your question. You should also click on "Subscribe" to receive an email when a new question is posted. It is a good practice to visit this forum regularly.

Submission deadline: Thursday at 15:00 (3 PM). Word limit: The report should not exceed 3,000 words. This limit excludes the Appendix, but includes the references. In preparing your coursework, you should be aware that you will be assessed by reference to the extent to which your answers meet the following criteria: Identification and application of knowledge to the question asked. Evidence of reading and research. Capacity to find data from online resources. Ability to construct financial models related to the question asked. Ability to correctly implement these models using spreadsheet software. Demonstration of ability to structure and present work in a clear and coherent way. Clear and accurate expression. Please preserve anonymity by using your university number, not your name. This coursework counts for 50% of the assessment in this module.

Referencing - Your coursework should clearly distinguish between your original words and ideas, and those of others. When referring to the work of others, from books, journals or any other source (including the internet), it is essential that you make this clear by acknowledging your source and referencing correctly. Failure to reference correctly will lose you marks and may constitute plagiarism or collusion. Unless specified otherwise by the module organiser, Norwich Business School uses the Harvard system of referencing. Penalties for late submission - The deadline for submission of coursework is 15:00 (3pm) on the submission/due day. This is for both electronic submission and paper copy submissions.