Question
In: Finance
BAD company is considering producing a new range of smartphones that will require it to build...
BAD company is considering producing a new range of smartphones that will require it to build a
new factory. Feasibility studies have been done on the factory which cost $5 million. The studies
have found the following:
-
The factory will cost $25 million and will have a useful life of 20 years.
-
The land where the factory will go is currently used as a carpark for workers and it is assumed that the company will have to pay $200000 per year for their workers to park in a nearby carpark.
-
The factory will be depreciated on a straight line basis and will have a salvage value of $0 but it is believed that most of it can be sold for scrap after 20 years for $50000.
-
Due to the nature of the business they are in, they will have to perform some environmental tests to make sure that some of the chemicals they are using are not entering the ground water around the factory. These tests will be performed every 5 years and cost $625000.
-
Through the building of this factory and the selling of the phones it produces, it’s revenue will increase by $5 million in year 1 and remain at this level for the operational life of the factory.
-
The extra costs that the company accrues per year due to the project are $435000 for labour, $50000 for overhead like power and water bills and marketing costs for the new line of phones will be $500000 per year but will decrease by $15000 per year as the phone gains greater penetration.
-
The company’s current cost of capital is 8% per year.
-
The tax rate is 30%.
-
The project requires an initial investment in working capital of $1000000 that is returned
in year 20.
Use the above information to answer the following.
Calculate the NPV, IRR and payback period of the project. Should they go ahead with the project?
Solutions
Expert Solution
NPV = 4,803,753
IRR = 10.36% (IRR is the rate which would make NPV = 0 i.e cash outflows = cash inflows. This is dont by trial and error method by changing discount factor in below table column p. Or in excel with formula "=IRR(o1:o21)" IRR of years 0 to 20
Payback years = 15.41 (where NPV = 0, manually check which year the cash inflows = outflows). In year 15, we see NPV = -359023. So in year 16 NPV, use 359023/890558 (Year 16 NPV). so in year 16, in 0.4 years the NPV would be zero.
| a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q |
| Years | Factory cost | Working capital | Depreciation | Salvage | Parking cost | Environment test | Revenue | Labour+overhead | Marketing | Net income | Tax @30% | Net profit | Net cash flow from operations | Total Net cash flow | Discount factor @ 8% | NPV |
| Investment/20 yrs | (Once 5 years) | (Reduced by 15k every year) | =sum(d:j) | k*30% | =k-l | Add back depreciation (d) | =(b+c+n) | =(1/1+i^n | =o*p | |||||||
| 0 | -25,000,000 | -1,000,000 | 0 | -26,000,000 | 1.0000 | -26,000,000 | ||||||||||
| 1 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -500,000 | 2,665,000 | -799,500 | 1,865,500 | 3,115,500 | 3,115,500 | 0.9259 | 2,884,722 | ||||
| 2 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -485,000 | 2,680,000 | -804,000 | 1,876,000 | 3,126,000 | 3,126,000 | 0.8573 | 2,680,041 | ||||
| 3 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -470,000 | 2,695,000 | -808,500 | 1,886,500 | 3,136,500 | 3,136,500 | 0.7938 | 2,489,855 | ||||
| 4 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -455,000 | 2,710,000 | -813,000 | 1,897,000 | 3,147,000 | 3,147,000 | 0.7350 | 2,313,139 | ||||
| 5 | -1,250,000 | -200,000 | -625,000 | 5,000,000 | -385,000 | -440,000 | 2,100,000 | -630,000 | 1,470,000 | 2,720,000 | 2,720,000 | 0.6806 | 1,851,186 | |||
| 6 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -425,000 | 2,740,000 | -822,000 | 1,918,000 | 3,168,000 | 3,168,000 | 0.6302 | 1,996,377 | ||||
| 7 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -410,000 | 2,755,000 | -826,500 | 1,928,500 | 3,178,500 | 3,178,500 | 0.5835 | 1,854,624 | ||||
| 8 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -395,000 | 2,770,000 | -831,000 | 1,939,000 | 3,189,000 | 3,189,000 | 0.5403 | 1,722,917 | ||||
| 9 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -380,000 | 2,785,000 | -835,500 | 1,949,500 | 3,199,500 | 3,199,500 | 0.5002 | 1,600,547 | ||||
| 10 | -1,250,000 | -200,000 | -625,000 | 5,000,000 | -385,000 | -365,000 | 2,175,000 | -652,500 | 1,522,500 | 2,772,500 | 2,772,500 | 0.4632 | 1,284,204 | |||
| 11 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -350,000 | 2,815,000 | -844,500 | 1,970,500 | 3,220,500 | 3,220,500 | 0.4289 | 1,381,217 | ||||
| 12 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -335,000 | 2,830,000 | -849,000 | 1,981,000 | 3,231,000 | 3,231,000 | 0.3971 | 1,283,075 | ||||
| 13 | -1,250,000 | -200,000 | 5,000,000 | -385,000 | -320,000 | 2,845,000 | -853,500 | 1,991,500 | 3,241,500 | 3,241,500 | 0.3677 | 1,191,893 | ||||
| 14 | -1,250,000 | -200,000 | 5,000,000 |
 jeff jeffy answered 1 year agoRelated SolutionsABC company is considering producing a new range of smartphones that will require it to build...ABC company is considering producing a new range of smartphones
that will require it to build a new factory. Feasibility studies
have been done on the factory which cost $5 million. The studies
have found the following:
1. The factory will cost $25 million and will have a useful life
of 20 years.
2. The land where the factory will go is currently used as a
carpark for workers and it is assumed that the company will have to
pay...
ABC company is considering producing a new range of smartphones that will require it to build...ABC company is considering producing a new range of smartphones
that will require it to build a new factory. Feasibility studies
have been done on the factory which cost $5 million. The studies
have found the following:
1. The factory will cost $25 million and will have a useful life
of 20 years.
2. The land where the factory will go is currently used as a
carpark for workers and it is assumed that the company will have to
pay...
ABC company is considering producing a new range of smartphones that will require it to build...ABC company is considering producing a new range of smartphones
that will require it to build a
new factory. Feasibility studies have been done on the factory
which cost $5 million. The studies
have found the following:
The factory will cost $25 million and will have a useful life of
20 years.
The land where the factory will go is currently used as a
carpark for workers and it is assumed that the company will have to
pay $200000 per...
ABC company is considering producing a new range of smartphones that will require it to build...ABC company is considering producing a new range of smartphones
that will require it to build a new factory. The project itself
will go for 20 years. Feasibility studies have been done on the
factory which cost $5 million. The studies have found the
following:
The factory will cost $25 million and will have a useful life of
25 years.
The land where the factory will go is currently used as a
carpark for workers and it is assumed that...
Question 1 ABC company is considering producing a new range of smartphones that will require it...Question 1
ABC company is considering producing a new range of smartphones
that will require it to build a new factory. The project itself
will go for 20 years. Feasibility studies have been done on the
factory which cost $5 million. The studies have found the
following:
1. The factory will cost $25 million and will have a useful life
of 25 years.
2. The land where the factory will go is currently used as a
carpark for workers and...
A nut producing company decides to explore the possibility of launching a new range of light...A nut producing company decides to explore the possibility of
launching a new range of light almond. For this study, an analysis
of the fat content of five samples of both varieties is done to
confirm the hy-pothesis that a new variety of almond contains less
fat than the commonly used one. The results are: Usual variety 27.0
26.9 27.3 27.2 27.1; mean=27.1 New variety 26.8 27.0 26.9 27.1
26.8; mean=26.92 We analyze the data and have the following
results:...
Your Company is considering a new project that will require $880,000 of new equipment at the...Your Company is considering a new project that will require
$880,000 of new equipment at the start of the project. The
equipment will have a depreciable life of 5 years and will be
depreciated to a book value of $300,000 using straight-line
depreciation. The cost of capital is 13%, and the firm's tax rate
is 21%. Estimate the present value of the tax benefits from
depreciation.
$116,000
$91,640
$85,680
$24,360
Your company is considering a new project that will require $10,000 of new equipment at the...Your company is considering a new project that will
require $10,000 of new equipment at the start of the project. The
equipment will have a depreciable life of five years and will be
depreciated to a book value of $3,000 using straight-line
depreciation. The cost of capital is 9 percent, and the firm's tax
rate is 34 percent. Estimate the present value of the tax benefits
from depreciation.
A.
$476
B.
$924
C.
$1,400
D.
$1,851
Which statement is true...
Your company wants to build a new plant in China to increase its capacity for producing...Your company wants to build a new plant in China to increase its
capacity for producing a new polymer that is being used widely in
consumer goods there. To build the plant, the company would need to
pay $175,000,000 now, $150,000,000 at the beginning of next year
(i.e. or you can think of it as the end of the first year,
whichever you like), and $125,000,000 at the end of the second year
to have the plant built. It will...
A company is considering a new project. This project will require the purchase of $321,000 of...
A company is considering a new project. This project will
require the purchase of $321,000 of equipment, the purchase of
$45,000 in inventory and will increase accounts payable by $73,000.
Expected sales are $625,000 with costs of $480,000. The project
will last for five years, be taxed at 35% and have a required rate
of return of 14%. The equipment will have no salvage value at the
end of the project and will be depreciated using the MACRS
three-year class....
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|