Individual Assignment: Financial Ratio Analysis

Individual Assignment: Financial Ratio Analysis in $35 OnlyFinancial Ratio Analysis

The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions.

Content
Selected a Fortune 500 Company from one of the following industries:
Pharmaceutical
Energy
Retail
Automotive
Computer Hardware
Reviewed the balance sheet and income statement in the company’s 2015 Annual Report.

Debt, CR and REs After Paying Dividends Calculation

Debt, CR and REs After Paying Dividends Calculation in $6.50 only

PSU Manufacturing Inc. has the following financial statements data for 2012.

Income Statement
Sales                      $102,500
Cost of Goods           $50,000
SG & E Expenses       $35,000
EBIT                         $17,000
Interest Expenses        $2,500
Taxes                         $6,000
Net Income                 $9,000

Balance Sheet
Cash                              $40,000
Fixes Assets                   $55,000
Total Assets                   $95,000
Accounts Payable           $12,000
Long-term Debt              $25,000
Retained Earnings           $28,000
Paid-in Common Equity   $30,000

Comparison of Oracle and Microsoft (Ratio Analysis)

Oracle logo at the Oracle headquarters.

For Parts 1 and 2:

Create an Excel spreadsheet to show your computations for the six ratios listed under each part.

For Part 3:

Create an Excel spreadsheet to show your computations for the six ratios listed under this part and also to include (copy and paste) the ratio calculations from the first two parts. In this part, you will calculate the last six ratios as well as comment on all of the ratios calculated so far, including the first twelve ratios calculated under the first two parts. Your comments for each ratio should include more than just a definition of the ratio. You should focus on interpreting each ratio number for each company and support your comments with the numbers found in the ratios.

The summary and conclusion should discuss the liquidity, solvency and profitability of each company.

Part 1

Prepare a four-column worksheet in Excel, with the left-most column (column 1) to write the ratio names, the second column from the left (column 2) to show the calculation of each ratio for Oracle Corporation, the second column from the right (column 3) to show the calculation of each ratio for Microsoft Corporation, and the right-most column (column 4) to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios. Earnings per Share Current Ratio, Gross Profit Rate, Profit Margin Ratio, Inventory Turnover Ratio, and Days in Inventory (Average Age of Inventory).

Part 2

Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Oracle Corporation, column 3 to show the calculation of each ratio for Microsoft Corporation, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Calculate each of the following six ratios. Receivable Turnover Ratio, Average Collection Period, Assets Turnover Ratio, Return on Assets, Ratio Debt to Total Assets Ratio, and Times Interest Earned Ratio

Part 3

Prepare a four-column worksheet in Excel, column 1 to write the ratio names, column 2 to show the calculation of each ratio for Oracle Corporation, column 3 to show the calculation of each ratio for Microsoft Corporation, and column 4 to include your DETAILED comments about each ratio and what the ratio tells you about each company under study. Remember to copy and paste the ratio calculations and interpretations from the first two parts of the project in this worksheet, in addition to calculating the following six ratios. Payout ratio, Return on Common Stockholders’ Equity Ratio, Free Cash Flow Current, Cash Debt Coverage ratio, Cash Debt Coverage ratio, and Price/Earnings Ratio [For the purpose of this ratio, use the market price per share on June 1, 2007 for each company].

ANSWERS AVAILABLE. 

Price of Answer: Just US$ 24 only (Instant Download)

ANSWERS PREVIEW: 

Buy Now

Need Assistance !! email us at caresolvemyquestion.com 

If you need any other type of help regarding Homework, Assignments, Projects,  Case study, Essay writing then email us at question@solvemyquestion.com  We will get back to you very soon.

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc

Ratio Analysis and Comparison for Exxon Mobil Corporation and Royal Dutch Shell plc in $15 Only
1) Need to choose two firms within the same industryRatio Analysis and Comparison

 

2) Go to each firm’s Web site, and then access and download their annual reports (financial statements).

3) Using the accounting data from the firms’ financial statements, calculate all ratios for each firm (liquidity ratios, activity ratios, profitability ratios, leverage ratios, and coverage ratio)

Liquidity Ratios

Current Ratio = Current Assets/Current Liabilities

Quick Ratio = Current Assets – Inventory/Current Liabilities

Finance Questions

Finance Questions in $25 only

Prepare a paper on the ratio presentation on the compaFinance Questionny selected by each team for this course. The ratios are to include liquidity ratio, current ratio,quick acid test ratio, inventory turnover ratio, days sales outstanding , fixed assets turnover ratio, total assets turnover ratio, debt management ratios, total debt total assets, times interest earned ratio, book value per share, basic earning power ratio, return on total assets, profit margin on sales, EBITDA coverage ratio, return common equity, market value ratio, price, price/earning ratio, price/cash flow ratio, market/book ratio, du pont equation, ROA, ROE on the following companies:

  • Johnson & Johnson
  • Procter & Gamble
  • 3M Company
  • Cardinal Health, Inc.
  • Henry Schein, Inc.
  • UnitedHealth Group Inc
  • Pfizer Inc.
  • Aberforth Smaller Comp…
  • Equity Partnership Inv…
  • Ricmore Capital PLC
  • Equity Capital Managem…
  • Puma VCT Plc
  • Martin Currie Pacific …
  • IP Group Plc
  • Phaunos Timber Fund Ltd.
  • JPMorgan Smaller Cos I…
  • Starvest plc
  • General Capital Group plc
  • Or any other company using comparisons of industry averages.

Price of Answer: Just US$25 onlyBuy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

Loading...