Please help solve this and, What are the excel formulas to solve this case study?
MERCURY ATHLETIC FOOTWEAR
4
Men's Athletic 6 Revenue ess: Operating Expenses 8 Operating Income 9 10 Men's Casual 11 Revenue 12 ess: Operating Expenses 13 Operating Income 14 15 Women's Athletic 16 Revenue 7 ess Operating Expenses 18 Operating Income 19 20 Women's Casual: 21 Revenue 22 ess Operating Expenses 23 Operating Income 24 25 Consolidated Revenue 26 ess Operating Expenses 7 ess: Corporate Overhead
2006 219,093 187,672 31,421
2007 251,957
2008 282,192
2009 310,411
2010 335,244
2011 352,006
51,663 43,421 8,242
52,180
53,223
54,288
55,916
57,594
123,563 110,860 12,703
138,391
153,614 167,439 179,159
188,117
36,802 37,645 (843)
36,802
431,121 379,598 9,224
>
FCF Calculation
Valuation
2006 Balance Sheet
Ready
LO
Accessibility Good to go
64F Windy
Search