Question: (please show me how to do it in excel) Suppose you work for a software company that has developed a new product. The patent on

(please show me how to do it in excel)

Suppose you work for a software company that has developed a new product. The patent on this product will last for seventeen years. You expect that the product will produce cash-flows of $10,000,000 in its 1st year and that this amount will grow at a rate of 4 percent per year for the next seventeen years. Once the patent expires, your competitors will be able to produce equivalents copies of your software and drive any future profits to zero. If the interest rate is 11 percent per year, then what is the present value of producing this software?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

please show me how to do this with excel functions You work for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. You expect that the drug's profits...

Please show all work and label all inputs, thank you! You work for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. You expect that the drug's...

please show step by step how you solved this question. You work for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. You expect that the drug's...

please show work for req 3 and 4!! thank you 1 Last year Minden Company introduced a new product and sold 26,000 units of it at a price of $95 per unit. The product's variable expenses are $65 per...

Please show the excel work needed to get the answers below. Talbot Industries is considering launching a new product. The new manufacturing equipment will cost $17 million, and production and sales...

please show all work!! (no excel please) 7. Your company is exploring the possibility of offering a new product. The equipment required to manufacture the new product will cost $900,000 and will be...

please show all work! (no excel plesse) 7. Your company is exploring the possibility of offering a new product. The equipment required to manufacture the new product will cost $900,000 and will be...

Use differential analysis to solve the series of problems Differential Analysis Problems Attached Files: Differential Analysis Problems.xisx (40.262KB) Instructions: 1. The attached Excel file...

Questions: 1) Please bridge ADSs 12/31/2019 Cash EBITDA before Q of E adjustments (reported cash EBITDA) to 12/31/2109 Cash EBITDA after Q of E adjustments (adjusted cash EBITDA). List every...

Integrated Marketing Communications Plan DELL CASE STUDY Introduction Integrated Marketing communications report has been executed over the topic Marketing communication which is an important aspect...

What are the three distinct types of business activity in which companies engage? Assume that you start your own company to rent bicycles in the summer and skis in the winter. Give an example of at...

Given the following tax structure, what minimum tax would need to be assessed on Shameika to make the tax progressive with respect to average tax rates? Taxpayer Salary Muni-bond interest Total Tax...

The flexible exchange system since 1 9 7 3 has contributed toa. More liquidity in the financial marketsb. Market forces have more power to determine the daily value of some currenciesc. More...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

5. In small groups in your class, discuss how popular culture and films portray interpersonal relationships, considering specifically relationship stages. Discuss communication techniques that the...

4. As a new romantic relationship begins, keep a journal of the communication events that occur. In this journal, indicate the stage you perceive the relationship to be in (based on the stages in...

3. Consider a romantic relationship that has ended. Using the stages outlined in this chapter, create a time line of the relationship. Include significant turning points that encouraged the...