Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Orange Tech (OT) is a software company that provides a suite of programs that are essential to everyday business computing. OT has just enhanced its

image text in transcribedimage text in transcribedimage text in transcribed

Orange Tech (OT) is a software company that provides a suite of programs that are essential to everyday business computing. OT has just enhanced its software and released a new version of its programs. For financial planning purposes, OT needs to forecast its revenue over the next few years. To begin this analysis, OT is considering one of its largest customers. Over the planning horizon, assume that this customer will upgrade at most once to the newest software version, but the number of years that pass before the customer purchases an upgrade varies. Up to the year that the customer actually upgrades, assume there is a 0.50 probability that the customer upgrades in any particular year. In other words, the upgrade year of the customer is a random variable. For guidance on an appropriate way to model upgrade year, refer to Appendix 11.1. Furthermore, the revenue that OT earns from the customer's upgrade also varies (depending on the number of programs the customer decides to upgrade). Assume that the revenue from an upgrade obeys a normal distribution with a mean of $100,000 and a standard deviation of $25,000. Using the template in the file OrangeTech, complete a simulation model that analyzes the net present value of the revenue from the customer upgrade. Use an annual discount rate of 10%. Click on the datafile logo to reference the data. DATA file (a) What is the average net present value that OT earns from this customer? Round your answer to the nearest whole number. Do not round your intermediate calculation. (b) What is the standard deviation of net present value? Round your answer to the nearest whole number. Do not round your intermediate calculation. $ Orange Tech Orange Tech 0.5 Parameters Annual Upgrade Probability Upgrade Year Discount Rate Upgrade Revenue 10% Upgrade Revenue (normal) mean standard deviation $100,000 $25,000 Model Year Upgrade Revenue 10 11 12 13 14 15 16 17 18 19 20 24 NPV $0.00 Orange Tech (OT) is a software company that provides a suite of programs that are essential to everyday business computing. OT has just enhanced its software and released a new version of its programs. For financial planning purposes, OT needs to forecast its revenue over the next few years. To begin this analysis, OT is considering one of its largest customers. Over the planning horizon, assume that this customer will upgrade at most once to the newest software version, but the number of years that pass before the customer purchases an upgrade varies. Up to the year that the customer actually upgrades, assume there is a 0.50 probability that the customer upgrades in any particular year. In other words, the upgrade year of the customer is a random variable. For guidance on an appropriate way to model upgrade year, refer to Appendix 11.1. Furthermore, the revenue that OT earns from the customer's upgrade also varies (depending on the number of programs the customer decides to upgrade). Assume that the revenue from an upgrade obeys a normal distribution with a mean of $100,000 and a standard deviation of $25,000. Using the template in the file OrangeTech, complete a simulation model that analyzes the net present value of the revenue from the customer upgrade. Use an annual discount rate of 10%. Click on the datafile logo to reference the data. DATA file (a) What is the average net present value that OT earns from this customer? Round your answer to the nearest whole number. Do not round your intermediate calculation. (b) What is the standard deviation of net present value? Round your answer to the nearest whole number. Do not round your intermediate calculation. $ Orange Tech Orange Tech 0.5 Parameters Annual Upgrade Probability Upgrade Year Discount Rate Upgrade Revenue 10% Upgrade Revenue (normal) mean standard deviation $100,000 $25,000 Model Year Upgrade Revenue 10 11 12 13 14 15 16 17 18 19 20 24 NPV $0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Comparative Public Budgeting

Authors: George M Guess

2nd Edition

1316648109, 978-1316648100

More Books

Students also viewed these Finance questions

Question

If A in Prob. 9 is defined by

Answered: 1 week ago

Question

8.10 Explain several common types of training for special purposes.

Answered: 1 week ago