Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0...

Project Wind Power

	Year 0	Year 1	Year 2	Year 3
Costs	$6,000,000	$4,000,000	$0	$0
Benefits	$18,000,000	$15,000,000	$12,000,000	$12,000,000

Project Hydroelectric power

	Year 0	Year 1	Year 2	Year 3
Costs	$4,000,000	$2,000,000	$1,000,000	$0
Benefits	$10,000,000	$14,000,000	$15,000,000	$16,000,000

If the interest rate is 3%, which project would you choose and why? Show your work using excel (15 points)

If the interest rate is 15%, which project would you choose and why? Show your work using excel (15 points)

Solutions

Expert Solution

ANSWER:

in excel we calcualte net present worth by using the npv function.

=npv(interest rate,cash flow from year 1 to year 3) + cash flow in year 0

1) I = 3%

*Project wind power*
*year*	0	1	2	3
*costs*	*-60,00,000*	*-40,00,000*	0	0
*benefits*	*1,80,00,000*	*1,50,00,000*	*1,20,00,000*	*1,20,00,000*
*cash flows*	*1,20,00,000*	*1,10,00,000*	*1,20,00,000*	*1,20,00,000*
*npv*	*4,49,72,462*

*Project hydroelectric power*
*year*	0	1	2	3
*costs*	*-40,00,000*	*-20,00,000*	*-10,00,000*	0
*benefits*	*1,00,00,000*	*1,40,00,000*	*1,50,00,000*	*1,60,00,000*
*cash flows*	*60,00,000*	*1,20,00,000*	*1,40,00,000*	*1,60,00,000*
*npv*	*4,54,89,095*

if the interest rate is 3% i would chose project hydro electric power.

2) i = 15% :

*Project wind power*
*year*	0	1	2	3
*costs*	*-60,00,000*	*-40,00,000*	0	0
*benefits*	*1,80,00,000*	*1,50,00,000*	*1,20,00,000*	*1,20,00,000*
*cash flows*	*1,20,00,000*	*1,10,00,000*	*1,20,00,000*	*1,20,00,000*
*npv*	*3,85,29,136*

*Project hydroelectric power*
*year*	0	1	2	3
*costs*	*-40,00,000*	*-20,00,000*	*-10,00,000*	0
*benefits*	*1,00,00,000*	*1,40,00,000*	*1,50,00,000*	*1,60,00,000*
*cash flows*	*60,00,000*	*1,20,00,000*	*1,40,00,000*	*1,60,00,000*
*npv*	*3,75,41,054*

if the interest rate is 15% i would chose project hydro wind power.

Rahul Sunny answered 1 year ago

Next > < Previous

Related Solutions

Project 1 Project 2 project 3 Project 4 Initial CF -4,000,000 -5,000,000 -10,000,000 5,000,000 Year 1...

Project 1 Project 2 project 3 Project 4 Initial CF -4,000,000 -5,000,000 -10,000,000 5,000,000 Year 1 CF 1,000,000 2,000,000 4,000,000 2,700,000 Year 2 CF 2,000,000 3,000,000 6,000,000 2,700,000 Year 3 CF 3,000,000 3,000,000 5,000,000 2,700,000 You have a $10 million capital budget and must make the decision about which investments your firm should accept for the coming year. The firm’s cost of capital is 12 percent. Use the information on the four projects to determine what project(s) your firm should...

Project 1 Project 2 Project 3 Project 4 Initial CF -4,000,000 -5,000,000 -10,000,000 5,000,000 Year 1...

Project 1 Project 2 Project 3 Project 4 Initial CF -4,000,000 -5,000,000 -10,000,000 5,000,000 Year 1 CF 1,000,000 2,000,000 4,000,000 2,700,000 Year 2 CF 2,000,000 3,000,000 6,000,000 2,700,000 Year 3 CF 3,000,000 3,000,000 5,000,000 2,700,000 You have a $10 million capital budget and must make the decision about which investments your firm should accept for the coming year. The firm’s cost of capital is 12 percent. Use the information on the four projects to determine what project(s) your firm should...

Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$ 49 $ 25...

Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two projects? b. If your discount rate is 4.8%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?

3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3...

3. AICC is considering the following two projects: (2 pts) Project Year 0 1 2 3 A Cash flows -$50 $15 $25 $25 B Cash flows -$50 $20 $25 $30 a. If these projects are mutually exclusive, which project should the company invest in based on the NPV and IRR if the WACC = 10%? b. Calculate MIRR, payback period, and discounted payback period for the project you chose to invest in from part A only.

Year 0 1 2 3 4 Project 1 −$152 $19 $42 $58 $82 Project 2 &nb

Year 0 1 2 3 4 Project 1 −$152 $19 $42 $58 $82 Project 2 −827 0 0 6,992 −6,490 Project 3 20 38 62 82 −246 a. For which of these projects is the IRR rule reliable? The IRR rule is reliable for (project 2 /project 3 /project 1) Unless all of the (positive/negative) cash flows of the project precede the (positive/negative) ones, the IRR rule may give the wrong answer and should not be used. Furthermore, there may...

1. A project has the following cash flow. Year Costs Benefits 0 $10,000 0 1 0...

1. A project has the following cash flow. Year Costs Benefits 0 $10,000 0 1 0 $5,000 2 $1,000 $5,000 3 0 $3,000 Assuming a discount rate of 10%, estimate the following: a) Net Present Value (NPV) b) Discounted Benefit-Cost Ratio c) Net discounted Benefit-Cost Ratio d) Is the project feasible? Explain your answer

Consider the following project: Year 0 1 2 3 4 Project A -20.00 8.00 7.00 6.00...

Consider the following project: Year 0 1 2 3 4 Project A -20.00 8.00 7.00 6.00 7.00 Find the payback for this project. (ROUND TO TWO DECIMAL PLACES)

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...

TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...

Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash...

Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash flow -$12,300 $4000 $4000 $3000 $3000 $3000 14.21% 12.75% 13.11% 13.85%

A firm has projected the following financials for a possible project: YEAR 0 1 2 3...

A firm has projected the following financials for a possible project: YEAR 0 1 2 3 4 5 Sales 123,422.00 123,422.00 123,422.00 123,422.00 123,422.00 Cost of Goods 69,079.00 69,079.00 69,079.00 69,079.00 69,079.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 22,072.20 22,072.20 22,072.20 22,072.20 22,072.20 Investment in NWC 1,152.00 540.00 540.00 540.00 540.00 540.00 Investment in Gross PPE 110,361.00 The firm has a capital structure of 48.00% debt and 52.00% equity. The cost of debt is 9.00%, while the cost of...

Subjects