In: Economics
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.
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...
Use PWs to calculate the benefit/cost ratio of i=5% for a highway project. The first cost...Use PWs to calculate the benefit/cost ratio of i=5% for a
highway project. The first cost is $150,000 and the O&M costs
are $5000 per year. There is no salvage value after 20 years. Time
savings to users are worth $35,000 per year, and neighborhood
disruption is a disbenefit of $10,000 per year. Is this project
attractive?
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
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|