A project is being analyzed with the following set of cash flows. Calculate the internal rate of return (IRR). (Do not round intermediate calculations and enter your answer a percent rounded to 2 decimal places, e.g., 32.16.) Cash Year Flow 0 $16,000 1 -23 6,700 2 8,000 6,500

A project is being analyzed with the following set of cash flows. Calculate the internal rate of return (IRR). (Do not round intermediate calculations and enter your answer a percent rounded to 2 decimal places, e.g., 32.16.) Cash Year Flow 0 $16,000 1 -23 6,700 2 8,000 6,500

Name: A project is being analyzed with the following set of cash flows. Cal
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: A project is being analyzed with the following set of cash flows. Calculate the internalrate of return (IRR). (Do not round intermediate calculations and enter your answer asa percent rounded to 2 decimal places, e.g., 32.16.)CashYearFlow016,0001236

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

Assume San Lucas Corporation in MAD 26-1 assigns the following probabilities to the estimated annual net cash flows: a. Compute the expected value of the annual net cash flows. b. Determine the expected net present value of the equipment, assuming a desired rate of return of 10% and the expected annual net cash flows computed in part (a). Use the present value tables (Exhibits 2 and 5) provided in the chapter in determining your answer. c. Based on your results in parts (a) and (b), should San Lucas Corporation invest in the equipment?
Assume a company is going to make an investment in a machine of $825,000 and the following are the cash flows that two different products would bring. Which of the two options would you choose based on the payback method?
The NPV method assumes that cash inflows associated with a particular investment occur when? A. only at the time of the initial Investment B. only at the end of the year C. only at the beginning of the year D. at any of these times
Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.
The expected period of time that will elapse between the date of a capital investment and thecomplete recovery of the amount of cash investedis called: A.The average rate of return period B.The cash payback period C.The net present value period D.The internal rate of return period
Assume Home Garden Inc. in MAD 26-5 assigns the following probabilities to the estimated construction cost of the warehouse and annual net cash flows: a. Compute the expected value of the construction cost. b. Compute the expected value of the annual net cash flows. c. Determine the expected net present value of building the distribution warehouse, assuming a desired rate of return of 14% and using the expected values computed in parts (a) and (b). Use the present value tables provided in Appendix A. Round to the nearest dollar. d. Based on your results in part (c), should Home Garden Inc. build the distribution warehouse?
The management of Ryland International Is considering Investing in a new facility and the following cash flows are expected to result from the investment: A. What Is the payback period of this uneven cash flow? B. Does your answer change if year 6s cash inflow changes to $920,000?
Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two, $2,500 in year three, $3,000 in year four and $2,000 in year five. What is the NPV using 8% as the discount rate?
Which of the following discounts future cash flows to their present value at the expected rate of return, and compares that to the Initial Investment? A. internal rate of return (IRR) method B. net present value (N PV) C. discounted cash flow model D. future value method
Assume a company is going to make an investment of $450,000 in a machine and the following are the cash flows that two different products would bring in years one through four. Which of the two options would you choose based on the payback method?
Consider the following project cash flow. YEAR CASH FLOW 0 -1000 1 500 2 500 3 500 4 500 5 500 Use this information to calculate the Internal Rate of Return by linear interpolation(the trial and error method). WITH WORKING PLEASE
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000