In: Finance
Question 5
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 |
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 | ||||||||||||