Question

A pencil-manufacturing company Sharpy Sharp wants to make its production more efficient, and it has hired Bain and Co. to assist in the decision making process. Several months later the consultants at Bain came up with the conclusion that it could be cheaper to make pencil tops [in-house] rather than buying them from an outside supplier, as direct production pre-tax costs are estimated to be only $1.50 a top. To produce the tops in house, the company will have to immediately buy new machinery that costs $150,000. This investment could be written off for tax purposes using straight-line depreciation over 3 years to a salvage value of zero. The company pays tax at a rate of 35 percent, the required rate of return is 15 percent, and the company needs to produce 200,000 pencil top units a year. The consultants estimate that operating the new machine will increase the company’s hydro bills by $1,000 a month (hydro bills are due at the end of each month). Finally, the company will have to invest $40,000 in net working capital right away but will be able to recover all of it at the end of year 3.

Currently the company buys pencil tops from an outside supplier at a price of $2 a lid. Sharpy Sharp anticipates that it will produce (or buy) the pencil tops for the foreseeable future, and all the costs/prices outlined in the question will remain unchanged.

In answering the question, assume that all the numbers are adjusted for inflation. Unless specified otherwise, all the cash flows arrive/are paid at the end of the specified period. Both the outsourced and the in-house production will lead to the same quality of the product and will not affect the pencil prices. To receive full credit, please show your calculations.

1. What investment decision rule should you use to compare the two options?

2. Which option is better? To receive full credit for the question, show the time line, the FCF, and all of your calculations. Answers in Excel are acceptable. If you choose to answer the question in Excel, please add the Excel file to your submission to ensure clarity and visibility of your calculations to the grader.

Answer 1

Answer;

GIVEN DATA

COST OF OUT SIDE SUPPLIERS=1.5

TOTAL NUMBER OF UNITS PRODUCED=200000

CAPEX REQUIRED=150000

NUMBER OF YEARS=3

INCREMENTAL HYDRO BILLS PER MONTH

TAX RATE=35%

REQUIRED RATE=15%

WORKING CAPITAL=40000

DESRIPTION	YEAR 0	YEAR1	YEAR2	YEAR3
SALES	NILL	300000	300000	300000
INCRIMENT BILLS	NILL	12000	12000	12000
DEPRICATION	NILL	50000	50000	50000
PPT	NILL	238000	238000	238000
TAX@35%	NILL	83300	83300	83300
TOTAL PAT	NILL	154700	154700	154700

THE CASH FLOW TABLE IS GIVEN BELOW

PAT+DEPRICIATION	NILL	204700	204700	204700
CAPEX	-150000	-	-	-
WORKING CAPITAL	-40000	-	-	40000
TOTAL	-190000	204700	204700	244700
NPV	264067

RESULT: THE COMPANY ASSUMED THAT PUT UP ON THE MACHINERY START PRODUCING THE PENCIL HIGGER THE EQUAL PRICE THE POSITIVE MAKING NPV THAT MAKE THE COMPANY PRODUCING IN HOUSE INSTEAD OF OUTSOURCING