based on sample data, what is the accumulated depreciation in Year 8, in Cell B43, using excel formula

B C F G H A D E Information Provided 3 Factory Cost $500 million 4 Initial Capacity 2,000 million 5 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 Electric Car Sales Growth 0.0728 4 5 6 7 8 2 3 Year 2157 2314 2482 10 Projected Sales for Electric Cars 1518 1628 1747 1874 2011 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 24 In the following years, this number will increase at the same rate as sales increase. 15 Fixed Cost in Year 1. 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 4 5 6 7 8 1 2 3 30 Year 2152 2309 2477 31 Sales 1513 1623 1742 1869 2006 1206 1294 1389 1490 1599 1715 1840 1975 32 Variable Cost 24 26 28 30 32 35 37 40 33 Fixed Costs 0 34 Depreciation 177 177 177 177 177 0 173 198 402 431 463 35 EBIT 106 127 149 1 1 1 1 36 Interest 148 172 197 401 431 462 37 Taxable Income 105 126 44 52 60 69 140 151 162 38 Taxes 37 112 128 261 280 300 68 82 96 39 Net Income 40 5 6 7 8 41 Year 0 1 2 3 4 766 538 578 713 821 381 42 Capital Investment 2500 620 665 43 Accumulated Depreciation in Year 8 44 Book Value of the factory in Year 8 45 Market Value of the factory in Year 8 46 Salvage Value Net Of Tax