Question

In: Finance

Use the cash flows from the following two projects to answer the questions below. The firms...

Use the cash flows from the following two projects to answer the questions below. The firms required rate of return is 11%. Make sure to show all your computations.

Year

Project A

Project B

0

-$200,000

-$200,000

1

$80,000

$100,000

2

$80,000

$100,000

3

$80,000

$100,000

4

$80,000

Assuming the firm’s required rate of return increases to 16% and that your firm only has $200,000 available to invest, which project of the two above would you chose if you used:

a.) The Profitability Index (as percentage of invested funds) as your capital rationing criterion?

b.) The Internal Rate of Return as your capital rationing criterion?

c.) The replacement chain method to evaluate mutually exclusive projects of equal size but different lifespans?

d.) Equivalent Annual Annuities to evaluate mutually exclusive projects of equal size but with different lifespans?

Solutions

Expert Solution

Satetement shwoing Present value of cash inflow for project A and B

Year Project A PVIF @ 11% PV Project B PVIF @ 11% PV
1 80000 0.9009 72072.07207 100000 0.90090 90090.09
2 80000 0.8116 64929.79466 100000 0.81162 81162.24
3 80000 0.7312 58495.3105 100000 0.73119 73119.14
4 80000 0.6587 52698.47793
248196 244371.5


A)PI = Cash inflow/Cash outflow

Particulars Project A Project B
PV of cash inflow 248196 244371.4715
PV of cash outflow 200000 200000
PI 1.240978 1.221857358

B)

IRR is rate at which NPV is 0,

For project A

At 21.86% NPV comes to 0, hence IRR = 21.86%

Year Project A PVIF @ 21.86% PV
1 80000 0.8206 65647.92
2 80000 0.6734 53870.62
3 80000 0.5526 44206.18
4 80000 0.4534 36275.54
200000
Less: PV of cash out flow 200000
NPV 0

For project B

IRR = 23.375%

Year Project B PVIF @ 23.375% PV
1 100000 0.81054 81053.63
2 100000 0.65697 65696.91
3 100000 0.53250 53249.73
4
200000
Less: PV of cash out flow 200000
NPV 0

C) Statement showing NPV

Year Project A PVIF @ 11% PV Project B PVIF @ 11% PV
1 80000 0.9009 72072.07207 100000 0.90090 90090.09
2 80000 0.8116 64929.79466 100000 0.81162 81162.243
3 80000 0.7312 58495.3105 100000 0.73119 73119.138
4 80000 0.6587 52698.47793
248196 244371.47
Less: PV of cash out flow 200000 200000
NPV 48196 44371

Thus project A should be choosen

D) Statement showing Equal annual revenue

Year Project A PVIF @ 11% PV Project B PVIF @ 11% PV
1 80000 0.9009 72072.07207 100000 0.90090 90090.09
2 80000 0.8116 64929.79466 100000 0.81162 81162.243
3 80000 0.7312 58495.3105 100000 0.73119 73119.138
4 80000 0.6587 52698.47793
248196 244371.47
Less: PV of cash out flow 200000 200000
NPV 48196 44371
PVIFA 3.1024 2.44371
Equal Annual revenue 15535 18157

Thus project B should be choosen


Related Solutions

Use the following information to answer the next three questions. Consider the cash flows from two...
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: Cash Flow Year Project A Project B 0 -$470,000 -$460,000 1 $120,000 $392,000 2 $210,000 $110,000 3 $375,000 $120,000 The appropriate discount rate is 11.7%. Calculate the net present value (NPV) for both projects, and determine which project should be accepted based on NPV. Round both NPVs to the nearest dollar. Calculate the internal rate of return (IRR) for both projects,...
Use the following information to answer the next two questions. Consider the after-tax cash flows below:...
Use the following information to answer the next two questions. Consider the after-tax cash flows below: Year 0 1 2 3 4 Cash Flow -$75,000 $5,100 -$1,100 $498,000 -$272,000 The required rate of return is 12 percent. Find an internal rate of return (IRR) for these cash flows. Should you use the IRR you calculated in the previous question to decide whether the project is acceptable? Explain show work please
Use the following information to answer the next four questions. The cash flows for two mutually...
Use the following information to answer the next four questions. The cash flows for two mutually exclusive projects are shown in the following table. Investors require a 16% rate of return for each project. Year Cash Flows: Project S (in millions) Cash Flows: Project T (in millions) 0 -200 -200 1 -20 50 2 45 60 3 70 30 4 -10 -40 5 125 100 6 125 100 7 150 100 Find the profitability index for project S. Round intermediate...
Please use the financial ratio data below to answer the following questions. Assume the two firms...
Please use the financial ratio data below to answer the following questions. Assume the two firms are in the same industry:                           FIRM A                                                                               FIRM B Asset Turnover 0.62 Asset Turnover 0.63 Price-earnings Ratio 20 Price-earnings Ratio 15 Current Ratio 1 Current Ratio 0.9 Profit Margin (%) 8.2 Profit Margin (%) 7.9 Financial Leverage 2.5 Financial Leverage 5.5 Times Interest Earned 5 Times Interest Earned 2 Return on Equity (%) 12.7 Return on Equity (%) 27.4 5a. Which firm would you prefer...
Suppose you are given the following two projects A and B with the cash flows below,...
Suppose you are given the following two projects A and B with the cash flows below, if the cost of capital is 10%, what is the Profitability Index (PI) of projects A and B? Year Project A Project B 0 -5000 -6000 1 1500 1500 2 2000 2500 3 3000 4000 4 3500 4000
Use the following set of cash flows for the questions below: Table A Year Cash Flow...
Use the following set of cash flows for the questions below: Table A Year Cash Flow 1 $5,973 2 $18,662 3 $61,839 4 $66,528 5 $68,052 6 $73,559             2. Using the cash flows in Table A, determine the present value of the cash flow stream at the following discount rates: 3%, 8%, 12%, 18%, and 22%. (Use a data table to complete these calculations. (please show how to do in excel, having a hard time figuring out how to...
The cash flows for two projects, A and B, are shown in the table, below. Notice...
The cash flows for two projects, A and B, are shown in the table, below. Notice that Project A has a life of 5 years and Project B has a 3 year life. Calculate the NPV of each project and calculate which should be adopted using the replacement chain approach. Assume that the cost of capital is 10%. Project CFs Project CFs Time A B 0 -100 -150 1 20 75 2 25 60 3 30 50 4 30 5...
Consider the cash flows from two mutually exclusive projects
Use the following information to answer the next three questions. Consider the cash flows from two mutually exclusive projects: Cash FlowYearProject AProject B0-$420,000-$420,0001$140,000$400,0002$230,000$110,0003$331,000$140,000The appropriate discount rate is 8.5%.Calculate the internal rate of return (IRR) for both projects, and determine which project should be accepted based on IRR.
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work.
Use the following information to answer the next three questions. Consider the following cash flows: Year...
Use the following information to answer the next three questions. Consider the following cash flows: Year Cash Flow 0 -$2,110,000 1 1,000,000 2 450,000 3 790,000 4 890,000 Assume a discount rate of 17.5 percent. What is the payback period? Round your answer to two decimal places. What is the net present value (NPV) rounded to the nearest dollar? What is the internal rate of return? please show work
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT