Question
a. Project A costs $8,000 and will generate annual after-tax net cash inflows of $3,250 for 5 years. What is the payback period for this
a. Project A costs $8,000 and will generate annual after-tax net cash inflows of $3,250 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 $8,000 and will generate after-tax cash inflows of $1,250 in year 1, $1,950 in year 2, $3,400 in year 3, $2,950 in year 4, and $3,400 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 $8,000 and will generate net cash inflows of $3,750 before taxes for 5 years. The firm uses straight-line depreciation with no salvage value and is subject to a 20% 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 $8,000 and will generate sales of $4,900 each year for 5 years. The cash expenditures will be $1,950 per year. The firm uses straight-line depreciation with an estimated salvage value of $500 and has a tax rate of 20%.
(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 7% on investment.
e2. What is the NPV of project B? Assume that the firm requires a minimum after-tax return of 7% on investment.
e3. What is the NPV of project C? Assume that the firm requires a minimum after-tax return of 7% on investment.
e4. What is the NPV of project D? Assume that the firm requires a minimum after-tax return of 7% on investment.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Lets start by calculating the payback period for each project a Payback Period for Project A Project A costs 8000 and generates annual aftertax net cash inflows of 3250 for 5 years textPayback Period ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started