Question
In: Finance
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present...
Capital Budgeting Assignment
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 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.
Solutions
Expert Solution
| 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 |
 jeff jeffy answered 1 year agoRelated 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
the following techniques for analyzing projects: Payback Rule Discounted Payback Period Net Present Value Internal Rate...the following techniques for analyzing projects:
Payback Rule
Discounted Payback Period
Net Present Value
Internal Rate of Return
Why must corporate managers use multiple techniques of project
evaluation?
Which technique is most commonly used and why?
Describe several ways the techniques above can be used as one
progresses in their professional career. (Identify specific types
of projects that can be analyzed and discuss the advantages and
disadvantages of using the techniques above)
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...
Net Present Value and Discounted Payback Period Using the amount of capital expenditures incurred in 2018...Net Present Value and Discounted Payback Period
Using the amount of capital expenditures incurred in 2018
-1976.4 (which will consider to be an initial investment outflow),
assume the company will generate operating cash inflows of $205
million the first year, $385 million the second year, $478 million
the third year, $599 million the fourth year, $625 million the
fifth year, and $100 million the year six.
a.) What is the NPV using the company’s WACC of 3.56 and what is...
(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...
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.
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|