Creating a Project 

          Follow the instructions below to create a small project file to submit to your instructor.

Instructions: 

1. Sign up for the free trial of  Smartsheet . (http://www.smartsheet.com/signup?trp=17) Note that this free trial version is only available for 30 days from sign up.
2. Click the Create New tab. On the left hand side you will see the Template Gallery.
3. Select “Project Management” from the left hand list.
4. Scroll down the template list and search for “Basic Project with Gantt & Dependencies.” and click “Use Template” under template option:.
5. Name your sheet as first name.last name.inf410.w2 (example: jane.doe.inf410.w2) and leave all options checked.
6. Review the following video tutorials. Tutorial #1, Tutorial #2, and Tutorial #5. Note: although the tutorials are for Microsoft Project software, Smartsheet has the same Gantt chart functionality.
7. Once it comes up, you will see the Gantt view. To see the rest of the tabs (duration tab), move the border of the calendar over to the right or click on the Grid View Button under the home tab and that will show the rest of the menu tabs.
8. Modify the work breakdown structure names and levels to look exactly how it is shown in Tutorial #2 (the basic breakdown structure is already provided for you in the Smartsheet template) and enter the tasks exactly how the video tutorial describes. You will need to add and remove rows along with indenting and outdenting to complete this assignment. Start and finish dates do not have to be copied from the video example.
9. Select the durations of the tasks as shown in Tutorial #5. Use the exact durations shown in Tutorial #5 for your assignment. You do not need to use the “alternative” timeframes, as shown in Tutorial #5. You can keep everything in single numerical days.
10. Save your project.
11. Under the Home window on the left side of the project tab, click on the paper icon, select “Export” from the dropdown list and “Export to Excel” to save your file as an Excel document on your computer, keeping the file name already assigned in Step 3.
12. Submit the file by following the Waypoint Assignment Submission instructions.
13. Experiment with some of the features of the program that may help you to organize and track your future projects. (Not graded but encouraged.)
    

This assignment is the third part of the course project. In this assignment, you will utilize the two stocks within the same industry that were selected in Module 03.

Required

For the two firms, locate and download their latest annual report. Annual reports are typically found within the ‘Investor Relations’ section of a firm’s website.

Utilizing the data from each of the firm’s annual reports, calculate the following ratios:

• Liquidity Ratios – Current Ratio and Quick Ratio
• Activity Ratios – Inventory Turnover, Receivables Turnover, Days Sales Outstanding, Fixed Asset Turnover, and Total Asset Turnover
• Profitability Ratios – Gross Profit Margin, Operating Profit Margin, Net Profit Margin, Return on Assets, and Return on Equity
• Leverage Ratios – Debt/Net Worth and Debt Ratio
• Coverage Ratios – Times-Interest-Earned

You may utilize a Microsoft Excel document to calculate the ratios for each firm.

After calculating the ratios for each of the firms, present the results and provide a brief analysis on the financial health of each firm.

Your assignment should be a minimum of 3 written pages in addition to the ratio calculations and utilize APA formatting. In-text citations and a reference page should also be included.