Problem: A large auto company has just completed the research and development (R&D) on a new product, the Electrobicycle

Problem:

A large auto company has just completed the research and development (R&D) on a new product, the Electrobicycle. The Electrobicycle is an electronic, climate-controlled bicycle with zero emissions. The R&D efforts focused on developing the capability to utilize electricity to power bicycles. Ultimately, the auto company expects Electrobicycles to be popular for most urban citizens due to convenience and low cost.

The R&D, which cost $3 million, is complete and paid for. The plant and equipment to mass produce the Electrobicycles will cost $2 million. This plant and equipment will be depreciated over 5 years using the straight-line method to zero book value ($400,000 per year). A working capital investment of $1 million will be needed at the beginning of the project. A working capital investment of $200,000 per year will be needed thereafter.

At the end of 5 years, the auto company believes there will be no more sales opportunities for Electrobicycles and will cease all production. Thus, at the end of the project, all working capital investments (the $1 million initial investment and the $200,000 per year) will be recovered at full value. The plant and equipment will be scrapped for a salvage value of $300,000 (after tax).

The company expects moderate sales in years 1 and 2, and then significant growth in each year thereafter as consumers adopt the Electrobicycles. Revenues and earnings will cease at the end of Year 5. The revenues, after-tax earnings, and cash flow for the 5-year life of the project are shown in this table.

Table 1

Projected Electrobicycle Financial Projection

Numbers in $000’s

TodayYear 1Year 2Year 3Year 4Year 5Revenues$1,000$1,500$3,000$6,000$12,000After-tax earnings($500)$100$300$600$1,200Project Cash FlowAfter-tax earnings($500)$100$300$600$1,200Plus: Depreciation$400$400$400$400$400Less: Cost of plant, equipment($2,000)$0$0$0$0$0Less: Working capital($1,000)($200)($200)($200)($200)($200)Plus: Recovery of working capitaln/an/an/an/a$2,000Plus: Salvage valuen/an/an/an/a$600Annual project cash flow($300)$300$500$800$4,000

Note: n/a = not applicable

Calculate:

• Determine the NPV for the Electrobicycle project. Use the annual project cash flow from the table above. For the required rate of return, use the percent value from your birthday date 11%. For example, if your birthday falls on the 16th of the month, the required rate of return would be 16%.
  • For guidance, review Section 7.1 of the textbook, NPV Example: The Pizza Scooter Delivery Project Revisited.

Write:

In your post, include the following:

• Calculate the NPV of the Electrobicycle project. Be sure to show your NPV calculations.
• Explain, in your own words, why working capital investments are subtracted each year in the cash flows.
• Explain, in your own words, the meaning of the required rate of return for the project.
• Assume the auto company has a required rate of return of 15%. Based on the required rate of return you used for the Electrobicycles (based on your birthday date 11= my birthday), is the Electrobicycle project more or less risky than the auto company? Explain your answer.
• Based on your concluded NPV, should the company invest in this project to build Electrobicycles? Justify your answer.

my answer (can you please correct if wrong)

Week 4 Discussion

   YEAR 1 YEAR 2 YEAR 3  YEAR 4 YEAR 5   ANNUAL COST FLOW 300,000 300,000 500,000 800,000 4,000,000   PV FACTOR= (1+R)-N 0.9009 0.8116 0.7312 .6587 .5935   PRESENT VALUE 270,270 243,480 365,600 526,960 2,374,000    

R= RATE OF RETURN (MY BIRTHDAY)

N= PERIOD/YEAR

Cost of Investment = Cost of plant and equipment  2,000,000 + Working Capital 1,000,000 = 3,000,000

NPV= PV of cash flow- cost of investment

NPV= 3,780,310- 3,000,000=780,310