Using theProject Two Financial Formulasspreadsheet and the balance sheet, income statement, and cash flow statement fromMergent Onlinefor your chosen company, calculate the financial ratios for the...

1 answer below »

Using theProject Two Financial Formulasspreadsheet and the balance sheet, income statement, and cash flow statement fromMergent Onlinefor your chosen company, calculate the financial ratiosfor the most recent fiscal quarter.Then, compare those ratios with the same ratios for the same fiscal quarter from one year prior in Mergent Online, and analyze your results.


Specifically, you must address the following rubric criteria:




  • Financial Calculations:Calculate accurate financial ratios to assess the business’s current financial health. Specifically, calculate the following ratios:

    • Working capital

    • Current ratio

    • Debt ratio

    • Earnings per share

    • Price/earnings ratio

    • Total asset turnover ratio

    • Financial leverage

    • Net profit margin

    • Return on assets

    • Return on equity






  • Fiscal Quarter Comparison:Using Mergent Online, summarize the differences between the results from your financial calculations of themost recent fiscal quarterand the results of the same financial calculations of the same fiscal quarter froma year beforefor your chosen business.

    • For example, if the most recent fiscal quarter available is the 3rd quarter in 2020, then you will compare those results to the same financial calculations from the 3rd quarter in 2019.






  • Comparison Analysis:Explain what the results of your calculations and your comparison indicate about the business’s current financial health, providing examples to support your explanation. You might consider the following questions:

    • Do the results indicate the business is financially healthy or financially unhealthy? Which results indicate this?

    • What might be the cause(s) of the business’s financial success or failure?

    • Is more information needed to determine the business’s financial health? If so, which pieces of information might still be needed?






  • Short-Term Financing:Explain how potential short-term financing sources could help the business raise needed funds to improve its financial health. Base your response on the business’s current financial information.






Key Financials


(In USD as of 07/03/2021)












































































Income Statement
Revenue63,591m
Net Income1,126m
EPS from Continuing Operations0.62
EPS - Net Income - Diluted0.61
Revenue per Share34.98
Balance Sheet
Total Assets202,221m
Total Liabilities115,480m
Shareholders' Equity86,741m
Total Assets per Share113.54
Net Assets per Share48.70
Cash Flows
Cash from Operations4,601m
Cash from Investing-2,615m
Cash from Financing-9,210m
Capital Expenditures3,197m
Cash Flow per Share2.51
Answered Same DayOct 03, 2021

Answer To: Using theProject Two Financial Formulasspreadsheet and the balance sheet, income statement, and cash...

Himanshu answered on Oct 04 2021
121 Votes
Key Matrices
    Most Recent Quarter
    Last Year
    Working Capital
    1.32
    0.90
    Debt Ratio
    0.29

    0.24
    EPS
    0.62
    -1.88
    P/E Ratio
    284.48
    -93.41
    Total Asset Turnover
    0.32
    0.36
    Financial Leverage
    2.41
    2.18
    Net Profit Margin
    0.02
    -0.04
    ROA
    0.006
    -0.015
    ROE
    0.18
    0.17
Working Capital
The gap among a firm's current assets and current liabilities on its balance sheet is known as net working capital. It is a measurement of a corporation 's cash and capacity to fulfil short-term commitments and support business activities.
Debt Ratio
The debt ratio is a measurement of a firm's indebtedness in regards of total debt to total assets.
Earnings Per share
Earnings per share refers to the financial worth of a company's earnings per outstanding share of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here