Based on the sample income statement and facts provided, the life of this project will be 8 years. Sales in the first year for the new model are estimated to be 1% of the 2016 revenue. Sales growth is expected to be the average sales growth in the past 20 years plus 7%. Calculate excel formula for cell B8

A B C D E F G H Information Provided Factory Cost $500 million Initial Capacity S 2,000 million Life of the Project 8 years Sales Of Electric Cars in Year 1 1% of Company's 2016 revenue Reduction in existing car sales 5 million per year 8 Electric Car Sales Growth 9 Year 1 2 3 4 5 6 7 10 Projected Sales for Electric Cars