DEADLINE FOR COMPLETION: September 15 2013 @ NOONThis assignment requires solid

DEADLINE FOR COMPLETION: September 15 2013 @ NOONThis assignment requires solid knowledge of DCF and EVA spreadsheets (valuations) as well as the ability to create a DAROE model from the data.Company: HeinzAssignments (2 spreadsheets): DCF and EVA spreadsheet: Complete the spreasheet by providing the inputs in the highlighted areas. In addition to that calculate the value of the firm per share (value / shares outstanding) and then complete a DAROE model. Add the DAROE model as a third tab. This assigment also ties into forecasting as you have to put in growth rates (look at the growth from last year and use that rate going forward).Buffett spreadsheet: Go to tab 4 (Buffett Valuation) and replace Nikes data with the data for Heinz. Make sure to enter the data in the correct order. Year 1 is last year year 8 is eight years ago.Thanks in advance for your consideration of this assignment!