Week 7: Guidance for submission of the three files in

  

Week 7: Guidance for submission of the three files in the Assignments folder

The grading rubric found in the syllabus will be used to grade the deliverables for the project. Take care to avoid academic dishonesty. Create, read, and edit your work. Explain the analyses in your reports using your own words. If you use direct quotes or paraphrased content, provide links and/or parenthetical references for your sources. Copying information from the Web and pasting it into LEO is plagiarism. Plagiarism is cheating. Reports, spreadsheets, presentations, and discussion postings must comply with UMUC academic honesty policies.

1.  Microsoft Word document:

• Estimated length: five to seven (5-7) pages
• 1 inch margins top & bottom; 1 to 1.25 inches on left & right sides
• Line spacing: single spacing with double spacing between paragraphs
• Font size: 12 CPI
• Font style: Times New Roman
• Save the file with YOUR NAME in the file name.
  Example: YourNameSECreport.docx

2.  Excel Ratio File spreadsheet:

• Using the SEC Financial Statements Ratios and Calculations, prepare a ratio analysis of your SEC corporation’s current and prior years financial statements. In addition to presenting the year to year profit and loss and balance sheet variances, calculate inventory turnover, operating margin, working capital and operating margin. Explain the value of understanding why inventory balances, inventory turnover, cost of goods sold, operating margin, and working capital are important metrics for Cost Accounting. Label your work in Excel to assist those who read your work.

• Using the SEC 10-K financial statements, create a three year comparative income statement with summary line items focusing on revenue through net income with key line items included but items of lower value appropriately grouped as All other Expenses. Revenue, Cost of Goods Sold, SG&A, and Income Tax Expense should be separate line items. Include a vertical analysis column for each of the three years presented.

https://www.sec.gov/reportspubs/investor-publications/investorpubsbegfinstmtguidehtm.html

· Formulas must be embedded into the cells
  If you do not know how to create formulas in Excel, click the following link and take a free 40-50 minute training course offered by Microsoft: http://office.microsoft.com/en-us/excel-help/overview-RZ101773335.aspx?section=1 or use other resources.
• Save the file with YOUR NAME in the file name.
  Example: YourNameSECreport.xls

3.  Microsoft Power Point presentation:

• Prepare your slides to make a formal presentation to the senior management team of your manufacturing corporation. Be creative and present an overview and meaningful cost    accounting information to support decision-making by corporate executives and other key personnel internally at your manufacturing corporation. Use your own judgment to      select the cost accounting-related highlights for your presentation.
• You may wish to add audio or to provide speaker’s notes for your presentation.
• Save the file with YOUR NAME in the file name.
  Example: YourNameSECreport.ppt

Upload the three components of the project under the appropriate tabs in the Assignment folder for the SEC 10-K project under Week 7.

Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!