Question

In: Economics

The city is considering 2 separate cell tower providers. The city expects a benefit-cost ratio of...

The city is considering 2 separate cell tower providers. The city expects a benefit-cost ratio of 1.0 or better, and their cost of capital is 10% per year. Assume repeatability

Verizon AT&T
Initial investment $90,000 $170,000
Useful life in years 6 12
Market value at end of useful life $25,000 $40,500
Annual benefits from operation $30,000 $40,000
Annual operating expenses $9,800 $11,300

a) Conduct benefit-cost ratio on the Verizon and AT&T projects and indicate which project is the preferred project (Show Work)

b) Conduct an incremental difference to validate the decision.

Solutions

Expert Solution

A) Please see the tables below. First table shows the analysis for Verizon proposal and the second one for the AT&T proposal. We should select AT&T since it has a higher B/C Ratio of 1.23

Verizon Net CF / 1.1^Time
T Investment Revenue Cost Salvage Value Net CF PV @ 10%
0 -90000.00 -90000.00 -90000.00
1 30000.00 -9800.00 20200.00 18363.64
2 30000.00 -9800.00 20200.00 16694.21
3 30000.00 -9800.00 20200.00 15176.56
4 30000.00 -9800.00 20200.00 13796.87
5 30000.00 -9800.00 20200.00 12542.61
6 -90000.00 30000.00 -9800.00 25000.00 -44800.00 -25288.43
7 30000.00 -9800.00 20200.00 10365.79
8 30000.00 -9800.00 20200.00 9423.45
9 30000.00 -9800.00 20200.00 8566.77
10 30000.00 -9800.00 20200.00 7787.97
11 30000.00 -9800.00 20200.00 7079.98
12 30000.00 -9800.00 25000.00 45200.00 14402.11
B/C Ratio 1.21
(Sum of PV of Net CF T1toT15 / -Investment)
AT&T Net CF / 1.1^Time
T Investment Revenue Cost Salvage Value Net CF PV @ 10%
0 -170000.00 -170000.00 -170000.00
1 40000.00 -11300.00 28700.00 26090.91
2 40000.00 -11300.00 28700.00 23719.01
3 40000.00 -11300.00 28700.00 21562.73
4 40000.00 -11300.00 28700.00 19602.49
5 40000.00 -11300.00 28700.00 17820.44
6 40000.00 -11300.00 28700.00 16200.40
7 40000.00 -11300.00 28700.00 14727.64
8 40000.00 -11300.00 28700.00 13388.76
9 40000.00 -11300.00 28700.00 12171.60
10 40000.00 -11300.00 28700.00 11065.09
11 40000.00 -11300.00 28700.00 10059.17
12 40000.00 -11300.00 40500.00 69200.00 22049.25
B/C Ratio 1.23
(Sum of PV of Net CF T1toT15 / -Investment)

B) When we do incremental analysis (by taking the difference between AT&T and Verizon, AT&T being the more expensive investment project), we get a B/C Ratio of 1.24 which validates our decision in part A. Pls see calculations below.

Incremental (AT&T - Verizon) Net CF / 1.1^Time
T Investment Revenue Cost Salvage Value Net CF PV @ 10%
0 -80000.00 0.00 0.00 0.00 -80000.00 -80000.00
1 0.00 10000.00 -1500.00 0.00 8500.00 7727.27
2 0.00 10000.00 -1500.00 0.00 8500.00 7024.79
3 0.00 10000.00 -1500.00 0.00 8500.00 6386.18
4 0.00 10000.00 -1500.00 0.00 8500.00 5805.61
5 0.00 10000.00 -1500.00 0.00 8500.00 5277.83
6 90000.00 10000.00 -1500.00 -25000.00 73500.00 41488.83
7 0.00 10000.00 -1500.00

Related Solutions

(10 pts) The city of New York is considering two separate cell tower providers. The city...
(10 pts) The city of New York is considering two separate cell tower providers. The city expects a benefit-cost ratio of 1.0 or better, and their cost of capital is 10% per year. Assume repeatability. Verizon AT&T Initial investment (first cost) $90,000 $170,000 Useful life in years 6 12 Market value at end of useful life $25,000 $40,500 Annual benefits from operation $30,000 $40,000 Annual operating expenses $9,800 $11,300 a. Conduct benefit-cost ratio on the Verizon and AT&T projects and...
Considering discount rate of 14%, calculate NPV, Benefit Cost Ratio, and Present Value Ratio for the...
Considering discount rate of 14%, calculate NPV, Benefit Cost Ratio, and Present Value Ratio for the following investment and explain if it is a good investment. C=10,000 C=8,000 C=6,000 I=7,500 I=7,500 ... I=7,500 L=10,000 0 1 2 3 4 ... 10 C: Cost, I:Income, L: Salvage value
Benefit-Cost Analysis Given Parameters: Scenario One Benefit-Cost Ratio: 1.11 Scenario Two Benefit-Cost Ratio: 0.52 Did your...
Benefit-Cost Analysis Given Parameters: Scenario One Benefit-Cost Ratio: 1.11 Scenario Two Benefit-Cost Ratio: 0.52 Did your benefit-cost analysis reach the same or different conclusions in the two scenarios analyzed? If different conclusions, why? Assume that the proposal in fact “passed” the analysis with a benefit-cost ratio greater than 1. Does this imply that the proposed project is the optimal or best use for the $8.55 million to be invested in resource conservation? Explain. In conducting benefit-cost analyses, do you think...
Tower Corp. has a debt-equity ratio of .85. The company is considering a new plant that...
Tower Corp. has a debt-equity ratio of .85. The company is considering a new plant that will cost $145 million to build. When the company issues new equity, it incurs a flotation cost of 8%. The flotation cost on new debt is 3.5%. A) What is the initial cost of the plant if the company raises all equity externally? B) What if it typically uses 60% retained earnings? C) What if all equity investments are financed through retained earnings? Solve...
There are two ways for finding the benefit to cost ratio (B/C Ratio) B/C Ratio =...
There are two ways for finding the benefit to cost ratio (B/C Ratio) B/C Ratio = [ Annual Benefits-Annual Disbenefits] / [Annual Cost of Implementing Project] B/C Ratio = [NPV of Benefits-NPV of Disbenefits] / [NPV of Implementing Project] If the B/C Ratio is greater than one, we can infer that the project is worth undertaking. Note that there can only be one B/C ratio for a project (unlike IRR which can at times have multiple values) Problem: The City...
between net present value rule used in cost benefit analysis and benefit-ratio used in cost-effectiveness analysis....
between net present value rule used in cost benefit analysis and benefit-ratio used in cost-effectiveness analysis. Why do most economists choose net present value rule? fix :“benefit ratio ” is “benefit-cost ratio”
A friend or yours is considering two cell phone service providers. Provider A charges $100 per...
A friend of yours is considering two cell phone service providers. Provider A charges $100 per month for the service regardless of the number of phone calls made. Provider B does not have a fixed service ree but instead charges $1 per minute for calls. Your friend's monthly demand for minutes or calling is given by the equation p-120-30P, where P is the price of a minute.  With Provider A, the cost of an extra minute is 5 _______ .with...
Calculate Payback period, Net Present Value and Benefit Cost Ratio Period 0 1 2 3 4...
Calculate Payback period, Net Present Value and Benefit Cost Ratio Period 0 1 2 3 4 5 Year 2,019 2020 2021 2022 2023 2024 Cash Flows -30,000 11,000 x .8929 = 9821.9 14,000 x .7972 = 11,160.8 10,000 x .7118= 7,118 7,000 x .6335 = 4434.5 12,000 x .5674 = 6808.8
1. What is the traditional benefit cost ratio applying an interest rate of 5.0% that requires...
1. What is the traditional benefit cost ratio applying an interest rate of 5.0% that requires an upfront investment of 120,000 of the public project below? 1 2 3 4 5 6 7 8 Benefits 35,000 51,000 51,000 51,000 51,000 51,000 46,000 41,000 Revenues 4,000 6,000 6,000 6,000 6,000 6,000 6,000 3,000 Operating Cost 13,000 16,000 16,000 16,000 16,000 17,000 19,000 18,000 2. What is the net benefit cost ratio of the project above
A Company is considering investing in a new dock that will cost $350,000. The company expects...
A Company is considering investing in a new dock that will cost $350,000. The company expects to use the dock for 5 years, after which it will be sold for $90,000. LakeFront anticipates annual net cash inflows of $85,000 resulting from the new dock. Instructions Calculate the net present value of the dock assuming the company's cost of capital is 10%. Calculate the net present value of the dock assuming the company's cost of capital is 15%.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT