Answer and calculate the part 1 2 3 data on the yahoo finance of Ford motor. Thi

Question

Answer and calculate the part 1 2 3 data on the yahoo finance of Ford motor. This is the link of it. https://finance.yahoo.com/quote/F?p=F. Use the information on the links to calculate and answers all the part 1 2 3 questions.

Final Project: Stock Analysis FINC 213 England Part i: The Corporation (pick a stock...each group member should have a different one to track) A. Organizational Structure a. List the names of the Board of Directors and their corresponding b. Who is the Chief Executive Officer (CEO)? i, is this individual also the Chairman of the Boar? Who is Chief Operating Officer (CO0)? c. d. Who is the Chief Financial Officer (CFO) B. History/Background When was the organization founded? a. b. When was the organization incorporated? C. Where was the organization incorporated? d. Where are the headquarters located? e. When did the company go public(the date of the IPO)? C. Basic Financial Data a. On which exchange is the company's stock traded? b. What is the company's ticker symbol? c. What is the current market price of the company's stock? (please include the date the market price was retrieved) Part II: Financial Analysis-Overall look A. Financial Statements (most recent yearend available) a. Balance Sheet i. What is the company'stotal assets? ii. What percentage is fixed assets? (Plant & Equipment ii. What percentage is current assets? iv. Growth in assets over the years shown (at least 3-5)? v. Debt management 1. Total debt of the company? 2. 3. Statement of Cash Flows How much of the total debt is long-term debt? What are the main ways in which the organization finances assets? b. i. Factors that have affected the company's cash position in the last 2years C. Income Statement i. What is the company's most recent sales? ii. What is the company's most recent net income? ili. What is the growth rate in sales? (overthe last several years-3-5) iv. What is the growth rate in net income? (overthe last several years-3-5) d. Market Value Added i. Calculate the Market value added (using the current stock price versus the book value) Economic Value Added e. i. Calculate this using the most recent year's data as well as the year prior Free Cash Flow i. 2014 ii. 2015 ii. 2016 f.

Explanation / Answer

Part I:

A:

a) List of board of directors:

Name                          - Role in board

Mr. William Clay Ford Jr- Chairman

Mr. Jim Hackett            - President and CEO

Stepen G Butler            -Member, Board of Directors, Ford Motor Company

Antony F Early Jr         -Member, Board of Directors, Ford Motor Company

William W Helman IV     -Member, Board of Directors, Ford Motor Company

John C Lechleiter PHD   -Member, Board of Directors, Ford Motor Company

Kimberly A Casiano       -Member, Board of Directors, Ford Motor Company

Edsel B Ford II              -Member, Board of Directors, Ford Motor Company

William E Kennard        -Member, Board of Directors, Ford Motor Company

Ellen R Marram             -Member, Board of Directors, Ford Motor Company

b) CEO is Mr. Jim Hackett and ceo is not the chairperson of the board. Chair person is Mr. William Clay Ford Jr

c) COO is Mr. Joseph R. Hinrichs

d) CFO is Mr. Robert L. Shanks

B:

a) It is founded in june 16, 1903

b) Incorporated on july 23 1903

c) Incorporated at Wakerville (now Windsor)

d) Head quarters are located in Dearborn, Michigan, US

e) It went public on 1956

C:

a)Company's Stocks are traded on NYSE

b) Company's ticker Symbol is F

c) Current Market price is $12.58 (as on 1 December 2017)

Part II:

A:

a) i) Total assets: $237,951,000

ii) Percentage of Fixed asets : 60901000/237,951,000 = 25.6%

iii) Percentage of current Assets: 108461000/237,951,000 =45.6%

iv) Growth in Assets over years (in 3 years from 2014-2016) : (((237,951,000-208,615,000)/237,951,000)*100) = 14.06%

v) Debt management

1) Total Debt: $208,685,000

2) Percentage of Long term debt : 93,301,000/208,685,000 = 44.70%

3) Debt (both long term ( $93,301,000) and short term($ 49,669,000)) is the major source of financing after which it is equity ($29,170,000).

b) Statement of Cashflows:

i) factors that have effected the company's cash position are:

Cash flow from operating and financing activities is increased which lead to an overall increase in cash flows from 2014-2016.

c) Income Statement

i) most recent sales: $151,800,000

ii) most recent net income: $6,376,000

iii) growth rate in sales: 5.36% (((16,312,000-12,174,000)/16,312,000)*100) (in 3 years from 2014-2016)

iv) growth ratein net income:154.43% (((6,376,000-2,506,000)/6,376,000)*100) (in 3 years from 2014-2016)

d) Market Value added=Shares Outstanding x Current Share Price – Shareholder’s Equity

=(3.9 Billion * 12.58) - 29,170,000 = 49.03 billion

e) Economic value added

EVA = Net Operating Profit After Tax - (Capital Invested x WACC)

WACC = ((E / V) * Re) + [ ((D / V) * Rd) * (1 - T)]

T= 34.33%

E= 21.53 B

D=146.01B

V= E+D = 167.54B

Re=12.02%

Rd= 6.25%

WACC=((21.53 B/167.54B)*0.1202)+((146.01B/167.54B)*0.0625) = 0.0154+0.0544= 0.0698 = 6.98%

EVA = 6,376,000 - (29,170,000 x 0.0698 ) =$ 4,339,934

f) Free cash flow (FCF) = Operating cash flow – capital expenditures

i) 2014 : 14,507,00- 7,463,000= $7,044,000

ii) 2015: 16,170,000- 7,196,000= $8,974,000

iii) 2016: 19,792,000- 6,992,000= $12,800,000

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.