Question
In: Finance
Project 1 Initial $ 130,000.00 Investment Cost of Capital 7% Target Payback 4 years Period Cash...
| Project 1 | ||
| Initial | $ 130,000.00 | |
| Investment | ||
| Cost of Capital | 7% | |
| Target Payback | 4 years | |
| Period |
| Cash Flow | |||||
| Project 1 | Cum. CF | Discounted CF | Cum. CF | ||
| Initial Investment | $ (130,000) | $ (130,000) | $ (130,000) | $ (130,000) | |
| Year | 1 | $ 33,000 | $ (97,000) | $ 30841 | $ (99,159) |
| Year | 2 | $ 33,000 | $ (60,000) | $ 28,823 | $ (70,335) |
| Year | 3 | $ 33,000 | $ (31,000) | $ 26,938 | $ (43,398) |
| Year | 4 | $ 30,000 | $ (1,000) | $ 22,887 | $ (20,511) |
| Year | 5 | $ 30,000 | $ 29,000 | $ 21,390 | $ 879 |
Please find the answer for the Payback Period, Discounted Payback, NPV, IRR for Project One. Explain how to get the answer.
Solutions
Expert Solution
| Cash Flow | |||||||||
| Project 1 | Cum. CF | PVIF @ 7% | Discounted CF | Cum. CF | |||||
| Initial Investment | -130000 | -130000 | 1.0000 | (130,000.00) | (130,000.00) | ||||
| Year | 1 | 33000 | -97000 | 0.9346 | 30,841.12 | (99,158.88) | |||
| Year | 2 | 33000 | -64000 | 0.8734 | 28,823.48 | (70,335.40) | |||
| Year | 3 | 33000 | -31000 | 0.8163 | 26,937.83 | (43,397.57) | |||
| Year | 4 | 33000 | 2000 | 0.7629 | 25,175.54 | (18,222.03) | |||
| Year | 5 | 33000 | 35000 | 0.7130 | 23,528.54 | 5,306.52 | |||
| 5,306.52 | |||||||||
| Ans 1 | Payback period = | 3+31000/33000 | 3.94 | year | |||||
| Ans 2 | Discounted payback period = | 4+18222.03/23528.54 | 4.77 | year | |||||
| Ans 3 | NPV = | 5,306.52 | |||||||
| Ans 4 | IRR = | 8.51% | |||||||
jeff jeffy answered 5 months agoRelated Solutions
Project 1 Initial $ 120,000.00 Investment Cost of Capital 9% Target Payback 4 years Period Cash...
Project 1
Initial
$ 120,000.00
Investment
Cost of Capital
9%
Target Payback
4 years
Period
Cash Flow
Project 1
Cum. CF
Discounted CF
Cum. CF
Initial Investment
$ (120,000)
$ (120,000)
$ (120,000)
$ (120,000)
Year
1
$ 30,000
$ (90,000)
$ 27,523
$ (92,477)
Year
2
$ 30,000
$ (60,000)
$ 25,250
$ (67,227)
Year
3
$ 30,000
$ (30,000)
$ 23,166
$ (44,061)
Year
4
$ 35,000
$ 5,000
$ 24,795
$ (19,266)
Year
5
$ 35,000
$ ...
Project 1 Initial $ 150,000.00 Investment Cost of Capital 10% Target Payback 4 years Cash Flow...
Project 1
Initial
$ 150,000.00
Investment
Cost of Capital
10%
Target Payback
4 years
Cash Flow
Project 1
Cum. CF
Discounted CF
Cum. CF
Initial Investment
$ (150,000)
$ (150,000)
$ (150,000)
$ (150,000)
Year
1
$ 35,000
$ (115,000)
$
31,818
$ (118,182)
Year
2
$ 35,000
$ (80,000)
$ 28,926
$ (89,256)
Year
3
$ 45,000
$ (35,000)
$
33,809
$ (55,447)
Year
4
$ 45,000
$
10,000
$
30,736
$ (24,711)
Year
5
$ 45,000
$
55,000...
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.
Using a 7% annual cost of capital, what is the discounted payback period in years of...
Using a 7% annual cost of capital, what is the discounted
payback period in years of the potential project below? round to 2
decimals
Year-----Cash Flows
0..............-5000
1...............1625
2..............1668
3..............1616
4..............1679
5..............1619
can you please let me know how you find this? especially if
using a financial calculator. Thanks!
Using a 7% annual cost of capital, what is the discounted payback period in years (round...
Using a 7% annual cost of capital, what is the discounted
payback period in years (round to 2 decimal places) of the
potential project below?
Year Cash Flow
0 -$5,000
1 $1,609
2 $1,693
3 $1,558
4 $1,545
5 $1,582
Please include the steps to plug into a financial calculator,
thank you
Given the following cash flows for a proposed capital investment project, calculate the payback period. Year...
Given the following cash flows for a proposed capital investment
project, calculate the payback period.
Year
Cash Flow
0
-$40,000
1
15,000
2
15,000
3
15,000
4
15,000
5
10,000
6
10,000
Question 4 options:
5.50 years
3.33 years
4.33 years
2.67 years
A capital project has an initial investment of $100,000 and cash flows in years 1-6 of...
A capital project has an initial investment of $100,000 and cash
flows in years 1-6 of $25,000, $15,000, $50,000, $10,000, $10,000,
and $60,000, respectively. Given a 15 percent cost of capital,
(a) compute the net present value.
(b) compute the internal rate of return
(c) should the project be accepted? Why or why not?
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
Find the discounted payback period for the following project. THe discount rate is 7%. Initial Outlay...
Find the discounted payback period for the following project.
THe discount rate is 7%.
Initial Outlay - $8,273
Year 1 - $3.774
Year 2 - $3,300
Year 3 - $5,328
Year 4 - $7,303
Round the answer to two decimal places. Show your work.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Matlab Programming Write an M-file to read a real-valued vector of any length from the keyboard...
- TASK back to top In the contemporary management environment, mergers and acquisitions are hot topics; particularly...
- A room with 2.7-m-high ceilings has a metal plate on the floor with V = 0V...
- which of the following statements are true? a) the same nuclear changes (creation/destruction of specific nucleons)...
- Overview: Advances in technology have impacted many facets of the auditing process, from assessing risk and...
- Background: This course is all about data visualization. However, we must first have some understanding about...
- A rescue helicopter lifts a 70.6-kg person straight up by means of a cable. The person...
ADVERTISEMENT