Question

In: Finance

You are given the following information: Project A Project B Investment $125,000 $100,000 CF-1 $12,500 $15,000...

You are given the following information:

	Project A	Project B
Investment	$125,000	$100,000
CF-1	$12,500	$15,000
CF-2	$15,000	$25,000
CF-3	$25,000	$20,000
CF-4	$40,000	$10,000
CF-5	$60,000	$15,000
CF-6	$70,000	$35,000
Required rate of return	10%	10%

Compute the following:
a) MIRR for Project A
b) MIRR for Project B
c) Profitability Index for Project A
d) Profitability Index for Project B

Expert Solution

FV of Cash flows:

Project A: $ 125,000 has increased to $ 259,767.88

$ 259,767.88 = $ 125,000 (1+MIRR)⁶

(1+MIRR)⁶ = $ 259,767.88 / $ 125,000

= 2.0781

1+MIRR = 2.0781^1/6

= 1.1297

MIRR = 0.1297 i.e 12.97%

Project A: $ 100,000 has increased to $ 150,980.15

$ 150,980.15 = $ 100,000 (1+MIRR)⁶

(1+MIRR)⁶ = $ 150,980.15 / $ 100,000

= 1.5098

1+MIRR = 2.0781^1/6

= 1.0711

MIRR = 0.0711 i.e 07.11%

Profitability Index = PV of Cash Inflows / PV of Cash Outflows

jeff jeffy answered 2 years ago

This table will cover information for Q7-Q8 year CF project A CF project B 0 -1000...

This table will cover information for Q7-Q8 year CF project A CF project B 0 -1000 -800, 1 600 300, 2 700 300, 3 300, 4 400 With discount rate 7%. Q7: what is project B's NPV? Q8: what is annualized EAC (annualized NPV) for project A?

Consider a project with the following cash flows: $3,500 at t=1, $12,500 at t=2, $15,000 at...

Consider a project with the following cash flows: $3,500 at t=1, $12,500 at t=2, $15,000 at t=3, $15,000 at t=4. The Discounted Payback Period of this project is 3.3 years. The appropriate discount rate is 11%. Find the Net Present Value of the project. (Note that the cash flow for t=0 is not provided to you.) A. $6,916.67 B. ($11,852.73) C. ($1,627.27) D. $4,952.58 E. Insufficient information.

Consider the following investment opportunities. Period A B C D 0 -12,500 -11,000 12,500 -13,000 1...

Consider the following investment opportunities. Period A B C D 0 -12,500 -11,000 12,500 -13,000 1 5,400 -3,000 -7,000 5,500 2 14,400 21,000 -2,000 5,500 3 7,200 13,000 4,000 8,500 a) Compute the present worth of each investment, assuming a MARR of 15% b) Compute the future worth of each investment, assuming a MARR of 15% c) Which project or projects are acceptable?

Consider the investment project cash flows given below n CF 0 -220000 1 94000 2 144000...

Consider the investment project cash flows given below n CF 0 -220000 1 94000 2 144000 3 72000 a) Find the IRR for this investment. b) Plot the present worth of the cash flow as a function of the interest rate, i.e., consider interest rates of 5%,10%,15%,…, 30%. Identify the interest rate at which the present worth is zero. c) Assuming a MARR of 15%, is this investment acceptable?

You are given the following information for 1994: Sales = $50,000, CoG’s = $15,000, Depreciation =...

You are given the following information for 1994: Sales = $50,000, CoG’s = $15,000, Depreciation = $5000, tax rate = 40%, Net Capital Spending = $15,000, Additions to Net Working Capital = $5000. Calculate EBIT, OCF, and CFA. Do you have to be worried if the CFA is negative? Explain.

You have been given a project to evaluate. The upfront cost is $100,000. The project will...

You have been given a project to evaluate. The upfront cost is $100,000. The project will then generate $40,000 in year one, $50,000 in year two, and then $60,000 for the last 3 years of the project. If your cost of capital is 11%, what is the NPV? IRR? Show Calculations.

LeBron holds the following portfolio: Stock Investment Beta A $100,000 1.40 B $100,000 0.70 C...

LeBron holds the following portfolio: Stock Investment Beta A $100,000 1.40 B $100,000 0.70 C $200,000 1.40 D $100,000 1.80 Total $500,000 LeBron plans to sell Stock C and replace it with Stock E, which has a beta of 0.80. By how much will the portfolio beta change?

An investment project costs $12,500 and has annual cash flows of $3,100 for six years. a....

An investment project costs $12,500 and has annual cash flows of $3,100 for six years. a. What is the discounted payback period if the discount rate is zero percent? b. What is the discounted payback period if the discount rate is 5 percent? c. What is the discounted payback period if the discount rate is 21 percent?

BMI Inc. is considering a project with an initial investment of $1, 100,000. the percent value...

BMI Inc. is considering a project with an initial investment of $1, 100,000. the percent value of the future cash flows of the project is $1,175,000. the company can issue equity at a flotation cost of 9.76 percent and debt at 6.93 percent. the firm currently has a debt-equity ratio of 0.60. the firm is considering two scenarios. first, all funds will be raised externally. second, seventy percent of equity will come from retained earnings (internal sources). what should the...

A firm invests $100,000 in a project today. It receives $15,000 a year from now, $20,000...

A firm invests $100,000 in a project today. It receives $15,000 a year from now, $20,000 two years from now, and $95,000 three years from now and nothing more. What is the IRR of the project? Where aX:aY are cells aX to aY which have cash flows entered into them. The initial investment is a negative cash flow so it should have a negative sign. Z is a "guess" IRR, usually you can set to 0.1 (which is 10%).