a). Complete the spreadsheet below by estimating the project's annual after tax cash flow. b). What is
Fantastic news! We've Found the answer you've been seeking!
Question:
a). Complete the spreadsheet below by estimating the project's annual after tax cash flow. b). What is the investment's net present value at a discount rate of 10 percent? c). What is the investment's internal rate of return? d). How does the internal rate of return change if the discount rate equals 20 percent? e). How does the internal rate of return change if the growth rate in EBIT is 8 percent instead of 3 percent?
Chapter 7 Problem 12 | |||||||||||
a). Complete the spreadsheet below by estimating the project's annual after tax cash flow. | |||||||||||
b). What is the investment's net present value at a discount rate of 10 percent? | |||||||||||
c). What is the investment's internal rate of return? | |||||||||||
d). How does the internal rate of return change if the discount rate equals 20 percent? | |||||||||||
e). How does the internal rate of return change if the growth rate in EBIT is 8 percent instead of 3 percent? | |||||||||||
Facts and Assumptions | |||||||||||
Equipment initial cost $ | $ 350,000 | ||||||||||
Depreciable life yrs. | 7 | ||||||||||
Expected life yrs. | 10 | ||||||||||
Salvage value $ | $0 | ||||||||||
Straight line depreciation | |||||||||||
EBIT in year 1 | 28,000 | ||||||||||
Tax rate | 38% | ||||||||||
Growth rate in EBIT | 3% | ||||||||||
Discount rate | 10% | ||||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Initial cost | 350,000 | ||||||||||
Annual depreciation | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | ||||
EBIT | 28,000 | 28,840 | 29,705 | 30,596 | 31,514 | 32,460 | 33,433 | 34,436 | 35,470 | 36,534 | |
Net present value @ 10% | |||||||||||
Internal rate of return |
Related Book For
Posted Date: