Microsoft Excel – Essaylink
Get your Assignment in a Minimum of 3 hours
Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.Free Inquiry Order A Paper Now Cost Estimate
In this module, you will complete and submit your final project. First, complete the horizontal, vertical, and ratio analysis on the Module 06 tab in the Course Project Template workbook.
Then, complete a PowerPoint presentation including the following information, with an emphasis on the analysis of the company’s financial information. You may find helpful information in the annual report, annual 10-K filing, and the following library databases: Mergent Online, Business Source Complete via EBSCO, and Business via ProQuest. (For database help see http://guides.rasmussen.edu/business/databasehelp)
Your final Company Analysis should include the following:
- Brief company history
- Company values and goals
- Product lines
- Industry Challenges
- Main Competitors
- Company Risks (See Management Discussion and Analysis in Annual Filing)
- Horizontal Analysis – include a minimum of 3 income statement items and 3 balance sheet items to highlight, positive or negative. Share what these items mean in terms of the company’s performance.
- Vertical Analysis – include a minimum of 3 income statement items and 3 balance sheet items to highlight, positive or negative. Share what these items mean in terms of the company’s performance.
- Ratio Analysis – Address ratios in all five areas of ratio analysis: liquidity, asset management, solvency, profitability, and market analysis. Interpret these ratios, and explain what they mean for Tootsie Roll Industries Inc., supporting your explanation with your calculations. Compare your company to the competition and explain which company is performing better. In addition to using the information provided on the company’s website, also try Mergent Online: http://rasmussen.libanswers.com/faq/32789 Support your explanation with your calculations of your company and research of the competition or industry.
Include APA in-text citations and references for all sources used (including non-clipart images). Information about how to include in-text citations and references in a PowerPoint: http://rasmussen.libanswers.com/faq/32484
As with previous assignments, in the References box of the spreadsheet, include an APA reference for all information retrieved, whether from the Tootsie Roll website itself, specific forms (i.e. 10k) from the Tootsie Roll website, or other outside sources. Instructions for citing a 10k or Annual Report: http://rasmussen.libanswers.com/faq/32821
Your final submission will include TWO files: Your completed Course Project Template Workbook Excel file, and your Module 06 Company Analysis PowerPoint slideshow, and will be due in the end of Module 06.
Need help? Click here to work with a professional Accounting tutor in Live Help. See our Answer FAQ on the difference between Live Help and Tutor Match.
Also see the Writing Guide for additional guidance on Power Point presentations and Course Projects.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your two assignments as separate Microsoft Excel and Microsoft PowerPoint documents. (Mac users, please remember to append the “.xlsx” and .pptx extensions respectively to the filenames.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Need Help? Click here for complete drop box instructions.
"Is this question part of your assignment? We Can Help!"
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"Get Started