Capital Budgeting Excel Model
  • Capital Budgeting Excel Model
  • Capital Budgeting Excel Model
  • Capital Budgeting Excel Model
  • Capital Budgeting Excel Model
Originally published: 24/12/2018 09:29
Last version published: 20/06/2019 09:33
Publication number: ELQ-78459-3
View all versions & Certificate
certified

Capital Budgeting Excel Model

Should I pursue the project? Analyse your Investment Decision with this 4 tab Excel Template.

Description
This is a 4 tab Excel model that will help you evaluate a project and take a decision whether to pursue the project or not and which project should pursue between the two.

How do you use the Model?

1) Intro tab - you have to select how you are going to fund the project out of the 3 options presented: Equity, Debt and Equity+Debt. After clicking one option you will be re-directed to that specific page.

2) Equity Tab - This is were you will have to fill the inputs provided in blue. i.e Project cost, Life of the project, Salvage Value, Year, Expected Return Cost, Annual saving Because of that project expected, expected savings to invest in the project and Expected future cash flows etc... The Model will then calculate present value of all the future cash flows and will calculate 4 Major decision indicators.
1. NPV (Net Present Value)
2. IRR (Internal Rate of Return)
3. Return on investment (ROI)
4. Profitability Index (PI)

3) Bank Loan Tab - This is were you will have to fill the inputs provided in blue i.e Project cost, Year, Salvage Value, Interest Rate and expected future cash flow etc.. The Model will then calculate present value of all the future cash flows and will calculate 4 Major decision indicators.
1. NPV (Net Present Value)
2. IRR (Internal Rate of Return)
3. Return on investment (ROI)
4. Profitability Index (PI)

4) Equity+Loan - This is were you will have to fill the inputs provided in blue. i.e Project cost, Own Money (Equity), Life of the project, Salvage Value, Interest Rate, Equity Cost and expected future cash flow etc..
The Model will then calculate present value of all the future cash flows and will calculate 4 Major decision indicators.
1. NPV (Net Present Value)
2. IRR (Internal Rate of Return)
3. Return on investment (ROI)
4. Profitability Index (PI)

This model is prepared to consider all of the major and minor aspects that can effect the cash flow of an the project and will help you to select the one that is profitable for you.

You must have basic Excel knowledge to use this capital budgeting excel model.
-Jatin

This Best Practice includes
1 Excel Model

Acquire business license for $55.00

Add to cart

Add to bookmarks

Discuss

Further information

Project Decision

Decision Making, Project Analysis

Standalone

Reviews

  • Rate this Downloadable Tool

    Write a review

  • Tibor Rusiňák(last updated: 22/06/2019 14:28)
  • Amir Ganic(last updated: 01/01/2019 14:34)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Jatin Goel

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Capital Budgeting Excel Model?

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


4.0 / 5 (2 votes)

please wait...