Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with question 2a and 2b. Need to know how to perform a sensitivity analysis in excel preferably. 1 Take Five Systems, a new

Need help with question 2a and 2b. Need to know how to perform a sensitivity analysis in excel preferably.image text in transcribed

1 Take Five Systems, a new start-up, is developing a new iPhone application ("app") and provides you with the following assumptions: a. Development and testing of the new app will take four months. Month five is the first month of revenue generation. b. Initial monthly app sales of 5,000 downloads at a price of $2.99 C. Unit sales will grow at 15% per month for months six through twelve and then will be flat thereafter d. The app will become obsolete and will need to be revised/replaced after month 18 Use the data provided to forecast Take Five's monthly revenue for Months 1-18 2 Take Five Systems is concerned about the accuracy of their revenue estimates in Question 1. Specifically, they wish to use sensitivity analysis to evaluate the impact on Month 18 revenue of the following: a. Variations in 2% increments between 9-21% in the growth rate of unit sales in Months 5-12 (that is, 9%, 11%, ..., 19%, 21%) b. Variation in 500 unit increments between 2,500 and 7,500 in the level of initial sales (that is, 2,500, 3,000,..., 7,000, 7,500)

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

Financial Markets And Institutions

Authors: Anthony Saunders, Marcia Cornett

5th Edition

0078034663, 978-0078034664

More Books

Students also viewed these Finance questions