Given the following attributes of an investment project with a five-year life: investment outlay, year 0, $6,100; after-tax cash inflows, year 1, $850; year 2, $950; year 3, $2,000; year 4, $2,300; and year 5, $3,700. (a) Use the built-in NPV function of
Given the following attributes of an investment project with a five-year life: investment outlay. year 0 $5,000; after-tax cash inflows. year 1, $800; year 2, $900; year 3, $1,500; year 4, $1,800; and year 5 $3,200. Use the built-in NPV function in Excel to estimate the NPV of this project. Round to the nearest whole dollar. Assume an after-tax discount rate of 12.0%.
Given the following attributes of an investment project with a five-year life: investment outlay, year 0, $8,700; after-tax cash inflows, year 1, $930; year 2, $1,070; year 3, $3,200; year 4, $3,500; and year 5, $4,900. (a) Use the built-in NPV function of Excel to estimate the NPV of this project. Assume an after-tax discount rate of 11.0% (b) Estimate the payback period, in years, for this project under the assumption that cash inflows occur evenly throughout the year. (Round...
Given the following attributes of an investment project with a five-year life: investment outlay. year 0 $5,000; after-tax cash inflows. year 1, $800; year 2, $900; year 3, $1,500; year 4, $1,800; and year 5 $3,200. Estimate the payback period, in years, for this project under the assumption that cash inflows occur evenly throughout the year. round to the 1 decimal place.
Project A costs $5,400 and will generate annual after-tax net cash inflows of $1,800 for five years. What is the NPV using 5% as the discount rate? Round your present value factor to three decimal places and final answer to the nearest dollar.
Project B cost $4,900 and will generate after-tax net cash inflows of $500 in year one, $1,300 in year two, $2,000 in year three, $2,500 in year four, and $2,000 in year five. What is the NPV using 12% as the discount rate? Round your present value factor to three decimal places and the rest to nearest dollar.
3. (5 pts) Create a cash flow for a simple investment project with a 4-year life that produces a discounted payback of 3 years and an IRR of 8%/year if the MARR is 4%.
4) A firm is considering the following investment project. Assume a 5-year property for MACRS Before-Tax Cash Flow Year (thousands) 0 - 100,000 +35,000 +35,000 +35,000 +35,000 5 +35,000 The income tax rate is 21%. If the firm requires a 10% after-tax rate of return, should the project be undertaken? MACRS depreciation will be used.