Question on the right screen, excel file for reference on the left

~ ~ G H 40 . aneSoIny Spreadsheet_10_1 (1).xisx - Excel Search Craft, Coy Ray (Analytics and Decision Support) Cc X Connect Get Hom > C ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flearn.liberty.edu%252Fwebapps%252Fportal%252Fframeset jsp%253Ftab_tab_group_id%253D_2_19%252Gurl625309 webapps%25252FBb-Mc.. * * File Home Insert Page Layout Formulas Data Review View Help Share Comments Apps APPDEV BANPPRD BANTEST BANPRD BANNER TABLEAU ADP TIMESAVER @ ARGOS CONFLUENCE FONT AWESOME UDEPLOY LU ServiceNow 11 ~ A" A " General Insert Chapter 10 Homework Saved Help Save & Exit Submit LO Calibri x Delete ~ Paste Sort & Find & deas Sensitivity Check my work $ ~ % 9 00 20 Conditional Format as Cell Formatting " Table Styles Format ~ Filter Select Clipboard Font Alignment Number Style Cells Editing Ideas Sensitivity 3 Blooper's analysts have come up with the following revised estimates for its magnoosium mine: $29 X V fx Pessimistic Optimistic O P 2 AA AB AC AD AE AF AH points Initial investment A. Inputs Variable costs renal investment Is that Salvage value ($ thousands) working capital 15,000 BOO masonary costs [$ thousands) Inflation rate (2) 50% Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying Discount rate Prime data as a starting point for the analysis. (Do not round intermediate calculations. Negative amounts should be indicated by a minus Receivables (% of sales) 16.7% sign. Enter your answers in thousands rounded to the nearest whole dollar.) Inventory (%% of next year's costs) Tax rate (2) Project NPV car 0 Pessimistic Expected Optimistic B. Fixed assets Sales of fixed anded assets 10,000 Initial investment 40 Cash flow from fixed assets 10 000 580 Revenues Variable cost C. Operating cash flow Fixed costs Variable expenses Fixed expenses 6,090 Working capital Pretax profit Profit after tax Operating cash flow 2370 D. Working capital Working capital Cash flow from investment in working capita 1500 E. Project valuation Discount factor Net present value Sheet1 + Display Settings -- - + 50% 9:34 AM Type here to search 9 Tex w 9/17/2020 24 pame