Question: I create the table below by using b-c ratio analysis I need to do sensitivity analysis for this table by using again excel can u
I create the table below by using b-c ratio analysis
I need to do sensitivity analysis for this table by using again excel
can u help pls? Sensitivity analysis by changing which variable is not important. Any of them could be.
A B C D 1 2 3 4 Benefits Additional business and commerce Estimated future economic activity Reduction in accidents Sum of benefits PV of benefits 5 $ $ $ $ $ 5,000,000.00 1,250,000.00 500,000.00 6,750,000.00 103,764,044.43 LO 7 8 9 10 11 Disbenefits Destruction of vegetable gardens Reduction in business on present road is 500,000.00 250,000.00 12 $ 13 14 Costs 15 Initial Cost $ $ $ 16 17 18 19 Maintenance Cost Variable Cost PV of costs 39,000,000.00 256,000.00 1,006,000.00 54,464,685.73 $ $ 20 21 B/C Ratio 1.905161905)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
