Fpc replacement project analysis worksheet


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 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)

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.)

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

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10