Capital Budgeting Analysis Excel Model
  • Capital Budgeting Analysis Excel Model
Originally published: 20/06/2016 10:52
Last version published: 02/02/2018 14:50
Publication number: ELQ-58034-2
View all versions & Certificate

Capital Budgeting Analysis Excel Model

This Excel Model allows you to do a basic capital budgeting analysis for a project, and compute NPV, IRR and ROI

With this Capital Budgeting Excel Model, compute the equity analysis of a project by giving data on your initial investment, working capital, growth rates, cashflow details and discount rate.

- Prof. Aswath Damodaran

Side note: If you have appreciated this model, feel free to give it a rating/review!

This Best Practice includes
1 Excel Model File

Prof. Aswath Damodaran offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

The objective of this Capital Budgeting Analysis Excel Model is to get the following output values:
- Net Present Value (NPV)
- Internal Rate of Return (IRR)
- Return on Capital (ROC)



More Best Practices from Prof. Aswath Damodaran

See all

Discussion feed for Capital Budgeting Analysis Excel Model

The user community and author are here to help. Go ahead!

  • Gary Ostafin
    I downloaded template, but can't find actual template to use
    1arrow_drop_uparrow_drop_downReply reply
    • Eloquens Team
      Hi Gary!

      (As this seems to be more a technical issue), we will intervene instead of Prof. Aswath Damodaran.

      Here is the process to download your Capital Budgeting Analysis Excel Model (when signed in, and when having added the tool to your library):
      1/ Go to:
      2/ Then click on the blue link with the text "Capital Budgeting Analysis Excel Model"
      3/ Then on this page, scroll down until you find the big blue "download" button, and click on it
      4/ Go to your downloads folder on your MAC/PC and find the excel file there!

      Hope this helps!

      Let us know if you have any additional questions. You can reach out to us via Private Message here:

      The Eloquens Team
      arrow_drop_uparrow_drop_downReply reply
    please wait...