determine EBIT calculation in Cell C35 with information provided. show in excel formula

A B C D E F G H J K Information Provided W N Factory Cost $500 million 4 Initial Capacity S 2,000 million Life of the Project 8 years 6 Sales Of Electric Cars in Year 1 1% of Company's 2016 revenue Reduction in existing car sales 5 million per year Electric Car Sales Growth 0.0728 Year 1 2 3 4 5 6 7 8 10 Projected Sales for Electric Cars 1518 1628 1747 1874 2011 2157 2314 2482 11 Investment to expand capacity made in yr 12 Capital Invesment as a percentage of sales 0.3557 13 Capital Expansion Required (Dollar Amount) S 383 million 14 Variable cost as a percentage of revenue 79.7115 15 Fixed Cost in Year 1 24 In the following years, this number will increase at the same rate as sales increase. 16 Depreciation Straight Line to 0 Over 5 years 17 Market Value in Year 8 10% of total capital investments made 18 Bond Issued 200 million 19 Bond Coupon Rate 6% 20 Bond Interest 12 million 21 22 Investment in NWC as a % of upcoming sales 23 Tax Rate 0.35 24 WACC 0.12 25 26 27 Intermediary Calculations 28 29 Pro-Forma Statement 30 Year 1 2 3 4 5 6 7 8 31 Sales 1518 1628 1747 1874 2011 2157 2314 2482 32 Variable Cost 1210 1298 1393 1494 1603 1719 1844 1979 33 Fixed Costs 24 26 28 30 32 35 37 40 34 Depreciation 177 177 177 177 177 0 0 0 35 EBIT 36 Interest