Question
In: Finance
Capital 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 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 |
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 |
Solutions
Expert Solution
Project A :
| Year | Cash Flow | Cummulative Cashflow | Discounting factor = 1/ ( 1+ r)^n | Present value | Cummulative present value |
| 1 | 6000 | 6000 | 0.840336134 | 5042.016807 | 5042.016807 |
| 2 | 6000 | 12000 | 0.706164819 | 4236.988913 | 9279.00572 |
| 3 | 6000 | 18000 | 0.593415814 | 3560.494885 | 12839.5006 |
| 4 | 6000 | 24000 | 0.498668751 | 2992.012508 | 15831.51311 |
| Total | 15831.51311 |
Risk adjusted rated for Project A = 10 + 1.8* ( 15 - 10) = 19%
Payback period = 2 + ( 15000-12000) / 6000 = 2.5 years
Discounted payback period = 3 + ( 15000 - 12839) / 2992.01 = 3.72 years
Net present value = present value of cash inflows - initial investment = 15831.51 - 15000 = 831.51
Profitability index = Present value of cash inflows / initial invetsmnet = 15831.51 / 15000 = 1.055
Project B :
| Year | Cash Flow | Cummulative Cashflow | Discounting factor = 1/ ( 1+ r)^n | Present value | Cummulative present value |
| 1 | 4000 | 4000 | 0.884955752 | 3539.823009 | 3539.823009 |
| 2 | 6000 | 10000 | 0.783146683 | 4698.8801 | 8238.703109 |
| 3 | 8000 | 18000 | 0.693050162 | 5544.401298 | 13783.10441 |
| 4 | 12000 | 30000 | 0.613318728 | 7359.824732 | 21142.92914 |
| Total | 21142.92914 |
Payback period = 3 + ( 19000 - 18000) / 12000 = 3.08 years
Discounted payback period = 3 + ( 19000 - 13783) / 7359.82 = 3.71 years
Net present value = 21142.93 - 19000 = 2142.93
PI = 21142.93 / 19000 = 1.11
jeff jeffy answered 2 years agoRelated Solutions
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...
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
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...
q.1 Discounted payback period. Becker, Inc. uses the discounted payback period for projects costing less than...
q.1
Discounted payback
period.
Becker, Inc. uses the discounted payback period for projects
costing less than $25,000 and has a cutoff period of four years
for these small-value projects. Two projects, R and S, are under
consideration. Their anticipated cash flows are listed in the
following table. If Becker uses a discount rate of
4 %4%
on these projects, are they accepted or rejected? If it uses a
discount rate of
12 %12%?
A discount rate of
18 %18%?
Why...
The Basics of Capital Budgeting: Payback Period Payback Period Payback period was the earliest ________ selection...
The Basics of Capital Budgeting: Payback Period
Payback Period
Payback period was the earliest ________ selection
criterion.
-Select-
capital structure
financial statement
capital budgeting
The _________
-Select-
NPV
MIRR
IRR
payback
is a "break-even" calculation in the sense that if a project's
cash flows come in at the expected rate, the project will break
even. The equation is:
The
-Select-
shorter
longer
a project's payback, the better the project is. However, payback
has 3 main disadvantages: (1) All dollars received...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback
Period for the following project:
1. An initial investment of $20,000 with expected after-tax
operating cash flows of $125,000 per year for each of the
next 3 years. However, in preparation for its
termination at the end of year 3, an additional investment of
$350,000 must be made at the end of Year 2.
Please show all work in excel.
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate
its payback period and discounted payback period. The required rate
of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37500 $11250
$11250 $15000 $6000 $6000 The discounted payback period is 0.16
year longer than the payback period. 0.80 year longer than the
payback period. 1.27 years longer than the payback period. 1.85
years longer than the payback period.
Given the following cash flows for a capital project, calculate its payback period and discounted payback...
Given the following cash flows for a capital project, calculate
its payback period and discounted payback period. The required rate
of return is 8 percent.
Year
0
1
2
3
4
5
Cash Flows
$-56900
$13650
$18050
$25200
$10000
$5000
The discounted payback period is
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT