Determine the minimum and maximum internal rate of return for the following cash flow. Use Excel....

Determine the minimum and maximum internal rate of return for the following cash flow. Use Excel.

Year	Net Cash
0	-2500
1	1500
2	1000
3	-1500
4	900
5	500

Expert Solution

For the project with the following cash flows ,

Year	Net CF
0	-2500
1	1500
2	1000
3	-1500
4	900
5	500

The IRR is calculated as

=IRR($C$4:$C$9,F5)

Where the range is the range of Cashflows and the rate is the Guess rate for the multiple IRR

So we get the Minimum IRR = -2%

Year	Net CF
0	-2500
1	1500
2	1000
3	-1500
4	900
5	500

IRR	-2%

If we plot the data of NPV at various discount rate

And then plot them in IRR graph as

We find the maximum IRR approaches to infinity

.

Thanks

jeff jeffy answered 2 years ago

Forecasting Cash Flow and Burn Rate Create a Cash Flow Forecast on Excel using the following...

Forecasting Cash Flow and Burn Rate Create a Cash Flow Forecast on Excel using the following assumptions: Forecast duration: Years 0 through 5, then Exit Unit Sales: Sell 2000 units your first year and increase 30% per year Price: $100/unit first year and increase 5% per year COGS: Calculate based on a 75% Gross Profit Margin NOTE: to complete the Operating Expense section, break it into two lines: Payroll and Other Payroll: Start with 2 employees in year 0 paid...

What is the internal rate of return (IRR) of the previous project? Year Cash flow 0...

What is the internal rate of return (IRR) of the previous project? Year Cash flow 0 -$100,000 (it is minus!) 1 $20,000 2 $50,000 3 $30,000 4 $40,000 A. 13.98% B. 15.98% C. 12.98% D. 11.98% E. 14.98%

I. Determine the "internal rate of return" of the following investments. to. a. An initial payment...

I. Determine the "internal rate of return" of the following investments. to. a. An initial payment of $ 10,000 which will produce a cash flow (NCF) annual of $ 1,993 for the next ten years. b. An initial payment of $ 10,000 which will produce a cash flow (NCF) annual of $ 2,054 for the next twenty years. c. An initial payment of $ 10,000 which will produce a cash flow (NCF) annual of $ 1,193 for the next twelve...

What is the internal rate of return (IRR) on an investment with the following cash flows?...

What is the internal rate of return (IRR) on an investment with the following cash flows? Holding period 5 years. Round your answer to nearest 0.25%. Please show work (NO EXCEL) Year Net Income Purchase Price $4,000,000 1 $250,000 2 $300,000 3 $350,000 4 $400,000 5 $450,000 Resale $4,750,000 (net of costs)

\\ Compute the internal rate of return for the cash flows of the following two projects....

\\ Compute the internal rate of return for the cash flows of the following two projects. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Year Project A Project B 0 –$ 6,300 –$ 3,900 1 2,400 1,400 2 3,200 2,500 3 2,000 1,600

Determine the internal rate of return on the following project: An initial outlay of 9000 resulting...

Determine the internal rate of return on the following project: An initial outlay of 9000 resulting in a cash inflow of 1800 at the end of year 1, 4800 at the end of year 2, and 7800 at the end of year 3

Use the following cash flow with a 5% discount rate: Year Cash Flow 0 -$ 80,000...

Use the following cash flow with a 5% discount rate: Year Cash Flow 0 -$ 80,000 1 20,000 2 15,000 3 20,000 4 25,000 5 30,000 What is the NPV? $ 9,154 -$2,567 $14,003 $10,036

What is the internal rate of return (IRR) of this project given the following cash flows?...

What is the internal rate of return (IRR) of this project given the following cash flows? Year CF 0 -$9,800 1 $1,000 2 $4,500 3 $1,000 4 $1,500 5 $1,700 6 $2,700 Convert your answer to percentage and round off to two decimal points. Do not enter % in the answer box.

16) A project has the following cash flows. What is the internal rate of return? Year/Cash...

16) A project has the following cash flows. What is the internal rate of return? Year/Cash Flow 0/ -$89,300.00 1/ $82,900.00 2/ $4,200.00 3/ $5,800.00 A) 1.02 percent B) 6.77 percent C) 5.97 percent D) 1.11 percent E) 3.45 percent 17) A company wants to purchase a new machine costing $1.46 million. Management is estimating the machine will generate cash inflows of $223,000 the first year and $600,000 for the following four years. If management requires a minimum 12 percent...

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...

Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 10-year analysis period, double declining depreciation is used, 21% corporate tax rate, an initial cost of $200,000, an annual benefit of $60,000 and no salvage value but instead you must pay a disposal fee of $20,000 that your corporate accountant determined is 100% tax deductible.

Question