{"id":20302,"date":"2023-05-19T16:54:44","date_gmt":"2023-05-19T16:54:44","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/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\/"},"modified":"2023-05-19T16:54:44","modified_gmt":"2023-05-19T16:54:44","slug":"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","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/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\/","title":{"rendered":"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***"},"content":{"rendered":"

Purpose<\/font><\/h3>\n

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.<\/p>\n

<\/p>\n

Overview<\/font><\/h3>\n

Throughout this course you will work with the Mergent Online database and perform elements of securities analysis involving a select group of companies.<\/p>\n

Directions<\/font><\/p>\n

1. Alter the Excel spreadsheets (SPEADSHEETS ARE ATTACHED) as directed above so that the data is ordered historically oldest to most recent.<\/span><\/p>\n

((<\/span> <\/span>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.))<\/span><\/p>\n

2. <\/span>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:<\/span><\/p>\n

    \n
  • Current Ratio<\/li>\n
  • LT Debt to Equity<\/li>\n
  • Total Asset Turnover<\/li>\n
  • ROA % (Net)<\/li>\n
  • ROE % (Net)<\/li>\n
  • <\/li>\n<\/ul>\n
    3. <\/span>Write a 3-4 page paper (approximately 600 words) in APA format<\/strong> <\/span>that includes:<\/span><\/div>\n

    <\/span><\/div>\n
    A.) <\/span>An
    \nintroduction that identifies the two companies that are the subject of your
    \nanalysis.<\/span><\/div>\n

    <\/span><\/div>\n
    B.) <\/span>Your
    \nExcel graphs inserted into the body of your paper. There should be a total of
    \nfour graphs discussed in your narrative. For each graphed ratio, respond to the
    \nfollowing:<\/span><\/div>\n
    <\/div>\n
    –<\/span>What
    \nis the difference between the two companies on this ratio? What is a plausible
    \nexplanation as to why they would differ? Is one company clearly different than
    \nthe other?<\/span><\/div>\n

    <\/span><\/div>\n
    –<\/span>Are
    \nthere economic or end-market influences that explain why the ratios differ?
    \nWhat might they be?<\/span><\/div>\n

    <\/span><\/div>\n
    –<\/span>Over
    \ntime, is each company\u2019s overall financial performance improving, declining, or
    \nis something strange going on?<\/span><\/div>\n

    <\/span><\/div>\n
    –<\/span>Do you
    \nthink evaluating financial statements is a good idea? What do you regard as
    \nsome of the shortcomings of financial ratio analysis?<\/span><\/div>\n

    <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[676],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/20302"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=20302"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/20302\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=20302"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=20302"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=20302"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=20302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}