Question
In: Finance
Central Food Inc., is considering replacing its current production line to improve efficiency. The new production...
Central Food Inc., is considering replacing its current production line to improve efficiency. The new production line will cost $650,000 plus $50,000 for shipping and installation. The current production line has a book value of $0 and an estimated market value of $119,666.67. CF uses straight-line depreciation method and has a marginal tax rate of 25% for net income and capital gain.
CF’s current annual sales is $433,000 and by estimation, the new production line can increase CF’s annual sales by about 28%. NWC will rise by $35,000. And due to higher maintenance cost, the operating costs will rise by $15,000 each year. In 11 years the production line currently under consideration can be sold for $110,000.
CF’s require rate of return is 11%.
For this replacement project:
1) Find initial investment and all the future incremental cash flows.
** ignore the depreciation on the old production line when finding the “increase in depreciation” for this replacement project.
2) Put all cash flows in #1 on a timeline.
3) Find the discounted payback period. If the threshold is 4.5 years, should CF accept his project?
4) Find the net present value. Should CF accept this project?
5) Find the profitability index. Should CF accept this project?
6) Find the modified internal rate of return. Should CF accept this project?
Solutions
Expert Solution
1)
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
0 represents Initial out flow. In absence of information on life of new asset it is assumed as 11 years. Outflow representended in negative and Inflows in positive.
2)
Cashflows on Timeline
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
3)
Payback period
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
| PVF @ 11% | 1 | 0.90 | 0.81 | 0.73 | 0.66 | 0.59 | 0.53 | 0.48 | 0.43 | 0.39 | 0.35 | 0.32 |
| PV of Cashflows | -610250 | 26184.89 | 23589.99 | 21252.24 | 19146.17 | 17248.8 | 15539.46 | 13999.51 | 12612.17 | 11362.32 | 10236.32 | 35397.79 |
Payback period
= Initial investment ( 0 ) / Cashflows inflows from project (1 to 11)
= 610250 / 206569.7
= 2.95
Payback period is greater than 1. Project should not be accetpted.
4)
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
| PVF @ 11% | 1 | 0.90 | 0.81 | 0.73 | 0.66 | 0.59 | 0.53 | 0.48 | 0.43 | 0.39 | 0.35 | 0.32 |
| PV of Cashflows | -610250 | 26184.89 | 23589.99 | 21252.24 | 19146.17 | 17248.8 | 15539.46 | 13999.51 | 12612.17 | 11362.32 | 10236.32 | 35397.79 |
NPV = Pv of all cashflow = - 403680
NPV is negative. Project should not be accetpted.
5)
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
| PVF @ 11% | 1 | 0.90 | 0.81 | 0.73 | 0.66 | 0.59 | 0.53 | 0.48 | 0.43 | 0.39 | 0.35 | 0.32 |
| PV of Cashflows | -610250 | 26184.89 | 23589.99 | 21252.24 | 19146.17 | 17248.8 | 15539.46 | 13999.51 | 12612.17 | 11362.32 | 10236.32 | 35397.79 |
Profitability Index = PV of Cashflows ( 1 to 11) / Initial Investment
= 206569.7 / 610250 = 0.3385
Profitability Index is below 1. Project should not be accetpted.
6)
| Particulars | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| New Production Line Cost | -700000 | |||||||||||
| Old Machine Sale after Tax | 89750 | |||||||||||
| Incremental Sales | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 121240 | 231240 | |
| Interest on additional Working capital | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | -3850 | |
| Increase in Operating Cost | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | -15000 | |
| Incremental Depriciation SLM 11 yrs | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | -63636.4 | |
| Incremental Profit before Tax | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 38753.64 | 148753.6 | |
| Tax on above | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -9688.41 | -37188.4 | |
| Cash flows | -610250 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 29065.23 | 111565.2 |
MIRR
= ( Future Cash flows / Inital investment ) ^ (1/n) -
n = 11 yrs
= ( 402217.5 / 610250 ) ^ (1/11) - 1
= 0.9628 - 1
= - 0.03719
= - 3.72 %
MIRR is negative. Project should not be accetpted.
jeff jeffy answered 1 year agoRelated Solutions
Central Food Inc., is considering replacing its current production line to improve efficiency. The new production...
Central Food Inc., is considering replacing its current
production line to improve efficiency. The new production line will
cost $650,000 plus $50,000 for shipping and installation. The
current production line has a book value of $0 and an estimated
market value of $119,666.67. CF uses straight-line depreciation
method and has a marginal tax rate of 25% for net income and
capital gain.
CF’s current annual sales is $433,000 and by estimation, the new
production line can increase CF’s annual sales...
Central Food Inc., is considering replacing its current production line to improve efficiency. The new production...
Central Food Inc., is considering replacing its current
production line to improve efficiency. The new production line will
cost $650,000 plus $50,000 for shipping and installation. The
current production line has a book value of $74,000 and an
estimated market value of $95,000. CF uses straight-line
depreciation method and has a marginal tax rate of 25% for net
income and capital gain. CF’s current annual sales is $433,000 and
by estimation, the new production line can increase CF’s annual
sales...
Central Food Inc., is considering replacing its current production line to improve efficiency. The new production...
Central Food Inc., is considering replacing its current
production line to improve efficiency. The new production line will
cost $650,000 plus $50,000 for shipping and installation. The
current production line has a book value of $74,000 and an
estimated market value of $95,000. CF uses straight-line
depreciation method and has a marginal tax rate of 25% for net
income and capital gain.
CF’s current annual sales is $433,000 and by estimation, the new
production line can increase CF’s annual sales...
(Please show work and equations used) Central Food Inc., is considering replacing its current production line...
(Please show work and equations used)
Central Food Inc., is considering replacing its current
production line to improve efficiency. The new production line will
cost $650,000 plus $50,000 for shipping and installation. The
current production line has a book value of $0 and an estimated
market value of $119,666.67. CF uses straight-line depreciation
method and has a marginal tax rate of 25% for net income and
capital gain.
CF’s current annual sales is $433,000 and by estimation, the new
production...
Company A is considering replacing its current production line. The current line has fixed cost 350,000...
Company A is considering replacing its current production line.
The current line has fixed cost 350,000 per year, has variable cost
10 per unit and sells for 14 per unit.
The new production line will have fixed cost of 500,000,
variable cost of 9.6 per unit and sells for 16 per unit.
1. Determine the breakeven quantities for both lines.
2. Plot the two profit relations.
3. Determine the breakeven quantity between the two
alternatives.
Must be completed in Microsoft...
The Luddite Corporation is considering replacing its southwest production line with a totally new system that...
The Luddite Corporation is considering replacing its southwest
production line with a totally new system that will increase
production as well as decreasing costs from labor and material
waste. The new line will cost $680,000 to have in place ready to
go. Luddite expects that it will increase cash flows by $120,500
each year for ten years. At the end of its expected life, the
system's salvage value is expected to equal the costs to remove it.
The required return...
Blue Line Machine Shop is considering a four-year project to improve its production efficiency. Buying a...
Blue Line Machine Shop is considering a four-year project to
improve its production efficiency. Buying a new machine press for
$556800 is estimated to result in $185600 in annual pretax cost
savings. The press falls in the MACRS five-year class, and it will
have a salvage value at the end of the project of $81200. The press
also requires an initial investment in spare parts inventory of
$23200, along with an additional $3,480 in inventory for each
succeeding year of...
Blue line machine shop is considering a four-year project to improve its production efficiency. Buying a...
Blue line machine shop is considering a four-year project to
improve its production efficiency. Buying a new machine press for
$485,000 is estimated to result in $179,000 in annual pretax cost
savings. The press falls in the MACRs five-year class, and it will
have a salvage value at the end of the project of $45,000. The
press also requires an initial investment in spare parts inventory
of $15,000, along with an additional $4,000 in inventory for each
succeeding year of...
Bronson manufacturing is considering replacing an existing production line with a new line that has a...
Bronson manufacturing is considering replacing an existing
production line with a new line that has a greater output capacity
and operates with less labor than the existing line. The new line
would cost $1 million, have a five-year life, and be depreciated
using straight line method. At the end of five years, the new line
would be sold as scrap for $200,000 (in year 5 dollars). Because
the new line is more automated, it would require fewer operators,
resulting in...
ACME manufacturing is considering replacing an existing production line with a new line that has a...
ACME manufacturing is considering replacing an existing
production line with a new line that has a greater output capacity
and operates with less labour than the existing line. The new line
would cost $1 million, have a 5-year life, and would be depreciated
using the straight-line depreciation method over 5 years. At the
end of 5 years, the new line could be sold as scrap for $200 000
(in year 5 dollars). Because the new line is more automated, it...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 21) A company with a polycentric orientation, selling a low-tech product in a less-developed country will...
- 2.1)Explain briefly the following relationships relating to the precipitation over a basin: a. Depth-Area Relationship b....
- Multistep problem that I'm confused on the entire thing: A) The addition of 5E-3 total moles...
- What are interjurisdictional externalities? Identify the problems created for a federal system by interjurisdictional externalities.
- Describe Trader Joe's key business functions (excluding "logistics") and the functional strategies as they relate to...
- At week 24 of a project to shoot a television commercial what should the expenditures be?...
- Explain whether acid can catalyze each of the following reactions; i.e., whether the reaction is faster...
ADVERTISEMENT