A Wrap Text General Normal 2 Normal 3 & Cut Calibri 11 Da Copy BIU- -A== 3. Format Painter Clipboard Font Merge & Center $ - % Bad Conditional Format as Normal Formatting Table Alignment Number E F G H 1 M Given the information to the left fill in the cells in yellow The perform a Scenario analysis on NPVwith the three possible scerarios listed below. Three Possible Scenarios A B D Problem 6 15 Points Pizza Deliveries, Replacement Analysis Utilize the Scenario Function Old Truck Drones Difference Price 40,000 100.000 Shipping and Install 0 6,000 Original Life 10 5 Current Life 5 5 Original Salvage Value 0 15.000 Current Salvage Value 22.000 0 Book Value 20.000 100.000 Increase in Raw Materials 0 3.000 Depreciation 4.000 18.200 -14.200 Salaries 35.000 35.000 Maintenance 6.000 6,000 0 Defects 4.000 3.000 1.000 Marginal Tax Rate 34.00 Required Retur 15.00 Cash Flows Period Cash Flows Initial Outlay 87.680 0 -87.680 Annual After Tax Saving 23.760 1 28.588 Depreciation Tax Benefit 4.828 2 28.588 Total ATCH 28.588 3 28.588 Terminal Cal Flow 15.000 4 28.588 5 46.588 Net Prevent Vilo (NPV 17.100.59 Best Case Expected Worst Case Maintenan 2000 SO Defects 1000 2000 S000 1000 A Wrap Text General Normal 2 Normal 3 & Cut Calibri 11 Da Copy BIU- -A== 3. Format Painter Clipboard Font Merge & Center $ - % Bad Conditional Format as Normal Formatting Table Alignment Number E F G H 1 M Given the information to the left fill in the cells in yellow The perform a Scenario analysis on NPVwith the three possible scerarios listed below. Three Possible Scenarios A B D Problem 6 15 Points Pizza Deliveries, Replacement Analysis Utilize the Scenario Function Old Truck Drones Difference Price 40,000 100.000 Shipping and Install 0 6,000 Original Life 10 5 Current Life 5 5 Original Salvage Value 0 15.000 Current Salvage Value 22.000 0 Book Value 20.000 100.000 Increase in Raw Materials 0 3.000 Depreciation 4.000 18.200 -14.200 Salaries 35.000 35.000 Maintenance 6.000 6,000 0 Defects 4.000 3.000 1.000 Marginal Tax Rate 34.00 Required Retur 15.00 Cash Flows Period Cash Flows Initial Outlay 87.680 0 -87.680 Annual After Tax Saving 23.760 1 28.588 Depreciation Tax Benefit 4.828 2 28.588 Total ATCH 28.588 3 28.588 Terminal Cal Flow 15.000 4 28.588 5 46.588 Net Prevent Vilo (NPV 17.100.59 Best Case Expected Worst Case Maintenan 2000 SO Defects 1000 2000 S000 1000