Our Services

Get 15% Discount on your First Order

The project is an exercise of fundamental analysis of a

February 16, 2022

The project is an exercise of fundamental analysis of a firm using ratios. You are expected to calculate a number of ratios for a firm and analyze its financial condition. As the main outcomes of the project, upload 2 files on Canvas: Project Report (word/pdf) and Calculation (excel).

Pick a prominent non-financial public firm (EXCEPT WALMART) from any industry. Calculate the following ratios for your chosen firm for 2019 and 2020 (if data for 2021 is available, use 2020 and 2021data)

Liquidity Ratios:

Current Ratio

Quick Ratio

Cash Ratio

Solvency Ratios:

Total Debt Ratio

Debt-equity Ratio

Times Interest Earned Ratio

Turnover Ratios:

Inventory Turnover

Receivables Turnover

Total Asset Turnover

Profitability Ratios:

Profit Margin

Return on Assets (ROA)

Return on Equity (ROE)

Market values Ratios:

Price-earnings Ratio

Price-sales Ratio

Market-to-book Ratio

Investigate the firm’s financial condition in 2020 (by comparing with 2019) in terms of its Liquidity, Solvency, Turnover, Profitability, and Market Values by analyzing the calculated ratios. How the firm’s performance changed through time? Based on your analysis, comment on the future prospect of the firm from an investor’s viewpoint.

Instructions:

Consistent with the university academic integrity policy, your submission MUST be your original work.
Show all your works/calculation in an excel file (Question 1). The required financial statements (Income Statement and Balance Sheet) must be presented in excel; calculate all the ratios from those data using excel formula.
Use a word/pdf file for the analysis part (Question 2). There is no page limit for the Project Report. The length of the report depends on the work needed in completing each of the components of the project.
For both calculation and analysis, use extensively the content of Chapter 3: Working with Financial Statements.
Use reliable web sources for financial statements such as Bloomberg, Yahoo Finance, Edgar etc.
The grade for the project depends on the quality of work in terms of accuracy, analyses, completeness, organization, writing, and relevance.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Overview Healthcare revenue-cycle management is a strictly Nursing Assignment Help

Overview Healthcare revenue-cycle management is a strictly managed and closely monitored process that impacts the patients (beneficiaries), providers, or payers. Therefore, it is important for both stakeholders to understand the other’s perspective, so that they have a more holistic view of the entire process. The following flowcharts capture the revenue

Managerial Accounting

Requirements for Written Case Analyses: 1. Answer the questions in the assignment in order. Number your answers to the questions to make it clear which question you are answering. No introduction or statement of the problem is required. 2. Type your answers, double-spaced, in 12 point font. Number each page

West Coast Hip Hop of the ’90’s

This paper is based on a guiding research question about a genre of music and a societal issue. West Coast Hip Hop of the ’90’s is the genre. Create a question about some aspect of society in relation to the genre, specifically discuss some background of the genre, some bibliography

What is digital transformation and what are the main domains

What is digital transformation and what are the main domains of this concept? Please explain and have some proof or your thoughts All answers must include APA 7th in-text citation (video and research) as well as APA 7th edition references. All reference links should be valid! References should be

Locate two Administrative Healthcare Information Systems (AHIS using Internet search

Locate two Administrative Healthcare Information Systems (AHIS using Internet search (e.g., https://www.healthcareitnews.com/news/buyers-guide-practice-management, https://www.capterra.com/sem-compare/medical-practice-management-software?utm_source=bing&utm_medium=cpc). In a tabulated form compare their patient management and revenue management features and functions; which of these two systems would you recommend for a healthcare facility you may be working for and why? Make sure to provide

After reading the articles, 10 Brainteasers to Stretch your Brain

After reading the articles, 10 Brainteasers to Stretch your Brain and Are you Solving the Right Problems, respond to the following prompt. (If the link does not work you can google for the article too) Please share with the class a recent problem you have encountered either at work or in

Your assignment: First read (again) the article: Taxonomy of Cross-Platform

Your assignment: First read (again) the article: Taxonomy of Cross-Platform Mobile Applications Development – notice how the author breaks the research problem into 6 measurable questions (Code is Resuable, Plugins, Easy for Web Developers, etc.). Use any 3 of these as your research questions. Since your Method is exploratory

Recently, Green Branch Coffee mangers have approached you with questions

Recently, Green Branch Coffee mangers have approached you with questions regarding the Americans with Disabilities Act (ADA), the Age Discrimination in Employment Act (ADEA), the Equal Pay Act (EPA), and the Fair Labor Standards Act (FLSA). To address these questions, you have decided to prepare a presentation for the managers

Impact of “isms” on Human Development

This assignment is designed to assess your ability to meet the following course objectives: Critically analyze the interplay between biophysical, psychological, social, economic, spiritual and cultural forces in human development; the risks and resilience of each stage of life; major theories of human development. Critically evaluate the impact that human

Answer ANY four (4) questions (100 marks) 1. A warehouse

Answer ANY four (4) questions (100 marks) 1. A warehouse is a temporary place to store inventory which acts as a buffer ina supply chain. With an aid of an example illustrate the role of a warehousefor the following companies/organisations; a) Mydinb) Peroduac) Follow Me Shampood) Penang Porte) Hankyu Hanshin

Please revise assignment When using graphics, for ADA compliance, use alternate text (right click=> edit alt text) and explain in the speakers’ notes.

Please revise assignment When using graphics, for ADA compliance, use alternate text (right click=> edit alt text) and explain in the speakers’ notes. Do not rely on automatically generated alt-text. Try regenerating text-based graphics. Explain Leadership actions required as per the 4 adjustments identified by Burkus as they relate

NO ONLINE SOURCE / NO REFERENCES All questions are worth

NO ONLINE SOURCE / NO REFERENCES All questions are worth 20 points: 1. In which ways can elder abuse legislation infringe on individual rights and self-determination? How can legislation effectively balance the preservation of individual rights and the protection of older or vulnerable adults against neglect and abuse? Justify your

Kroger Co. Analysis

Part 7: Operations Discuss the firm’s operations. Convince management that you know how the company operates to create value for its owners through its operations. The executive’s description is the 10-K Report section called “Business description” (the 10-K is available on CIQ). You will also find info about the business

Evaluation and Communication Plans

Submit the Evaluation and Communication Plans portions of your change initiative proposal. This should be a comprehensive description of the initiative’s evaluation plan—how will success or failure be measured—and its communications plan. Utilize tables, figures, and graphs to the extent that you deem appropriate, and incorporate these tables, figures, and

Write a 2–3-page paper in which you: Explain the goals

Write a 2–3-page paper in which you: Explain the goals of criminal law and why these goals are still important today. Explain the connection between state police power and the limitations of this power imposed by the Constitution. Identify the differences between state and federal jurisdiction, when it comes

on the influence patient education has in health care using

on the influence patient education has in health care using the experiences of a patient. Interview a friend or family member about that person’s experiences with the health care system. You may develop your own list of questions. Suggested interview questions: Did a patient education representative give you instructions on

In our contemporary work, we seem to be perpetually busy

In our contemporary work, we seem to be perpetually busy in a fast-paced existence. Many of us find it challenging to disconnect from our phones or social media and allow ourselves a change to rest and recharge. Work – life balance seems critical in ensuring that we are able to

Using the company you chose for this week’s ethical project,

Using the company you chose for this week’s ethical project, please summarize your analysis and share your thoughts with the class. In your responses among your peers, expand the discussion by providing your thoughts on the ethical dilemma and how your peer intends to handle it. Be sure to