QUESTION 2 You expect to receive $100 in year 1, $150 in year 2, and $200 in year 3 if you invest in Project XYZ. The project requires you to make an initial investment of $150 in year 0. You also expect to incur the following expenses: $80 in year 1, $80 in year 2, $100 in year 3. Suppose the current discount rate is 10% and remain the same. Suppoe all cash flows are incurred at the end of each year. What is the dynamic payback period? (round to 2nd decimal place)

QUESTION 2 You expect to receive $100 in year 1, $150 in year 2, and $200 in year 3 if you invest in Project XYZ. The project requires you to make an initial investment of $150 in year 0. You also expect to incur the following expenses: $80 in year 1, $80 in year 2, $100 in year 3. Suppose the current discount rate is 10% and remain the same. Suppoe all cash flows are incurred at the end of each year. What is the dynamic payback period? (round to 2nd decimal place)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 16EB: Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two,...

See similar textbooks

Similar questions

You are asked to evaluate an investment project with the following cash flows: Year 1 234. 2 4 Cash Flow $800 1,090 1,350 1,475 a. If the discount rate is 7 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the present value at 17 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the present value at 25 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Present value at 7% b. Present value at 17% c. Present value at 25% $ 3,926.98
1 2 The following cash flow pattern has two IRRs. Use Excel to draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRS. Would you invest in this project if the opportunity cost were 30%? 3 Discount rate 10.00% -34.96 Data table 4 NPV S Year Cash flow 6 7 0 -300 8 1 300 9 2 200 10 3 150 11 4 122 12 5 133 13 6 -800 14 15 IRR 1 16 IRR2 17 18 19 + ? ?
ems with IRR Suppose you are offered a project with the following cash flows: Year Cash Flows 0 $ 8,900 1 -4,600 2 -3,300 3 -2,400 4 -1,700 a. What is the IRR of this offer? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % b. If the appropriate discount rate is 11 percent, should you accept this offer? O Reject Accept c. If the appropriate discount rate is 23 Sercent, should you accept this offer? 3 Percent, should you accept this offer? O Accept O Reject d-1. What is the NPV of the offer if the appropriate discount rate is 11 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d-2. What is the NPV of the offer if the appropriate discount rate is 23 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
Problem #2: Consider an investment where the cash flows are: - $920.33 at time 1 = 0 (negative since this is your initial investment) S407 at time = 1 in years $222 at time = 2 in years $426 at time = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
Nikul
Year Cash Flow 0 -1000 1 800 2 1000 3 1300 4 -2200 Begin by plotting how the NPV of this project changes with different discount rates. Note that you'll have to find the NPV of the project first using a discount rate of your choosing. Use a data table to create this plot. Have your discount rates range from 0% to 60% in increments of 2%. Please label your x-axis "Discount Rate" and your y-axis "Net Present Value of Cash Flows". Title your graph "NPV Calculation". There should be no legend on the graph. How many IRRs does this project have? What are they? Perform your IRR calculations in the box on the left.
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Project B Year Cash Flow Year Cash Flow Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward…
You have an opportunity to make an investment that will pay $100 at the end of year 1, $400 at the end of year 2, $400 at the end of year 3, $400 at the end of year 4 and $300 at the end of year 5. Find the present value of this cash flow stream if the interest rate is 8%. (Hint: You can simply discount each cash flow to the present and then add them up or use the "=NPV function" in Excel or the CF key on your financial calculator a. $1,251.25 b. $1,351.25 c. $1,151.25 d. $1,451.25 a.. b.. C. . d..
Hi can you help with this question please? An investment has the following cash flow profile. For each value of MARR below, what is the minimum value of X such that the investment is attractive based on an internal rate of return measure of merit? EOY 0 1 2 3 4 Cash Flow $(30,000.00) $ 6,000.00 $ 13,500.00 $X $ 13,500.00 MARR is 12 percent/year
Q. 2 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 2 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).
Manshuk
Answer in typing