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

  • You are considering opening a new plant. The plant will cost $97.4 million upfront and will...

    You are considering opening a new plant. The plant will cost $97.4 million upfront and will take one year to build. After​ that, it is expected to produce profits of $28.5 million at the end of every year of production. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 7.5%. Should you make the​ investment? Calculate the IRR. Does the IRR rule agree with the NPV​ rule? ......

  • You are considering opening a new plant. The plant will cost $ 101.8 million upfront and...

    You are considering opening a new plant. The plant will cost $ 101.8 million upfront and will take one year to build. After​ that, it is expected to produce profits of $ 30.5 million at the end of every year of production. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 7.9 % . Should you make the​ investment? Calculate the IRR. Does the IRR rule agree with...

  • You are considering opening a new plant. The plant will cost $ 104.4 million upfront and...

    You are considering opening a new plant. The plant will cost $ 104.4 million upfront and will take one year to build. After​ that, it is expected to produce profits of $ 28.6 million at the end of every year of production. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 7.7 %. Should you make the​ investment? Calculate the IRR. Does the IRR rule agree with the...

  • You are considering opening a new plant. The plant will cost $102.5 million upfront and will...

    You are considering opening a new plant. The plant will cost $102.5 million upfront and will take one year to build. After​ that, it is expected to produce profits of $29.5 million at the end of every year of production. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 7.8 %. Should you make the​ investment? Calculate the IRR. Does the IRR rule agree with the NPV​ rule?...

  • You are considering opening a new plant. The plant will cost $ 99.9 million upfront. After​...

    You are considering opening a new plant. The plant will cost $ 99.9 million upfront. After​ that, it is expected to produce profits of $ 31.6 million at the end of every year. The cash flows are expected to last forever. Calculate the NPV of this investment opportunity if your cost of capital is 6.3%. Should you make the​ investment? Calculate the IRR. Use the IRR to determine the maximum deviation allowable in the cost of capital estimate to leave...

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