determine calculation for Variable Cost, starting in Cell C32 using excel formula

A B C D E F G H J K Information Provided w 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 Co Electric Car Sales Growth 0.0728 9 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 883 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