Question

In: Finance

XYZ Company is evaluating a project as to whether expansion would be advisable. Here are the...

XYZ Company is evaluating a project as to whether expansion would be advisable. Here are the parameters you must use to assess whether that is advisable. The Company's cost of capital is 9.6% and they are making a 1.75 percentage point adjustment to it for additional risk associated with the project. Five year life. 1. Cost of the Project: $750,000 Working Capital Required: $75,000 Depreciation: $120,000 per Year Salvage value recovery at the end of the project is $47,500. Company tax rate is 30%. Assume that there is no gain or loss at the end of the project. 2. Annual Cash Flow: Sales of product: 120 units at $3,650 each Fixed Costs: $42,500 Variable Costs: $1,920 per unit.

Solutions

Expert Solution

Answer : Let us first list down the parameters given to us in the question

Cost of capital : 9.6% + adjusted for additional risk (1.75% ) = 11.35% effective cost of capital

Life of the project 5 years

Cost of the project $750000

Working capital required : $75000

Depreciation : 120000

Salvage value : 47,500

Tax rate : 30%

Lets use Net present value method to calculate is the project workable or not.

If NPV is above 0 that means we can accept the project

Calculating present value formula : Fund flow/ ( 1 + interest rate) ^(No of years)

Calculation of Net present value

Years 0 1 2 3 4 5
Cost of project 750000
Working capital 75000
Sales 438000 438000 438000 438000 438000
Variable costs 230400 230400 230400 230400 230400
Fixed Costs 42500 42500 42500 42500 42500
EBITDA 165100 165100 165100 165100 165100
Depreciation 120000 120000 120000 120000 120000
EBIT 45100 45100 45100 45100 45100
Tax 13530 13530 13530 13530 13530
PAT 31570 31570 31570 31570 31570
Add back depreciation 151570 151570 151570 151570 151570
Salvage value 0 0 0 0 47500
Add back working capital 0 0 0 0 75000
Net Money benefit -825000 151570 151570 151570 151570 274070
Cost of capital 11.35% 11.35% 11.35% 11.35% 11.35%
Present value -825000 136120.3 122245.5 109784.9 98594.43 160107
Net Present value -198148

As you can see NPV is negative which suggests project is not feasible for us.


Related Solutions

xyz is evaluating the reno proejct. the project requires an intial investment of 136,000 that would...
xyz is evaluating the reno proejct. the project requires an intial investment of 136,000 that would be depreciated to 16,000 over 6 years using the straight-line depreciation. the projec is expected to have operating cash flows of 51,000 per year forever. xyz expects the project to have an after tax terminal value of 186,000 in 3 years. the tax rate is 30% what is (X+Y)/Z if the x is the projects relevant expected cash flow in 3 years, Y is...
Q1. A company plans to undertake an expansion project and is evaluating two proposals, A and...
Q1. A company plans to undertake an expansion project and is evaluating two proposals, A and B. Proposal A Proposal B Year 0 -$150,000 -$150,000 Year 1   $50,000 $60,000 Year 2 $50,000                           $55,000 Year 3 $50,000                           $50,000 Year 4   $50,000                           $40,000 Year 5   $50,000                           $35,000 Since the previous answer gave results, what is the cross-over rate? A. 16.94% B. 17.20% C. 16.66% D. 16.20% Q2. ABC Inc. is considering purchase of a new equipment that will produce a new range of spare parts...
XYZ Steel Corporation is deciding whether to expand operations. The expansion would require purchasing a new...
XYZ Steel Corporation is deciding whether to expand operations. The expansion would require purchasing a new machine for $500,000, with additional $30,000 shipping and installation fees. The machine will be depreciated using a 7-year recovery period (use the percentages given in table 7-3 in the textbook). This project is expected to last 6 years, and the machine is expected to be sold for $200,000 at the end of year 6. In each of the six years of the project (years...
A company is evaluating a prospective project. The project would use equipment that the company already...
A company is evaluating a prospective project. The project would use equipment that the company already fully owns. Is the original cost of the equipment part of the initial cost of this prospective project? Why or why not?
ABC Company is evaluating whether to invest in a projects. The project is a robot that...
ABC Company is evaluating whether to invest in a projects. The project is a robot that will stack the finished goods product on pallets for shipment. Currently, the product is being stacked manually. The robot will cost $1,000,000. The cash inflows for the project are Tear 1: $230,000; Year 2: $180,000; Year 3: $150,000; and Years 4-10: $100,000. Evaluate the investment using the capital budgeting method "Payback Period". The cost of capital for ABC Co. is 8%. Discuss your findings...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $123,000, and shipping and installation costs would add another $17,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $79,950. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $5,000 increase in net operating working capital (increased...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $290,000, and it would cost another $58,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $116,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must...
Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $290,000, and it would cost another $72,500 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $72,500. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require a...
7.  Problem 12.09 Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS...
7.  Problem 12.09 Click here to read the eBook: Analysis of an Expansion Project NEW PROJECT ANALYSIS You must evaluate a proposal to buy a new milling machine. The base price is $156,000, and shipping and installation costs would add another $13,000. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $62,400. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The machine would require a $8,000 increase in net operating working...
Epsilon Corp. is evaluating an expansion of its business. The cash-flow forecasts for the project are...
Epsilon Corp. is evaluating an expansion of its business. The cash-flow forecasts for the project are as follows: Years Cash Flow ($ millions) 0 −180 1-12 46 The firm's existing assets have a beta of 2.2. The risk-free interest rate is 4% and the expected return on the market portfolio is 10%. What is the project's NPV? (Enter your answer in millions. A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your answer...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT