There will be a attached apple case
Apple assignment #1
Complete the balance sheet of Apple, Inc. for years 2012-2016. That includes completing the retained earnings and the flexible financing account for each year.
Compute FCF for all years 2007-2016 and show your calculation clearly on the spreadsheet. (Note: You will have to use a different method to compute FCF in 2007-2011 and in 2012-2016.)
Show the disposition of FCF for all years.
Compute FCFE for years 2007 through 2011.
Show the disposition of FCFE for years 2007 through 2011.
Submit your worksheet as an email attachment. I will need an electronic copy so that I can see the formulas in the individual cells.
Appropriate penalty for poorly organized or poorly presented results.