Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need an experienced tutor that can provide a clear and thorough explanation. I need assistance on these questions. The answers that I got were
I need an experienced tutor that can provide a clear and thorough explanation.
I need assistance on these questions. The answers that I got were incorrect. Please correct them and explain where I went wrong. For example, you can write: \"Problem 1: My answer was 533 and the correct answer is $1,250. I missed this because I...\" Please Assist. 1. Possible net present values and associated probabilities for a new investment are as follows: NPV -1450 320 380 444 555 950 1650 Probability .15 .10 .30 .10 .10 .15 .10 What is the expected value______________, median,______________ and mode _________________? (remember the median is the center based on probabilities) Expected Value = 553 Median = 444 Mode = 0 2. As a follow on to the prior problem, assume that the investment committee determined the probabilities below: Probability the competitor will response 40%, will not respond 60% Probability of each economic state over the six year horizon Weak - 10%., Normal - 60% and Strong 30% Please complete the table of joint probabilities (by multiplying the economy probability by the competitor response probability) below and then calculate the expected net present value. Competitor Weak Normal Strong Response Economy Economy Economy Yes 4% 24% 12% No 6% 36% 18% The expected net present value is $17,153.24. 3. Please rework the prior problem to determine what annual sales volume is needed to generate a net present value of $0? To do this you will need to review the problem in the book and its excel answer. I will repeat the instructions here. You will need to calculate the net present value in the traditional way. You must make sure that the second year sales references the first year ( plus \"first year\" in the formula). You will then do a goal seek to solve this problem The goal seek function is accessed by clicking on the DATA tab -- then clicking on the \"what if\" box -- then clicking on the goal seek box. To use this function, you will set the \"npv\" cell to zero by changing the first years sales cell. There are videos that illustrate how to do a goal seek on the internet. If you cannot figure this out, you may email me a phone number where you can be reached during the day (and one during the evening - I will not call after 9:00pm your time). This offer is only good in the continental US -- sorry. Answer: This final question had me stumped. In my academic opinion, the corporation will continue to sell 100,000 at the price of $1.60. This is a presumption being that there is no clear price per unit, amount of working days and hours of the year, cost per unit, as well as no sales in quantity. With that being stated, the corporation will have to put up for sale the amount of 100,000 sandwiches at the price of $1.60 hence leading to the end result of $45, 715 units sold. Question 1: NPV Probability -1450 0.15 -217.5 320 0.1 32 380 0.3 114 444 0.1 44.4 555 0.1 55.5 950 0.15 142.5 1650 0.1 165 Expected Value = 335.90 Median = 444 Mode = 0 Question 2 YES NPV Weak economy Normal Economy Strong Economy NO NPV Weak economy Normal Economy Strong Economy -1450 0.4 0.24 0.12 -1102 320 0.4 0.24 0.12 243.2 380 0.4 0.24 0.12 288.8 444 0.4 0.24 0.12 337.44 555 0.4 0.24 0.12 421.8 950 0.4 0.24 0.12 722 1650 0.4 0.24 0.12 1254 -1450 0.6 0.36 0.18 -1653 320 0.6 0.36 0.18 364.8 380 0.6 0.36 0.18 433.2 444 0.6 0.36 0.18 506.16 555 0.6 0.36 0.18 632.7 950 0.6 0.36 0.18 1083 1650 0.6 0.36 0.18 1881 Expected value = 2165.24 + 3247.86 = $5413.1/2 = $2,706.55 Question 3 Your opinion is correct according to me. The corporation will continue to sell 100,000 at the price of $1.60 hence leading to the end result of $45, 715 units sold. Expected Value 335.9 Total 2165.24 Total 2 = $2,706.55 3247.86 5413.1 Question 1: NPV Probability -1450 0.15 -217.5 320 0.1 32 380 0.3 114 444 0.1 44.4 555 0.1 55.5 950 0.15 142.5 1650 0.1 165 Expected Value = 335.90 Median = 444 Mode = 0 Question 2 YES NPV Weak economy Normal Economy Strong Economy NO NPV Weak economy Normal Economy Strong Economy -1450 0.4 0.24 0.12 -1102 320 0.4 0.24 0.12 243.2 380 0.4 0.24 0.12 288.8 444 0.4 0.24 0.12 337.44 555 0.4 0.24 0.12 421.8 950 0.4 0.24 0.12 722 1650 0.4 0.24 0.12 1254 -1450 0.6 0.36 0.18 -1653 320 0.6 0.36 0.18 364.8 380 0.6 0.36 0.18 433.2 444 0.6 0.36 0.18 506.16 555 0.6 0.36 0.18 632.7 950 0.6 0.36 0.18 1083 1650 0.6 0.36 0.18 1881 Expected value = 2165.24 + 3247.86 = $5413.1/2 = $2,706.55 Question 3 Your opinion is correct according to me. The corporation will continue to sell 100,000 at the price of $1.60 hence leading to the end result of $45, 715 units sold. Expected Value 335.9 Total 2165.24 Total 2 = $2,706.55 3247.86 5413.1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started