Explore BrainMass
Share

Cash Flow analysis, NPV and IRR

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

A company is considering the replacement of an existing machine. Develop the relevant cash flows to analyze the proposed replacement. Determine the net present value, the IRR of the proposal and make a recommendation to accept or reject the replacement proposal. What is the highest cost of capital that the firm could have and still accept the proposal?

New Machine Cost \$1.2 million
Installation Cost \$150,000.00
Can be sold for \$200,000.00 net of removal and clean up costs at the end of 5 years
Will be depreciated using MACRS using 5 yr recovery
Should reduce operating costs by \$350,000 per year

Existing Machine ( is 2 years old)
Existing Machine ( is 2 years old) can be sold for 185000 before taxes
Cost New \$800,000.00
Book Value \$384,000.00
Remaining Useful Life 5 years
Depreciated under MACRS using 5 year recovery
Final 4 years of depreciation remaining
If it is held for 5 more years the machines market value will be \$0.00

An increased investment in net working capital of \$25,000.00 will be needed to support operations of the new machine. Firm has a 9% cost of capital and is subject to 40% tax rate.

Solution Summary

Response guides about Cash Flow analysis, NPV and IRR to evaluate replacement of existing machine

\$2.19

NPV, IRR, and Sensitivity Analysis

Crumbly Cookie Company is considering expanding by buying a new (additional) machine that costs \$42,000, has zero terminal disposal value and a 10-year useful life. It expects the annual increase in cash revenues from the expansion to be \$23,000 per year. It expects additional annual cash costs to be \$16,000 per year. Its cost of capital is 6%. Ignore taxes.

1. Calculate the net present value and internal rate of return for this investment.
2. Assume the finance manager of Crumbly Cookie Company is not sure about the cash revenues and costs. The revenues could be anywhere from 10% higher to 10% lower than predicted. Assume cash costs are still \$16,000 per year. What are NPV and IRR at the high and low points for revenue?
3. The finance manager thinks that costs will vary with revenues, and if the revenues are 10% higher, the costs will be 7% higher. If the revenues are 10% lower, the costs will be 10% lower. Recalculate the NPV and IRR at the high and low revenue points with this new cost information.
4. The finance manager has decided that the company should earn 2% more than the cost of capital on any project. Recalculate the original NPV in #1 using the new discount rate and evaluate the investment opportunity.
5. Discuss how the changes in assumptions have affected the decision to expand.

* Complete in Excel

View Full Posting Details