Follow the prompt below. Please type using a word processing program and submit online via Canvas. Write as much or as little as you feel necessary to show your new expertise. You may use all...

1 answer below »
Follow the prompt below. Please type using a word processing program and submit online via Canvas. Write as much or as little as you feel necessary to show your new expertise. You may use all available resources to complete this case – e.g., lecture slides, notes, your book, and the Accounting Standards Codification. Collaboration with others in your group is allowed to the extent that it is helpful. How you work together is up to you – however, the final turned-in paper is ultimately a group effort and you are mutually responsible for the final work. As such, I encourage you to take ownership of every part of the finished product – not just what you are assigned. Please turn in only one finished assignment for each group. Groups have a maximum size of five. However, there is no minimum size of group (e.g., groups of 1 are acceptable). Note that I will consider the group’s size when grading and have higher expectations with groups of greater size.
Use appropriate citations where relevant and according to your professional judgment. When using the codification, please use the following style:
Cite the ASC down to the Paragraph. For example, (ASC 330-10-05-01)At the end of the document in an Appendix, copy-paste the paragraph you cite from the codification into the word document.The main goal is to interpret your findings into ‘plain English’ as best you can. In other words, how would you explain the appropriate accounting treatment to a colleague, boss, or business partner who has a basic understanding of accounting? You may (and are encouraged to) use debits and credits and/or t-accounts to illustrate the accounting if appropriate.For all other citations, please consistently follow a single style (e.g., APA, MLA, Chicago). Always cite if you are making a factual claim.
Prompt:

Select a company that you find interesting and would like to learn more about. The company must be a public company with available financial statements for the past five years. Download the financial statements of the company from either SEC’s website (Links to an external site.) or the company’s website and transfer the information to Tableau. Use your knowledge from this course and your Tableau skills to analyze the financial statement of the company. You can use various financial statements analysis tools (i.e. horizontal, vertical, and ratios), but I encourage you to use ratio analysis and compare the company’s liquidity and profitability with the industry averages. For your final submission please write a report on the current and future prospects of the company based on your analysis.
p/s: I attached my group file and just do the 2 paragraphs at the red headers
Answered Same DayMay 17, 2022

Answer To: Follow the prompt below. Please type using a word processing program and submit online via Canvas....

Prateek answered on May 17 2022
89 Votes
Times Interest Earned Graph
Analysis:
The times interest earned ratio of Nike is declining year on year. A times interest earned ratio determines how
many times a company is able to pay off its interest using the operating income (EBITDA). It is computed by dividing EBITDA of a company by its interest expense. In 2017, the company was able to generate income which could pay at least 83 times the interest during a period. The overall trend has been declining just by looking at the graph. Now, comparing the times interest earned ratio of Nike with that of the industry, it seems that it is well below industry average in 2021. However, the company did well in 2020 with a ratio of 33.43 compared to the industry average of -44.07. Based on the past trends, the company had a better ratio than industry in 2017. Even though the ratio is lower compared to the industry average, it doesn’t mean that the company is not able to pay its interest. Well, it can still pay its interest back 26 times using its operating income, which is a good sign. Sometimes, companies in similar business have varied ratios which also depends upon the type of accounting methods they use. Thus, even though the industry ratio is high, it does not give the full picture of whether the company is having low ratio due to lower operating income or different accounting methods are used due to which this ratio is lower. Thus, one needs to analyze the notes to accounts of the company to gain further insights about this ratio.
Times Interest...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers