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.I create the table below by using b-c ratio analysis I need

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!