Question

In: Finance

For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index...

For the following two projects, determine the

  1. Payback Period
  2. Discounted Payback
  3. Net Present Value
  4. Profitability Index (Benefit-Cost Ratio)
  5. Internal Rate of Return
  6. Modified Internal Rate of Return

           

Project A

Project B

Year

Net Income

Cash Flow

Net Income

Cash Flow

0

(15,000)

(19,000)

1

5,000

6,000

3,000

4,000

2

5,000

6,000

5,000

6,000

3

5000

6,000

7,000

8,000

4

5,000

6,000

11,000

12,000

Risk Index

1.80

.60

The firm’s cost of capital ko is 15% and the risk free rate Rf is 10%. The firm assesses risk and assigns a risk index to determine a risk adjusted discount rate. An index of 1.0 would be assigned to an average risk project.

To determine risk adjusted rates the firm uses the following equation:

Risk Adjusted Rate (RADR) = Rf + [Risk Index (ko – Rf)

Task: Rank the projects in accordance with each method of analysis.

Solutions

Expert Solution

Project A :

Year Cash Flow Cummulative Cashflow Discounting factor = 1/ ( 1+ r)^n Present value Cummulative present value
1 6000 6000 0.840336134 5042.016807 5042.016807
2 6000 12000 0.706164819 4236.988913 9279.00572
3 6000 18000 0.593415814 3560.494885 12839.5006
4 6000 24000 0.498668751 2992.012508 15831.51311
Total 15831.51311

Risk adjusted rated for Project A = 10 + 1.8* ( 15 - 10) = 19%

Payback period = 2 + ( 15000-12000) / 6000 = 2.5 years

Discounted payback period = 3 + ( 15000 - 12839) / 2992.01 = 3.72 years

Net present value = present value of cash inflows - initial investment = 15831.51 - 15000 = 831.51

Profitability index = Present value of cash inflows / initial invetsmnet = 15831.51 / 15000 = 1.055

Project B :

Year Cash Flow Cummulative Cashflow Discounting factor = 1/ ( 1+ r)^n Present value Cummulative present value
1 4000 4000 0.884955752 3539.823009 3539.823009
2 6000 10000 0.783146683 4698.8801 8238.703109
3 8000 18000 0.693050162 5544.401298 13783.10441
4 12000 30000 0.613318728 7359.824732 21142.92914
Total 21142.92914

Payback period = 3 + ( 19000 - 18000) / 12000 = 3.08 years

Discounted payback period = 3 + ( 19000 - 13783) / 7359.82 = 3.71 years

Net present value = 21142.93 - 19000 = 2142.93

PI = 21142.93 / 19000 = 1.113


Related Solutions

Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR. A. Year ATCF 0 $(60,000) 1 21,000 2 27,000 3 24,000 4 16,000 Assume a 16% required rate of return
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR B. Year ATCF 0 (100,000) 1 (320,000) 2 130,000 3 185,000 4 200,000 5 195,000 6 150,000 Assume a 20% required rate of return
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and...
Use the discounted payback method, the net present value method, and the profitability index method to...
Use the discounted payback method, the net present value method, and the profitability index method to evaluate the following project: Year 0 Initial Investment 900,000 Year 1 Income 175,000 Year 2 Income 450,000 Year 3 Additional investment 100,000 Year 4 Income 630,000 Discount rate 7% DPB __________ years NPV ______________ PI ______________ Would you recommend that the board accept or reject this project? ________________ Accept or reject
Please Calculate the WACC, the discounted payback period, and the net present value for the following...
Please Calculate the WACC, the discounted payback period, and the net present value for the following scenario. Show all work and clearly show how you came to your answers. A municipal stadium owned by a city stadium authority is thinking about updating it's grass field to turf. New turf will cost $750,000. A local company has offered to give you $100,000 to put their logo on the turf, which you will happily take if you decide to go forward with...
Calculate the payback period, net present value, profitability index, and internal rate of return for Project...
Calculate the payback period, net present value, profitability index, and internal rate of return for Project A. Assume a discount rate of 20%. Should the firm accept or reject Project A? Explain. If the firm must choose between Project A and Project B, which is the better choice? Explain. Under what circumstances should the modified internal rate of return be used instead of the standard internal rate of return? Project A Project B Year Cash Flow Year Cash Flow 0...
Payback period, net present​ value, profitability​ index, and internal rate of return​ calculations)  You are considering...
Payback period, net present​ value, profitability​ index, and internal rate of return​ calculations)  You are considering a project with an initial cash outlay of ​$73 comma 00073,000 and expected cash flows of ​$21 comma 17021,170 at the end of each year for six years. The discount rate for this project is 9.99.9 percent. a.  What are the​ project's payback and discounted payback​ periods? b.  What is the​ project's NPV? c.  What is the​ project's PI? d.  What is the​ project's...
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3....
Capital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3. Net Present Value 4. Profitability Index (Benefit-Cost Ratio) 5. Internal Rate of Return 6. Modified Internal Rate of Return Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital...
Calculate? (a) net present? value, (b) payback? period, (c) discounted payback? period, and? (d) internal rate...
Calculate? (a) net present? value, (b) payback? period, (c) discounted payback? period, and? (d) internal rate of return. Cost of the equipment $166,000 Reduced labor costs $45,000 Estimated life of the equipment 10 years Terminal disposal value ?$0 ?After-tax cost of capital 12 ?% Tax rate 20 ?% Assume depreciation is calculated on a? straight-line basis for tax purposes. Assume all cash flows occur at? year-end except for initial investment amounts. Calculate? (a) net present? value, (b) payback? period, (c)...
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1)...
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1) Select three of the analytical tools and provide supportive statements explaining how each can be used to screen and/or rank future available projects. 2) Select one of the analytical tools listed and provide supportive statements explaining why you believe it provides the most important information in the decision process.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT