All Courses Free Udemy Courses

Managing Project With Microsoft Excel – Free Udemy Courses

Managing Project With Microsoft Excel – Free Udemy Courses

Techniques of Capital Budgeting

What you’ll learn

Managing Project With Microsoft Excel – Free Udemy Courses

  • Project Management. Selection of Project. Microsoft Excel
  • Calculation of NPV. IRR, ROI


  • Basic knowledge of Excel and Project Management


Capital Budgeting come under the branch of Financial Management – Investment Decisions.

Capital budgeting is

the process a business undertakes to evaluate potential major projects or investments


Construction of a new plant or a big investment in an outside venture are examples of projects that would require capital budgeting before they are approved or rejected.

The organization wants to undertake a project than two important factors to be considered

Technical Feasibility if Project is not Technical feasible then no point in moving forward

Different capital budgeting methods include the Payback Period,

the accounting rate of return, the net present value, the discounted cash flow, the profitability Index, and the Internal Rate of Return method.

To Check Financial Feasibility we use Different methods /Techniques of capital budgeting

Capital Budgeting is a planning process to check whether a project is worth to take or not



3 PI


These methods use the incremental cash flows from each potential investment or



An example of a project with cash flows that do not conform to this pattern is a loan, consisting of a positive cash flow at the beginning, followed by negative cash flows later. The greater the IRR of the loan, the higher the rate the borrower must pay, so clearly, a lower IRR is preferable in this case. Any such loan with an IRR less than the cost of capital has a positive NPV.

Excluding such cases, for investment projects, where the pattern of cash flows is such that the higher the IRR, the higher the NPV, for mutually exclusive projects, the decision rule of taking the project with the highest IRR will maximize the return, but it may select a project with a lower NPV.

In some cases, several solutions to the equation NPV = 0 may exist, meaning there is more than one possible IRR. The IRR exists and is unique if one or more years of net investment (negative cash flow) are followed by years of net revenues. But if the signs of the cash flows change more than once, there may be several IRRs. The IRR equation generally cannot be solved analytically but only via iterations.

Who this course is for:

  • Students, Professionals, Business Analysts
  • Accounts, Business Development, Project Management, Finance

Udemy Free Courses

If the links does not work, contact us we will fix them