Question

In: Finance

Investiment opportuity as folows: Year 0, unknown cash flow, Year 1 = 200 cash flos,,Year 2...

Investiment opportuity as folows: Year 0, unknown cash flow, Year 1 = 200 cash flos,,Year 2 = 400 cash flow, Year 3 = -100 cash flow, year 4= 500 cash flow, Year 5 = 200 cash flow

a. If other investments with comparble risk are earning 12% then how mudh shoud you be willing to pay for this investment?

If you purchace it for 800 then what is the anual rate of retun on the investment?

Solutions

Expert Solution

a.       If comparable projects earns 12% then we should calculate projects initial cash flow keeping IRR or rate as 12%

CF0 = ?

CF0 = CF1 /1.12^1 + CF2/1.12^2 + CF3/1.12^3 + CF4/1.12^4 + CF5/1.12^5

CF0 = 200 /1.12^1 + 400/1.12^2 + (-100)/1.12^3 + 500/1.12^4 + 200/1.12^5

CF0 = 178.54 + 318.76 + (71.14) + 317.53 + 113.38

CF0 = 857.52

b.       For getting annual rate of return from different cash flows, we need to perform IRR, for performing IRR we need to work on trial and error. To keep this clean IRR rate is directly used.

CF0 = - 800 [Given]

-CF0/(1+r)^0 + CF1 /(1+r)^1 + CF2/(1+r)^2 + CF3/(1+r)^3 + CF4/(1+r)^4 + CF5/(1+r)^5 = 0

We need to perform trial and error for getting r or rate here, we used first 13% then 14% and then interpolated both the trials to get the discounting rate 14.79% which can make our following equation equal to zero.

-CF0/(1+14.79%)^0 + CF1 /(1+14.79%)^1 + CF2/(1+14.79%)^2 + CF3/(1+14.79%)^3 + CF4/(1+14.79%)^4 + CF5/(1+14.79%)^5 = 0

-800 + 174.2312048 + 303.5651273 - 66.11314733 + 287.9743328 + 100.3482299 = 0

The sum is near to zero hence our annual rate of return = 14.79%

(We can fix rate or r as 13% and 14% to see the results of 36.16 and 15.64 respectively for clearer understanding)


Related Solutions

Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2...
Consider the following two projects: Project Year 0 Cash Flow Year 1 Cash Flow Year 2 Cash Flow Year 3 Cash Flow Year 4 Cash Flow Discount Rate A -100 40 50 60 N/A .15 B -73 30 30 30 30 .15 Assume that projects A and B are mutually exclusive. The correct investment decision and the best rational for that decision is to: Group of answer choices a.invest in project A since NPVB < NPVA. b.invest in project B...
Consider the following cash flows:    Year Cash Flow 0 $-28,400       1 15,300       2...
Consider the following cash flows:    Year Cash Flow 0 $-28,400       1 15,300       2 13,600       3 10,000          Requirement 1: What is the profitability index for the above set of cash flows if the relevant discount rate is 8 percent? (Do not round intermediate calculations. Round your answer to 3 decimal places (e.g., 32.161).)      Profitability index       Requirement 2: What is the profitability index if the discount rate is 13 percent? (Do not round...
14. Following is project A's cash flow table Year Cash Flow 0 -26,000 1 6,200 2...
14. Following is project A's cash flow table Year Cash Flow 0 -26,000 1 6,200 2 6,200 3 6,200 4 6,200 5 9,700 Assuming that the project is found by 40% of equity and 60% of debt. The required rate of return of equity is 10%. The yield of debt is 6% and the tax rate is 30%. Using the above information to answer Q1 - Q4. Q1) What is the WACC of this project? a)6.52% b)4% c)7.43% d)5% Q2)...
Year Cash flow 0 59000 1 -34000 2 -39000 a. What is the IRR for this...
Year Cash flow 0 59000 1 -34000 2 -39000 a. What is the IRR for this project? b. What is the NPV of this project if the required return is 12 percent? c. What is the NPV of the project if the required return is 0 percent? d. What is the NPV of the project if the required return is 24 percent?
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....
Year Cash Flow (X) Cash FLow (Y) 0 -23000 -23000 1 10490 12000 2 10900 9360...
Year Cash Flow (X) Cash FLow (Y) 0 -23000 -23000 1 10490 12000 2 10900 9360 3 10500 10400 Calculate the IRR for each project. What is the crossover rate for these two projects?
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2...
A project has the following cash flows: Year Cash Flow 0 –$ 16,100 1 6,800 2 8,100 3 6,600 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) NPV $ What is the NPV at a discount rate of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV $ What is the NPV...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2...
A project has the following cash flows: Year Cash Flow 0 $ 73,000 1 –54,000 2 –27,600 What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return             % What is the NPV of this project if the required return is 5 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round...
A project has the following cash flows:    Year Cash Flow 0 $64,100 1 –30,100 2...
A project has the following cash flows:    Year Cash Flow 0 $64,100 1 –30,100 2 –48,100    a. What is the IRR for this project?    b. What is the NPV of this project, if the required return is 11.5 percent?    c. NPV at 0 percent?    d. NPV at 23 percent?
A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2...
A project has the following cash flows: Year Cash Flow 0 –$ 15,600 1 6,300 2 7,600 3 6,100     What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)      NPV $       What is the NPV at a discount rate of 9 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)      NPV $   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT