Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I am in need of help with this homework assignment. I have attached the actual assignment with bullet points and instructions to complete. Thanks.
Hi, I am in need of help with this homework assignment. I have attached the actual assignment with bullet points and instructions to complete. Thanks.
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: Joe's Fly-by-Night Oil INCOME STATEMENT, 2015 BALANCE SHEET, as of Dec 31, 2015 Sales Cost of goods sold Gross profit S, G & A expenses EBIT Interest Before-tax earnings Taxes Net income ASSETS Cash Accounts receivable Inventory Current assets Equipment (gross) Less Accum Depreciation Equipment (net) Total assets LIABILITIES AND EQUITY Accounts payable Current liabilities Long-term debt Total liabilities Common stock (1,000 shares) Retained earnings Total equity Total liabilities & Equity $10,000 4,000 $6,000 3,000 $3,000 $200 $2,800 1,000 $1,800 EPS Dividends Addition to retained earnings $1.80 $600 $1,200 $5,000 3,000 17,000 $25,000 27,000 (12,000) $15,000 $40,000 $17,000 $17,000 $3,000 $20,000 $7,000 $13,000 $20,000 $40,000 Prepare a ratio analysis for the fiscal year ended Dec 31, 2015. 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, 2015...$50.00 Number of common shares outstanding on Dec 31, 2015...1,000 Case Study Tasks: 1. Refer to the Case Study topic lecture on the Week 3 Content page. Using the information you obtained last week, complete the Part 2, Financial Overview portion of the case study report. Note that your Financial Overview should contain: a. A Sales and Income Record, to include sales and net income figures for 2011-2015 and a graph displaying the trends. b. Comments on the Sales and Income Record. c. A list of the company's major expenses for FY 2015 and a pie chart showing the Expense Distribution. d. Comments on the expense distribution. e. A list of the company's major assets for FY 2015 and a pie chart showing the Assets Distribution. f. Comments on the assets distribution. g. A list of the company's major capital accounts for FY 2015 and a pie chart showing the Capital StructureStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started