Internal rate of return For the project shown in the following table, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $100,000 Year (t) Cash inflows (CF;) $10,000 $10,000 $45,000 $30,000 $35,000 1 4 5 Print Done

Internal rate of return For the project shown in the following table, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $100,000 Year (t) Cash inflows (CF;) $10,000 $10,000 $45,000 $30,000 $35,000 1 4 5 Print Done

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter11: Cash Flow Estimation And Risk Analysis

Section: Chapter Questions

Problem 7MC: Calculate the project cash flows for each year. Based on these cash flows and the average project...

See similar textbooks

Similar questions

Average rate of return The following data are accumulated by Watershed Inc. in evaluating two competing capital investment proposals: Determine the expected average rate of return for each project.
Calculate the project cash flows for each year. Based on these cash flows and the average project cost of capital, what are the projects NPV, IRR, MIRR, PI, payback, and discounted payback? Do these indicators suggest that the project should be undertaken?
Net present value method, present value index, and analysis for a service company First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Instructions 1. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value table appearing in Exhibit 2 of this chapter. 2. Determine a present value index for each project. (Round to two decimal places.) 3. Which project offers the largest amount of present value per dollar of investment? Explain.
Internal rate of return For the project shown in the following table, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable.
Use the information provided to answer the questions Calculate the Accounting Rate of Return (on average investment) of Project B (expressed to twodecimal places).Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). Use your answers from previous question to recommend the project that should be chosen. Motivateyour choice.
What are the internal rates of return (IRR) on the three projects? Does the IRR rule in this case give the same decision as NPV? How do you know? If the opportunity cost of capital is 11%, what is the profitability index for each project? Please analyze if, in general, decisions based on the profitability index are consistent with decisions based on NPV. What is the most generally accepted measure to choose between the projects? Please justify your answer. Project A -5000 +1000 +1000 +3000 0 B -1000 0 +1000 +2000 +3000 C -5000 +1000 +1000 +3000 +5000 I will need full analysis (qualitative examples and references citations and examples of relative current investments of big companies.
You are considering the following two projects for investment: Project A Project B Year 0 ($10000) ($5000) Year 1 $3000 $3000 Year 2 $7000 $4000 Year 3 $9000 $5000 You must conduct an analysis using your knowledge of capital budgeting (NPV, IRR ect, ) and time value of money to decide which of the options is better. All analysis must be done in Excel. (This will require all calculations to be done using cell references and excel functions). Your analysis will require you to: A. Calculate thefollowing values for the investment proposals: i. The payback period assuming end-of-the-year cash flows. ii. The discounted payback period assuming a required rate of return of 10% and ending of-the-year cash flows. iii. The NPV of each project. iv. The PI of each…
Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. 5.1.3 Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). 5.1.4 Use your answers from question 5.1.3 to recommend the project that should be chosen. Motivateyour choice. INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%.
You are analyzing a project and have prepared the following data: a. Based on the net present value of this project, should you reject or accept this project? (Please provide the formulas for calculation or the keys applied if a financial calculator is used) b. What is the internal rate of return (IRR) of this project? Should you reject or accept this project? (Please use a financial calculator and list the keys you use)
Suppose that, for an engineering project, the optimistic, most likely, and pessimistic estimates are as shown in the accompanying table. Develop a spreadsheet to determine the AW for each of the three estimate conditions. It is thought that the most critical elements are useful life and net annual cash flow. Include in your spreadsheet a table showing the AW for all combinations of the estimates for these two factors, assuming that all other factors remain at their most likely values.
What are the internal rates of return (IRR) on the three projects? Does the IRR rule in this case give the same decision as NPV? How do you know? If the opportunity cost of capital is 11%, what is the profitability index for each project? Please analyze if, in general, decisions based on profitability index are consistent with decisions based on NPV. What is the most generally accepted measure to choose between the projects? Please justify your answer.
Suppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow.