Equipment and annual depreciation for project

Assignment Help Financial Management

Reference no: EM131933530

Coca Cola's CEO is now looking to expand its operations by investing in new property, plant, and equipment. You are now asked to do some capital budgeting analysis that will determine whether the company should invest in these new plant assets.

The parameters for this project are:

Coca Cola is now looking to expand its operations and wants you to do some analysis using key capital budgeting tools to accomplish this. The parameters for this project are as follows.

The firm is looking to expand its operations by 10% of the firm's net property, plant, and equipment. (Calculate this amount by taking 10% of the property, plant, and equipment figure that appears on the firm's balance sheet ( $10,635,000*.10= $1,063,500 )

The estimated life of this new property, plant, and equipment will be 12 years. The salvage value of the equipment will be 5% of the property, plant and equipment's cost.

The annual EBIT for this new project will be 18% of the project's cost.

The company will use the straight-line method to depreciate this equipment. Also assume that there will be no increases in net working capital each year. Use 38.90% as the tax rate.

The hurdle rate for this project will be the WACC 1.541%.

Deliverable for this Project an excel worksheet with:

· Your calculations for the amount of property, plant, and equipment and the annual depreciation for the project

· Your calculations that convert the project's EBIT to free cash flow for the 12 years of the project.

· The following capital budgeting results for the project

o Net present value

o Internal rate of return

o Discounted payback period.

· Your discussion of the results that you calculated above, including a recommendation for acceptance or rejection of the project.

Reference no: EM131933530

Questions Cloud

What will be its stock price the recapitalization : What is the stock's current price per share (before the recapitalization)? what will be its stock price following the recapitalization?

The beta of the common stock of unlevered firm : Comparing two otherwise equal firms, the beta of the common stock of an unlevered firm is _____________ the beta of a levered firm.

Determine the continousing value in terminal year : Using the WACC 12%, determine the continousing value in terminal year in the free cash flow growth rate of 4.5%.

About the price of the joint annuity : Determine anything about the price of the joint annuity because the differing ages of the annuitants would require the use of mortality

Equipment and annual depreciation for project : Your calculations for the amount of property, plant, and equipment and the annual depreciation for the project

Hope return on the no-load fund would be : Hope invested $7200 in a mutual fund at a time when the price per share was $27. Hope's return on the no-load fund would be ___%

What is the npv that oxygen optimization : What is the NPV that Oxygen Optimization would compute for project A?

Discount rate used for average-risk project : The appropriate discount rate for it is 1.19 percentage points different than the discount rate used for an average-risk project at Fairfax Pizza.

What is peter weighted average cost of capital : The U.S. Treasury bill is yielding 3 percent and market risk premium is 7% . Peter's tax rate is 35 percent.What is Peter's weighted average cost of capital?

User Account

All Pages