Reference no: EM131012260

1. Determine the rate of return of the following investment using calculator.  

Year	$
0	-5000
1	1000
2	2000
3	3000
4	4000

2. A consulting company plans to purchase a new computer network for $125,000 to save $35,000/year over its projected  9 year life from doing all their CAD activities in house.  At the end of its life, the salvage value of this system is estimated to be $12,500.  What is the rate of return of this investment (I want the actual rate) and is it a good idea if the MARR = 8%/year?

3.  An individual has $50,000 to invest.  The government treasury bills (T-bills) pay 3.5% interest per year.   She considers investing in the stock parket instead, by buying a stock that now sells for $35 each and pays an anuual dividend of $7/per stock.  She thinks that after 7 years the stock will be selling for $55 each.  What is the rate of return of the stock investment and is it a better deal than the T-bills?

4. Compare the following two alternatives by the IRR method, given MARR of 6%/year. 

Alt.	Construction cost $	Benefits $/yr	Salvage $	Service Life (yrs)
A	110,000	45,000	10,000	7
B	275,000	55,000	25,000	7

5. Compare the following two alternatives by the IRR method, given MARR of 8%/year. 

Alt.	Construction cost $	Benefits $/yr	Salvage $	Service Life (yrs)
A	510,000	145,000	10,000	7
B	775,000	155,000	20,000	9

6. Compare the following 3 alternatives of the same service life (5 years) using the DROR (Differential Rate of Return) method with a MARR = 10%/year.   Verify your hand calculations using the Excel's built in function.

Year	A	B	C
0	-250,000	-400,000	-1,000,000
1	300,000	350,000	650,000
2	450,000	475,000	500,000
3	350,000	425,000	450,000
4	300,000	350,000	400,000
5	200,000	250,000	300,000