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 Explain how biology, culture, and their interaction shape sex differences. Write a program that computes the tax and tip on a restaurant bill for a patron... clear all close all % %*******Parameter Settings******** %********************************* Fs=8192; %Sampling frequency (MATLAB's default) Ts=1/Fs; %Sampling time... Name a business that you believe has experienced declining costs attributable to computerization. Were variable costs... With C++, 1. Assume we use two linked lists that represent Set A and Set B... A beam of light shines on an equilateral glass prism at an angle of 45∘ to... This is an intro to python question. #Write a function called search_for_string() that takes two #parameters,... ADVERTISEMENT About @ 2020 WizEdu