Question
Michael estimates that this venture will require an initial outlay of $255,000 to buy a refrigerated storage unit, which can be depreciated (Straight-Line method) to
Michael estimates that this venture will require an initial outlay of $255,000 to buy a refrigerated storage unit, which can be depreciated (Straight-Line method) to a salvage value of $120,000 in 20 years. In addition, he estimates that he will need $92,000 in working capital during the 20 years of the project. Annual sales are estimated to be $128,000 and annual expenses $78,000. At the end of the tenth year there will be an expense of $105,000 to properly maintain the storage unit. Michael estimates that the marginal tax rate will be 27% during the lifetime of the project.
a. What is the terminal after-tax operating cashflow?
b. If Michael requires a 8% RRR to make this investment, calculate the NPV of the project.
c. Should he make the investment?
d. What is the project's IRR?
e. What is the projects payback period?
Please fill in this table in Excel.
| Year | One Time Cash Flow | Sales | Expenses | Depreciation | Tax | Operating Cash Flow | Total Cash Flow | PV | Cumulative PV |
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | |||||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 | |||||||||
| 11 | |||||||||
| 12 | |||||||||
| 13 | |||||||||
| 14 | |||||||||
| 15 | |||||||||
| 16 | |||||||||
| 17 | |||||||||
| 18 | |||||||||
| 19 | |||||||||
| 20 |
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
Impact Investing Instruments Mechanisms And Actors
Authors: Wolfgang Spiess-Knafl Barbara Scheck
1st Edition
3319665553,3319665561
