Question

In: Finance

RBC, is considering a five-year investment in a machine to produce widgets. Before investing, the Students...

RBC, is considering a five-year investment in a machine to produce widgets. Before investing, the Students at RBC, completed a marketing study on the demand of the widget. The marketing study cost $350,000. The machine cost is $1,000,000 and produces 30,000 widgets annually. At the end of the year, the variable cost is $45 per widget and it is expected to grow at 3%, the sales price is $60 per widget and expected to grow at 5%, and the fixed costs to operate the machine are $150,000 annually. The cost of the plant is depreciated in straight line over 5 years. The appropriate annual discount rate is 15% and the corporate tax rate is 21%. The machine will be place in a building at RBC that is currently being rented at the beginning of each year for $50,000. The required net working capital is $45,000 per year for the first three years, and $65,000 for the last two years, and it is recovered at the end of the project. At the end of the project RBC is expected to sell the machine for $100,000. RBC expects to sell all widgets produced each year. Find out Should RBC invest in this project?

Solutions

Expert Solution

Tax rate 21%
Calculation of annual depreciation
Depreciation Year-1 Year-2 Year-3 Year-4 Year-5 Total
Cost $         1,000,000 $         1,000,000 $         1,000,000 $         1,000,000 $         1,000,000
Dep Rate 20.00% 20.00% 20.00% 20.00% 20.00%
Depreciation Cost * Dep rate $            200,000 $            200,000 $            200,000 $            200,000 $            200,000 $        1,000,000
Calculation of after-tax salvage value
Cost of machine $         1,000,000
Depreciation $         1,000,000
WDV Cost less accumulated depreciation $                       -  
Sale price $            100,000
Profit/(Loss) Sale price less WDV $            100,000
Tax Profit/(Loss)*tax rate $              21,000
Sale price after-tax Sale price less tax $              79,000
Calculation of annual operating cash flow
Year-1 Year-2 Year-3 Year-4 Year-5
No of units                   30,000                   30,000                   30,000                   30,000                   30,000
Selling price $                60.00 $                63.00 $                66.15 $                69.46 $                72.93
Operating cost $                45.00 $                46.35 $                47.74 $                49.17 $                50.65
Sale $         1,800,000 $         1,890,000 $         1,984,500 $         2,083,725 $         2,187,911
Less: Operating Cost $         1,350,000 $         1,390,500 $         1,432,215 $         1,475,181 $         1,519,437
Contribution $            450,000 $            499,500 $            552,285 $            608,544 $            668,474
Less: Fixed cost $            150,000 $            150,000 $            150,000 $            150,000 $            150,000
Less: Depreciation $            200,000 $            200,000 $            200,000 $            200,000 $            200,000
Profit before tax (PBT) $            100,000 $            149,500 $            202,285 $            258,544 $            318,474
Tax@21% PBT*Tax rate $              21,000 $              31,395 $              42,480 $              54,294 $              66,880
Profit After Tax (PAT) PBT - Tax $              79,000 $            118,105 $            159,805 $            204,249 $            251,595
Add Depreciation PAT + Dep $            200,000 $            200,000 $            200,000 $            200,000 $            200,000
Cash Profit after-tax $            279,000 $            318,105 $            359,805 $            404,249 $            451,595
Payment of rent in beginning $              50,000.00
Tax benefit at the end of year $              10,500.00 50000*21%
Calculation of NPV
15.00%
Year Capital Working capital Rent payment Tax benefit on rent Operating cash Annual Cash flow PV factor, 1/(1+r)^time Present values

Related Solutions

Tocserp is considering the purchase of a new machine that will produce widgets. The widget maker...
Tocserp is considering the purchase of a new machine that will produce widgets. The widget maker will require an initial investment of $12,000 and has an economic life of five years and will be fully depreciated by the straight line method. The machine will produce 1,400 widgets per year with each costing $2.00 to make. Each will be sold at $4.50. Assume Tocserp uses a discount rate of 14 percent and has a tax rate of 34 percent. What is...
Mmasodwo Enterprice is considering investing in a machine to produce computer keyboards. The price of the...
Mmasodwo Enterprice is considering investing in a machine to produce computer keyboards. The price of the machine will be ¢530,000 and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 15,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 ¢20 in the first year and will increase...
Mmasodwo Enterprice is considering investing in a machine to produce computer keyboards. The price of the...
Mmasodwo Enterprice is considering investing in a machine to produce computer keyboards. The price of the machine will be ¢530,000 and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 15,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 ¢20 in the first year and will increase...
A supervisor needs to produce widgets. Two machines are able to make the widgets. Machine A...
A supervisor needs to produce widgets. Two machines are able to make the widgets. Machine A takes 2 hours to set up and can then make widgets at a rate of 80 per hour. The machine does not have to be stopped once it is running. Machine B takes 30 minutes to set up and can then widgets at the rate of 60 per hour, but every 2 hours the machine has to be stopped and lubricated. Lubrication takes 30...
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...
Earp Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of...
Earp Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $976,000, and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 21,000 keyboards each year. The price of each keyboard will be $40 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 $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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT