Question

In: Finance

Question 5 Given the following cash flows, for the two independent projects A and B, calculate...

Question 5

  1. Given the following cash flows, for the two independent projects A and B, calculate
    1. Payback Period                                                               
    2. Accounting rate of return                                               
    3. Net Present Value                                                         
    4. Profitability index                                                          

And recommend acceptance or rejection of projects considering individual techniques of capital budgeting. A rate of 10 % has been selected for the NPV analysis.

Project A

Project B

Initial outlay

$50,000

$100,000

Cash inflows

Year 1

$10,000

$ 25,000

Year 2

15,000

25,000

Year 3

20,000

25,000

Year 4

25,000

25,000

Year 5

30,000

25,000

                                                                     

  1. Explain the distinctive features of capital budgeting decisions.                                                                                                       

Solutions

Expert Solution

Present Value (PV) of Cash Flow:
(Cash Flow)/((1+i)^N)
i=Discount Rate=10%=0.1
N=Year of Cash Flow
ANALYSIS OF PROJECT A
N Year 0 1 2 3 4 5 SUM
CF Cash Flow ($50,000) $10,000 $15,000 $20,000 $25,000 $30,000 $50,000
PV=CF/(1.1^N) Present Value of cash Flow ($50,000) $9,091 $12,397 $15,026 $17,075 $18,628 $22,217
Cumulative Cash Flow ($50,000) -$40,000 -$25,000 -$5,000 $20,000 $50,000
NPV=Sumof PV Net Present Value(NPV) $22,217
Payback Period(3+(5000/25000)             3.20 YEARS (Period in which Cumulative cash flow=NIL)
Accounting Rate of Return= Average Return/Investment
TotalReturn =(50000+50000) $100,000
Average Return per year=100000/5 $20,000
Accounting Rate of Return= 20000/50000             0.40
Accounting Rate of Return= (Percentage) 40%
Profitability Index =(NPV+Initial Investment)/InitialInvestment
Profitability Index =(22217+50000)/50000             1.44
ANALYSIS OF PROJECT B
N Year 0 1 2 3 4 5 SUM
CF Cash Flow ($100,000) $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
PV=CF/(1.1^N) Present Value of cash Flow ($100,000) $22,727 $20,661 $18,783 $17,075 $15,523 ($5,230)
Cumulative Cash Flow ($100,000) -$75,000 -$50,000 -$25,000 $0 $25,000
NPV=Sumof PV Net Present Value(NPV) ($5,230)
Payback Period             4.00 YEARS (Period in which Cumulative cash flow=NIL)
Accounting Rate of Return= Average Return/Investment
TotalReturn =(25000+100000) $125,000
Average Return per year=100000/5 $25,000
Accounting Rate of Return= 25000/100000             0.25
Accounting Rate of Return= (Percentage) 25%
Profitability Index =(NPV+Initial Investment)/InitialInvestment
Profitability Index =(-5230+100000)/100000             0.95
CAPITAL BUDGETING DECISION:
Determine the appropriate discount rate based on cost of capital and risk factor
Find the initial cash flow considering investment in plant & machinery, working capital etc
Determine annual operating cash flow taking into account depreciation, taxes, effect of the project on other income and expenses
Determine TerminalCash Flow considering release of working capital,Salavage of equipment etc
In mutually exclusive projects normally NPV determines which project should be accepted
Other Evaluation criterian are used to initially short list the projects
These criterian may be IRR, Payback period, etc

Related Solutions

Given the following two projects and their cash​ flows, ​, calculate the discounted payback period with...
Given the following two projects and their cash​ flows, ​, calculate the discounted payback period with a discount rate of 6%, 8​%,and 18​%. What do you notice about the payback period as the discount rate​ rises? Explain this relationship. With a discount rate of 6​%, the cash outflow for project A​ is:  A. recovered in 5 years. B.recovered in 3.16 years. C.recovered in 3 years. D.never fully recovered.  Cash Flow A B   Cost ​ $8,000 ​$100,000   Cash flow year 1...
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
choosing between two projects. The cash flows for the projects are given in the following table​...
choosing between two projects. The cash flows for the projects are given in the following table​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A negative $ 48 −$48 $ 24 $24 $ 21 $21 $ 19 $19 $ 15 $15 B negative $ 102 −$102 $ 20 $20 $ 41 $41 $ 48 $48 $ 58 $58 a. What are the IRRs of the two​ projects? b. If your discount rate is 4.7 %...
Given the following cash flows for a two mutually exclusive projects (A&B) and assuming 16% cost...
Given the following cash flows for a two mutually exclusive projects (A&B) and assuming 16% cost of capital; answer the next 2 questions: year Project A Project B 0 -5000 -1000 1 2500 600 2 2500 600 3 2500 600 1)  Which project should be accepted, if any and why? Project B; it has a higher IRR and PI Neither project should be accepted, they both have negative NPVs Both project should be accepted; they have IRRs greater than the cost...
You are given the following two projects cash flows that will be used to illustrate the...
You are given the following two projects cash flows that will be used to illustrate the application of the various capital techniques in project analysis. PROJECTS / CASHFLOWS (RM) YEAR A B 0 (100,000) (120,000) 1 30,000 20,000 2 30,000 30,000 3 30,000 40,000 4 30,000 40,000 5 30,000 50,000 a. Identify the payback period for both of the project. (2mark) b. Assume that the firm’s cost of capital is 10%, calculte the Net Present Value (NPV) for both projects....
Two projects A and B with the following cash flows with a fix interest rate of...
Two projects A and B with the following cash flows with a fix interest rate of 12%. A. Use the present worth to select which project is better? Table 1 Project A 0 1 2 3 -9000 3000 3000 6000 Table 2 Project B 0 1 2 3 -12000 4000 3000 8000 B. Repeat the question in part A using AW analysis C. Repeat the question in part A using FW analysis
The following are the cash flows of two projects: Year    Project A    Project B...
The following are the cash flows of two projects: Year    Project A    Project B 0 -250    -250 1    130    150 2    130    150 3    130    150 4    130 If the opportunity cost is 10%, what is the profitability index for each project? Project Profitability Index A B   
You are considering two independent projects with the following cash flows. The required return for both...
You are considering two independent projects with the following cash flows. The required return for both projects is 10%. Given this information, which one of the following is correct? Year Project A Project B 0 -$950,000 -$125,000 1 $330,000    $   55,000 2 $400,000    $   50,000 3 $450,000    $ 50,000 A. You should accept project B since it has the higher IRR and reject project A because you cannot accept both projects. B. You should accept project A because it has...
You are choosing between two projects. The cash flows for the projects are given in the...
You are choosing between two projects. The cash flows for the projects are given in the following table​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$52 $27 $19 $22 $17 B −$100 $22 $41 $48 $61 a. What are the IRRs of the two​ projects? b. If your discount rate is 5.4%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently?
You are choosing between two projects. The cash flows for the projects are given in the...
You are choosing between two projects. The cash flows for the projects are given in the following table​ ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A −$52 $27 $19 $18 $17 B −$101 $19 $40 $51 $58 a. What are the IRRs of the two​ projects? b. If your discount rate is 5.4%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently? a. What...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT