Question: I just need a little help understanding how to get the answers please: Coca Cola's CEO is now looking to expand its operations by investing

I just need a little help understanding how to get the answers please:

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

A narrated PowerPoint presentation that will highlight the following items.

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

oNet present value

oInternal rate of return

oDiscounted payback period.

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

Please embed your Excel spreadsheets into your document. Be sure to follow APA standards for this project.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!