1
1. The equipment has a delivered cost of $205,000. An additional $4,000 is required to install
and test the new system.
2. The new pumping system is classified by the IRS as 5-year property, although it has an
8-year estimated service life. For assets classified by the IRS as 5-year property, the
Modified Accelerated Cost Recovery System (MACRS) permits the company to depreciate
the asset over 6 years at the following rates: Year 1 = 20 percent, Year 2 = 32 percent,
Year 3 = 19 percent, Year 4 = 12 percent, Year 5 = 11 percent, Year 6 = 6 percent. At the
2
end of 8 years, the salvage value is expected to be around 5 percent of the original
purchase price, so the best estimate of salvage value at the end of the equipment's service
life is $5,300, with removal costs of $1,200.
3. The existing pumping system was purchased at $45,000 eight years ago and has been
depreciated on a straight-line basis over its economic life of 10 years. If the existing system
is removed from the well and crated for pickup, it can be sold for $3,500 before tax. It will
cost $1,000 to remove the system and crate it.
4. At the time of replacement, the firm will need to increase its net working capital
requirements by $4,500 to support inventories.
5. The new pumping system offers lower maintenance costs and frees personnel who would
otherwise have to monitor the system. In addition, it reduces product wastage because of
a higher cooling efficiency. In total, it is estimated that the yearly savings will amount to
$25,000 if the new pumping system is used.
6. The firm has its target debt ratio of 30 percent, and its cost of new debt is 10 percent. Its
expected dividend per share next year, D1, is $2.00 with a future growth rate of 6 percent
per year. The firm’s current stock price, P0, is $40.00. The firm uses its overall weighted
average cost of capital in evaluating average risk projects, and the replacement project is
perceived to be of average risk.
7. The firm’s federal-plus-state tax rate is 30 percent, and this rate is projected to remain
fairly constant into the future.
QUESTIONS
(Please show all your work either through Excel formulas/equations on the Cash Flow
Estimation Worksheet or in separate tables at the bottom of your spreadsheet, whenever
applicable. NO WORK SHOWN, NO POINTS.)
1. Compute the firm’s weighted average cost of capital given the info/data in the case. What
other approaches/methods can be used to measure the firm’s cost of equity and thus
its WACC? To that end, what additional info/data would you need? (Hint: A firm’s
weighted average cost of capital is equal to 𝐾𝑎 = 𝑊𝑑(𝐾𝑑)(1 - t) + 𝑊𝑒𝐾𝑒, where 𝑊𝑑 and
𝑊𝑒 are the weights of debt and equity in the capital structure; 𝐾𝑑 and 𝐾𝑒 are the
respective costs of debt and equity; and t is the corporate tax rate; Do no round up
your WACC figure.)
3
2. Develop a capital budgeting schedule using the attached Cash Flow Estimation Worksheet
(Excel spreadsheet) that should list all relevant cash flow items and amounts related
to the replacement project over the 8-year expected life of the new pumping system.
3. Based on the capital budgeting schedule, evaluate the replacement project by computing
NV, IRR, MIRR, and Payback Period. Would you recommend to accept or reject the
replacement project based solely on your DCF analysis so far?
4. Before you make the final accept/reject decision, what other factors and approaches would
you consider further? Discuss also how to PRACTICALLY take into account those
factors and approaches in the capital budgeting decision process, whenever
applicable
(
1
1. The equipment has a delivered cost of $205,000. An additional $4,000 is required to install
and test the new system.
2. The new pumping system is classified by the IRS as 5-year property, although it has an
8-year estimated service life. For assets classified by the IRS as 5-year property, the
Modified Accelerated Cost Recovery System (MACRS) permits the company to depreciate
the asset over 6 years at the following rates: Year 1 = 20 percent, Year 2 = 32 percent,
Year 3 = 19 percent, Year 4 = 12 percent, Year 5 = 11 percent, Year 6 = 6 percent. At the
2
end of 8 years, the salvage value is expected to be around 5 percent of the original
purchase price, so the best estimate of salvage value at the end of the equipment's service
life is $5,300, with removal costs of $1,200.
3. The existing pumping system was purchased at $45,000 eight years ago and has been
depreciated on a straight-line basis over its economic life of 10 years. If the existing system
is removed from the well and crated for pickup, it can be sold for $3,500 before tax. It will
cost $1,000 to remove the system and crate it.
4. At the time of replacement, the firm will need to increase its net working capital
requirements by $4,500 to support inventories.
5. The new pumping system offers lower maintenance costs and frees personnel who would
otherwise have to monitor the system. In addition, it reduces product wastage because of
a higher cooling efficiency. In total, it is estimated that the yearly savings will amount to
$25,000 if the new pumping system is used.
6. The firm has its target debt ratio of 30 percent, and its cost of new debt is 10 percent. Its
expected dividend per share next year, D1, is $2.00 with a future growth rate of 6 percent
per year. The firm’s current stock price, P0, is $40.00. The firm uses its overall weighted
average cost of capital in evaluating average risk projects, and the replacement project is
perceived to be of average risk.
7. The firm’s federal-plus-state tax rate is 30 percent, and this rate is projected to remain
fairly constant into the future.
QUESTIONS
(Please show all your work either through Excel formulas/equations on the Cash Flow
Estimation Worksheet or in separate tables at the bottom of your spreadsheet, whenever
applicable. NO WORK SHOWN, NO POINTS.)
1. Compute the firm’s weighted average cost of capital given the info/data in the case. What
other approaches/methods can be used to measure the firm’s cost of equity and thus
its WACC? To that end, what additional info/data would you need? (Hint: A firm’s
weighted average cost of capital is equal to 𝐾𝑎 = 𝑊𝑑(𝐾𝑑)(1 - t) + 𝑊𝑒𝐾𝑒, where 𝑊𝑑 and
𝑊𝑒 are the weights of debt and equity in the capital structure; 𝐾𝑑 and 𝐾𝑒 are the
respective costs of debt and equity; and t is the corporate tax rate; Do no round up
your WACC figure.)
3
2. Develop a capital budgeting schedule using the attached Cash Flow Estimation Worksheet
(Excel spreadsheet) that should list all relevant cash flow items and amounts related
to the replacement project over the 8-year expected life of the new pumping system.
3. Based on the capital budgeting schedule, evaluate the replacement project by computing
NV, IRR, MIRR, and Payback Period. Would you recommend to accept or reject the
replacement project based solely on your DCF analysis so far?
4. Before you make the final accept/reject decision, what other factors and approaches would
you consider further? Discuss also how to PRACTICALLY take into account those
factors and approaches in the capital budgeting decision process, whenever
applicable
(
Sheet1
FALCONVILLE PUMP COMPANY - CASH FLOW ESTIMATION WORK WORKSHEET | ||||||||
Input Data | New pump | |||||||
Cost of NEW equipment | 209000 | Annual dep. of old equipment | ||||||
Salvage value new equipment | 10450 | OLD equipment's depreciable life left | ||||||
Cost of old equipment | Old equipment's depreciated years | |||||||
Depreciation of old equipment till date | Annal cost savings | |||||||
Salvage value of old equipment | Removal cost of old equipment | |||||||
Tax rate | Removal cost of new equipment | |||||||
WACC | Net working capital requirement | |||||||
t=0 | t=1 | t=2 | t=3 | t=4 | t=5 | t=6 | t=7 | t=8 |
I | INVESTMENT OUTLAY | |||||||
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
II | OPERATING CASH FLOWS OVER THE PROJECT'S LIFE | |||||||
7 | ||||||||
8 | ||||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
III | TERMINAL YEAR CASH FLOWS | |||||||
13 | ||||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
IV | NET CASH FLOWS | |||||||
18 | ||||||||
V | RESULTS | |||||||
NPV | = | |||||||
IRR | = | |||||||
MIRR | = | |||||||
Payback period = | ||||||||
DECISION BASED ON YOUR ANALYSIS: | ||||||||
ANSWERS TO QUESTIONS: | ||||||||
Q#1: | ||||||||
Q#2: | ||||||||
Q#3: | ||||||||
Q#4: | ||||||||
Sheet2
Sheet3

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com