Homework Answers
Step 1. Arrange the different bandwidths in the increasing order of investments
Step 2. Select the bandwidth 44 as the base alternative and find the difference between bandwidth 55 and 44
Step 3. If the IRR of the difference is higher than the MARR of 25 percent, then the drop the base alternative 44 and select bandwidth 55 as the base
Step 4. Find the IRR of the difference of cashflow of alternative 88 and 55. As the IRR of the difference is lesser than the MARR of 25 percent, select the base alternative 44 and drop the bandwidth 88
|
n |
Bandwidth,44 |
Bandwidth,55 |
Bandwidth,88 |
Cashflow diff, 55-44 |
Cashflow diff, 88-55 |
|
0 |
-40000 |
-46000 |
-61000 |
-6000 |
-15000 |
|
1 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
2 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
3 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
4 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
5 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
6 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
7 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
8 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
9 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
10 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
11 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
12 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
13 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
14 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
15 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
16 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
17 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
18 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
19 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
20 |
2000 |
4000 |
7500 |
2000 |
3500 |
|
IRR |
33% |
23% |
Add Answer to:
Use Excel
For example.. I want it looks like that
6.38 A WiMAX wireless network integrated...
Use excel For example.. I want it looks like that. A car is purchased with a...
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
Use Excel For example.. I want it looks like that Two years ago, you bought 100...
Use Excel
For example.. I want it looks like that
Two years ago, you bought 100 shares of XYZ stock at $60 per share. The stock paid a dividend of $6 per share per quarter. If you sell the shares now for $98 per share, what is your annual ROR on this investment? cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 1500 1500 1500 1500 5500 0 1 2 ($535.27)($1,159.39) pv ($150,535.27) ($201,159.39) npv pv
Use Excel For example.. I want it looks like that. An engineer wanted to celebrate graduating...
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
Use Excel For example.. I want it looks like that 7.21 From the following data, calculate...
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Use Excel For example.. I want it looks like that 6.37 A small manufacturing company expects...
Use Excel
For example.. I want it looks like that
6.37 A small manufacturing company expects to expand its operation by adding new product lines. Any or all of four new lines can be added. If the company uses a MARR of 15% per year and a 5-year project period, which products, if any, should the company manufacture? Monetary terms are in $1000. Product 3 Initial cost, $ Annual cost, S/year Annual savings, S/year 40-500 64 180 190 570-620 70...
Use Excel For example.. I want it looks like that 53 Faro laser trackers are portable...
Use Excel
For example.. I want it looks like that
53 Faro laser trackers are portable contact measure- ment systems that use laser technology to measure large parts and machinery to accuracies of 0.0002 inches across a wide range of industrial applica- tions. A customer that manufactures and installs cell phone relay dishes and satellite receiving sta- tions reported the cash flows (in $1000 units) for one of its product lines. (a) Determine the number of possible rate of return...
Use Excel For example.. I want it looks like that At the end of 1987, you...
Use Excel
For example.. I want it looks like that
At the end of 1987, you bought a piece of land for $35,000. In addition to the $35,000, you paid $1,700 in closing costs (costs associated with the purchase and title registration). For the years 1988 through 2002, you paid, on average, $950 in property taxes at the end of each year. At the end of 2003, you sold the land for $120,000. A sale time, you paid a 6%...
Use excel
For example.. I want it looks like that.
A car is purchased with a 48 month and 9%/year compounding monthly rate with an initial balance of $15000. What is the balance due half way through the 4 years? 01 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 -1500 1500 1500 1500 5500 0 2 4 ($535.27) ($1,159.39) pv ($150,535.27) ($201,159.39)
Use Excel
For example.. I want it looks like that
Two years ago, you bought 100 shares of XYZ stock at $60 per share. The stock paid a dividend of $6 per share per quarter. If you sell the shares now for $98 per share, what is your annual ROR on this investment? cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 1500 1500 1500 1500 5500 0 1 2 ($535.27)($1,159.39) pv ($150,535.27) ($201,159.39) npv pv
Use
Excel
For example.. I want it looks like that.
An engineer wanted to celebrate graduating and getting a job by buying a new furniture $2400 Luckily the store was offering 6-month financing at an interest of 6%/year compounding monthly. Calculate the monthly payment. 01 cf 150000 -1000 -1000 -1000 -1000 4000 СТ 200000 1500 1500 1500 1500 5500 0 1 2 4 5 npv pv ($535.27) 1,159.39) ($150,535.27) ($201,159.39) I -
Use Excel
For example.. I want it looks like that
7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000...
Use Excel
For example.. I want it looks like that
6.37 A small manufacturing company expects to expand its operation by adding new product lines. Any or all of four new lines can be added. If the company uses a MARR of 15% per year and a 5-year project period, which products, if any, should the company manufacture? Monetary terms are in $1000. Product 3 Initial cost, $ Annual cost, S/year Annual savings, S/year 40-500 64 180 190 570-620 70...
Use Excel
For example.. I want it looks like that
53 Faro laser trackers are portable contact measure- ment systems that use laser technology to measure large parts and machinery to accuracies of 0.0002 inches across a wide range of industrial applica- tions. A customer that manufactures and installs cell phone relay dishes and satellite receiving sta- tions reported the cash flows (in $1000 units) for one of its product lines. (a) Determine the number of possible rate of return...
Use Excel
For example.. I want it looks like that
At the end of 1987, you bought a piece of land for $35,000. In addition to the $35,000, you paid $1,700 in closing costs (costs associated with the purchase and title registration). For the years 1988 through 2002, you paid, on average, $950 in property taxes at the end of each year. At the end of 2003, you sold the land for $120,000. A sale time, you paid a 6%...
Most questions answered within 3 hours.
-
Required information
[The following information applies to the questions
displayed below.]
In 2019, Alliant Corporation acquired...
asked 1 minute ago -
How much must I invest today if I want to withdraw 1/3 of my
original investment...
asked 2 hours ago -
What is meant by a “term premium”?
What can explain such a premium? Is it a...
asked 3 hours ago -
23. Which molecule has only covalent bonds? A. CO2 B. Al2O3 C.
Mg3N2
24. The octet...
asked 4 hours ago -
the
total pressure for a mixture of N2O4 and NO2 is 2.20 atm. If Kp=
7.10...
asked 4 hours ago -
Delaware Corp. prepared a master budget that included $22,385
for direct materials, $28,600 for direct labor,...
asked 4 hours ago -
For pesticide HCB (hexachlorobenzene), its logarithmic partition
coefficient log Kow is 5.6. What would be the...
asked 4 hours ago -
A chemist requires 0.422 mil Na2CO3 for a reaction. How many
grams does this correspond to?
asked 4 hours ago -
If the vapor pressure of carvone is approximately 9.4 torr at 99
°C, approximately how much...
asked 4 hours ago -
A juice bottling company is carrying out a test at 10%
significance that the mean population...
asked 4 hours ago -
What is the reflectivity (in percent) needed to keep water at a
temperature near its freezing...
asked 4 hours ago -
Suppose that the average surface temperature of Earth is 300K.
Assume this is uniform over its...
asked 4 hours ago