Question
In: Finance
Payback period, net present value, profitability index, and internal rate of return calculations) You are considering...
Payback period, net present value, profitability index, and internal rate of return calculations) You are considering a project with an initial cash outlay of
$73 comma 00073,000
and expected cash flows of
$21 comma 17021,170
at the end of each year for six years. The discount rate for this project is
9.99.9
percent.
a. What are the project's payback and discounted payback periods?
b. What is the project's NPV?
c. What is the project's PI?
d. What is the project's IRR?
a. The payback period of the project is
nothing
years.
Solutions
Expert Solution
a.
| Year | Cash flow stream | Cumulative cash flow | Discounting factor | Discounted cash flows project |
| 0 | -73000 | -73000 | 1 | -73000 |
| 1 | 21170 | -51830 | 1.099 | 19262.96633 |
| 2 | 21170 | -30660 | 1.207801 | 17527.72187 |
| 3 | 21170 | -9490 | 1.327373299 | 15948.79151 |
| 4 | 21170 | 11680 | 1.458783256 | 14512.09418 |
| 5 | 21170 | 32850 | 1.603202798 | 13204.81727 |
| 6 | 21170 | 54020 | 1.761919875 | 12015.30234 |
| Payback period is the time by which undiscounted cashflow cover the intial investment outlay |
| this is happening between year 3 and 4 |
| therefore by interpolation payback period = 3 + (0-(-9490))/(11680-(-9490)) |
| 3.45 Years |
| Discounted payback period is the time by which discounted cashflow cover the intial investment outlay |
| this is happening between year 4 and 5 |
| therefore by interpolation payback period = 4 + (0-(-5748.43))/(7456.39-(-5748.43)) |
| 4.44 Years |
| Where |
| Discounting factor =(1 + discount rate)^(corresponding year) |
| Discounted Cashflow=Cash flow stream/discounting factor |
b.
| Discount rate | 9.900% | ||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Cash flow stream | -73000 | 21170 | 21170 | 21170 | 21170 | 21170 | 21170 |
| Discounting factor | 1.000 | 1.099 | 1.208 | 1.327 | 1.459 | 1.603 | 1.762 |
| Discounted cash flows project | -73000.000 | 19262.966 | 17527.722 | 15948.792 | 14512.094 | 13204.817 | 12015.302 |
| NPV = Sum of discounted cash flows | |||||||
| NPV Project = | 19471.69 | ||||||
| Where | |||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||
| c. | |||||||
| PI= (NPV+initial inv.)/initial inv. | |||||||
| =(19471.69+73000)/73000 | |||||||
| 1.27 | |||||||
| d. | |||||||
| Project | |||||||
| IRR is the rate at which NPV =0 | |||||||
| IRR | 18.56% | ||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Cash flow stream | -73000.000 | 21170.000 | 21170.000 | 21170.000 | 21170.000 | 21170.000 | 21170.000 |
| Discounting factor | 1.000 | 1.186 | 1.406 | 1.666 | 1.976 | 2.342 | 2.777 |
| Discounted cash flows project | -73000.000 | 17856.463 | 15061.562 | 12704.120 | 10715.666 | 9038.445 | 7623.744 |
| NPV = Sum of discounted cash flows | |||||||
| NPV Project = | 0.000 | ||||||
| Where | |||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | ||||||
| IRR= | 18.56% | ||||||
jeff jeffy answered 1 year agoRelated Solutions
Calculate the payback period, net present value, profitability index, and internal rate of return for Project...
Calculate the payback period, net present value, profitability
index, and internal rate of return for Project A. Assume a discount
rate of 20%. Should the firm accept or reject Project A? Explain.
If the firm must choose between Project A and Project B, which is
the better choice? Explain. Under what circumstances should the
modified internal rate of return be used instead of the standard
internal rate of return?
Project A
Project B
Year
Cash Flow
Year
Cash Flow
0...
Accounting Rate of Return Payback Period Net Present Value Internal Rate of Return Profitability Index 1)...
Accounting Rate of Return Payback Period Net Present Value
Internal Rate of Return Profitability Index 1) Select three of the
analytical tools and provide supportive statements explaining how
each can be used to screen and/or rank future available projects.
2) Select one of the analytical tools listed and provide supportive
statements explaining why you believe it provides the most
important information in the decision process.
Need assistance with Basic ROI, Payback Period, Net Present Value, Internal Rate of Return calculations.
Need assistance with Basic ROI, Payback Period, Net
Present Value, Internal Rate of Return calculations.
Question Calculate Pay Back Period, Net Present Value, Internal Rate of Return and Profitability Index (Benefit...
Question
Calculate Pay Back Period, Net Present Value, Internal Rate of
Return and Profitability Index (Benefit Cost Ration) of each of
these projects and decide and provide your analysis which project
is better. Critically evaluate your decision.
On January 11, 2005, the finance committee of Harding Plastic
Molding Company (HPMC) met to consider eight capital budgeting
projects. Present at the meeting were Robert L. Harding, President
and founder, Susan Jorgensen, comptroller, and Chris Woelk, head of
research & development. Over...
Payback Period, Net Present Value, and Internal Rate of Return An organization’s initial outlay for a...
Payback Period, Net Present Value, and Internal Rate of
Return
An organization’s initial outlay for a
proposed project is $2,000,000. Use the table below to calculate
the payback period, net present value, and internal rate of return
for the project.
Free Cash Flows
Year
Amount
Year
Amount
1
$0.00
6
$0.00
2
$0.00
7
$0.00
3
$1,000,000.00
8
$500,000.00
4
$50.00
9
$500,000.00
5
$750,000.00
10
$500,000.00
As the CEO of the organization, if the
firm’s cost of capital is...
Calculate the net present value, internal rate or return and payback period for an investment project...
Calculate the net present value, internal rate or return and
payback period for an investment project with the following cash
flows using a 5 percent cost of capital:
Year
0
1
2
3
Net Cash Flow
-$150,000
$62,000 $62,000 $62,000
Do you recommend the investment?
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...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot
air balloons)
$
402,000
Useful life
9
years
Salvage value
$
51,000
Annual net income generated
34,572
BBS’s cost of capital
8
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot air balloons)
$
332,000
Useful life
6
years
Salvage value
$
50,000
Annual net income generated
30,876
BBS’s cost of capital
10
%
Assume...
PA11-1 Calculating Accounting Rate of Return, Payback Period, Net Present Value, Estimating Internal Rate of Return...
PA11-1 Calculating Accounting Rate of Return, Payback Period,
Net Present Value, Estimating Internal Rate of Return [LO 11-1,
11-2, 11-3, 11-4]
Balloons By Sunset (BBS) is considering the purchase of two new
hot air balloons so that it can expand its desert sunset tours.
Various information about the proposed investment
follows:
Initial investment (for two hot air balloons)
$
402,000
Useful life
9
years
Salvage value
$
42,000
Annual net income generated
35,778
BBS’s cost of capital
10
%
Assume...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- b. Do any unions represent employees in Microsoft? Describe which unions are involved. c. Have there been...
- Look up and use each of these Linux commands. (Each command will have two parts) Summarize...
- What was Lincoln 10 percent plan and what problems did it present?
- A cantilever beam 4m long carries a uniform load of 3.5 kN/m over a portion 1.5m...
- Our next optimization comes from using the brilliant Rabin-Karp substring matching algorithm (RK for short), invented...
- Give an example of an experiment to determine the focal length of a concave lens. (Note...
- Search the Internet to find (at least 2 websites) related to the general field of malware....
ADVERTISEMENT