What is the IRR of a project with the following characteristics? Initial investment is $2,000,000 Initial...

What is the IRR of a project with the following characteristics? Initial investment is $2,000,000 Initial investment is depreciated to $0 book value via straight-line over its 12 year life Project is expected to generate incremental sales of 1,900,000 per year, and incremental expenses of 1,400,000 per year There are no NWC or salvage cash flows The firm faces a 28% tax rate

Expert Solution

Particulars	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Incremental Sales	-	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000	1,900,000
Less: Incremental Expenses	-	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000	1,400,000
Less: Depreciation	-	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000
Earnings before Tax	-	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000	300,000
Less: Taxes at 28%	-	84,000	84,000	84,000	84,000	84,000	84,000	84,000	84,000	84,000	84,000
Net Income	-	216,000	216,000	216,000	216,000	216,000	216,000	216,000	216,000	216,000	216,000
Add back depreciation	-	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000	200,000
Annual Operating Cash Flow	-	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000
Initial investement	-$2,000,000.00	-	-	-	-	-	-	-	-	-	-
Net Cash flow	-$2,000,000.00	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000	416,000
IRR	16.14%

Excel formulas:

jeff jeffy answered 1 year ago

What is the NPV for a project with the following characteristics? Initial investment is $1,700,000 Initial...

What is the NPV for a project with the following characteristics? Initial investment is $1,700,000 Initial investment is depreciated to $0 over its 10 year life Project generates incremental after-tax cash flows (OCF) of $325,000 per year over the projects life Project requires a net working capital (NWC) investment today of $40,000, which is recovered at the end of the project Assets purchased with the initial investment are expected to have a salvage value of $62,000 at the end of...

KK Enterprises is evaluating a project with the following characteristics: Fixed capital investment is $2,000,000. The...

KK Enterprises is evaluating a project with the following characteristics: Fixed capital investment is $2,000,000. The project has an expected six-year life. The initial investment in net working capital is $200,000. At the end of each year, net working capital must be increased so that the cumulative investment in net working capital is one-sixth of the next year’s projected sales. The fixed capital is depreciated 30 percent in year 1, 35 percent in year 2, 20 percent in year 3,...

3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to...

3. A project has the following characteristics: Initial investment is $1,700,000 Initial investment is depreciated to $0 over its 10 year life Project generates incremental after-tax cash flows (OCF) of $325,000 per year over the projects life Project requires a net working capital (NWC) investment today of $50,000, which is recovered at the end of the project Assets purchased with the initial investment are expected to have a salvage value of $74,000 at the end of the project The firm...

Question 4 Acme Publishing has the following (independent) investment opportunities: Project Initial investment IRR A $13...

Question 4 Acme Publishing has the following (independent) investment opportunities: Project Initial investment IRR A $13 000 16% B $17 000 14% C $10 000 10% The optimal capital structure calls for financing all projects with 60 per cent ordinary shares and 40 per cent debt. The following information applies to the future financial position of Acme Publishing: The most recent dividend (DO) was $0.35 The growth rate of earnings and dividends is 6 per cent The current price of...

Calculate the rate of return for an investment with the following characteristics. Initial cost $20,000 Project...

Calculate the rate of return for an investment with the following characteristics. Initial cost $20,000 Project life 10 years Annual receipts $6000 Annual disbursements $3000

Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows...

Calculate the IRR for the following project: a. An initial outflow of $15,220 followed by inflows of $5,000, $6,000, and $6,500 b. An initial outflow of $47,104 followed by inflows of $16,000, $17,000, and $18,000.

A company is considering two mutually exclusive projects. Initial investment for Project A (IRR=32%) is 15,000...

A company is considering two mutually exclusive projects. Initial investment for Project A (IRR=32%) is 15,000 and for B (IRR=28%) 18,000. For both projects, life time of the projects is 5 years, required rate of return for both the projects is 10%. The net cash flows before the tax and depreciation are as given in the table below. For both projects tax of 40% on cash inflows is to be charged. Year 1 2 3 4 5 Project A 7000...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%

Compute the IRR on the following cash flow streams: a. An initial investment of $22,482 followed...

Compute the IRR on the following cash flow streams: a. An initial investment of $22,482 followed by a single cash flow of $32,290 in year 6. (Round answer to 2 decimal places, e.g. 5.25%.) IRR % ____ b. An initial investment of $1,229,844 followed by a single cash flow of $1,864,300 in year 4. (Round answer to 2 decimal places, e.g. 5.25%.) IRR % _____ c. An initial investment of $1,749,912 followed by cash flows of $1,585,900 and $1,108,200 in...

GeoGrocers is considering the following independent, average-risk investment projects: Project Size of Project Project IRR Project...

GeoGrocers is considering the following independent, average-risk investment projects: Project Size of Project Project IRR Project A $1.0 million 12.0% Project B 1.2 million 11.5% Project C 1.2 million 11.0% Project D 1.2 million 10.5% Project E 1.0 million 10.0% The company has a target capital structure that consists of 50 percent debt and 50 percent equity. Its after-tax cost of debt is 8 percent, its cost of equity is estimated to be 13.5 percent, and its net income is...

Question