Question

(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 indicate which project is the preferred project. b. Conduct an incremental difference to validate decision.

Answer 1

a. Pls see tables below. AT&T has a higher BC ratio and is better.

	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) The decision is validated when we do incremental analysis, as it yields a B/C ratio of 1.24. Pls see table 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	Rahul Sunny Next > < Previous Related Solutions 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... A new bridge is to be constructed over the East River in New York City. Two... A new bridge is to be constructed over the East River in New York City. Two structural possibilities exist: the support could be in the shape of a parabola or the support could be in the shape of a semi-ellipse. The space between the supports needs to be 1050 feet. The height at the center of the arch needs to be 350 feet. Determine the equation of a parabola with these characteristics. (Hint: Place the vertex of the parabola at... Walmart is considering opening a small experimental store in New York City. A store is expected... Walmart is considering opening a small experimental store in New York City. A store is expected to have a long economic life, but the valuation horizon is 15 years. The store in New York is likely to generate revenues of $36M in the first year and then it grows at 5.0%. But the costs of running the business are high because the margins on all the products sold are low. (It is a volume business!) The cost of goods sold... Walmart is considering opening a small experimental store in New York City. A store is expected... Walmart is considering opening a small experimental store in New York City. A store is expected to have a long economic life, but the valuation horizon is 19 years. The store in New York is likely to generate revenues of $30M in the first year and then it grows at 5.0%. But the costs of running the business are high because the margins on all the products sold are low. (It is a volume business!) The cost of goods sold... How is the New York City Budget determined? How is the New York City Budget determined? How is the New York City Budget determined? How is the New York City Budget determined? 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... New York City is the most expensive city in the United States for lodging. New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $204 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $55.what is the probability that a hotel room costs $225 or more per night?what is the probability that a hotel room costs less than $140 per night?What is the probability that a hotel room costs between $200 and $300 per... New York City is the most expensive city in the United States for lodging. New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $205 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $55. Use Table 1 in Appendix B. a. What is the probability that a hotel room costs $225 or more per night (to 4 decimals)? b. What is the probability that a hotel room costs less than $143 per night... Assume that the finishing times in a New York City 10-kilometer road race are normally distributed... Assume that the finishing times in a New York City 10-kilometer road race are normally distributed with a mean of 61 minutes and a standard deviation of 9 minutes. Let X be a randomly selected finishing time. a. What is the probability that a that a person running a 10-kilometer road race in New York City, will end up with finishing times average between 52 and 70 minutes for a road race? b. Find the value of the 95% percentile,... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Describe the electrical changes and movement of ions during the five main phases of membrane polarization... a. In your opinion, is "open source" innovation a good idea for technology transfer? b. Are... Assume that a simple random sample has been selected and test the given claim. Identify the... I would like to see a PowerShell script(for purely inspirational work to use as an inspiration... Briefly describe the rhetorical methods of development. Which of the rhetorical methods of development will be... C++ Question1. Create a class called Rantional for performing arithmatic with fractions. Then write a program... Balanced scorecards are widely used by companies to “balance” their financial with nonfinancial objectives. Do a... ADVERTISEMENT About @ 2020 WizEdu