Choose a company to value. Create a spreadsheet with 5 yrs of historical inform, business and finance homework help

Choose a company to value.

Create a spreadsheet with 5 yrs of historical information and 5 years of projected information

Compute NI, FCF for all 10 years

Follow the example given

Place a Horizon value on the firm at the end of 5 years.

Discount the FCF of 5 year to the horzon.

Total valuation.

case_study_questions_032611__1_.docx

case_study_rubric_020613.xlsx

nike_example__1_.xlsx