Question

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 the firm undertake the pr ect? Repeat the analysis fo dscount rates 15 and 136 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

We will use NPV and IRR formula to calculate as per image attached.

The cash flows are

Year Cash flows
0 -4.98
1 1.05
2 1.05
3 1.05
4 1.05
5 1.05
6 1.05
7 1.05
8 1.05
9 1.05
10 1.05

a:

Rate NPV in millions
6.10% 2.711609
1.50% 4.703294
13.60% 0.583504

b: IRR is 16.51%

Since IRR is greater than the cost of capital, the project should be undertaken.

AutoSave Book1 Excel (Product Activation Failed) Sign in File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri General Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & Editing Paste . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , : Filter Select Clipboard Font Alignment Number Styles Cells D1 xRate Cash flows 4.98 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1.05 1 Year Rate NPV 0.061 NPV (D2,SB$3:$B$12)+SB$2 0.015 NPV(D3,SB$3:$B$12)+ŞB$2 0.136 NPV(D4,SB$3:$B$12)+ŞB$2 4 2 IRR IRR(B2:B12) 10 8 11 9 12 10 13 14 15 16 17 Sheet1 Ready + 100 cENG 10:48 AM

Add a comment
Know the answer?
Add Answer to:
nnovation 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.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...

  • 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.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...

  • 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.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...

  • 2. Your company is looking at introducing a new product into its product line. Your company expects that this new p...

    2. Your company is looking at introducing a new product into its product line. Your company expects that this new product would be offered into perpetuity. It is expected to decrease the firm's FCFS immediately by $36 million and $22 million next year. Starting in year 2, the firm's FCFS will increase by $10 million. These incremental FCFS will then decrease at a rate of 2% into perpetuity (i.e. year 3's incremental FCF will be 10M*(1+(-0.02)) = 9.8M, and so...

  • 8pt X Company is planning to launch a new product. A market research study, costing $200,000,...

    8pt X Company is planning to launch a new product. A market research study, costing $200,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 $165,000 in each of the first two years and S116,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost 894,000. New manufacturing equipment will have to be purchased...

  • 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...

  • 8 pt X Company is planning to launch a new product. A market research study, costing...

    8 pt 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 $152.000 in each of the first two years and $106,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $83.000 New manufacturing equipment will have to be...

  • 6LTZSy 8 pt X Company is planning to launch a new product. A market research study,...

    6LTZSy 8 pt 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 $152.000 in each of the first two years and $106,000 in each of the last two years. The company plans to undertake an immediate advertising campaign that will cost $83,000. New manufacturing equipment will have to...

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