Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your supervisor has developed the given set of questions for you to answer: Please select two stocks and determine their free cash flow from 2017

Your supervisor has developed the given set of questions for you to answer:

  1. Please select two stocks and determine their free cash flow from 2017 and 2018. (you can find the free cash flows in Yahoo Finance). What inference can you draw from the companies free cash flow? Please present your findings in a table.
  2. Using the information and formulas from your textbook, please prepare two financial ratios for each stock, using the 2017 and 2018 financial statements, to include: liquidity ratios, asset management ratios, and profitability ratios. You should have a total of six ratios for each stock, per year (two ratios for each category per year). What challenges, strengths, or weaknesses do you see for each company? Please present your findings in a table.
  3. Using the following information, please calculate free cash flow in Excel for years 2015 and 2016: Income Statements and Balance Sheet

Income Statements 2014 2015 2016
Sales $3,432,000 $5,834,400 $7,035,600
Cost of goods sold except depr. 2,864,000 4,980,000 5,800,000
Depreciation and amortization 18,900 116,960 120,000
Other expenses 340,000 720,000 612,960
Total operating costs $3,222,900 $5,816,960 $6,532,960
EBIT $209,100 $17,440 $502,640
Interest expense 62,500 176,000 80,000
EBT $146,600 ($158,560) $422,640
Taxes (40%) 58,640 -63,424 169,056
Net income $87,960 ($95,136) $253,584
Other Data 2012 2013 2014
Stock price $8.50 $6.00 $12.17
Shares outstanding 100,000 100,000 250,000
EPS $0.88 ($0.95) $1.10
DPS $0.22 0.11 0.22
Tax rate 40% 40% 40%
Book value per share $6.64 $5.58 $7.91
Lease payments $40,000 $40,000 $40,000

Balance Sheets 2014 2015 2016
Cash $9,000 $7,282 $14,000
Short-term investments 48,600 20,000 71,632
Accounts receivable 351,200 632,160 878,000
Inventories 715,200 1,287,360 1,716,480
Total current assets $1,124,000 $1,946,802 $2,680,112
Gross fixed assets 491,000 1,202,950 1,220,000
Less: Accumulated depreciation 146,200 263,160 383,160
Net fixed assets $344,800 $939,790 $836,840
Total assets $1,468,800 $2,886,592 $3,516,952
Liabilities and Equity
Accounts payable $145,600 $324,000 $359,800
Notes payable $8.50 $6.00 $12.17
Shares outstanding 200,000 720,000 300,000
Accruals 136,000 284,960 380,000
Total current liabilities $481,600 $1,328,960 $1,039,800
Long-term debt 323,432 1,000,000 500,000
Common stock (100,000 shares) 460,000 460,000 1,680,936
Retained earnings 203,768 97,632 296,216
Total equity $663,768 $557,632 $1,977,152
Total liabilities and equity $1,468,800 $2,886,592 $3,516,952

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applications In Energy Finance

Authors: Christos Floros, Ioannis Chatziantoniou

1st Edition

3030929566, 978-3030929565

More Books

Students also viewed these Finance questions

Question

8.1 What is digital marketing?

Answered: 1 week ago

Question

Evaluate the impact of unions on nurses and physicians.

Answered: 1 week ago

Question

Describe the impact of strikes on patient care.

Answered: 1 week ago

Question

Evaluate long-term care insurance.

Answered: 1 week ago