Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As the finance manager of a company, you are presented with the following project. The company is considering the purchase of a new piece of

As the finance manager of a company, you are presented with the following project. The company is considering the purchase of a new piece of equipment which would cost $210,000. This equipment will have a five-year useful life and have a salvage value of $10,000 at the end of the five-year period. Assume straight-line depreciation It is estimated that the new equipment will be able to produce 10,000 shelves per year. the allocated overhead for running the equipment will be $20,000 per year. they can sell the shelves for $25 each. the cost of sales is $15 per shelf. Net Working Capital requirements for the project are as follows: Year 0 = $10,000 Year 1 = $15,000 Year 2 = $17,000 Year 3 = $15,000 Year 4 = $10,000 The company has a 30% marginal tax rate and a required rate of return of 15%.

1.What is the NPV for the project?- Need confirmation that NPV is 16,204.

2. The company has a preexisting line ofshelves that sell for $25 per unit with a unit cost of $15. You estimate that sales forthis preexisting line will be 500 units lower each year (not cumulative) as long asthe new line of shelves is in production. What is the new NPV?

image text in transcribed

Assumptions unit growth price per unit cost of sales per unit Seling, General Admin e pensa irital investment due numbers indicate the assumptions 25 15 20,000 alocated ovalad 210,00C 10,000 useful life Annual Deprecation tax rate discount rate 40,000 Assure straight-line depreciation 30. 15.0% 0 20.000 Year units Bales Cost osales Gross Profit Selling, General Admi Depreciation EBIT Incurre Tax Unlevered Net Income Add Back Depreciation After-tax cash flow from cuipment Sale Subtract Change in NWC Surat Capital Esperditure Free Cash Flow 1 10,000 250.000 150,000 100.000 29,000 40.000 40,000 12.000 28,000 40,000 Z 3 10.000 10,000 10.000 250,000 250.000 250.000 250.000 150.000 150.000 150.000 150.000 100,000 100.000 100.000 100.000 20.000 20,000 20.000 20,000 40,000 40.000 40,000 40,000 40.000 40,000 40.000 40,COU 12,000 12.000 12,000 12.000 28,000 28,000 28.000 29,000 40.000 40,000 40.000 40,000 10,000 12.000 2,000 10,000 (S.CCO! (10,000) (210,000 (220,000) 63,000 GG.000 70,000 73,000 89,000 Discount Factor FOF Present Value NPV 0309565217 0.7562437 0.6575162 0.5717532 0.4971767 (220.000 54,783 49,905 45026 41,718 43,752 16,204 0,30 accept the project 2 17,000 3 15,00 Year Lovel of NWC Chunrein NW Cash Flow Impact of NWC 0 10,000 10,000 (10,000; 1 15.000 5000 5.COM 4 10.000 (10,000 5.000 10,000 2000 12.0001 2,000 State of the economy Recession Normal Boom Probability Stock 0.15 0.55 0.30 0.01 0.09 0.14 Stock (0.25) 015 038 Assumptions unit growth price per unit cost of sales per unit Seling, General Admin e pensa irital investment due numbers indicate the assumptions 25 15 20,000 alocated ovalad 210,00C 10,000 useful life Annual Deprecation tax rate discount rate 40,000 Assure straight-line depreciation 30. 15.0% 0 20.000 Year units Bales Cost osales Gross Profit Selling, General Admi Depreciation EBIT Incurre Tax Unlevered Net Income Add Back Depreciation After-tax cash flow from cuipment Sale Subtract Change in NWC Surat Capital Esperditure Free Cash Flow 1 10,000 250.000 150,000 100.000 29,000 40.000 40,000 12.000 28,000 40,000 Z 3 10.000 10,000 10.000 250,000 250.000 250.000 250.000 150.000 150.000 150.000 150.000 100,000 100.000 100.000 100.000 20.000 20,000 20.000 20,000 40,000 40.000 40,000 40,000 40.000 40,000 40.000 40,COU 12,000 12.000 12,000 12.000 28,000 28,000 28.000 29,000 40.000 40,000 40.000 40,000 10,000 12.000 2,000 10,000 (S.CCO! (10,000) (210,000 (220,000) 63,000 GG.000 70,000 73,000 89,000 Discount Factor FOF Present Value NPV 0309565217 0.7562437 0.6575162 0.5717532 0.4971767 (220.000 54,783 49,905 45026 41,718 43,752 16,204 0,30 accept the project 2 17,000 3 15,00 Year Lovel of NWC Chunrein NW Cash Flow Impact of NWC 0 10,000 10,000 (10,000; 1 15.000 5000 5.COM 4 10.000 (10,000 5.000 10,000 2000 12.0001 2,000 State of the economy Recession Normal Boom Probability Stock 0.15 0.55 0.30 0.01 0.09 0.14 Stock (0.25) 015 038

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

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski PhD

3rd Edition

1567932320, 978-1567932324

More Books

Students also viewed these Finance questions

Question

Calculate the cost per hire for each recruitment source.

Answered: 1 week ago

Question

What might be some advantages of using mobile recruiting?

Answered: 1 week ago

Question

What external methods of recruitment are available?

Answered: 1 week ago