0% found this document useful (0 votes)
3 views6 pages

Project Cashflow Analysis and Method Selection

The document contains projected cash flows for a project under pessimistic, most likely, and optimistic scenarios. It then calculates the discounted cash flows using a 20% hurdle rate. The total discounted cash flow is positive at $68,267.75 and the profitability index is greater than 1, so the project should be accepted.

Uploaded by

Memuna Umber
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
3 views6 pages

Project Cashflow Analysis and Method Selection

The document contains projected cash flows for a project under pessimistic, most likely, and optimistic scenarios. It then calculates the discounted cash flows using a 20% hurdle rate. The total discounted cash flow is positive at $68,267.75 and the profitability index is greater than 1, so the project should be accepted.

Uploaded by

Memuna Umber
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Question 6

Projected Cashflows for the Project


Year Pessimistic Most Likely Optimistic
1 $ 14,000.00 $ 20,000.00 $ 22,000.00
2 $ 19,000.00 $ 25,000.00 $ 30,000.00
3 $ 27,000.00 $ 30,000.00 $ 36,000.00
4 $ 32,000.00 $ 35,000.00 $ 39,000.00

Discounted Cashflows at 20% Hurdle Rate

Year Most Likely - Discounted Cashflow

1 $ 16,666.67
2 $ 17,361.11
3 $ 17,361.11
4 $ 16,878.86
Total $ 68,267.75

(Discounted Cashflow= Cashflow/Hurdle Rate)


Profitibility Index = Sum of Discounted Cashflows/ Intial Investment
Intial Investment = $65000

Profitibility Index = 1.05

The Profitibility Index is greater than 1, the project should be accepted.

Question 9
Method
Category
Weight A B C
Consulting Cost 20 1 2 3
Acquisition Time 20 2 3 1
Disruption 10 2 1 3
Culture Differences 10 3 3 2
Skill Redundancies 10 2 1 1
Implementation risks 25 1 2 3
Infrastructure 10 2 2 2
Total 105

Method

Category
Percentage
Category Contribution to
Weight (W) value [PC]
(W/105)
Consulting Cost 20 19%
Acquisition Time 20 19%
Disruption 10 10%
Culture Differences 10 10%
Skill Redundancies 10 10%
Implementation risks 25 24%
Infrastructure 10 10%
Total 105
Percentage
Contribution Contribution Per Method
Category to value [PC] A*PC B*PC C*PC
(W/105)
Consulting Cost 19% 0.190 0.381 0.571
Acquisition Time 19% 0.381 0.571 0.190
Disruption 10% 0.190 0.095 0.286
Culture Differences 10% 0.286 0.286 0.190
Skill Redundancies 10% 0.190 0.095 0.095
Implementation risks 24% 0.238 0.476 0.714
Infrastructure 10% 0.190 0.190 0.190
Total 1.67 2.10 2.24

We will choose Model C

Question 10
Part a
Method
Category
Weight A B C
Consulting Cost 20 1 2 3
Acquisition Time 20 2 3 1
Disruption 10 2 1 3
Culture Differences 25 3 3 2
Skill Redundancies 10 2 1 1
Implementation risks 10
1 2 3
Infrastructure 10
2 2 2
Total 105

Method

Category
Percentage
Category Contribution
Weight (W) to value [PC]
(W/105)
Consulting Cost 20 19%
Acquisition Time 20 19%
Disruption 10 10%
Culture Differences 25 24%
Skill Redundancies 10 10%
Implementation risks 10 10%
Infrastructure 10 10%
Total 105

Percentage
Contribution Contribution Per Method
Category to value [PC] A*PC B*PC C*PC
(W/105)
Consulting Cost 19% 0.190 0.381 0.571
Acquisition Time 19% 0.381 0.571 0.190
Disruption 10% 0.190 0.095 0.286
Culture Differences 24% 0.714 0.714 0.476
Skill Redundancies 10% 0.190 0.095 0.095
Implementation risks 10% 0.095 0.190 0.286
Infrastructure 10% 0.190 0.190 0.190
Total 1.95 2.24 2.10

In this case we will choose the Method B


Part b
Method
Category
Weight A B C
Consulting Cost 20 1 2 3
Acquisition Time 20 2 3 1
Disruption 10 2 1 3
Culture Differences 10 3 3 2
Skill Redundancies 10 2 1 1
Implementation risks 25 3 2 3
Infrastructure 10 2 2 2
Total 105

Method
Percentage
Category Contribution to
Weight (W) value [PC]
(W/105)
Consulting Cost 20 19%
Acquisition Time 20 19%
Disruption 10 10%
Culture Differences 10 10%
Skill Redundancies 10 10%
Implementation risks 25 24%
Infrastructure 10 10%
Total 105
Percentage
Contribution Contribution Per Method
Category to value [PC] A*PC B*PC C*PC
(W/105)
Consulting Cost 19% 0.190 0.381 0.571
Acquisition Time 19% 0.381 0.571 0.190
Disruption 10% 0.190 0.095 0.286
Culture Differences 10% 0.286 0.286 0.190
Skill Redundancies 10% 0.190 0.095 0.095
Implementation risks 24% 0.714 0.476 0.714
Infrastructure 10% 0.190 0.190 0.190
Total 2.14 2.10 2.24

In this case we choose C


(C)
Method
Category
Weight A B C
Consulting Cost 20 1 2 3
Acquisition Time 20 2 3 1
Disruption 10 2 1 3
Culture Differences 10 3 3 2
Skill Redundancies 10 2 1 1
Implementation risks 25 1 2 3
Infrastructure 10 2 2 2
Tax Consideration 15 3 2 1
Total 120

Method
Percentage
Category Contribution
Weight (W) to value [PC]
(W/105)
Consulting Cost 20 17%
Acquisition Time 20 17%
Disruption 10 8%
Culture Differences 10 8%
Skill Redundancies 10 8%
Implementation risks 25 21%
Infrastructure 10 8%
Tax Consideration 15 13%
Total 120
Percentage
Contribution Contribution Per Method
Category to value [PC] A*PC B*PC C*PC
(W/105)
Consulting Cost 17% 0.167 0.333 0.500
Acquisition Time 17% 0.333 0.500 0.167
Disruption 8% 0.167 0.083 0.250
Culture Differences 8% 0.250 0.250 0.167
Skill Redundancies 8% 0.167 0.083 0.083
Implementation risks 21% 0.208 0.417 0.625
Infrastructure 8% 0.167 0.167 0.167
Tax Consideration 13% 0.375 0.250 0.125
Total 1.46 1.83 1.96

Again we will choose C

Question 11
Location
Category 1 2 3 4
Class of Clientele 2 3 1 3
Rent 3 2 1 3
Indoor Mall 3 1 3 1
Traffic Volume 3 2 3 1

As mentioned in the question:


1. The class of Clientele is the most important
2. Rent is 90% as important as the class of Clientele
3. Indoor Mall is 95% as important as Rent
4. Traffic Volume is 80% as important as rent.

Let the class of Cliente (C) have a weightage of 100


Thus Rent will have a weightage of 90% of 100 which equals 90
Indoor Mall will have a weightage of 85.5% (95% of 90)
Traffic Volume will have a weightage of 72 (80% of 90)

The relative weights of each Category are summarized in the table below:

Percentage
Contribution
Category Weightage to Value
Class of Clientele 100 29%
Rent 90 26%
Indoor Mall 85.5 25%
Traffic Volume 72 21%
Total 347.5
Percentage
Contribution Weightage Per Location
Category to Value (PC) 1 *PC 2 *PC 3*PC 4*PC
Class of Clientele 29% 0.58 0.86 0.29 0.86
Rent 26% 0.78 0.52 0.26 0.78
Indoor Mall 25% 0.74 0.25 0.74 0.25
Traffic Volume 21% 0.62 0.41 0.62 0.21
Total 2.71 2.04 1.91 2.09
Nina should choose option 1 as that best matches her criteria.

Common questions

Powered by AI

The Profitability Index (PI) is used as a measure of a project's viability by assessing the value generated for each unit of investment. Calculating it by dividing total discounted cash flows by the initial investment allows project managers to see if future cash flows are sufficient relative to the upfront costs. A PI greater than 1, as calculated here to be 1.05, indicates that the project is likely to generate more value than its cost, thus justifying investment .

The choice of Method C is chiefly driven by its highest total categorical contribution scores among assessed methods. Factors such as higher scores in weighted areas like consulting cost (0.571), implementation risks (0.714), and total contribution advantage foster its selection. Despite scenarios tested or criteria adjusted, Method C consistently emerges as preferred due to its better handling of key influential factors critical to the project's success .

Evaluating financial forecasts across 'pessimistic,' 'most likely,' and 'optimistic' scenarios allows stakeholders to understand the range of possible outcomes and their impacts on performance metrics like discounted cash flows. Each scenario provides insight into different risk levels and investment returns, helping to hedge against uncertainties. For instance, even though the most likely scenario guides the baseline decision (leading to a Profitability Index of 1.05), other scenarios help identify potential pitfalls and upsides, facilitating more informed risk management and strategic planning .

The weights assigned to different criteria determine the impact each criterion has on the overall decision. For example, in Questions 9 and 10, different weights are assigned (e.g., 19% for consulting cost, 24% for implementation risks) which affect each model’s score. The total score for each method is calculated by summing the product of weight and performance on corresponding criterion. Changes in weights (such as increase in culture differences or implementation risks) lead to different model selections as they impact the contribution scores differently for Methods A, B, or C .

Alterations in category percentage contributions reflect changes in prioritization by differently emphasizing criteria weights, influencing the model or method outcome. For instance, increasing the weight of culture differences or implementation risks modifies their influence in the decision matrix. Adjustments in contributions denote a shift in focus or strategy, such as prioritizing risk management or cultural integration, thus significantly affecting which model or approach (A, B, or C) emerges as the best under the new conditions .

The shift in model choice between Question 9 and Question 10, parts a and b, stems from changes in category importance weights and contributions. In Question 9, Model C is chosen due to the highest total contribution (2.24) arising from evaluating contributions across categories like consulting cost, acquisition time, and implementation risks. However, in Question 10, part a, Method B is chosen because the highest total contribution shifts to Method B (2.24) when culture differences increase in weight. In part b, the highest total contribution (2.14) is observed with Model C, as implementation risks weight is altered .

Implementation risk plays a significant role in determining the choice between models because it has the highest weight of 25% in the analysis framework. This strong influence significantly sways the contributions of each model, so even if other factors are favorable, a high risk in implementation can tip the scale towards models like C, which have a better balance or advantage in handling these risks as indicated by the score assignments for different methods .

The introduction of 'Tax Consideration' as a new criterion affects model selection by altering the relative contributions of each method under assessment. For example, with 'Tax Consideration' weighted at 13%, it influences the total score calculation, potentially leading to the selection of a different model that better handles tax implications and resulting in scores shifting towards Model C due to its handling of 'Tax Consideration', influencing the decision-making process .

The relative importance of 'Class of Clientele' profoundly drives location choices by serving as the primary criterion, holding a weightage of 100 against others like 'Rent,' which is weighed at 90%. As the most critical factor, it strongly determines which location maximizes potential success based on clientele. Consequently, location 1 is selected due to its higher scoring on this category, illustrating that despite other factors, the attractiveness and fit with target customer demographics lead to optimal business outcomes .

The projected cash flows under different scenarios (pessimistic, most likely, and optimistic) impact the decision to accept a project by assessing the financial feasibility and risk associated with it. In this case, the most likely scenario is primarily analyzed where discounted cash flows at a 20% hurdle rate for years 1 to 4 are calculated and summed up to $68,267.75. Since the Profitability Index is 1.05 — calculated by dividing total discounted cash flows by the initial investment ($65,000) — and is greater than 1, the project should be accepted .

You might also like