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 2 years 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...
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
$570,000 is estimated to result in $240,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 $96,000. The
press also requires an initial investment in spare parts inventory
of $30,000, along with an additional $3,500 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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- JAVASCRIPT: Please create an array of student names and another array of student grades. - Create...
- Topic - Construction: Structural, loads, tension 1.) Explain why pure tension members are the most efficient...
- Procter and Gamble (PG) paid an annual dividend of $ 1.62$1.62 in 2009. You expect PG...
- locate a recent case of online child pornography. Write a summary of the incident and describe...
- #Python 5. Write function called evaluate() that evaluates the following Python expressions or assignments as specified:...
- Suggest journal, research paper link reference. i need this as reference for writing a research with...
- Cryptography is used heavily in internet communications. True or false? Explain
ADVERTISEMENT