# Corporate Finance Calculations and Summary

Not what you're looking for?

Hi, I need some assistance using Excel to complete the following:

First identify or calculate the capital spending, the operating cash flow, the change in net working capital, and finally the free cash flow to the firm of the project. Free Cash Flows are cash flows available to the firm after stakeholders have been paid (interest and dividends). It is these free cash flows that you find that are discounted at the weighted average cost of capital to calculate the net present value and the internal rate of return.

You will assess whether to make the investment or not. Use your accept-reject rules for the net present value and the internal rate of return.

Redbird, Inc. is considering an addition to its current operations. The figures are below.

Cost of the new project:

- $3,000,000

Installation costs

- $100,000

Estimated unit sales in year 1

- $40,000

Estimated unit sales in year 2

- $65,000

Estimated unit sales in year 3

- $35,000

Estimated sales price in year 1

- $200

Estimated sales price in year 2

- $200

Estimated sales price in year 3

- $150

Variable cost per unit

- $130

Annual fixed cost

- $40,000

Initial working capital needed

- $60,000

Additional Working capital needed

- 5 % of sales

Depreciation method

- 5 years straight-line method, no salvage value

Redbird's tax rate

- 40%

Redbird's cost of capital

Calculate Operating Cash Flow, change in Net Working Capital, and calculate Free Cash Flow. Show your calculations in a Word document or an Excel spreadsheet. Determine the NPV and IRR of the project. Show your calculations in a Word document or an Excel spreadsheet. Assess the project. Be sure to state the basis upon which you made your option choices. You should prepare a one-page executive summary of your findings, with 3-5 pages of supporting analysis.

##### Purchase this Solution

##### Solution Summary

The following posting helps with corporate finance calculations such as capital spending, operating cash flow and net working capital.

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

##### Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

##### Introduction to Finance

This quiz test introductory finance topics.

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.