Question

In: Economics

Please use the following table, which represents the costs and benefits of a new bridge. 1st...

Please use the following table, which represents the costs and benefits of a new bridge.

1st year

2nd year

3rd year

4th year

Costs

100

200

0

0

Benefits

0

0

200

200

Now consider the following interest rates 0%, 10% and 50%. Calculate

A the net benefits with all interest rates

B the benefit-cost ratio with all interest rates     

Solutions

Expert Solution

1st year 2nd year 3rd year 4th year

Costs

100

200

0

0

Benefits

0

0

200

200

At i=0%, 10% and 50%

..

PV = FV/ (1+i)n

..

A. Net benefit with 0% interest rate

Total cost in 1st and 2nd year = 100+200= 300

Total benefits in the 3rd anf 4th year = 200+200= 400

NPV = 100

..

Net benefit with 10% interest rate

Total cost in 1st and 2nd year = 100+200 (1+0.1)2= 100+ 165.29 = 265.29

Total benefits in the 3rd anf 4th year = 200(1+0.1)3+200(1+0.1)4= 150.26 + 136.60 = 286.86

NPV = 286.86 - 265.29 = 21.57

..

Net benefit with 0% interest rate

Total cost in 1st and 2nd year = 100+200 (1+ 0.5)2= 100+88.88 = 188.89

Total benefits in the 3rd anf 4th year = 200(1+ 0.5)3+200(1+ 0.5)4= 59.25 + 39.51 = 98.76

NPV = 98.76 - 188.89 = -90.13

..

B. The benefit-cost ratio with all interest rates

Benefit-Cost ratio = Present value of benefit from the project/ Present value of cost of the project

at i = 0%

Present value of benefit from the project = 400

Present value of cost of the project = 300

B-C ratio = 400/300 = 1.33

..

at i =10%

Present value of benefit from the project = 286.86

Present value of cost of the project = 265.29

B-C ratio = 286.86/265.29 = 1.08

..

at i=50%

Present value of benefit from the project = 98.76

Present value of cost of the project = 188.89

B-C ratio = 98.76/188.89 = 0.52


Related Solutions

Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel...
Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel formulas) Discount rate 0.08 0 1 2 3 System A Costs Hardware 14000 3000 3000 3000 Software 12000 2000 2000 1000 Services 2500 2500 2500 2500 Benefits Increased productivity 15000 10000 5000 Lower Error rates 18000 5000 6000 System B Costs Hardware 15000 3000 3000 3000 Software 12000 4000 2000 5000 Services 7000 3000 3000 1000 Benefits Increased productivity 7000 10000 10000 Reduced Work...
Construct a table showing the first-year costs, annual costs, and the annual benefits for the following...
Construct a table showing the first-year costs, annual costs, and the annual benefits for the following investment proposal: Costs: Initial investment (software, hardware, implementation) $180,000, incurred in year zero. Software maintenance (starting in year two) $30,000 per year, increasing at a rate of 3% per year thereafter Benefits: Labor savings $140,000 per year, starting in year two Equipment savings $55,000, year one only. Increased clinic revenue, $50,000 per year, starting in year one. All yearly savings increase at the rate...
Use the following table solve the Benefit Cost Ratio , NPV benefits (Please show excel formulas...
Use the following table solve the Benefit Cost Ratio , NPV benefits (Please show excel formulas as well) Discount rate 0.08 0 1 2 3 System A Costs Hardware 14000 3000 3000 3000 Software 12000 2000 2000 1000 Services 2500 2500 2500 2500 Benefits Increased productivity 15000 10000 5000 Lower Error rates 18000 5000 6000 System B Costs Hardware 15000 3000 3000 3000 Software 12000 4000 2000 5000 Services 7000 3000 3000 1000 Benefits Increased productivity 7000 10000 10000 Reduced...
Use the data given in the table to answer the following questions. The data represents the...
Use the data given in the table to answer the following questions. The data represents the average number of miles that a salesperson travels in a day verses the number of sales made each month. Miles, x 24 32 75 41 76 107 32 46 112 Sales, y 76 58 190 112 141 235 24 147 188 (a) What is the value of the correlation coefficient for this set of data? Round to 3 decimal places. (b) What is the...
The following table shows the costs and benefits of 4 alternatives. What is the shortest pay...
The following table shows the costs and benefits of 4 alternatives. What is the shortest pay back period among all four alternatives if MARR =7%? Year A B C D 0 -$9,000 -$12,000 -$10,000 -$12,000 1 2,000 3,500 0 0 2 2,000 0 1,000 -2,000 3 2,000 3,000 2,000 0 4 2,000 3,500 3,000 18,000 5 1,000 0 4,000 0 6 3,000 3,000 5,000 0
You are wanting to invest. The following table represents the portfolio for shares. Use the Laspeyres...
You are wanting to invest. The following table represents the portfolio for shares. Use the Laspeyres and Paasche's price indices to determine how the shares fared. Conclude your calculations with a summary of how the shares faired, and whether or not you would consider investing in any of the company's. Share Base year 2018 p0 q0d p1 q1 A 120 210 180 125 B 150 220 175 212 C 180 250 205 220
You are wanting to invest. The following table represents the portfolio for shares. Use the Laspeyres...
You are wanting to invest. The following table represents the portfolio for shares. Use the Laspeyres and Paashe's price indices to determine how the shares fared. Conclude your claculations with a summary of how the shares faired, and whether or not you would consider investing in any of the company's. Share Base Year 2018 p0 q0 p1 q1 A 120 210 180 125 B 150 220 175 212 C 180 250 205 220
Create a table to identify some costs and benefits for microcredit
Create a table to identify some costs and benefits for microcredit
For questions 7a-7d, use the following functions, one of which represents supply, and the other represents...
For questions 7a-7d, use the following functions, one of which represents supply, and the other represents demand. (1) P = -100Q + 1000 (2) P = 50Q + 250 7a. Equation (1) represents supply/demand, and equation (2) represents supply/demand. 7b. What is the equilibrium quantity Q*? 7c. What is the equilibrium price P* 7d. Suppose that the price floor imposed at $700. This would create an excess supply/demand of 6,9,3,5,11
The following table shows the MB of polluting to firm A and firm B (which represents...
The following table shows the MB of polluting to firm A and firm B (which represents the MC of abatement of pollution to the firms) Emissions MB firm A MB firm B 20 0 0 19 4 2 18 8 4 17 12 6 16 16 8 15 20 10 14 24 12 13 28 14 12 32 16 11 36 18 10 40 20 9 44 22 8 48 24 7 52 26 6 56 28 5 60 30...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT