honda - three stage growth model

Project Description:

recalculate the intrinsic value of honda using the three-stage growth model of spread-sheet 13.1 (attached). treat each of the following scenarios independently:
a. roe in the constant-growth period will be 9%
b. honda's unlevered beta is .95
c. the market risk premium is 8.5%

solution using the attached excel file is needed. attach explanation on how you derived numbers to use in the excel file
solution needed within 36 hours of being hired