In: Finance
Probability |
Unit Sales |
VC% |
NPV |
|
Best case |
25% |
4,800 |
60% |
39,434 |
Base case |
50% |
4,000 |
70% |
4,245 |
Worst case |
25% |
3,200 |
75% |
-25,080 |
The firm's project CVs generally range from 1.0 to 1.5. A 3% risk premium is added to the WACC if the initial CV exceeds 1.5, and the WACC is reduced by 0.5% if the CV is 0.75 or less. Then a revised NPV is calculated. What WACC should be used for this project?
Terminal Year(Year3) Project Cash Flow | ||||||||||
Depreciation | ||||||||||
A | Asset Cost=55000+10000= | $65,000 | ||||||||
B | Year3 MACRS depreciation rate | 15% | ||||||||
C=A*B | Depreciation | $9,750 | ||||||||
Operating Cash Flow: | ||||||||||
D | Unit sales | 4000 | ||||||||
E | Sales Price | $50 | ||||||||
F=D*E | Sales Revenue | $200,000 | ||||||||
G=F*70% | Variable Cost | $140,000 | ||||||||
H | Fixed Cost(excluding depreciation) | $30,000 | ||||||||
I | Depreciation expense | $9,750 | ||||||||
J=F-G-H-I | Operating Profit before tax | $20,250 | ||||||||
K=J*40% | Tax expense | $8,100 | ||||||||
L=J-K | After tax operating Profit | $12,150 | ||||||||
I | Add: Depreciation (non cash expense) | $9,750 | ||||||||
M=L+I | Operating Cash Flow: | $21,900 | ||||||||
Terminal Cash Flow: | ||||||||||
Book Value at end of 3 years=7%*65000 | $4,550 | |||||||||
Salvage Value | $10,000 | |||||||||
Gain on Salvage =10000-4550= | $5,450 | |||||||||
Tax on Gain =40%*5450= | $2,180 | |||||||||
N | After tax salvage value=10000-2180= | $7,820 | ||||||||
Release of working Capital: | ||||||||||
Increase in Current asssets | $5,000 | |||||||||
Increase in Accounts Payable | $3,000 | |||||||||
P | Release of working Capital in year3 | $2,000 | ||||||||
T=N+P | Terminal Cash Flow | $9,820 | ||||||||
M+T | Terminal Year(Year3) Project Cash Flow | $31,720 | (21900+9820) | |||||||
p | A | B=p*A | D=A-5711 | E=D^2 | F=E*p | |||||
Probability | NPV | Probabilty*NPV | Deviation from expected | Deviation Squared | Deviation Squared*Probability | |||||
Best Case | 0.25 | $39,434 | $9,858.50 | $33,723.00 | $1,137,240,729 | $284,310,182 | ||||
Base Case | 0.5 | $4,245 | $2,122.50 | ($1,466.00) | $2,149,156 | $1,074,578 | ||||
Worst Case | 0.25 | ($25,080) | ($6,270.00) | ($30,791.00) | $948,085,681 | $237,021,420 | ||||
Related SolutionsAs a financial analyst, you must evaluate a proposed project to produce printer cartridges. The purchase...As a financial analyst, you must evaluate a proposed project to
produce printer cartridges. The purchase price of the equipment,
including installation, is $65,000, and the equipment will be fully
depreciated at t = 0. Annual sales would be 4,000 units at a price
of $50 per cartridge, and the project’s life would be 3 years.
Current assets would increase by $5,000 and payables by $3,000. At
the end of 3 years, the equipment could be sold for $10,000.
Variable...
As a financial analyst, you must evaluate a proposed project to produce printer cartridges. The purchase...As a financial analyst, you must evaluate a proposed project to
produce printer cartridges. The purchase price of the equipment,
including installation, is $65,000, and the equipment will be fully
depreciated at t = 0. Annual sales would be 4,000 units at a price
of $50 per cartridge, and the project’s life would be 3 years.
Current assets would increase by $5,000 and payables by $3,000. At
the end of 3 years, the equipment could be sold for $10,000.
Variable...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...You must evaluate the purchase of a proposed piece of equipment.
The cost of the equipment is $50,000. The installation and
transportation cost of bringing the equipment to its location is
$6,000. The equipment falls into the MACRS 3-year class. The
project is expected to increase revenues by $80,000 each year and
increase operating costs (excluding depreciation) by $30,000 each
year. This project leads to an increase in net operating working
capital by $10,000. You can salvage the equipment for...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...You must evaluate the purchase of a proposed piece of equipment.
The cost of the equipment is $50,000. The installation and
transportation cost of bringing the equipment to its location is
$6,000. The equipment falls into the MACRS 3-year class. The
project is expected to increase revenues by $80,000 each year and
increase operating costs (excluding depreciation) by $30,000 each
year. This project leads to an increase in net operating working
capital by $10,000. You can salvage the equipment for...
You must evaluate the purchase of a proposed piece of equipment. The cost of the equipment...You must evaluate the purchase of a proposed piece of equipment.
The cost of the equipment is $50,000. The installation and
transportation cost of bringing the equipment to its location is
$6,000. The equipment falls into the MACRS 3-year class. The
project is expected to increase revenues by $80,000 each year and
increase operating costs (excluding depreciation) by $30,000 each
year. This project leads to an increase in net operating working
capital by $10,000. You can salvage the equipment for...
NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department....NEW PROJECT ANALYSIS You must evaluate the purchase of a
proposed spectrometer for the R&D department. The base price is
$140,000, and it would cost another $35,000 to modify the equipment
for special use by the firm. The equipment falls into the MACRS
3-year class and would be sold after 3 years for $35,000. The
applicable depreciation rates are 33%, 45%, 15%, and 7%. The
equipment would require a $9,000 increase in net operating working
capital (spare parts inventory). The...
NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department....NEW PROJECT ANALYSIS
You must evaluate the purchase of a proposed spectrometer for
the R&D department. The base price is $160,000, and it would
cost another $40,000 to modify the equipment for special use by the
firm. The equipment falls into the MACRS 3-year class and would be
sold after 3 years for $72,000. The applicable depreciation rates
are 33%, 45%, 15%, and 7%. The equipment would require a $7,000
increase in net operating working capital (spare parts inventory).
The...
5. Problem 12.08 (New Project Analysis) You must evaluate the purchase of a proposed spectrometer for the...5. Problem 12.08 (New Project Analysis)
You must evaluate the purchase of a proposed spectrometer for
the R&D department. The purchase price of the spectrometer
including modifications is $140,000, and the equipment will be
fully depreciated at the time of purchase. The equipment would be
sold after 3 years for $48,000. The equipment would require a
$13,000 increase in net operating working capital (spare parts
inventory). The project would have no effect on revenues, but it
should save the firm $62,000...
NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department....NEW PROJECT ANALYSIS
You must evaluate the purchase of a proposed spectrometer for
the R&D department. The base price is $140,000, and it would
cost another $35,000 to modify the equipment for special use by the
firm. The equipment falls into the MACRS 3-year class and would be
sold after 3 years for $42,000. The applicable depreciation rates
are 33%, 45%, 15%, and 7%. The equipment would require a $8,000
increase in net operating working capital (spare parts inventory).
The...
NEW PROJECT ANALYSIS You must evaluate the purchase of a proposed spectrometer for the R&D department....NEW PROJECT ANALYSIS
You must evaluate the purchase of a proposed spectrometer for
the R&D department. The base price is $250,000, and it would
cost another $62,500 to modify the equipment for special use by the
firm. The equipment falls into the MACRS 3-year class and would be
sold after 3 years for $100,000. The applicable depreciation rates
are 33%, 45%, 15%, and 7%. The equipment would require a $15,000
increase in net operating working capital (spare parts inventory).
The...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|