Question

In: Finance

contains a list of available investment projects and their respective cash flows. Using a cost of...

contains a list of available investment projects and their respective cash flows. Using a cost of capital of 10%, please answer the following questions: 1- Find the payback period, net present value and internal rate of return for each project. (Using excel to do this will save you a lot of time). 2- Based on the results, identify conflicts in ranking the above projects based on the IRR and NPV approaches, i.e. a project that has a higher rank using IRR but a lower rank using NPV and vice versa. You should also provide a discussion of what caused the conflict? 3- Provide a discussion of the advantages and disadvantages of all the capital budgeting techniques covered in this course, and identify methods to overcome the disadvantages (if available). 4- Provide a brief discussion (a small paragraph) of the practicality (uses in real life) of the different capital budgeting methods.
(i gave everything i got from the teacher :D) A cash flow empty


Project A (1,000,000) $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 400,000
Project B (1,000,000)
$ 500,000 $ 500,000 $ 500,000
Project C $     (80,000) $      1,040 $      9,456 $    11,405 $    18,567 $    47,453 $      6,394 $    45,727 $    51,933 $    85,625
Project D $   (400,000) $      4,161 $    37,824 $    45,618 $    74,269 $ 189,812 $    25,577 $ 182,907 $ 207,733 $ 342,499
Project E $     (17,000) $    16,000 $    16,000 $ (16,000) $    16,000 $ (52,000)
Project F $        (5,000) $      2,000 $      2,000 $      2,000 $      2,000 $      2,000
Project G $        (5,000) $             -   $             -   $             -   $             -   $    15,000
Project H $     (20,000) $      7,000 $      7,000 $      7,000 $      7,000 $      7,000

Solutions

Expert Solution

Based on the given information, the NPV, IRR and Payback calculations are worked out in excel and provided below:

Table 1: Computation of IRR: This can be computed using formula in Excel = IRR("range of cashflows", discounting factor%); The IRR shall not be able to arrive in case of Project E, where there are negative cash flows in total;

Table 2: Computation of Net Present Value (NPV) based on the Disounted Cash flows; The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) = 1/(1+10%) = 0.9091; Year 2 = Yeaar 1 factor/(1+discounting factor %) = 0.9091/(1+10%) = 0.8264 and so on;

Next, the cashflows need to be multplied with the respective years' discounting factor, to arrive at the discounting cash flows;

The total of all the discounted cash flows is equal to its respective Project NPV of the Cash Flows;

Table 3: Computation of Pay Back Period: Here, the period is computed for each project, based on cumulative discounted cash flows: If the cumulative value is less than or equal to zero, the period is considered as 12 months (it means that the net cumulative cash flow has not yet paid back the initial invesment); Once the value turns postive in a particular year, the period for such year is observed at a proportion of actual discounted cash flow to the cumulative CF; This gives the period less than 12 months in such year; Once this is computed, total of all the years is taken and divided by 12, to arrive at the Payback period in no.of years.

Table 4: This table provide the comparative analysis of the various techniques used on the all these Projects; It may be observed that the ranking pattern between the NPV and IRR shall differ; This is due mainly the reason that these all are the mutually exclusive projects with different sizes and the difference in the timing of the cashflows;

Eg of Project A: As per NPV, it generates the highest amount of cashflows and is ranked 1, however, as per IRR, it is ranked at 6; This is due to the facts that there are other projects with lower initial investment which shall give benefits much earlier, however, in small value, like Project F (ranked 1 as per IRR); Hence, it is required to assess on the requirement of the project, Capital invesment proposed, Risk appetite on the Pack back period, etc, to evaluate the appropriate project.

Advantages and Disadvantages:

IRR: Advantage: This is very simple to use on various projects to assess based on the cost of capital / Hurdle rate / discounting factor; The IRR provides any small business owner with a quick glance of which projects would generate the greatest potential cash flows;

Main disadvantage of IRR is that it does not consider key factors like duration of the project duration, future costs or the size of a project. The IRR simply compares the project's cash flow to the project's current outflows, excluding all other factors;

NPV: Key advantage is that cash flows from future periods is discounted back to the present to find their value as at present date. The NPV method gives the value indicates how much value the project will create for the company. Project Managers can understand how much a project will contribute to their value, in value terms.

Disadvantage is that NPV takes into consideration the only cash flows of a project. It fails to include other critical costs that can have an impact on the true value of the investment. These costs include opportunity costs and any other costs, etc. Also, dependency on the cost of capital for PV of future cash flows ignores the sensitivity of the discounting factor;

Payback Period: This is mainly useful for any business that is in to making relatively small investments, and so does not need to engage in more complex calculations that take other factors into account. It establishes a comfort to the project evaluators on when their initial outlay shall be covered.

Key disadvantages is that it ignores any cash flows post the Payback period; Incase of any negative cash flows post payback, this technique completely fails in assessing the same (Project E above); Also, this technique is not helpful in assessing the profitability of a project.

While there are other Capital Budeting techniques like Breakeven analysis, Constraint analysis, the above three are key techniques used for any project evaluations;

Real use applications:

These techniques are used mainly in strategic investments which include major CAPEX investments including long term cash flows, Process changes, Business Valuations based on the expected net cashflows from the Business, Investments based on the expected return on the same (basic computations), etc; These help in assessing the profitability of the existing business by investing further in its operations, etc or rather by external business acquisitions.


Related Solutions

Projects A B Cost (initial investment) 40000 250000 Year Cash flows of A Cash flows of...
Projects A B Cost (initial investment) 40000 250000 Year Cash flows of A Cash flows of B 1 10000 40000 2 10000 120000 3 10000 200000 4 10000 200000 5 10000 200000 6 10000 200000 What are the Payback Periods of Projects A, and B? Assume all cash flows are evenly spread throughout the year and already discounted. If the cut-off period ( الفتره المقبوله) is three years, which projects do you accept?
a) Four investment projects have the following net cash flows. The cost of capital is 15%....
a) Four investment projects have the following net cash flows. The cost of capital is 15%. Decide which of them should be accepted using the net present value method. Find the discounted payback period. YEAR PROJECT A PROJECT B PROJECT C PROJECT D 0 (10,000) (15,000) (20,000) (30,000) 1 5,000 5,000 10,000 0 2 5000 5,000 10,000 0 3 20,000 5,000 4,000 100,000 4 1,000 10,000 2,000 120,000 5 - 5,000 - 60,000
Your firm has identified three potential investment projects. The projects and their cash flows are shown​...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​ here:  ​( Project Cash Flow Today ​(millions) Cash Flow in One Year ​(millions) A −$6 $17 B $3 $6 C $16 −$5 Suppose all cash flows are certain and the​ risk-free interest rate is 7%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​...
Your firm has identified three potential investment projects. The projects and their cash flows are shown​ here: Project Cash Flow Today ​(millions) Cash Flow in One Year ​(millions) A −$7 $17 B $6 $6 C $15 −$14 Suppose all cash flows are certain and the​ risk-free interest rate is 7%. a. What is the NPV of each​ project? b. If the firm can choose only one of these​ projects, which should it​ choose? c. If the firm can choose any...
The cash flows for four projects are shown below, along with the cost of capital for...
The cash flows for four projects are shown below, along with the cost of capital for these projects. If these projects are mutually exclusive, which one should be taken? A. Year:                         0                1            2              3            4                  5 Cash flow:                     -$12,000    $4000    $4000      $4000    $4000          $4000 Cost of Capital: 5.0% B. Year:                              0                1            2              3            4                  5 Cash flow:                     -$15,000    $4000    $4000      $4000    $4000          $4000 Cost of Capital: 7.0% C. Year:                              0                1            2              3            4                  5 Cash flow:                     -$20,000    $6000    $6000      $6000    $6000          $6000 Cost of Capital: 8.2% D. Year:                              0               ...
) The cash flows for four projects are shown below, along with the cost of capital...
) The cash flows for four projects are shown below, along with the cost of capital for these projects. If these projects are mutually exclusive, which one should be taken? 28) A) Year: 0 1 2 3 4 5 Cash flow: -$20,000 $6000 $6000 $6000 $6000 $6000 Cost of Capital: 8.2% B) Year: 0 1 2 3 4 5 Cash flow: -$15,000 $4000 $4000 $4000 $4000 $4000 Cost of Capital: 7.0% C) Year: 0 1 2 3 4 5 Cash...
Two investment projects which are mutually exclusive both require a $10,000,000 investment. Projected cash flows are:...
Two investment projects which are mutually exclusive both require a $10,000,000 investment. Projected cash flows are:                                     Year             Project A           Project B                                        1             $3,500,000        $6,500,000                                        2               3,500,000          3,000,000                                        3               3,500,000          3,000,000                                        4               3,500,000          1,000,000 If your discount rate is 12 percent, net present value each project and indicate which you would choose and why.
The following table contains projected cash flows for two mutually exclusive projects. Use the information for...
The following table contains projected cash flows for two mutually exclusive projects. Use the information for questions Part A-Part B. Year Project A Project B 0 -55000 -55000 1 10000 7500 2 9000 7500 3 8000 7500 4 8000 7500 5 7500 8000 6 7500 9000 7 7500 9000 8 7500 10000 Part A. Calculate NPVs for both project and for various interest rates. Annual Interest Rates NPVA NPVB Which Project is preferred 4.22% 3.59% 2.51% Part B. Calculate IRRs...
Create a web page using PHP and HTML that contains a list of movie names available...
Create a web page using PHP and HTML that contains a list of movie names available for rent (at least 10 movies), so that each time you visit the home page, you see a different order of movies in the list. The movie names are required. 2) The rental price for each movie ranges between $1.99 to $7.99. • Create an associative array with a code for the movie as the key (e.g., movie1, movie2, etc.) and the associated rental...
Financial investment analysis is a projects of future cash flows with (often) significant risks associated with...
Financial investment analysis is a projects of future cash flows with (often) significant risks associated with the projections. Investigate and discuss how project risk can impact the financial decisions made with cash flow analyses. What are the methods to consider project risk? Discuss the methods which are best for the variety of financial project options. Explain in detail ?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT