6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the...

6 You have the following cash flows: FIND the IRR, NPV (using 8 %), and the Profitability Index (Bang for your buck)

T0 = -1250 IRR = _______________%_

T1 = 350 NPV = __$______________

T2 = 450 PI = __$______________

T3 = 450

T4 = 550

Expert Solution

Answers:-

NPV = $221.37

Profitability Index = 1.18

IRR = 15.2%

IRR is the rate at which NPV is zero and it is calculated as below:-

jeff jeffy answered 1 year ago

Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%....

Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%. Y0 = ($1,500), Y1= $600, Y2 = $700, Y3 = $500. Determine which statement is true. a) NPV = 108.84; IRR = 9.99%; PI = 1.07 b) NPV = 108.84; IRR = 10.47%; PI = 1.07 c) NPV = 108.84; IRR = 9.99%; PI = 0.0726 d) NPV = 300; IRR = 9.99%; PI = 1.20 Please Explain

Find IRR for following cash flows:

4) Find IRR for following cash flows: 0_____1_____2_____3_____4 ($100) $10 $10 $10 $110 a) use spreadsheet, make sure that you know the procedure Show spreadsheet printout b) use intuition: if initial cashflow is changed to (90) the IRR will be Higher/lower because _________________________________ Hint: Consider the impact of a higher discount rate on the PV of a given set of cash flows.5) The Stated rate i=10% per year compounded semi-annually. TheEffective annual rate is __________% a) use built-in calculator/Excel...

NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of...

NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of these projects. When would you choose one over the other (i.e. what is the crossover rate)? Draw the NPV profile using 11 intervals of interest rates ranging from (and including) 0% to 100%. Place all data, ratios, calculations, findings, etc. in the first Excel sheet with references to the information in other sheets. Time A CF B CF 0 -10000 -10000 1 12000 9000...

Find IRR for following cash flows: 0_____1_

Find IRR for following cash flows: 0_____1_____2_____3_____4 ($100) $10 $10 $10 $110 a) use calculator, make sure that you know the procedure. p/yr=____, N=____, PMT=_____, FV=_____, PV=_____, IRR=____% per period. b) use spreadsheet, make sure that you know the procedure. Show spreadsheet printout by using Excel c) use intuition: if initial cash flow is changed to (90) the IRR will be higher because _________________________________ Hint: Consider the impact of a higher discount rate on the PV of a...

What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...

What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000 1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.

These are the cash flows for two projects. Calculate the NPV and IRR for both. Then...

These are the cash flows for two projects. Calculate the NPV and IRR for both. Then select the best project according to the NPV measure. Use a WACC of 10% for both projects. The investments are 7 for project 1, and 8 for project 2. Cash flows for project 1 year 1 2 3 4 cash 4 6 2 4 Cash flows for project 2 year 1 2 3 4 cash 3 2 7 4 Calculate the NPV for project...

You have computed the NPV of a project to be $30 million, using expected cash flows...

You have computed the NPV of a project to be $30 million, using expected cash flows and a risk-adjusted discount rate. You are, however, concerned that you may have made errors on estimating the cash flows and the discount rate. Which of the following make you feel more comfortable with taking the project, given this fear? Select one: a. The project NPV is very sensitive to changes in your discount rate b. In your best case scenario, the project has...

How to find IRR in excel using trial-error method? Cash flows for each year are following:...

How to find IRR in excel using trial-error method? Cash flows for each year are following: Y0 = -55 Y1 = -30.62 Y2 = 4.14 Y3 = 6.68 Y4 = 8.74 Y5 = 9.54 Y6: tricky part is after Y5, cash flow growth is 3% indefinitly rate of return = 11%

NPV versus IRR. Consider the following cash flows on two mutually exclusive projects for the Bahamas...

NPV versus IRR. Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation. Both projects require an annual return of 15 percent. Year Fishing Submarine 0 -835000 -1650000 1 450000 1050000 2 410000 675000 3 335000 520000 As a financial analyst for the company, you are asked the following questions. a) If your decision rule is to accept the project with the greater IRR, which project should you chose? b) Since you are fully aware...

NPV versus IRR Consider the following cash flows on two mutually exclusive projects for the Bahamas...

NPV versus IRR Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation. Both projects require an annual return of 15 percent. YEAR DEEPWATER FISHING NEW SUBMARINE RIDE 0 −$835,000 −$1,650,000 1 450,000 1,050,000 2 410,000 675,000 3 335,000 520,000 As a financial analyst for the company, you are asked the following questions. If your decision rule is to accept the project with the greater IRR, which project should you choose? Since you are fully...

Question