Profit = (revenues-sales)*(1-switch%) |
=(8690000-1860000)*(1-0.14) |
5873800 |
Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Cost of new machine | -26000000 | |||||||||||||
Initial working capital | -1190000 | |||||||||||||
=Initial Investment outlay | -27190000 | |||||||||||||
100.00% | ||||||||||||||
Profits | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | 5873800 | ||||
-Depreciation | (Cost of equipment-salvage value)/no. of years | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | 1000000 | =Salvage Value | |
=Pretax cash flows | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | 3373800 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | 2496612 | |||
+Depreciation | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | 2500000 | ||||
=after tax operating cash flow | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | ||||
reversal of working capital | 1190000 | |||||||||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 740000 | ||||||||||||
+Tax shield on salvage book value | =Salvage value * tax rate | 260000 | ||||||||||||
=Terminal year after tax cash flows | 2190000 | |||||||||||||
Total Cash flow for the period | -27190000 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 4996612 | 7186612 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.127125311 | 1.270411467 | 1.43191292 | 1.6139453 | 1.8191186 | 2.0503746 | 2.31102912 | 2.6048194 | 2.935958 | 3.309192 | ||
Discounted CF= | Cashflow/discount factor | -27190000 | 4433058.109 | 3933065.885 | 3489466.385 | 3095899.2 | 2746721.4 | 2436926.4 | 2162072.281 | 1918218.2 | 1701868 | 2171712 | ||
NPV= | Sum of discounted CF= | 899007.34 |
unanswered not_submitted Caspian Sea Drinks is considering the production of a diet drink. The expansion of...
#3 unanswered not_submitted Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $23.00 million. The plant and equipment will be depreciated over 10 years to a book value of $3.00 million, and sold for that amount in year 10. Net working capital will increase by $1.43 million at the beginning of the project and will be recovered at the...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $27.00 million. The plant and equipment will be depreciated over 10 years to a book value of $3.00 million, and sold for that amount in year 10. Net working capital will increase by $1.35 million at the beginning of the project and will be recovered at the end. The new...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $24.00 million. The plant and equipment will be depreciated over 10 years to a book value of $2.00 million, and sold for that amount in year 10. Net working capital will increase by $1.34 million at the beginning of the project and will be recovered at the end. The new...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $26.00 million. The plant and equipment will be depreciated over 10 years to a book value of $2.00 million, and sold for that amount in year 10. Net working capital will increase by $1.24 million at the beginning of the project and will be recovered at the end. The new...
"Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $25.00 million. The plant and equipment will be depreciated over 10 years to a book value of $1.00 million, and sold for that amount in year 10. Net working capital will increase by $1.41 million at the beginning of the project and will be recovered at the end. The new...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $23.00 million. The plant and equipment will be depreciated over 10 years to a book value of $2.00 million, and sold for that amount in year 10. Net working capital will increase by $1.46 million at the beginning of the project and will be recovered at the end. The new...
1. Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $22.00 million. The plant and equipment will be depreciated over 10 years to a book value of $2.00 million, and sold for that amount in year 10. Net working capital will increase by $1.23 million at the beginning of the project and will be recovered at the end. The...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $22.00 million. The plant and equipment will be depreciated over 10 years to a book value of $1.00 milion, and sold for that amount in year 10. Net working capital will increase by $108 milion at the beginning of the project and will be recovered at the end. The new...
Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $28.00 million. The plant and equipment will be depreciated over 10 years to a book value of $1.00 million, and sold for that amount in year 10. Net working capital will increase by $1.38 million at the beginning of the project and will be recovered at the end. The new...
"Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $23.00 million. The plant and equipment will be depreciated over 10 years to a book value of $3.00 million, and sold for that amount in year 10. Net working capital will increase by $1.43 million at the beginning of the project and will be recovered at the end. The new...