In: Finance
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?
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 SolutionsTocserp 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
Latest Questions
ADVERTISEMENT
|