## (Solved) Please type your numeric answers in the spaces below. Thank you and good luck. 1. Possible net present values and associated probabilities for a new

Need help answering the 3 questions on the attached document. Thanks for your help!

1. Possible net present values and associated probabilities for a new investment are as follows:
NPV Â­1200 Â­980 80
450
550
800
Probability
.15
.30
.20
.10
.10
.15
What is the expected value______________, median,______________ and mode _________________? 2. Teresaâ€™s Tanning Salon expects annual sales of \$175,000, annual fixed cash outlays are \$57,000 a year at each location, variable cash outlays are 25 percent of sales, depreciation is \$15,000 per year, and taxes are 32% (of pretax income). Initial
outlay for the building is \$440,000. The company does its analysis based on a 10-year store life. We believe the business
can be sold for \$500,000 after taxes (disposal value) at the end of its 10 year lifer. Using an 8% required return, what is the
net present value of this venture? 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. If you do not know how to do a goal seek in
excel please consult the help menu or google or other sources (there are many). Remember -- you will need to calculate the
net present value in the traditional way first. When you do this you need to make sure that the second year sales references
the first year ( plus â€œfirst yearâ€ in the formula) You will then need to click on the data tab to access theâ€œwhat ifâ€ box and
then click on the goal seek box. To use this function, you will set the â€œnpvâ€ cell to zero by changing the sales cell in the
first year.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 05, 2019

Solution~000200207253.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 05, 2019

EXPERT

Tutor