Question
A company wants to open a warehouse. A company owns a building that it could use, then sell it for $100,000 after taxes, should it
A company wants to open a warehouse. A company owns a building that it could use, then sell it for $100,000 after taxes, should it decide not to open the new warehouse. Use straight line depreciation over the project's Three Year life. There will be Zero on salvage. There is No new working capital neededrevenues and other operating costs would be constant over the project's Three Year life.
Please Use Excel Functions to show answer.
What is the project's NPV?
(Cash flows constant 1-3yrs)
Project cost of capital (r); 10.0%
Opportunity cost; $100,000
Net Cost Equipment (Dep. Basis); $65,000
Depreciation on Equipment.; 33.333%
Sales Yearly; $123,000
Operating costs (Not showing Deprec.); $25,000
Tax rate; 25%
Please use Excel and show the functionshappy to thumbs up, need to see how to calculate.
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