asg. fin. 1

1. Pick a public company and get their annual SEC filings for the last 5 years (Fiscal year 2018 being the latest year)

2. Using the information in these filings, produce the following financial analysis for each year (using excel):

a. WACC

b. Capital structure

c. Payout (dividends or share repurchases)

3. Plot the time series graph for each

4. Write up your evaluation of:

a. How these financial measures/ratios change over time

b. To what extent they are consistent with firms' business strategy

c. Your recommendation on how the company should revise their policies. 

Your write should not exceed 3 pages (not including the figures/tables)