Week 4 Assignment - Joe’s Fly-By-Night Oil Company

Question # 00012212 Posted By: vikas Updated on: 04/13/2014 02:39 PM Due on: 05/12/2014
Subject Finance Topic Finance Tutorials:
Question
Dot Image
For Week 4, please complete the following for Joe’s Fly-By-Night Oil Company, whose financial statements are shown below:
Homework Assignment for Week 4:

For Week 4, please complete the following for Joe’s Fly-By-Night Oil Company, whose financial statements are shown below:
• Prepare a ratio analysis for the fiscal year ended Dec 31, 2012. Organize your analysis per the following outline:

(1) Liquidity
- Current ratio
- Quick ratio
Comments on liquidity

(2) Asset management
- Total Asset turnover
- Average collection period (ACP)
Comments on asset management

(3) Debt management
- Debt ratio
- Times interest earned
Comments on debt management

(4) Profitability
- Net profit margin
- Return on Assets (ROA)
- Return on Equity (ROE)
- Extended Du Pont equation
Comments on profitability to include your comments on the sources of ROE
revealed by the Du Pont equation

(5) Market value ratios
- PE ratio
- Market to book ratio
Comments on the market value ratios

For the purposes of this exercise, assume the following data for Joe’s Fly-By-Night Oil:

Stock price on Dec 31, 2012…$50.00
Number of common shares outstanding on Dec 31, 2012...1,000

Dot Image
Tutorials for this Question
  1. Tutorial # 00011772 Posted By: vikas Posted on: 04/13/2014 02:40 PM
    Puchased By: 3
    Tutorial Preview
    its assets with Total Asset ...
    Attachments
    Week_4_Assignment_-_Joe’s_Fly-By-Night_Oil_Company_Solution.xlsx (13.12 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    ad...ec00 Rating Provide re-checking service for customer satisfaction 07/28/2015

Great! We have found the solution of this question!

Whatsapp Lisa