Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A Complete the spreadsheet to estimate the project's annual after-tax cash flows. Cash Flows In A Outflow-Purchase 350,000 B What is the investment's Net Present
A | Complete the spreadsheet to estimate the project's annual after-tax cash flows. | Cash Flows In | A | Outflow-Purchase | 350,000 |
B | What is the investment's Net Present Value (NPV) at a discount rate of 10 percent? | Net Present Value | B | Print screen | |
C | What is the investment's Internal Rate of Return ? | Internal Rate of Return | C | Print screen | |
D | What is the investment's NPV at a discount rate of 20 percent? | D | Print screen |
Facts and Assumptions | |
Equipment initial cost | $350,000 |
Depreciable life yrs. | 7 |
Expected life yrs. | 10 |
Salvage value | $0 |
Straight line depreciation | |
Earrings Before Taxes | $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 (cash to be added) | $ 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | ||||
Earrings Before Taxes | $ 28,000 | $28,840 | $29,705 | $30,596 | $31,514 | $32,459 | $33,433 | $34,436 | $35,469 | $36,533 | |
Taxes | $ 10,640 | 10,959 | 11,288 | 11,626 | 11,975 | 12,334 | 12,705 | 13,086 | 13,478 | 13,883 | |
Earrings After Taxes | $ 17,360 | $ 17,881 | $18,417 | 18,970 | 19,539 | 20,125 | 20,728 | 21,350 | $21,991 | $22,650 | |
After-tax cash flow | (350,000) | $ 67,360 | 67,881 | 68,417 | 68,970 | 69,539 | 70,125 | 70,728 | 21,350 | 21,991 | 22,650 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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