Payback Period calculation gives us an idea that how long it will take for a project to recover the initial investment.
We can use cumulative cash flow table to see that when the cumulative cash flow is equal to zero (or non-negative).
|
Year |
Cash Flow |
Cumulative Cash Flow |
|
0 |
-$100,000 |
-$100,000 |
|
1 |
$30,000 |
-$70,000 |
|
2 |
$40,000 |
-$30,000 |
|
3 |
$50,000 |
$20,000 |
We can see from above table that at the end of year 2 the initial investment is not recovered, so the payback period is greater than 2 year and can be calculated in following manner
Payback Period for project = last year of negative cumulative cash flow + (absolute value of last year of negative cumulative cash flow / Cash flow of next year after negative Cumulative Cash Flow)
= 2 + ($30,000/ $50,000) = 2 + 0.60 = 2.60 years
The payback period is 2.60 years.
1) If a project cost is $100,000 and you get a cash flow of $30,000 in...
If a project cost $100,000 and you get a cash flow of 30,000 in year 1, $40,000 in year 2, and $50,000 in year three. If you are using the NPV calculation in Excel, do you use all the numbers or not? Please explain your answer.
software company is evaluating the following projects with estimated cash flow (in $): Year (t) Project A Project B Project C 0 -100,000 -100,000 -120,000 1 30,000 30,000 40,000 2 40,000 30,000 40,000 3 40,000 30,000 40,000 4 40,000 30,000 40,000 5 100,000 130,000 120,000 Calculate the net profit, payback period, return on investment (ROI), and net present value (NPV) of all projects. Discount rate= 3.00% a) Show your calculated discount rate and fill in the table. Project A Project...
you are considering a project with an initial cash outlay of $100,000 and expected free cash flow of $50,000 at the end of each year for 3 years. the required rate of return for this project is 10 percent. a. What is the project's conventional payback periods? b. What is the project's discounted payback period? c. what is the project's NPV? d. what is the project's PI? e. what is the project's IRR?
Payback Period: Initial Investment Year 1 Cash Inflow Year 2 Cash Inflow Year 3 Cash Inflow Year 4 Cash Inflow Year 5 Cash Inflow Project A 100,000 10,000 10,000 20,000 30,000 30,000 Project B 200,000 50,000 60,000 90,000 60,000 60,000 In years, what is the payback period for Project A? In years, what is the payback period for Project B? Based on payback period, which project would you recommend for your company to pursue? Initial Investment 1st Year Cash Inflow...
Given a project with the following cash flows and a cost of capital of 9%. Calculate the NPV, IRR, MIRR, and PI. For each of the four calculations, give a brief interpretation of what it measures and how it should be used to evaluate a project. Should the project be accepted? Why or why not? Time Period Cash Flow 0 -$200,000 1 $50,000 2 $70,000 3 -$80,000 4 $75,000 5 $100,000 6 $120,000...
You are evaluating a project that will cost $504,000, but is expected to produce cash flows of $123,000 per year for 10 years, with the first cash flow in one year. Your cost of capital is 10.9% and your company's preferred payback period is three years or less. a. What is the payback period of this project? b. Should you take the project if you want to increase the value of the company? a. What is the payback period of...
Cash Flow E F Cost 44000 105000 Cash flow year 1 9778 42000 Cash flow year 2 9778 31500 Cash flow year 3 9778 21000 Cash flow year 4 9778 10500 Cash flow year 5 9778 0 Cash flow year 6 9778 0 Payback period. What are the payback periods of projects E and F in the following table: Assume all the cash flow is evenly spread throughout the year. If the cutoff period is 3 years, whichproject(s) do you...
You are evaluating a project that will cost $493,000, but is expected to produce cash flows of $128,000 per year for 10 years, with the first cash flow in one year. Your cost of capital is 11.3% and your companys preferred payback period is three years or less. a. What is the payback period of this project? b. Should you take the project if you want to increase the value of the company? If you want to increase the value...
Please Use TI BAII Plus Calculator and Show How You Get the Answer with it. The TurtlesandWhales Company wants to calculate how long it will take to recover their initial investment on a project, Project X. It is assumed that the estimated cash flows are received evenly throughout the year. Cost 100,000 Year 1 $53,000 Year 2 $30,000 Year 3 $30,000 Year 4 $100,000 a) What is the payback period? (Give partial year to two decimal places. SHOW ALL WORK). b)...
Nano Specialist is considering an upgrade project. The estimated cash flows from the upgrade project appear below. What is the project's payback period? Note that year 0 and year 1 cash flows are negative. (Answer in years, round to 2 places) Year 0 cash flow = -85,000 Year 1 cash flow = -55,000 Year 2 cash flow = 11,000 Year 3 cash flow = 41,000 Year 4 cash flow = 30,000 Year 5 cash flow = 25,000 Year 6 cash...