One spreadsheet assignment involved estimating the cash flows for a capital budgeting project. The financial projections and inputs are listed below. What is the Excel formula needed to calculate the desired value for spreadsheet cell F9? INPUTS: OUTPUTS: (All dollar figures are in Sthousands) (AHLE Alls figures in thousands) Austin Inputs: Austin building cost ATotal Revenue Estimated Austin building salvage valun (5) Acost of Revenue Saving 2019E Year 1 $ 4.900 $ 2020 Yes $ 50,000 $ 12,000 2020 20215 Year 2 Year $ 4.900 $ 4.900 $ $ 2020 Year 4 0.5 4000 5 $ 4.00 - Austin Annual Inputs State of Texas tax-free subsidy 5 6,000 Austin savings in cost of labor & shipping costs $ 7,000 Lease payment (Austin land) $ 1.000 Cost to relocate equipment to Austin $ 15,000 Texas State property taxes $ 3.000 ARSD Expense Selling General & Admin Exp Alease Paymentsavings Deprec/Amort Tax Savings AProperty Taxes AstateOfTexasSubsidy AOC $ $ $ 5 $ $ 5 $ $ 4,900 $ 5,900 $ 7.700$ 6,000 $ 29.400$ 4,900 $ 7,5685 7,700 5 6,000 5 31,0685 4,900 3,1225 7,700 5,000 26,622 05 05 4000 $ 2012 5 5500 5 5000 5 285565 5,600 5.000 20,300 Sen Diese Annual Inputs: State of California property taxes Building and land lease payments $ 14,000 $ 8.000 Outlay: Relocation Cost $(15,000) Outlay: Buildings $ 150,000) Building Salvage Value (Austin) Tax on Salvage Value Gain (Austin $ 12.00 11.400 30 Company Inputs Marginal tax rate Cost of capital $ (65,000) 29,400 $ M.622 31,068 5 ANCE 23556 $ 41,700 NPV $ 41,964 Austin building depreciation (MACRS) Year 1 Year 2 0.3313 0.4445 Year 3 Year 4 0.1481 0.0741 Select one: O a. =(B16-B10)*(1 - B19) O b. =(B10)*(1 - 819) OC. (B16-B10)(1 - B19) O d. =(B16)*(1 - B19)