Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Corporate Finance A Focused Approach

Authors: Suk Hi Kim, Kenneth A Kim

2nd Edition

9814618004, 9789814618007

More Books

Students also viewed these Finance questions

Question

LO2 Describe the human resource planning process.

Answered: 1 week ago