Question

In: Finance

Uber is considering a new project. You have the following information: • Estimate life of the...

Uber is considering a new project. You have the following information:

• Estimate life of the project is 3 years.

• Expect sales of $15,000,000 for the first year of the forecast with sales to grow by 25% and 10%, respectively, for years 2 & 3.

• Variable costs (COGS) are 60% of sales. Fixed costs (SG&A) are $2,000,000 per year.

• They require a machine that costs $11,000,000 and will be depreciated using MACRS under a 3-year convention (.3333/.4445/.1481/.0741) The tax rate is 21%.

• Interest expense is $1,000,000 per year.

• Initial net operating working capital is $1,500,000. Net operating working capital for years 1 and 2 is 10% of NEXT year sales. All net operating working capital will be returned at the end of year 3.

a. They decide to sell the machine at the end of year 3 for $2,500,000. Find the free cash flows for years 1, 2 and 3.

b. The cost of capital is 10%. Find the net present value, internal rate of return and modified internal rate of return. Should the project be accepted?

Please show work!

Expert Solution

Answer (a):

Answer (b):

Net present value = $2,144,976.21

Internal rate of return = 18.05%

Modified internal rate of return = 15.96%

Yes.

Project should be accepted.

Reason:

NPV is positive

IRR > Cost of Capital

MIRR > Cost of Capital

Working:

Above excel with 'show formula' is as follows:

jeff jeffy answered 2 years ago

You are considering a new project launch. The project will cost $1950000, have a four-year life...

You are considering a new project launch. The project will cost $1950000, have a four-year life and have no salvage value; depreciation is straight-line to zero. Sales are projected at 210 units per year; price per unit will be 17500, variable cost per unit will be 10,600, and fixed costs will be 560,000 per year. The required return on the project is 12 percent and the relevant tax rate is 21 percent. a. Based on your experience, you think the...

ABC is considering a new project. You have the following information: Time 0 1 2 3...

ABC is considering a new project. You have the following information: Time 0 1 2 3 4 Cash Flow -100 25 60 45 35 The cost of capital is 11%. Find the profit index and payback period for the project. Assume the maximum payback is 2 years. Do they accept the project? Explain.

You are considering an investment project. The project has a life of three years. Project Information:...

You are considering an investment project. The project has a life of three years. Project Information: Initial investment into a new machine, which would cost Rs.4,50,000. Machine is to be depreciated to zero over three years (straight line depreciation) with no salvage value at the end. Operating revenue is expected to be Rs. 6,00,000 per year. Operating costs for raw materials expected to be Rs.3,00,000 per year. Assume tax rate is 30% and the discount rate is 20%. a. Compute...

You are considering a new product launch. The project will cost $760,000, have a 4-year life,...

You are considering a new product launch. The project will cost $760,000, have a 4-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 450 units per year; price per unit will be $17,800, variable cost per unit will be $14,500, and fixed costs will be $740,000 per year. The required return on the project is 13 percent, and the relevant tax rate is 24 percent. a. The unit sales, variable cost, and fixed...

You are considering a new product launch. The project will cost $1,750,000, have a four-year life,...

You are considering a new product launch. The project will cost $1,750,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 220 units per year; price per unit will be $20,000, variable cost per unit will be $13,000, and fixed costs will be $500,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 34 percent. a. The unit sales, variable cost, and...

You are considering a new product launch. The project will cost $680,000, have a four-year life,...

You are considering a new product launch. The project will cost $680,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 100 units per year, price per unit will be $19,000, variable cost per unit will be $14,000, and fixed costs will be $150,000 per year. The required return on the project is 15%, and the relevant tax rate is 35%. Ignore the half-year rule for accounting for depreciation. a. Calculate...

You are considering a new product launch. The project will cost $1,950,000, have a 4-year life,...

You are considering a new product launch. The project will cost $1,950,000, have a 4-year life, and have no salvage value; depreciation is straight-line to 0. Sales are projected at 180 units per year; price per unit will be $24,000; variable cost per unit will be $15,000; and fixed costs will be $540,000 per year. The required return on the project is 10%, and the relevant tax rate is 34%. a. Based on your experience, you think the unit sales,...

You are considering a new product launch. The project will cost $2,300,000, have a four-year life,...

You are considering a new product launch. The project will cost $2,300,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 160 units per year; price per unit will be $30,000, variable cost per unit will be $18,500, and fixed costs will be $610,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 36 percent. a. The unit sales, variable cost, and fixed...

You are considering a new product launch. The project will cost $1,282,500, have a five-year life,...

You are considering a new product launch. The project will cost $1,282,500, have a five-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 410 units per year; price per unit will be $20,300, variable cost per unit will be $16,800, and fixed costs will be $339,000 per year. The required return on the project is 15 percent, and the relevant tax rate is 30 percent. Based on your experience, you think the unit...

You are considering a new product launch. The project will cost $1,500,000, have a four-year life,...

You are considering a new product launch. The project will cost $1,500,000, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 160 units per year; price per unit will be $18,000, variable cost per unit will be $10,500, and fixed costs will be $450,000 per year. The required return on the project is 10 percent, and the relevant tax rate is 30 percent. a. Based on your experience, you think...