Question

Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.92 million. The product is expected to generate profits of $1.01 million per year for ten years. The company will have to provide product support expected to cost S93,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 6.4%? Should the firm undertake the project? Repeat the analysis for discount rates of 1.8% and 12.6%, respectively. b. What is the IRR of this investment opportunity? c. What does the IRR rule indicate about this investment?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

B58 xfIR(B46:B56) 44 Year | Cash flows PVIF@6.4% 45 Present value Ax B 0 $ (6,373,125) 1 $ 1,010,000 2 $ 1,010,000 3 1,010,000 4 $ 1,010,000 5$ 1,010,000 6 $ 1,010,000 7 $ 1,010,000 8$ 1,010,000 9 $ 1,010,000 56 10 1,010,000 1.000$ 0.940 $ 0.883 $ 0.830 $ 0.780 $ 0.733 $ 0.689| $ 0.648 $ 0.609 $ 0.572| $ 0.538 $ 6,373,125.00)-4920000-93000/6.4% 47 48 49 50 51 52 53 54 949,248.12 892,150.49 838,487.30 788,051.98 740,650.35 696,099.96 654,229.28 614,877.14 577,892.05 543,131.63 57 58 IRR 9.39% 60 Net present value $921,693.30 61 62 Yes, undertake project.

B58 xfIR(B46:B56) 44 Year | Cash flows | PVIF@1.8% 45 46 0$(10,086,667) 47 48 49 50 51 52 53 54 Present value A×B 1.000 $ 0.982| $ 0.965 $ 0.948 $ 0.931 $ 0.915 $ 0.898 $ 0.883| $ 0.867 $ 0.852 $ 0.837 $ 10,086,666.67)--4920000-93000/1.8% 1 $ 1,010,000 2 $ 1,010,000 3 $ 1,010,000 4 $ 1,010,000 5$ 1,010,000 6 $ 1,010,000 7 $ 1,010,000 8 $ 1,010,000 9 $ 1,010,000 992,141.45 974,598.68 957,366.09 940,438.20 923,809.63 907,475.08 891,429.35 875,667.34 860,184.02 844,974.48 56 10$ 1,010,000 57 58 IRR 0.02% 60 Net present value$(918,582.36) 61 62 No, Reject project.

B58 xfIR(B46:B56) 44 Year Cash flows PVIF@12.6 45 Present value A×B 0 5 (5.658.095 1 $ 1,010,000 2 $ 1,010,000 3 $ 1,010,000 4 $ 1,010,000 5$ 1,010,000 6 $ 1,010,000 7 $ 1,010,000 8 $ 1,010,000 9 $ 1,010,000 1.000 $ 0.888 $ 0.789 $ 0.700 $ 0.622 $ 0.552 $ 0.491 $ 0.436 $ 0.387 $ 0.344 $ 0.305 $ (5,658,095.24)--4920000-93000/12.6% 47 48 49 50 51 52 53 54 896,980.46 796,607.87 707,467.03 628,301.09 557,993.86 495,554.05 440,101.29 390,853.72 347,116.98 308,274.41 56 10$ 1,010,000 57 581 IRR 12.21% 60 Net present value$ (88,844.49) 61 62 No, Reject project.

As per IRR and NPV undertake the project only at 6.4%

Add a comment
Know the answer?
Add Answer to:
Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop...

    Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.92 million. The product is expected to generate profits of $1.19 million per year for ten years. The company will have to provide product support expected to cost $91,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 5.7%​? Should...

  • Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop...

    Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.97 million. The product is expected to generate profits of $1.19 million per year for ten years. The company will have to provide product support expected to cost $90,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year a. What is the NPV of this investment if the cost of capital is 5.9%? Should...

  • nnovation Company is thinking about marketing a new software product. Upfront costs to market and develop...

    nnovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.98 million. The product is expected to generate profits of $1.05 million per year for ten years. The company will have to provide product support expected to cost $90,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a What s the NPV of this investment if the cost of capital is 6.1%? Should...

  • Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop...

    Innovation Company is thinking about marketing a new software product. Upfront costs to market and develop the product are $4.99 million. The product is expected to generate profits of $1.19 million per year for ten years. The company will have to provide product support expected to cost $97,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. a. What is the NPV of this investment if the cost of capital is 6.3 %6.3%​?...

  • Problem 7 (20 points) Innovation Company is thinking about marketing a new software product Up-front costs...

    Problem 7 (20 points) Innovation Company is thinking about marketing a new software product Up-front costs to market and develop the product are $5 million. The product is expected to generate profits of $1 million per year for 10 years. The company will have to provide product support expected to cost $100,000 per year in perpetuity. Assume all profits and expenses occur at the end of the year. what is the NPV of this investment if the cost of capital...

  • You own a coal mining company and are considering opening a new mine. The mine itself...

    You own a coal mining company and are considering opening a new mine. The mine itself will cost $120 million to open. If this money is spent immediately, the mine will generate $22 million for the next 10 years. After that, the coal will run out and the site must be cleaned and maintained at environmental standards. The cleaning and maintenance are expected to cost $1.8 million per year in perpetuity. What does the IRR rule say about whether you...

  • X Company is planning to launch a new product. A market research study, costing $150,000, was...

    X Company is planning to launch a new product. A market research study, costing $150,000, was conducted last year, indicating that the product will be successful for the next four years. Profits from sales of the product are expected to be $154,000 in each of the first two years and $100,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $87,000. New manufacturing equipment will have to be purchased for...

  • Your firm has been hired to develop new software for the​ university's class registration system. Under...

    Your firm has been hired to develop new software for the​ university's class registration system. Under the​ contract, you will receive $ 508,000 as an upfront payment. You expect the development costs to be $ 431,000 per year for the next 3 years. Once the new system is in​ place, you will receive a final payment of $ 825,000 from the university 4 years from now. a. What are the IRRs of this​ opportunity?  ​ (Hint: Build an Excel model...

  • Your firm has been hired to develop new software for the​ university's class registration system. Under...

    Your firm has been hired to develop new software for the​ university's class registration system. Under the​ contract, you will receive $ 506,000 as an upfront payment. You expect the development costs to be $ 441,000 per year for the next 3 years. Once the new system is in​ place, you will receive a final payment of $ 857,000 from the university 4 years from now. a. What are the IRRs of this​ opportunity?  ​ (Hint: Build an Excel model...

  • Herjavec Enterprises is thinking about introducing a new surface cleaning machine. The marketing department has come...

    Herjavec Enterprises is thinking about introducing a new surface cleaning machine. The marketing department has come up with the estimate that the company can sell 15 units per year at $300,000 net cash flow per unit for the next five years. The engineering department has come up with the estimate that developing the machine will take a $14.8 million initial investment. The finance department has estimated that a discount rate of 16 percent should be used. a. What is the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT