Question
A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $90,000 and have
A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $90,000 and have a useful life of 6 years. At the end of the period the plant and equipment will have a salvage value of $11,000. The Tax Office allows the company to depreciate this equipment at 30% per annum using the prime cost method (straight line). The tax rate is 30%, and is paid in the year of income. An additional working capital investment of $22,000 is also required and will be recouped in the final year of the project. Additional gross operating revenues from the investment are expected to be: Year 1 = $22,000; Year 2 = $42,000; Year 3 = $48,000; Year 4 = $40,000; Year 5 = $29,000; and Year 6 = $15,000. The company requires a rate of return on their investments of 10%. Required: What is the Net Present Value of this investment opportunity?
Please show in excel with formulas.
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