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

Conflict and diplomacy in the middle east

After you read the article write a summary about 1 page and answer the 3 questions blew and critically analyze assigned 1. Reading Assignment 1 https://www.e-ir.info/2018/10/04/conflict-and-diplomacy-in-the-middle-east/ 1- How does Barry Buzan define the Middle East region? 2- What are the main arguments of the Regional Security Complex Theory? 3-Critically analyze

Idea Generation Submit a word document describing three possible project

Idea Generation Submit a word document describing three possible project ideas along with possible data sources for each of the three proposed projects. Indicate whether you would collect primary data or use secondary data from a published source. Be sure to think the projects through carefully as you will be

Instructions: You are the tax manager of Maximus & Smith

Instructions: You are the tax manager of Maximus & Smith CPA and have asked the two tax interns to prepare a research memo regarding the same client. You provided each the same information (Attached) about the client and are using this assignment as one of the indicators to help you

Submit a paper with your personal response to the topic

Submit a paper with your personal response to the topic and questions. This is your personal reflection. To form your opinion, you may want to research what people who work in the field say about it. You are welcome summarize what they say. Then add your personal thoughts for

Patriot Act & Homeland Security Act and Cyber Crime Prior

Patriot Act & Homeland Security Act and Cyber Crime Prior to beginning work on this discussion read the Fong and Delaney (2013) (Links to an external site.) article and the Mitchell and Pate online resource (Links to an external site.). The destruction of the World Trade Towers, the attack on the Pentagon,

Homeostasis Please explain and discuss the physiology of a faster

Homeostasis Please explain and discuss the physiology of a faster heart rate with a reduced blood volume and how it relates to homeostasis and feedback mechanisms. 1. Your original post must have a clear understanding of the topic and should be a minimum of 1 paragraph with at least 5

Write a Ethic and Plagiarism paper with the following content:

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Compare and contrast the structure and recent performance of the UK

1) Start by explaining the structure of the UK art market and identifying the main players within the market. Outline the current performance of the UK art market. In order to have more narrow focus, analyse specific art market structure and its performance i.e. Impressionist and Modern Art within UK

Effective communication is a staple of our healthcare culture. Working with patients, peers, and interprofessional teams requires that nurses manage information and evidence toward influencing safe a Nursing Assignment Help

Effective communication is a staple of our healthcare culture. Working with patients, peers, and interprofessional teams requires that nurses manage information and evidence toward influencing safe and positive patient outcomes. Please address the following: Describe caring attributes of the culture where you currently practice. Which attributes stand out as having

2 Question/600 words per question Response’s need to be 600

2 Question/600 words per question Response’s need to be 600 words – excluding direct quotes. You are to provide at least 3 references other than your readings to support each response. These references are to be in APA format. Corresponding citations should be included in your response to document/support the

In this module we have been examining environmental indicators and

In this module we have been examining environmental indicators and standards. One way to be aware of the environmental impact of a person or business is to know the carbon footprint. In this assignment you will calculate your carbon footprint. Please write a short 2 page paper that you submit

This assignment will offer an opportunity to review and analyze

This assignment will offer an opportunity to review and analyze two websites that provide information and/or education about drugs. It is meant to help you understand some of the factors involved in seeking information or services, and recognize the value of thinking critically about what is offered online. 1. Go

Copy and paste the following CDC website link into a

In your journal, reflect on ethical issues that you can foresee coming up as a forensic psychologist who does civil commitment assessments. How can you

In your journal, reflect on ethical issues that you can foresee coming up as a forensic psychologist who does civil commitment assessments. How can you as an assessment psychologist be cognizant of them, work through them, or avoid them? Also, consider the special populations mentioned in the article. How

ADULT Wellness check up Follow the Soap Note Rubric, template

ADULT Wellness check up Follow the Soap Note Rubric, template and directions attached as a guide Use APA format and must include a minimum of 3 Scholarly Citations. Will be placed through TURN-It-In (anti-Plagiarism program) and less than 15 % or will not be accepted Use the sample templates ,

Lysistrata question: The battle between men and women is timeless.

Lysistrata question: The battle between men and women is timeless. Consider how the battle of the sexes has changed from when Aristophanes wrote the play and now. What is your impression of Lysistrata? Is she a likeable character? Why/why not? Do you believe that her plan makes her a hero?

Read the attached lecture notes, visit this website, and view

Read the attached lecture notes, visit this website, and view this video for tips on introduction strategies. Write the introduction for the research paper and be sure to give credit to your sources using APA format for in-text citation. ONLY SUBMIT THE INTRODUCTION FOR THIS WEEK’S ASSIGNMENT.

Complete your Research Project 2 in a Word document, APA

Complete your Research Project 2 in a Word document, APA formatted, and then submit it in the Assignment section of the classroom by midnight, EST, Day 7.The instructions concerning this assignment as well as the grading rubric are reproduced below. In 2009 the American auto industry was in a