Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Stuck on this Excel assignment, if you could please show the formulas, thanks. HiLO Co. - CAPITAL PROJECT ANALYSIS - CHAPTER 10 HW ON CANVAS
Stuck on this Excel assignment, if you could please show the formulas, thanks.
HiLO Co. - CAPITAL PROJECT ANALYSIS - CHAPTER 10 HW ON CANVAS HiLO Co. Inc. is a plumbing service company serving the northeastern United States. Its is considering the purchase of a new warehouse sorting system which will be more efficent in storing and accessing parts for customer projects. It is expected that the system will save warehousing and distribution costs of $1,500,000 in year one, as well as $175,000 year one in general and administrative expenses. In each year thereafter it is expected that the warehouse distribtuion savings will increase 2% annually, and general and administrative cost savings will increase 3% annually. The cost of the sorting system is $9,250,000 an is expected to have a life of 10 years. Over the ten years an annual investment in working capital will be required of $25,000 at the end of each year as well as at the time of the purchase of the system. In the final year no working capital investment is needed and the annual working capital investments will be realized as a cash inflow as the project terminates. At the end of its life it can be sold for 10% of the original cost. Five year MACRS depreciation will be used for tax purposes and the company's average tax rate is 22% and the marginal rate is 24%. The required rate of return for high risk projects is 14%, average risk 12% and low risk 11%. Prepare NPV, IRR, payback and profitability index analyses to determine if this project will generate an attractive level of economic benefits. Also prepare a data table to measure the impact on the NPV using the following assumptions: Required rate of return: 9%,10%,11%,12%,13% Tax rate: 22%,23%,24%,25%,26% Required Rate of Return HiLO Co. - CAPITAL PROJECT ANALYSIS - CHAPTER 10 HW ON CANVAS HiLO Co. Inc. is a plumbing service company serving the northeastern United States. Its is considering the purchase of a new warehouse sorting system which will be more efficent in storing and accessing parts for customer projects. It is expected that the system will save warehousing and distribution costs of $1,500,000 in year one, as well as $175,000 year one in general and administrative expenses. In each year thereafter it is expected that the warehouse distribtuion savings will increase 2% annually, and general and administrative cost savings will increase 3% annually. The cost of the sorting system is $9,250,000 an is expected to have a life of 10 years. Over the ten years an annual investment in working capital will be required of $25,000 at the end of each year as well as at the time of the purchase of the system. In the final year no working capital investment is needed and the annual working capital investments will be realized as a cash inflow as the project terminates. At the end of its life it can be sold for 10% of the original cost. Five year MACRS depreciation will be used for tax purposes and the company's average tax rate is 22% and the marginal rate is 24%. The required rate of return for high risk projects is 14%, average risk 12% and low risk 11%. Prepare NPV, IRR, payback and profitability index analyses to determine if this project will generate an attractive level of economic benefits. Also prepare a data table to measure the impact on the NPV using the following assumptions: Required rate of return: 9%,10%,11%,12%,13% Tax rate: 22%,23%,24%,25%,26% Required Rate of Return
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