Develop analysis of three investments

Assignment Help Financial Management
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


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?


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).

Verified Expert

Reference no: EM13847827

Sustainable and internal growth rates

Find the sustainable and internal growth rates for a firm with the following ratios: asset turnover = 2.00; profit margin = 7%; payout ratio = 30%; equity/assets = .60. (Do no

Future value of an expected series of payments

Starting to invest early for retirement increases the benefits of compound interest. If the discount (or interest) rate is positive, the future value of an expected series of

What must the coupon rate be on orages bonds

Orage Enterprises has bonds on the market making annual payments, with 13 years to maturity, face value of $1,000, and selling for $1,157.2. At this price, the bonds yield 8.4

What is the expected return from this investment strategy

You observe that IBM, Google, and Facebook’s stock returns have the betas in the table provided below. Suppose the expected market return is 8% and the risk-free rate is 3%. S

Discounting and present values

If the account had a beginning balance of $3,500, and you decided to make 2 equal deposits - one today and one 3 years from today - rather than a single deposit today, how muc

Most of earnings to finance that intense growth level

Massy United Ltd. has been experiencing high levels of growth over the past 5 years and management has decided to retain most of its earnings to finance that intense growth le

Bond issue currently outstanding

Suppose we have a bond issue currently outstanding that has 15 years left to maturity. The coupon rate is 6% and coupons are paid semiannually. The bond is currently selling f

How much will you pay for company stock today

Caan Corporation will pay a $3.26 per share dividend next year. The company pledges to increase its dividend by 6.5 percent per year indefinitely. If you require a return of 1


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd