Question

In: Finance

Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...

  1. Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $975,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 20,000 keyboards each year. The price of each keyboard will be $40 in the first year and will increase by 5 percent per year. The production cost per keyboard will be $15 in the first year and will increase by 6 percent per year. The project will have an annual fixed cost of $195,000 and require an immediate investment of $25,000 in net working capital. The corporate tax rate for the company is 34 percent. If the appropriate discount rate is 11 percent, what is the NPV of the investment?

Solutions

Expert Solution

Calculation of NPV of investment
Year 0 1 2 3 4 5 NPV
Investment in Machine -$975,000
Increase in net working capital -$25,000
Operating cash flow $267,600 $282,120 $297,247 $313,005 $329,417
Net Cash flow -$1,000,000 $267,600 $282,120 $297,247 $313,005 $329,417
X Discount factor @ 11%                     1.00000              0.90090              0.81162              0.73119              0.65873              0.59345
Present Value -$1,000,000 $241,081 $228,975 $217,345 $206,186 $195,493 $89,079
NPV of investment $89,079
Working 1
Calculation of operating cash flow for the project over 5 years
Year 1 2 3 4 5
Production Units 20000 20000 20000 20000 20000
x Sales price per car $40.00 $42.00 $44.10 $46.31 $48.62
Sales   $800,000.00 $840,000.00 $882,000.00 $926,100.00 $972,405.00
Production cost per unit $15.00 $15.90 $16.85 $17.87 $18.94
Less : Production cost (units x per unit cost) $300,000.00 $318,000.00 $337,080.00 $357,304.80 $378,743.09
Contribution Margin $500,000.00 $522,000.00 $544,920.00 $568,795.20 $593,661.91
Less : Fixed cost $195,000.00 $195,000.00 $195,000.00 $195,000.00 $195,000.00
Less : Depreciation $195,000.00 $195,000.00 $195,000.00 $195,000.00 $195,000.00
Profit before tax $110,000.00 $132,000.00 $154,920.00 $178,795.20 $203,661.91
Less : Tax @ 34% $37,400.00 $44,880.00 $52,672.80 $60,790.37 $69,245.05
Add : Depreciation $195,000.00 $195,000.00 $195,000.00 $195,000.00 $195,000.00
Operating Cash flow $267,600 $282,120 $297,247 $313,005 $329,417
Working-2
Depreciation per year using straight line method = (Cost of machine - salvage value)/useful life
Depreciation per year using straight line method = ($9,75,000 - $0)/5 years
Depreciation per year using straight line method = $1,95,000

Related Solutions

Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $992,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 37,000 keyboards each year. The price of each keyboard will be $35 in the first year and will increase by 5 percent per year. The production cost per keyboard will be $15 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,800,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 29,000 keyboards each year. The price of each keyboard will be $63 in the first year and will increase by 6 percent per year. The production cost per keyboard will be $30 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,750,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 28,000 keyboards each year. The price of each keyboard will be $62 in the first year and will increase by 5 percent per year. The production cost per keyboard will be $28 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $986,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 31,000 keyboards each year. The price of each keyboard will be $30 in the first year and will increase by 4 percent per year. The production cost per keyboard will be $10 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,250,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 24,000 keyboards each year. The price of each keyboard will be $46 in the first year and will increase by 3 percent per year. The production cost per keyboard will be $16 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $978,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 23,000 keyboards each year. The price of each keyboard will be $50 in the first year and will increase by 6 percent per year. The production cost per keyboard will be $15 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,600,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 25,000 keyboards each year. The price of each keyboard will be $54 in the first year and will increase by 6 percent per year. The production cost per keyboard will be $24 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,700,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 27,000 keyboards each year. The price of each keyboard will be $59 in the first year and will increase by 4 percent per year. The production cost per keyboard will be $26 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,700,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 27,000 keyboards each year. The price of each keyboard will be $59 in the first year and will increase by 4 percent per year. The production cost per keyboard will be $26 in the first year and will...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Dickinson Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $1,400,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 27,000 keyboards each year. The price of each keyboard will be $49 in the first year and will increase by 6 percent per year. The production cost per keyboard will be $19 in the first year and will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT