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

#### Determine how much one months interest expense

Determine the maximum loan for which Charmin Paper Company could qualify. - Determine how much one month's interest expense would be on the loan balance determined in part a.

#### What is price of bond if its yield to maturity increases

A 30-year maturity bond making annual coupon payments with a coupon rate of 12% has duration of 11.54 years and convexity of 192.4. The bond currently sells at a yield to matu

#### Bank net interest income of interest rates increasing

Suppose that a bank has \$5 billion of one-year loans and \$30 billion of five-year loans. These are financed by \$25 billion of one-year deposits and \$10 billion of five –year d

#### What is the present value of your savings account

Suppose you invest \$ 2,026 today to start a business. In 4 years you hope to sell this company for \$ 8,865. What would be your annualized rate of return? Assume that, starting

#### What is the new debt-to-value ratio

Company A has assets worth \$100,000,000. The company has a 0.2 debt-to-value ratio and keeps a constant-debt policy. Company A decides unexpectedly to reduce its debt by a hal

#### Forward rates and markets expectation of future short rates

Forward rates and the market’s expectation of future short rates are related. Explain the relationship in context of both the expectations and the liquidity preference theorie

#### What is the one forward rate that can be derived

Suppose the current one-year rate is 3% and the current two-year is 5%. What is the one forward rate that can be derived? (State in both words and symbols). Solve for it by se

#### Equivalent and effective annual yield of this type of bond

Suppose the price of a stock is \$100 a share. A call option on the stock with two months until expiration date and exercise price \$105 sells for \$2. A put on the stock with th