Year |
Cash Flow |
0 |
-4000 |
1 |
250 |
2 |
500 |
3 |
750 |
4 |
1000 |
5 |
1250 |
6 |
1500 |
Therefore Present Worth=
1(-4000)+250(0.909)+500(0.826)+750(0.751)+1000(0.683)+1250(0.621)+1500(0.564)
=-4000+227.25+413+563.25+683+776.25+846=-$904.25
=$ 904.25 (0.10)/{1-(1+0.10)^-4
=$904.25(0.10)/0.31698654
=285.264
(4000)(1)+227.25(1.10)+413(1.10)^2+563.25(1.10)^3+683(1.10)^4+776.25(1.10)^5+846(1.10)^6
=-4000+249.975+499.73+749.686+999.980+1250.158+1498.741
=$1248.27
Year |
Cash Flow |
Cummulative value of Present value of Cash flow @10% |
0 |
(-4000) |
-4000 |
1 |
250 |
227.25=227.25 |
2 |
500 |
227.25+413=640.25 |
3 |
750 |
640.25+563.25=1203.5 |
4 |
1000 |
1203.5+683=1886.5 |
5 |
1250 |
1886.5+776.25=2662.75 |
6` |
1500 |
2662.75+846=3508.75 |
Discounted payback is approximately beyond 6 years
For the following cash flows, compute the following assuming a 10% interest rate: PW EAW FW...
Which of the following is the discount rate that makes the present value of the estimated cash flows equal to the initial cost of the investment? Modified internal rate of return Internal rate of return Discounted payback period Payback period Net present value
Consider the following 5-years investment table of Agus's cash flow with required return rate j=11% (RRR). Discounted is a discount factor based on RRR. Contribution is amount of money that Agus paid to start the business (investment). Whereas, return is amount of money that Agus received from the investment. Furthermore, PV Contrib is present value of Contribution based on RRR, then Net Cash Flow is Return minus Contribution. Moreover, Discounted Cash Flow is present value of Net Cash Flow based...
use FW Q6. [20 marks] The estimated annual cash flows of an investment project along with associated probabilities are given below. Determine the expected equivalent worth of this cash flow series at an interest rate of 12% per year (If your student ID number is even, use the FW method. Otherwise, use the PW method). EOY 0 Probability = 0.45 Probability = 0.25 Probability = 0.3 -$10,000 -$20,000 -$12,000 $4,200 $3,500 $3,100 $3,250 $3,500 $3,100 $6,000 $5,000 $3,100 2-6 7
J&E Enterprises is considering and investment which produces no cash flows for the first year. In the second year, the cash inflow is $47,000. This inflow will increase to $198,000 and then $226,000 for the following two years, respectively, before ceasing permanently. The initial investment will cost $318,000. The firm requires a 15.5 percent rate of return and has a required discounted payback period of three years. Should the project be accepted? Why or why not? show all work Year...
The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR. Consider the following situation: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $2,750,000. The project's expected cash flows are: Year Year 1...
FW please :) Q6. [20 marks] The estimated annual cash flows of an investment project along with associated probabilities are given below. Determine the expected equivalent worth of this cash flow series at an interest rate of 12% per year (If your student ID number is even, use the FW method. Otherwise, use the PW method). EOY 0 1 Probability = 0.45 -$10,000 $4,200 $3,250 $6,000 Probability = 0.25 -$20,000 $3,500 $3,500 $5,000 Probability = 0.3 -$12,000 $3,100 $3,100 $3,100...
A project has the following cash flows: Year Cash Flows 0 -2,500 1 750 2 800 3 500 4 400 5 300 6 250 What is the Internal Rate of Return (IRR) of this project?
Calculate payback periods. Please show calculations so I can duplicate it in excel. 7 Your division is considering two projects. Its wACC is 10%, and the projects, after-tax cash flows (in millions 8 of dollars) would be as follows: Expected Cash Flows Project A Project B 10 Time (S30) S5 s10 S15 S20 (S30) S20 S10 S8 S6 12 13 14 15 16 17 18 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted payback Use Excel's NPV...
The length of time required for an investment to generate cash flows sufficient to recoup the initial cost of the investment is called the a. Net present value b. Profitability index c. Payback period d. Internal rate of return e. Discounted cash period
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year Project Cash Flow (millions) $(240) 72 80 95 If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period? The project's discounted payback period is years. (Round to two decimal places.) (Discounted payback period) The Callaway Cattle Company is considering the construction of a new feed handling system for its feed lot in Abilene, Kansas. The new system will...