Edit View History Bookmarks Window Help ezto.mheducation.com C Student Portal Week 7: Homework Question 3 - Week 7: Homework - Connect Answer each independent ques 7: Homework i Saved Help Save & Exit Check my c. Project C costs $9,000 and will generate net cash inflows of $4,250 before taxes for 5 years. I ne firm uses straight-line depreciation with no salvage value and is subject to a 30% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) d. Project D costs $9,000 and will generate sales of $5,600 each year for 5 years. The cash expenditures will be $2,300 per year. The firm uses straight-line depreciation with an estimated salvage value of $400 and has a tax rate of 30%. (1) What is the accounting (book) rate of return based on the original investment? (Round your answer to 2 decimal places.) (2) What is the book rate of return based on the average book value? (Round your answer to 2 decimal places.) Use the built-in NPV function in Excel to calculate the amounts for projects a through d. (Round your answers to the nearest whole Book dollar amount.) Ask e1. What is the NPV of project A? Assume that the firm requires a minimum after-tax return of 10% on investment. e2. What is the NPV of project B? Assume that the firm requires a minimum after-tax return of 10% on investment. Print e3. What is the NPV of project C? Assume that the firm requires a minimum after-tax return of 10% on investment. e4. What is the NPV of project D? Assume that the firm requires a minimum after-tax return of 10% on investment. erences a. Payback period years b . Payback period years C . Payback period years d1. Book rate of return % d2. Book rate of return % e1. NPV of Project A e2. NPV of Project B e3. NPV of Project C e4 . NPV of Project D raw 16 MacBook Pro Q DEVRYYOU & @ # O 17 5 6 8 9 N W T O P E R Uiew History Bookmarks Window Help ezto.mheducation.com Portal Week 7: Homework Question 3 - Week 7: Homework - Connect Answer each independent question, (a) nework i Saved Help Save & Exit Submit Check my work Answer each independent question, (a) through (e), below. a. Project A costs $9,000 and will generate annual after-tax net cash inflows of $3,600 for 5 years. What is the payback period for this investment under the assumption that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) b. Project B costs $9,000 and will generate after-tax cash inflows of $800 in year 1, $2,300 in year 2, $4,100 in year 3, $3,300 in year 4, and $4,100 in year 5. What is the payback period (in years) for this investment assuming that the cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) c. Project C costs $9,000 and will generate net cash inflows of $4,250 before taxes for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 30% tax rate. What is the payback period under the assumption that all cash inflows occur evenly throughout the year? (Round your answer to 2 decimal places.) d. Project D costs $9,000 and will generate sales of $5,600 each year for 5 years. The cash expenditures will be $2,300 per year. The firm uses straight-line depreciation with an estimated salvage value of $400 and has a tax rate of 30% (1) What is the accounting (book) rate of return based on the original investment? (Round your answer to 2 decimal places.) (2) What is the book rate of return based on the average book value? (Round your answer to 2 decimal places.) Use the built-in NPV function in Excel to calculate the amounts for projects a through d. (Round your answers to the nearest whole dollar amount.) e1. What is the NPV of project A? Assume that the firm requires a minimum after-tax return of 10% on investment. e2. What is the NPV of project B? Assume that the firm requires a minimum after-tax return of 10% on investment. e3. What is the NPV of project C? Assume that the firm requires a minimum after-tax return of 10% on investment. e4. What is the NPV of project D? Assume that the firm requires a minimum after-tax return of 10% on investment