Question

A bicycle manufacturer currently produces 392,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $1.90 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct? in-house production costs are estimated to be only $1.60 per chain. The necessary machinery would cost $294,000 and would be obsolete after ten years. This investment could be depreciated to zero for tax purposes using a? ten-year straight-line depreciation schedule. The plant manager estimates that the operation would require $29,000 of inventory and other working capital upfront? (year 0), but argues that this sum can be ignored since it is recoverable at the end of the ten years. Expected proceeds from scrapping the machinery after ten years are $22,050. If the company pays tax at a rate of 20% and the opportunity cost of capital is 15%?, what is the net present value of the decision to produce the chains? in-house instead of purchasing them from the? supplier?

- Project the annual free cash flows (FCF?) of buying the chains years 1 to ten.
(Round to the nearest dollar. Enter a free cash outflow as a negative? number.)

- Compute the NPV of buying the chains from the FCF.
?(Round to the nearest dollar. Enter a negative NPV as a negative? number.)

- Compute the initial FCF in years 1-9 of producing the chains. ?
(Round to the nearest dollar. Enter a free cash outflow as a negative? number.)

- Compute the FCF in year 10 of producing the chains.
?(Round to the nearest dollar. Enter a free cash outflow as a negative? number.)

- Compute the NPV of producing the chains from the FCF.
(Round to the nearest dollar. Enter a negative NPV as a negative? number.)

- The net present value of producing the chains? in-house instead of purchasing them from the supplier is ? (Round to the nearest? dollar.)

Answer 1

No of units produced yearly = 392,000

Alternative A : Buy the chain
Cost of buying =$1.90 per chain

Alternative B : Making the chain in house
Production cost = $1.60 per chain

Machinery Cost = $294,000
Life of Machine = 10 Years
Scrap Value of Machine = $22,050

Depreciation per annum = (Machinery Cost – Scrap Value) / Life of Machine
                                                = (294,000-22,050) / 10
                                                = 271,950 / 10
                                                = 27,195

Net Working Capital Required = $29,000
The contention to ignore this money is not legitimate as the investment will be today and recovery will be at the end of ten year. So the cash outflow will take place today and inflow will be at the end of 10th year which will have a lower Net Present Value.


1) Project the annual free cash flows (FCF?) of buying the chains years 1 to ten.

PARTICULARS	Year	1	2	3	4	5	6	7	8	9	10
NO OF UNITS		392000	392000	392000	392000	392000	392000	392000	392000	392000	392000
COST OF BUYING PER UNIT		1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90
TOTAL COST OF BUYING		744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00
INCOME TAX @20%		148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00
POUND FREE CASH FLOW		-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00

2) Compute the NPV of buying the chains from the FCF.

PARTICULARS	Year	1	2	3	4	5	6	7	8	9	10
NO OF UNITS		392000	392000	392000	392000	392000	392000	392000	392000	392000	392000
COST OF BUYING PER UNIT		1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90	1.90
TOTAL COST OF BUYING		744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00	744800.00
INCOME TAX @20%		148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00	148960.00
POUND FREE CASH FLOW		-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00	-595840.00
PRESENT VALUE FACTOR @15%		0.86956522	0.75614367	0.65751623	0.57175325	0.49717674	0.4323276	0.37593704	0.32690177	0.28426241	0.24718471
PRESENT VALUE @15%		-518122	-450541	-391774	-340673	-296238	-257598	-223998	-194781	-169375	-147283
NPV = SUM OF PRESENT VALUE AT EACH YEAR										-2990383

3) Compute the initial FCF in years 1-9 of producing the chains.

PARTICULARS	Year	1	2	3	4	5	6	7	8	9
NO OF UNITS		392000	392000	392000	392000	392000	392000	392000	392000	392000
COST OF MAKING		1.60	1.60	1.60	1.60	1.60	1.60	1.60	1.60	1.60
TOTAL COST OF BUYING		627200.00	627200.00	627200.00	627200.00	627200.00	627200.00	627200.00	627200.00	627200.00
DEPRECIATION		27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00
EBIT		-654395.00	-654395.00	-654395.00	-654395.00	-654395.00	-654395.00	-654395.00	-654395.00	-654395.00
INCOME TAX @20%		-130879.00	-130879.00	-130879.00	-130879.00	-130879.00	-130879.00	-130879.00	-130879.00	-130879.00
UNLEVERED NET INCOME		-523516.00	-523516.00	-523516.00	-523516.00	-523516.00	-523516.00	-523516.00	-523516.00	-523516.00
ADD : DEPRECIATION		27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00	27195.00
POUND FREE CASH FLOW		-496321.00	-496321.00	-496321.00	-496321.00	-496321.00	-496321.00	-496321.00	-496321.00	-496321.00

4) Compute the FCF in year 10 of producing the chains.

PARTICULARS	Year	10
NO OF UNITS		392000
COST OF MAKING		1.60
TOTAL COST OF BUYING		627200.00
DEPRECIATI jeff jeffy Next > < Previous Related Solutions A bicycle manufacturer currently produces 268,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 268,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $ 1.90 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $ 1.60 per chain. The necessary machinery would cost $276,000 and would be obsolete after ten years. This investment could... A bicycle manufacturer currently produces 201,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 201,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $1.80 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct? in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $260,000 and would be obsolete after ten years. This investment could be depreciated... A bicycle manufacturer currently produces 300,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 300,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $250,000 and would be obsolete after 10 years. This investment could be depreciated... A bicycle manufacturer currently produces 367,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 367,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.10 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $221,000 and would be obsolete after ten years. This investment could be depreciated... A bicycle manufacturer currently produces 336,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 336,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $1.90 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $203,000 and would be obsolete after ten years. This investment could be depreciated... A bicycle manufacturer currently produces 347,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 347,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.10 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $263,000 and would be obsolete after ten years. This investment could be depreciated... A bicycle manufacturer currently produces 353000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 353000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $ 1.80 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $ 1.60 per chain. The necessary machinery would cost $ 255 000 and would be obsolete after ten years. This... A bicycle manufacturer currently produces 230,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 230,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.20 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $1.40 per chain. The necessary machinery would cost $209,000 and would be obsolete after ten years. This investment could be depreciated... A bicycle manufacturer currently produces 269,000 units a year and expects output levels to remain steady... A bicycle manufacturer currently produces 269,000 units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $ 1.90 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct​ in-house production costs are estimated to be only $ 1.50 per chain. The necessary machinery would cost $286,000 and would be obsolete after ten years. This investment could... W5,12 A bicycle manufacturer currently produces 381,000units a year and expects output levels to remain steady... W5,12 A bicycle manufacturer currently produces 381,000units a year and expects output levels to remain steady in the future. It buys chains from an outside supplier at a price of $2.10 a chain. The plant manager believes that it would be cheaper to make these chains rather than buy them. Direct? in-house production costs are estimated to be only $1.50 per chain. The necessary machinery would cost $298,000and would be obsolete after ten years. This investment could be depreciated to... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions This problem is based on the transactions for the Sweet Homes Company in your text. Prepare... Time value Personal Finance Problem You have ​$1,800 to invest today at 8​% interest compounded annually.... Please indicate whether the claim reported in the headline below is most likely to be normative... An almost cube-shaped animal cell (side length 10 μm) uses 109 ATP molecules per minute. You... Give a brief overview of the article and highlight two key-takeaways you see important for your... Discuss the economic factors to emigration to the United States. (Minimum 200 words). 2.35 kg of oxygen as an ideal gas at 4.00 bar and 400 ° C develop... ADVERTISEMENT About @ 2020 WizEdu