Preparing a Capital Budgeting Analysis

1. Step 1: Determine the total amount of the investment.
2. Step 2: Determine the cash flows the investment will return.
3. Step 3: Determine the residual/terminal value.
4. Step 4: Calculate the annual cash flows of the investment.
5. Step 5: Calculate the NPV of the cash flows.

What are five methods of Capital Budgeting?

5 Methods for Capital Budgeting

• Internal Rate of Return.
• Net Present Value.
• Profitability Index.
• Accounting Rate of Return.
• Payback Period.

Which cost is not relevant in Capital Budgeting?

Irrelevant costs are those that will not change in the future when you make one decision versus another. Examples of irrelevant costs are sunk costs, committed costs, or overheads as these cannot be avoided.

What is a capital budget analysis?

Capital budgeting is used by companies to evaluate major projects and investments, such as new plants or equipment. The process involves analyzing a project’s cash inflows and outflows to determine whether the expected return meets a set benchmark.

What 3 pieces of data are needed to perform a capital budget analysis?

We will use three criteria: Net Present Value, Modified Internal Rate of Return, and Discounted Payback Period. The first criterion we will use to evaluate capital projects is Net Present Value.

What are the five steps of capital budgeting analysis?

The five steps of capital budgeting are often described as exploring opportunities, estimating costs, determining the benefits, assessing any potential risk involved, and making the final decision.

How is capital budgeting used in financial analysis?

Capital budgeting analysis uses various processes: Various capital budgets are used in decision-making to determine which projects will yield the most return over a given period. In this section, Zero-Based Budget and Rolling, or Continuous, Budget types of capital budgeting decision-making tools will be discussed.

Why are cash flow considerations important in capital budgeting?

Cash flow considerations are an important factor in capital budgeting. Projects are evaluated on the incremental cash flows that they bring in over and above the amount that they would generate in their next best alternative use. This is done to quantify just how much better one project is over another.

Why do you need a capital budget spreadsheet?

In other cases, a separate estimation or assumption of the Project Cost of Capital is required. This Capital Budgeting spreadsheet aims to assist investors, managers or analysts in correctly estimating the cash flow in different scenarios and accurately calculating the Net Present Value and Internal Rate of Return.

What are the assumptions for a capital budget?

This worksheet performs capital budgeting analysis by making three basic assumptions. The assumptions are the Discount Rate to use in the investment project, the company’s Tax Rate and the estimated percentage of Net Working Capital over Sales. 1.2.2 Projected Income The net income of the project is calculated by using the following formula: