In that project you have to select two companies (Target and Microsoft) to analyze ratios, create graphs and write about your findings. ***A 3-4 PAPER IS REQUIRED FOR THIS ASSIGNMENT***

May 19, 2023May 19, 2023 Discipline: Finance

Purpose

This assignment is intended to help you learn to interpret financial ratios and offer conclusions about company financial performance after drawing data through an online database.

Overview

Throughout this course you will work with the Mergent Online database and perform elements of securities analysis involving a select group of companies.

Directions

1. Alter the Excel spreadsheets (SPEADSHEETS ARE ATTACHED) as directed above so that the data is ordered historically oldest to most recent.

(( it will be necessary to reverse the date order so that the oldest date is in column B and the most recent date appears in column J.))

2. Create line graphs or bar charts (five in total) depicting the following comparisons between the two companies you are evaluating during each of the last five years:

  • Current Ratio
  • LT Debt to Equity
  • Total Asset Turnover
  • ROA % (Net)
  • ROE % (Net)
3. Write a 3-4 page paper (approximately 600 words) in APA format that includes:

A.) An
introduction that identifies the two companies that are the subject of your
analysis.

B.) Your
Excel graphs inserted into the body of your paper. There should be a total of
four graphs discussed in your narrative. For each graphed ratio, respond to the
following:
–What
is the difference between the two companies on this ratio? What is a plausible
explanation as to why they would differ? Is one company clearly different than
the other?

–Are
there economic or end-market influences that explain why the ratios differ?
What might they be?

–Over
time, is each company’s overall financial performance improving, declining, or
is something strange going on?

–Do you
think evaluating financial statements is a good idea? What do you regard as
some of the shortcomings of financial ratio analysis?

Are you struggling with your paper? Let us handle it - WE ARE EXPERTS!

Whatever paper you need - we will help you write it

Get started

Starts at $9 /page

Login Register Reset

How our paper writing service works

It's very simple!

  • Fill out the order form

    Complete the order form by providing as much information as possible, and then click the submit button.

  • Choose writer

    Select your preferred writer for the project, or let us assign the best writer for you.

  • Add funds

    Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.

  • Ready

    Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.

Place order now