Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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

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

Step: 3

blur-text-image

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

Financial Management Theory And Practice

Authors: Prasanna Chandra

8th Edition

0071078401, 978-0071078405

More Books

Students also viewed these Finance questions