### 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

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.

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

Verified Expert

#### Cost of Equity-DCF-What is the cost of common equity

Summerdahl Resorts' common stock is currently trading at \$23.00 per share. The stock is expected to pay a dividend of \$1.75 a share at the end of the year (D1 = \$1.75), and th

#### What is the process capability

A manufacturer of automobile headlamps tests 400 samples each day. The non-conformities are counted as scratches, circuit breaks etc. These defects are corrected before sendin

#### Corporate bonds-what is the current price of the bond

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company iss

#### Which journal entry reflects the adjusting entry needed

Which journal entry reflects the adjusting entry needed on December 31?: In November, BOC prepaid \$30,000 of rent for December, January, and February (and it was recorded prop

#### What is the new divisor for the price-weighted index

Able, Baker, and Charlie are the only three stocks in an index. The stocks sell for \$36, \$312, and \$82, respectively. If Baker undergoes a 3-for-2 stock split, what is the new

#### What would be appropriate estimate of stock price today

A company is expected to have earnings of \$3.03 per share next year, \$4.28 in two years, and \$5.79 in three years. The dividend payout ratio is expected to remain at 40% over

#### Consider flotation costs for the common stock issuance

Collins Manufacturing Company has determined its optimal capital structure, which is composed of the following sources and target market value proportions: Target Market - Sou

#### Review and evaluation of financial performance

Explain if the source of cash sustainable, and list any outstanding variances you have noticed below:3-4 variances required and now in the space provided, list the corrective