Reference no: EM13847827
Scenario: Using the situation from SLP2, recall that you are deciding between two investments. However, they each require a different initial investment amount. And you also have a third option, to invest in a 10 year municipal bond with a very high return. Here are the investment options with the augmented data.
Option A: Real estate development. This is a risky opportunity with the possibility of a high payoff, but also with no payoff at all. You have reviewed all of the possible data for the outcomes in the next 10 years and these are your estimates of the Net Present Value of the cash flow and probabilities.
Required initial investment: $0.75 million
High NPV: $5 million, Pr = 0.5
Medium NPV: $2 million, Pr = 0.3
Low NPV: $0, Pr = 0.2
Option B: Retail franchise for Just Hats, a boutique type store selling fashion hats for men and women. This also is a risky opportunity but less so than option A. It has the potential for less risk of failure, but also a lower payoff. You have reviewed all of the possible data for the outcomes in the next 10 years and these are your estimates of the Net Present Value of the cash flow and probabilities.
Required initial investment: $0.55 million
High NPV: $3 million, Pr = 0.75
Medium NPV: $2 million, Pr = 0.15
Low NPV: $1 million, Pr = 0.1
Option C: High Yield Municipal Bonds. This option has low risk and is assumed to be a Certainty. So there is only one outcome with probability of 1.0
Required initial investment: $0.75 million
NPV: $1.5 million, Pr = 1.0
Assignment
Develop an analysis of these three investments. Use expected NPV to determine which of these you should choose. Be sure to include all cash flows to generate the total NPV of each alternative. Do your analysis in Excel using decision tree.
Write a report to your private investment company and explain your analysis and your recommendation. Provide a rationale for your decision.
Upload both your written report and Excel file with the decision tree analysis to the SLP 3 Dropbox.
BONUS (2.0 pts): If the two options A and B could be made to be equal, what would have to change in the NPVs in Option A to make it equal to Option B?
Analysis
Accurate and complete Excel analysis.
Written Report
Length requirements = 2–3 pages minimum (not including Cover and Reference pages)
Provide a brief introduction/ background of the problem.
Complete and accurate Excel analysis.
Written analysis that supports Excel analysis, and provides thorough discussion of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).
|
Harley_davidson, wich once boasted
: Harley_Davidson, wich once boasted that it made "big toys for big boys", is trying to lure more women to the brand to make up for declining sales in a slow economy. How do you think this move will complement or confound the company's differentiation ..
|
|
How lenovo markets differently on the web
: What are the major differences in how Lenovo markets differently on the web, in the US, India & in Spain? In what way are differences in organizational cultures internationally likely to present significant challenges to Lenovo efforts to create a sm..
|
|
Bonds outstanding with coupon rate
: Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 26 years to maturity. The yield to maturity on these bonds is 4.3 percent and the bonds have a par value of $10,000. What is the price of the bo..
|
|
Restart manufacturing the tablet and maintain slashed price
: Troy Wolverton. (July 5, 2011). HP'S TABLET ENTRY NIPS AT APPLE IPAD'S HEELS :TouchPad's operating system, other features make it a worthy rival, but not a replacement. Contra Costa Times,C.1. Retrieved on December 1, 2011, from ProQuest Newsstand. (..
|
|
Develop analysis of three investments
: Using the situation from SLP2, recall that you are deciding between two investments. However, they each require a different initial investment amount. Real estate development. This is a risky opportunity with the possibility of a high payoff, but als..
|
|
Real-time location-based services have been talked up
: Consider the following questions and write a 3 page paper: The article states that "Some veterans of the tech industry note that real-time location-based services have been talked up several times in the past decade, only to disappoint. But there are..
|
|
Op-ed selection of a newspaper
: Problem: Select and bring to class on the assigned date a copy of an article from an OP-ED selection of a newspaper or an Editorial. Write a short paper on that writer's article (2-3 typed pages double spaced).
|
|
Strategic marketing process paper
: In a paper of 750-1,000 words, describe the strategic marketing process and its three key phases of planning, implementation, and control. Include an introduction and conclusion. Address the following: How does the marketing mix help businesses crea..
|
|
Assume semiannual compounding periods
: You find a zero coupon bond with a par value of $10,000 and 14 years to maturity. The yield to maturity on this bond is 5.1 percent. Assume semiannual compounding periods. What is the price of the bond?
|