26. (ts) For the following set of cash flows, calculate the NPV, IRR, MIRR, Profitability Index and Payback Period. Assume the WACC is 8%. NPV: IRR: MIRR: Profitability Index Payback Period: Year Cash Flow 0 $ (580,000.00) 1 $ 120,000.00 2 $ 132,000.00 3 $ 139,920.00 4 $ 151,190.00 5 $ 145,150.00 6 $ 148,250.00 Is this project acceptable? Why or why not? I

1. Discounted Payback (DCPB) and IRR analysis. Use the cash flow situation (table below) to answer. a. Determine the DCPB based on a MARR rate of 8.0% b. Determine the IRR Year Cash Flow (in $1000's) 0 1 -5500 +1500 2 +1800 3 +1500 4 +1800 5 6 +1500 +1800 7 +1500

Calculate the NPV of the following cash flows using a 10% discount rate? The first cashflow is negative, Year 0= -900, all others are positive Year 1= +100, Year 2= +100, Year 3= +400, Year 4= +500, Year 5= +500   a. $36 b. $ 520 c. $ 996 d. $ 326 e. $ 226

What's the FUTURE value of the following cash flows, at 6%/period: 0,200,400,600,800,1000 (Oh man! There's no FIG table...what to do?) Type your answer...

) Assuming a 9% cost of capital, find the modified internal rate of return for the following cash flows: a. 19.78% b. 6.95% c. 13.64% d. 7.86% Year Cash Flow 0 1 2 3 -$175 $167 $240 -$120

Problem 07.037 - MIRR calculation For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an investment rate of 20% per year and a borrowing rate of 10% per year. Year Net Cash Flow, $ The external rate of return is 1 4,000 2 -3,000 3 -7,000 4 12,000 5 -700

d. Determine the minimum annual net cash flow necessary to generate a positive net present value, assuming a desired rate of return of 12%. Round to the nearest dollar.Annual Net Cash Flow fill in the blank 1 of 1$

PV of Cash flows for the next 6 years as follows (1500,2000,2500,3000,3500,4000) at 8.8% discount rate.Formula?Excel Function?

Find the NPV for the following cash flows assuming a WACC of 10%.    YR CF 0 -15,000 1 6,000 2 4,000 3 2,000 4 3,000 5 2,000

Answer the question correctly. 7.