a.
Year |
A |
B |
Incremental Cash flow |
0 |
-12000 |
-25000 |
-13000 |
1 |
4000 |
5100 |
1100 |
2 |
4000 |
5100 |
1100 |
3 |
4000 |
5100 |
1100 |
4 |
4000 |
5100 |
1100 |
5 |
4000 |
5100 |
1100 |
6 |
4000 |
5100 |
1100 |
7 |
4000 |
5100 |
1100 |
PW = (-13000/(1+0.1)^0)+(1100/(1+0.1)^1)+(1100/(1+0.1)^2)+(1100/(1+0.1)^3)+(1100/(1+0.1)^4)+(1100/(1+0.1)^5)+(1100/(1+0.1)^6)+(1100/(1+0.1)^7)= -$7645.74
b. ROR is the interest rate at which NPV becomes zero
=(-13000/(1+-0.1161)^0)+ (1100/(1+-0.1161)^1)+ (1100/(1+-0.1161)^2)+ (1100/(1+-0.1161)^3)+ + (1100/(1+-0.1161)^4)+ (1100/(1+-0.1161)^5)+ (1100/(1+-0.1161)^6)+ (1100/(1+-0.1161)^7)
4-2 a. Calculate the PW of alternatives A & B in the following table using an...
*Two mutually exclusive cost alternatives, Machine A and Machine B, are being evaluated Given the following time events and incremental cash flow. If the MARR IS 12% per year, which alternative Machine A or Machine B) should be selected on the basis of rate of return? Assume Machine B requires the extra $8,000 initial Investment (Hint: You can solve with IRR function in Excel) Incremental Year Cash Flow S(Machine B-A) - 8,000 500 1.500 6,000 The "Incremental ROR" is more...
I only need help with doing Part C manually
4-1 You are considering three mutually exclusive design alternatives. Do nothing is also an option. MARR is 15%. A B Category First cost, $ Annual Expense, $/yr Annual revenue, $/yr Salvage value, $ Useful life, yrs ROR 26,000 12,500 20,000 5,000 10 26.60% 52,000 12,000 25,000 9,000 10 22.13% 40,000 21,000 29,000 8,000 10 16.30% a. What is the present worth of each alternative? Which would you choose? b. Perform an...
Consider four alternatives, each of which has an 8-year useful life: A B C D Initial cost $100 $80 $60 $50 Annual benefit $12.20 $12.00 $9.70 $12.20 Salvage Value $75.00 $50.00 $50.00 $0 a) Construct a plot with interest rate on the x axis and PW on the y axis. Plot the PW vs interest rate for all 4 alternatives. Label graphs and make sure the fonts are readable. If your computer chooses very light colors,...
Compare the following 2 alternatives using the Net Present Worth (NPS) method – rate is 3% per year. Draw all cash flow diagrams. Please show work using a formula. Alt. Construction Cost ($) Benefit ($/yr.) Service Life (yrs.) A 380,000 200,000 7 B 450,000 220,000 7
4. Project Selection 20 points) Three mutually exclusive projects are being considered. The cash flows for each project are shown below. Use an MARR of 12% per year. Which of the three alternatives, if any, should be chosen? Why? State any assumptions required. 17.000 First cost, $ Annual revenue, $/yr Salvage value, $ Useful life, yr 12.000 6,000 4,000 26,200 8,200 4,500 4,500 5,200 3 6 4
Using the incremental B-C analysis, B-C ratio with PW and a MARR of 10%, choose the best alternative from the following three mutually exclusive alternatives given below. State your assumptions. Option B Option C Option A $30000 $50000 $70000 5 10 15 Initial investment Life in years Salvage value Annual benefits 0 0 $2000 $8000 $8000 $8000
Below are the CFs of 2 design alternatives being considered Design ADesign B $5000 initial cost$3500 Annual Cash $1255 flow useful life (years) Based on a MARR of 12%, the incremental IRR is closest to $1480 4 20% 26% 12% 24%
Civil Engineering Economics Question...
Exercises 79 alternatives have been proposed for improving the water supply for a city, but ted. Each option has a lifetime of 8 yr and the MARR set is Six different anly one option can be implemen % All figures are m millions of dollars which alternative should be selected? Caiphal cost Amnuial cost Annual benefit T U 10 5 1 2.5 14 1.4 3 2.3 5 2.5 27 4 17 (a) Solve by present worth...
4. Given two alternatives A and B; Assuming that alternatives are Data replaced at the end of their useful life, determine the better alnernative First Cost using annual cash now analysis at an interest rate of 12%. Annual Cost |$1,500 |5900 Annual Benefit $2 500 $2,800 12 Salvage Value $4,000 S2.000
4. Given two alternatives A and B; Assuming that alternatives are Data replaced at the end of their useful life, determine the better alnernative First Cost using annual cash...
3. Compare the two following two alternatives using an equivalent worth method and a MARR of 12%. The repeatability assumption is acceptable. Aternative I: Initial investment of $45,000, net revenue the first year of $8,000, increasing $4,000 per year for the six year useful life. Salvage value is estimated to be $6500. Alternative II: Initial investment of $60,000, uniform annual revenue of $12,000 for the five year useful life. Slavage value is estimated to be $9,000.