can you help me solve this

Tools Window Help Chapter 10 Homework $9040 174PM A http::/ewconnect.mheducation.com/flow/connect.html Chapter 10 Homework Help Seve & Ead: Submel 3 Check my work Blooper's analysts have come up with the following revised estimates for its magnooslum mine: Range points Initial Investment Pessimistle Optimistic Revenues Variable costs # 201 Fixed cont - 201 Working capital Prin Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 101 and accompanying data as a starting point for the analysis. (Do not round Intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers In thousands rounded to the nearest whole dollar.) Project NPV Pessimistic Expected Optimistic Initial Investment Revenues Variable costs Food costs Working capital ( Prev 3 of 1 Next > 1. Internal R This website technologies 2. NPV and based advertA. Inputs 10:000 Salvage vilon (f thoouch) 2000 butid merman ($ thousand) 15000 Initial Slived conts (f thouarchi) 4,000 Initial total expenses (f thoumarch) 10 000 LAition nar (4) 120% Receivables ($h of sakai) 16.74 barvestory ('S of next year's costs) 15.0% Tax nko (1) 3504 I. Fland most Investment in ford ansets 10.000 Sales of food mets 1300 Cash Bow from fixed acts -10 030 1300 C. Operating cash Bow 15.000 15.350 16535 17364 18 217 Variable expernes 6000 6300 6.615 6.945 7.393 Hoed expenses 4 000 4:200 4.410 Depreciation 2000 200 2000 2.00) 2000 Pretax profit 1000 3,250 3513 4 0TH 1.050 1.138 1209 1326 1,427 Profit after tax 1.950 2.112 2.462 Operating cail Bow 1.950 4.112 4321 4 40 D. Working capital Working capital 1500 4075 4279 4,717 Change in working capital 2575 214 -1.679 Cash flow from investment in working capital -1.$00 -2.575 -314 1 679 E. Project valuation Total project cash flow -11.500