Question: Complete the attached excel file for Project #3 - due 5/7/23 Open the attached excel file to see the detailed instructions for Project #3. Select
Complete the attached excel file for Project #3 - due 5/7/23
Open the attached excel file to see the detailed instructions for Project #3.
Select a publicly traded company and locate their most recent financial statement publishing using the Edgar website. The steps have been identified in the excel file for how to access financial statements on the Edgar website.
Once youve selected a company calculate 10 of the following ratios in the excel template provided (submission template tab). The ratio options for your selection are included in the excel file.
On the submission template tab - Identify which ratio you're selecting in the ratio column. Indicate what does this ratio measure? Make sure to show your calculation for each ratio in the calculation column, and comment on what the ratio outcome is telling you - is the company a safe investment, have enough resources to pay debt, etc.
After completing all of your ratio calculations, comment on your overall assessment of the company. Is the company a good investment, why or why not.
Make sure to submit a copy of you excel file AND a copy of the financial statements you used to complete the project. You must actually pull the financial statements and locate the required information.
| Financial Accounting | |||||
| Project #3 | |||||
| Company Name: | |||||
| Financial Statement (10-K) or (10-Q) | |||||
| Date of Financial Statements | |||||
| Link to Financial Statements used | |||||
| Ratio | What does this Ratio Measure? | Calculation (Show your ratio calculation here) | Answer | What does your calculation tell you about the company? | |
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 | |||||
| Overall Comment on your assessment of the company - is the company a good investment? Why or why not? | |||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
