In: Finance
Capital Budgeting Assignment
For the following two projects, determine the
|
Project A |
Project B |
||||
Year |
Net Income |
Cash Flow |
Net Income |
Cash Flow |
||
0 |
(15,000) |
(19,000) |
||||
1 |
5,000 |
6,000 |
3,000 |
4,000 |
||
2 |
5,000 |
6,000 |
5,000 |
6,000 |
||
3 |
5000 |
6,000 |
7,000 |
8,000 |
||
4 |
5,000 |
6,000 |
11,000 |
12,000 |
||
Risk Index |
1.80 |
.60 |
The firm’s cost of capital ko is 15% and the risk free rate Rf is 10%. The firm assesses risk and assigns a risk index to determine a risk adjusted discount rate. An index of 1.0 would be assigned to an average risk project.
To determine risk adjusted rates the firm uses the following equation:
Risk Adjusted Rate (RADR) = Rf + [Risk Index (ko – Rf)
Task: Rank the projects in accordance with each method of analysis.
PROJECT A:: | |||||||||||||
Risk adjusted discount rate = 10%+1.80*(15%-10%) = | 19.00% | ||||||||||||
Year | Cash flow | Cumulative cash flow | PVIF at 19% | PV at 19% | Cumulative PV | PVIF at 22% | PV at 22% | PVIF at 21% | PV at 21% | FVIF at 19% | FV at 19% | ||
0 | -15000 | -15000 | 1 | -15000 | -15000 | 1.0000 | -15000 | 1.00000 | -15000 | ||||
1 | 6000 | -9000 | 0.84034 | 5042 | -9958 | 0.8197 | 4918 | 0.82645 | 4959 | 1.68516 | 10111 | ||
2 | 6000 | -3000 | 0.70616 | 4237 | -5721 | 0.6719 | 4031 | 0.68301 | 4098 | 1.41610 | 8497 | ||
3 | 6000 | 3000 | 0.59342 | 3560 | -2160 | 0.5507 | 3304 | 0.56447 | 3387 | 1.19000 | 7140 | ||
4 | 6000 | 9000 | 0.49867 | 2992 | 832 | 0.4514 | 2708 | 0.46651 | 2799 | 1.00000 | 6000 | ||
832 | -38 | 243 | 31748 | ||||||||||
Payback period = 2+3000/6000 = | 2.50 | Years | |||||||||||
Discounted payback = 3+2160/2992 = | 3.72 | Years | |||||||||||
NPV | 832 | ||||||||||||
PI = 15832/15000 = | 1.06 | ||||||||||||
IRR = 21%+1%*243/(243+38) = | 21.86% | ||||||||||||
MIRR = (31748/15000)^(1/4)-1 = | 20.62% | ||||||||||||
PROJECT B:: | |||||||||||||
Risk adjusted discount rate = 10%+0.6*(15%-10%) = | 13.00% | ||||||||||||
Year | Cash flow | Cumulative cash flow | PVIF at 13% | PV at 13% | Cumulative PV | PVIF at 18% | PV at 18% | PVIF at 17% | PV at 17% | FVIF at 13% | FV at 13% | ||
0 | -19000 | -19000 | 1 | -19000 | -19000 | 1.0000 | -19000 | 1.00000 | -19000 | ||||
1 | 4000 | -15000 | 0.88496 | 3540 | -15460 | 0.8475 | 3390 | 0.85470 | 3419 | 1.44290 | 5772 | ||
2 | 6000 | -9000 | 0.78315 | 4699 | -10761 | 0.7182 | 4309 | 0.73051 | 4383 | 1.27690 | 7661 | ||
3 | 8000 | -1000 | 0.69305 | 5544 | -5217 | 0.6086 | 4869 | 0.62437 | 4995 | 1.13000 | 9040 | ||
4 | 12000 | 11000 | 0.61332 | 7360 | 2143 | 0.5158 | 6189 | 0.53365 | 6404 | 1.00000 | 12000 | ||
2143 | -243 | 201 | 34473 | ||||||||||
Payback period = 3+1000/12000 = | 3.08 | Years | |||||||||||
Discounted payback = 3+5217/7360 = | 3.71 | Years | |||||||||||
NPV | 2143 | ||||||||||||
PI = 15832/15000 = | 1.06 | ||||||||||||
IRR = 17%+1%*201/(201+243) = | 17.45% | ||||||||||||
MIRR = (34473/19000)^(1/4)-1 = | 16.06% | ||||||||||||
RANKING: | |||||||||||||
Project A | Project B |
Related SolutionsCapital Budgeting For the following two projects, determine the 1. Payback Period 2. Discounted Payback 3....Capital Budgeting For the following two projects, determine the
1. Payback Period 2. Discounted Payback 3. Net Present Value 4.
Profitability Index (Benefit-Cost Ratio) 5. Internal Rate of Return
6. Modified Internal Rate of Return Project A Project B Year Net
Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000
6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000
8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s
cost of capital...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index...For the following two projects, determine the
Payback Period
Discounted Payback
Net Present Value
Profitability Index (Benefit-Cost Ratio)
Internal Rate of Return
Modified Internal Rate of Return
Project A
Project B
Year
Net Income
Cash Flow
Net Income
Cash Flow
0
(15,000)
(19,000)
1
5,000
6,000
3,000
4,000
2
5,000
6,000
5,000
6,000
3
5000
6,000
7,000
8,000
4
5,000
6,000
11,000
12,000
Risk Index
1.80
.60
The firm’s cost of capital ko is 15% and the risk
free...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...Determine the Payback Period, the Discounted Payback Period, and
the Net Present Value for the following after-tax cash flow
projections. Also tell me whether the IRR is greater or less then
the RRR.
A. Year ATCF
0 $(60,000)
1 21,000
2 27,000
3 24,000
4 16,000
Assume a 16% required rate of return
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...Determine the Payback Period, the Discounted Payback Period, and
the Net Present Value for the following after-tax cash flow
projections. Also tell me whether the IRR is greater or less then
the RRR
B. Year ATCF
0 (100,000)
1 (320,000)
2 130,000
3 185,000
4 200,000
5 195,000
6 150,000
Assume a 20% required rate of return
Please Calculate the WACC, the discounted payback period, and the net present value for the following...Please Calculate the WACC, the discounted payback period, and
the net present value for the following scenario. Show all work and
clearly show how you came to your answers.
A municipal stadium owned by a city stadium authority is
thinking about updating it's grass field to turf. New turf will
cost $750,000. A local company has offered to give you $100,000 to
put their logo on the turf, which you will happily take if you
decide to go forward with...
(a) Define the three capital budgeting techniques: the Payback Period, the Net Present Value (NPV) and...(a) Define the three capital budgeting techniques: the Payback
Period, the Net Present Value (NPV) and the Internal Rate of Return
(IRR).
(b) Briefly discuss the advantages, disadvantages, and decision
rule of each approach.
(c) If the net present value of a project is positive, which of
the following statement is (are) true? Explain why
I. Its payback period is less than or equal to the cut-off
point
II. Its payback period is more than the cut-off point
III. Its...
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...
Find an article where one of the methods of capital budgeting (net present value, payback period,...Find an article where one of the methods of capital budgeting
(net present value, payback period, profitability index, etc ) is
used by a company for a project and the result of the project.
Based on the method used, did the company move forward with the
project or dissolve the project? Your blog must be 300-500
words.
Calculate? (a) net present? value, (b) payback? period, (c) discounted payback? period, and? (d) internal rate...Calculate? (a) net present? value, (b) payback? period, (c)
discounted payback? period, and? (d) internal rate of return.
Cost of the equipment
$166,000
Reduced labor costs
$45,000
Estimated life of the equipment
10
years
Terminal disposal value
?$0
?After-tax cost of capital
12
?%
Tax rate
20
?%
Assume depreciation is calculated on a? straight-line basis for
tax purposes. Assume all cash flows occur at? year-end except for
initial investment amounts.
Calculate? (a) net present? value, (b) payback? period, (c)...
Capital budgeting takes into account computing a projects payback, net present value, internal rate of return...Capital budgeting takes into account computing a projects
payback, net present value, internal rate of return and return on
investments. Discuss the advantages and disadvantages on using each
of these.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|