New Project Problem Med Drive, Inc. manufactures a line of traditional light-wei
ID: 2461761 • Letter: N
Question
New Project Problem
Med Drive, Inc. manufactures a line of traditional light-weight adjustable collapsing wheel chairs for medical transport. Management is considering a business proposal to produce a new line of hydraulic reclining wheel chairs. The proposal has been studied carefully and the following information is forecast: Cost of new production equipment and machinery including
freight and setup (Assume 5 year straight line depreciation to 0) $220,000
Expense of hiring and training new employees . . . 121,500
Pre-start-up advertising and other miscellaneous expenses 25,000
Additional selling and administrative expense per year after start-up 115,000
Unit sales forecast
Year 1 300
Year 2 700
Year 3 1,100
Year 4 and beyond 1,600
Unit Price 700
Unit cost to manufacture (60% of revenue) 420
Last year, anticipating an interest in hydraulic reclining wheelchairs, the company bought the rights to a new hydraulic mechanism design for $70,000.
Med Drive production facilities are currently being utilized to capacity, so a new shop has to be acquired for incremental production. The company owns a lot near the present facility on which a new building can be constructed for $195,000 (assume 39 year straight line depreciation). The land was purchased 10 years ago for $60,700, and now has an estimated market value of 120,000.
If Med Drive produces hydraulic reclining wheel chairs, it expects to lose some of its current sales to the new product. Three percent of the new unit forecast is expected to come out of sales that would have been made in the old line. Prices and direct costs are about the same in the old line as in the new.
Med Drive's general overhead includes personnel, finance, and executive functions, and runs about 5% of revenue. Small one-time increments in business don’t affect overhead spending, but a major continuing increase in volume would require additional support. Management estimates that additional spending in overhead areas will amount to about 2% of the new project’s revenues.
Accounts receivable at year-end are expected to be 1/12 of the average of the current and the next year ‘s sales. Incremental inventories are estimated at $12,000 at start-up and for the first year. After that an inventory turnover of 15 times based on cost of sales is expected. Incremental payables are estimated to be 25% of inventories.
Med Drive's current business is profitable, so losses in the new line will result in tax credits. The company’s marginal tax rate is 35%.
Med Drive Inc. expects to sell the new line at the end of the 6th year for the price equal to the perpetuity of that year’s OCF discounted by its cost of capital of 16.8% (proceeds taxed at 35%).
Based on this data estimate cash flows for each of the six years, the project’s IRR and NPV, and suggest whether to accept or reject the new business proposal.
This is a "real life" problem and, as such, does not necessarily have a “correct” answer. Your logic, knowledge of the subject is what matters.
Explanation / Answer
Ans
At a Cost of capital of 18.95% NPV equal almost zero , Hence IRR is 18.95%
Details Amount Amount Initial investment Cost of new production equipment and machinery 2,20,000.00 After Tax cost of hiring new employess and training=121500*.65 78,975.00 After Tax Pre-start-up advertising and other miscellaneous expenses=25000*.65 16,250.00 Building construction cost 1,95,000.00 Oppurtunity cost of the land 1,20,000.00 Increase in Working capital Inventory 12000 Less Accouns Payable 3000 Net Increase in WC 15,000.00 Net Initial Investment -6,45,225.00 Present value of cash inflows 7,81,884.55 NPV 1,36,659.55 Workings Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Sales in Units 300.00 700.00 1,100.00 1,600.00 1,600.00 1,600.00 Sales Price 700.00 700.00 700.00 700.00 700.00 700.00 Less VC 420.00 420.00 420.00 420.00 420.00 420.00 Contribution 280.00 280.00 280.00 280.00 280.00 280.00 Total Contribution 84,000.00 1,96,000.00 3,08,000.00 4,48,000.00 4,48,000.00 4,48,000.00 Less Fixed selling and admin cost 1,15,000.00 1,15,000.00 1,15,000.00 1,15,000.00 1,15,000.00 1,15,000.00 Less General OVH expenses 2% of revenue 4,200.00 9,800.00 15,400.00 22,400.00 22,400.00 22,400.00 Operating Cash inflow before tax and WC changes -35,200.00 71,200.00 1,77,600.00 3,10,600.00 3,10,600.00 3,10,600.00 Less Tax @ 35% - 24,920.00 62,160.00 1,08,710.00 1,08,710.00 1,08,710.00 Operating Cash inflow After tax and before WC changes A -35,200.00 46,280.00 1,15,440.00 2,01,890.00 2,01,890.00 2,01,890.00 Account Receivable 3,50,000.00 6,30,000.00 9,45,000.00 11,20,000.00 11,20,000.00 11,20,000.00 Inventory 12,000.00 44,100.00 69,300.00 1,00,800.00 1,00,800.00 1,00,800.00 Accounts Payable -3,000.00 -11,025.00 -17,325.00 -25,200.00 -25,200.00 -25,200.00 Net Working Capital 3,59,000.00 6,63,075.00 9,96,975.00 11,95,600.00 11,95,600.00 11,95,600.00 Net Incremental WC B 3,50,000.00 3,04,075.00 3,33,900.00 1,98,625.00 - - Depreciation Tax Shield-Equipment 15,400.00 15,400.00 15,400.00 15,400.00 15,400.00 15,400.00 Depreciation Tax Shield-Building 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 1,750.00 Net Depreciation Tax Shield C 17,150.00 17,150.00 17,150.00 17,150.00 17,150.00 17,150.00 Net Cash inflow A+B+C -3,68,050.00 -2,40,645.00 -2,01,310.00 20,415.00 2,19,040.00 2,19,040.00 DF @ Cost of Capital 16.8% 0.86 0.73 0.63 0.54 0.46 0.39 Present value of cash inflow -3,15,111.30 -1,76,396.98 -1,26,338.82 10,969.28 1,00,764.89 86,271.31 Present value of cash inflow for 6 years -4,19,841.64 Terminal Cash Flow Operaring cash flow at the end of year 6 2,01,890.00 Cost of capital 0.17 PV of TerminalCashflow (assumed to be incl Land) 12,01,726.19 Total Cash inflow 7,81,884.55At a Cost of capital of 18.95% NPV equal almost zero , Hence IRR is 18.95%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.