You have an innovative product that you have been selling for the past year. You have...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have an innovative product that you have been selling for the past year. You have decided to apply for a patent to protect your IP, but you are also aware that businesses deem a patented product more worthy, which will lead to increased sales. Suppose a wholesaler offers to buy your entire production and inventory for the year for $8M (you won't be able to sell anything else). Run a Monte Carlo simulation to determine if you should take the offer. Use the following assumptions: ● • ● ● There is a 50% chance that your product gets patented. Without a patent (base sales), you expect sales to follow a normal distribution, with a mean of $6 million and a standard deviation of $1.2 million. If it does get patented, your sales go up by 20% to 80%, with 40% being the most likely case (i.e., triangular distribution) You do not have to consider any costs or expenses. Part 2 - Simulation using Excel Run a Monte Carlo simulation using the Excel template provided. 1. Add formulas to (a) randomly sample from the base sales distribution, and (b) randomly generate whether the patent is awarded. Note: Random sampling from a triangular distribution is not a native Excel function; this formula has been provided for you. 2. Use a formula to combine the random inputs into the proper relationship to simulate sales. You have an innovative product that you have been selling for the past year. You have decided to apply for a patent to protect your IP, but you are also aware that businesses deem a patented product more worthy, which will lead to increased sales. Suppose a wholesaler offers to buy your entire production and inventory for the year for $8M (you won't be able to sell anything else). Run a Monte Carlo simulation to determine if you should take the offer. Use the following assumptions: ● • ● ● There is a 50% chance that your product gets patented. Without a patent (base sales), you expect sales to follow a normal distribution, with a mean of $6 million and a standard deviation of $1.2 million. If it does get patented, your sales go up by 20% to 80%, with 40% being the most likely case (i.e., triangular distribution) You do not have to consider any costs or expenses. Part 2 - Simulation using Excel Run a Monte Carlo simulation using the Excel template provided. 1. Add formulas to (a) randomly sample from the base sales distribution, and (b) randomly generate whether the patent is awarded. Note: Random sampling from a triangular distribution is not a native Excel function; this formula has been provided for you. 2. Use a formula to combine the random inputs into the proper relationship to simulate sales.
Expert Answer:
Answer rating: 100% (QA)
1 a RANDMAXMINMIN b IFRAND0510 2 IFB11A112A1 This is a simple Monte Carlo simulation We are assuming ... View the full answer
Related Book For
Ethical Obligations and Decision Making in Accounting Text and Cases
ISBN: 978-0077862213
3rd edition
Authors: Steven Mintz, Roselyn Morris
Posted Date:
Students also viewed these accounting questions
-
In this chapter we discuss problems encountered by the PCAOB in gaining access to inspect work papers of audits by U.S. international accounting firms of Chinese companies. Explain why these problems...
-
In this chapter we discuss the role of Sherron Watkins in the Enron fraud. Evaluate Watkins thought process and actions from the perspective of Kohlbergs model. Do you think she went far enough in...
-
In this chapter we discuss the Joe Paterno matter at Penn State. Another situation where a respected individuals reputation was tarnished by personal decisions having nothing to do with performance...
-
in an armicie entitled Fuel Economy Calculations tio Be Alteted lames Healey indicated that the goermnt planned to change how it caleulates fuel economy for new cas and trucks Thia in the first...
-
Using the expression for Var (XX ())found in Exercise 10.26, show that as | | 2t o, Var (XX ()) > Var (X(t)), and therefore, the estimate of the autocorrelation function is at least as noisy as the...
-
A particle carrying \(5.0 \times 10^{-7} \mathrm{C}\) of charge is located on the perpendicular bisector of a small dipole, \(300 \mathrm{~mm}\) from the center of the line joining the two poles of...
-
On January 3, Jose Rojo, Inc., paid $224,000 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $700 transportation charges, $100...
-
At Western University the historical mean of scholarship examination scores for fresh-man applications is 900. A historical population standard deviation = 180 is assumed known. Each year, the...
-
PACE 2 CANADIAN CULTURE CASE STUDY Bill Miller Cross-Cultural Case Study: When is it time to do business? Bill Miller, a top American salesman with a major information technology manufacturer, sits...
-
There is a firm in Walla Walla, an isolated site with a labor force of 20 workers. During boom the firm faces a demand curve of P=100-Q. During recession it faces a curve of 80-2Q. Boom and recession...
-
A nursery sells potting soil for $ 0 . 5 2 per pound, and the soil is available in 4 - ???? ???? , 1 0 - ???? ???? , and 5 0 - ???? ???? bags. Let ???? ( ???? ) be the price of a bag ( a ) Find the...
-
A cash flow for a pass-through typically is based on some prepayment benchmark. Describe the benchmark.
-
Leaders must be clear about what drives them to authentically navigate the landscape and be able to see and understand other perspectives, as well as to be patient and persistent to be an influence....
-
Writing an executive summary should occur after the business plan is written. Think about a project or proposal that will either increase revenue or decrease expenses. Write a two-page concise...
-
What role does innovation play in disaster/emergency response planning? What is the role of the DNP-prepared nurse in disaster mitigation and response?
-
Indicate why you agree or disagree with the following statement: "Today, the proceeds from most original-issue, high-yield bonds are used for leveraged buyouts and recapitalizations."
-
What is the difference between an incremental backup and a differential backup and why would each of these be used? Which of these backup strategies do you think would be most beneficial for an...
-
By referring to Figure 13.18, determine the mass of each of the following salts required to form a saturated solution in 250 g of water at 30 oC: (a) KClO3, (b) Pb(NO3)2, (c) Ce2(SO4)3.
-
1. The following is from Amgens values statement: Our Values form a deeply held belief system that guides our behavior, helps us make the right decisions and builds the framework for our daily...
-
1. What would motivate you to speak up and act or to stay silent? 2. Assume you were in Gloria Hernandezs position. What would you do and why?
-
In 2004, the Government Accountability Office (GAO) conducted an investigation of tax shelters of 61 Fortune 500 users of tax shelters provided by accounting firms that were their external auditors...
-
Why is communications management so important during project execution? What is the difference between formal and informal communications? Why are nonverbal communications so important?
-
What is involved in managing quality, and how does it affect project execution? What are tools and techniques used in performing quality assurance? How did Kristins team use one of these tools to...
-
Find an example of a large project that took more than a year to complete. Describe some of the planning work completed for the project as part of project integration and scope management. Summarize...
Study smarter with the SolutionInn App