please consider the sign [+] / [-] against each variable in the first column.This will help you understand whether a particular variable has been added or subtracted.
Please be guided by the second column called "Linkage". This will help you understand the mathematics behind each row.
Year |
Linkage |
0 |
1 |
2 |
3 |
4 |
5 |
Initial Cost of asset |
A |
720,000 |
|||||
Investment in working capital |
B |
61,000 |
|||||
Savings in pre tax operating costs |
C |
209,000 |
209,000 |
209,000 |
209,000 |
209,000 |
|
[-] Depreciation |
D |
720,000 |
- |
- |
- |
- |
|
EBIT |
E |
(511,000) |
209,000 |
209,000 |
209,000 |
209,000 |
|
[-] Taxes |
F = E x 23% |
(117,530) |
48,070 |
48,070 |
48,070 |
48,070 |
|
NOPAT |
G |
(393,470) |
106,930 |
106930 |
106930 |
106930 |
|
Operating Cash flow |
H = G +D |
326,530 |
106,930 |
106,930 |
106,930 |
106,930 |
|
Release of working capital |
B (as before) |
61,000 |
|||||
Pre tax salvage value |
I |
98,000 |
|||||
Post tax salavage value |
J = I x (1 - 23%) |
75,460 |
|||||
Net cash flows |
K = -A - B + H + B + J |
(781,000) |
326,530 |
106,930 |
106,930 |
106,930 |
243,390 |
Discount rate |
R |
9% |
|||||
Discount factor |
(1+R)^(-N) |
1.0000 |
0.9174 |
0.8417 |
0.7722 |
0.7084 |
0.6499 |
PV of cash flows |
K x Discount factor |
(781,000) |
299,558.62 |
90,002.98 |
82,571.35 |
75,749.21 |
158,179.16 |
NPV |
Sum of PVs |
(74,938.68) |
Kolby's Korndogs is looking at a new sausage system with an installed cost of $720,000. The...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $705,000. The asset qualifies for 100 percent bonus depreciation and can be scrapped for $95,000 at the end of the project's 5-year life. The sausage system will save the firm $203,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $55,000. If the tax rate is 25 percent and the discount rate is 10 percent, what is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $725,000. The asset qualifies for 100 percent bonus depreciation and can be scrapped for $99,000 at the end of the project's 5-year life. The sausage system will save the firm $211,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $63,000. If the tax rate is 24 percent and the discount rate is 10 percent, what is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $670,000 The asset qualities for 100 percent bonus depreciation and can be scrapped for $88.000 at the end of the project's 5-year life. The sausage system will save the firm $213,000 per year in pretax operating costs and the system requires an initial investment in net working capital of $41.000. If the tax rate is 23 percent and the discount rate is 11 percent, what is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $655,000. This cost will be depreciated straightline to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $85,000. The sausage system will save the firm $183,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $35,000. If the tax rate is 22 percent and the discount rate is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $730,00o. This cost will be depreciated straight-line to zero over the project's 7-year life, at the end of which the sausage system can be scrapped for $100,000. The sausage system will save the firm $213,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $65,000. If the tax rate is 25 percent and the discount rate is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $750,000. This cost will be depreciated straight-line to zero over the project's 7-year life, at the end of which the sausage system can be scrapped for $104,000. The sausage system will save the firm $221,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $73,000. If the tax rate is 24 percent and the discount rate is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $735,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $105,000. The sausage system will save the firm $204,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $35,000. If the tax rate is 34 percent and the discount rate is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $725,000. This cost will be depreciated straight-line to zero over the project's 7-year life, at the end of which the sausage system can be scrapped for $99,000. The sausage system will save the firm $211,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $63,000. If the tax rate is 24 percent and the discount rate is...
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $720,000. This cost will be depreciated straight-line to zero over the project’s 6-year life, at the end of which the sausage system can be scrapped for $98,000. The sausage system will save the firm $209,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $61,000. If the tax rate is 23 percent and the discount rate is...
Kolby's Korndogs is looking at a new sausage system with an installed cost of $800,000. This cost will be depreciated straight-line to zero over the project's five- year life, at the end of which the sausage system can be scrapped for $95,000. The sausage system will save the firm $150,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $45,000. If the tax rate is 35 percent and the discount rate...