Accounting
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
· 1. Name of corporation: General Mills: NYSE: GIS
2. Why I chose the corporation: I personally love cereal and my favorite cereal is made by General Mills.
3. Link to corporation’s SEC 10-K report:
https://www.sec.gov/ix?doc=/Archives/edgar/data/40704/000119312520186469/d89717d10k.htm#Financial_Statements_and_Supplementary
4. Corporation’s position: Rank 169
https://fortune.com/company/general-mills/fortune500/
5. Page number for Financial statements:
Consolidated Statements of Earnings- page 48
Consolidated statements of Comprehensive Income – page 49
Consolidated Balance Sheets- page 50
Consolidated Statements of Total Equity and Redeemable Interest- page 51
Consolidated Statements of Cash Flows- page 52
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
