Capital Budgetting Workbook
Originally published: 19/07/2016 09:50
Publication number: ELQ-46576-1
View all versions & Certificate
certified

Capital Budgetting Workbook

This model can be adapted to illustrate concepts related to capital budgeting analysis of projects

Description
Certain aspects of a capital project may have not been included in order to help highlight basic concepts, such as Net Present Value. The spreadsheet is setup to evaluate six different projects and summarize all projects based on both economic analysis and risk factors assigned.

The user must define the following inputs:
- Project name(s)
- Marginal tax rate
- Weighted average cost of capital
- Threshold investment amount where formal project analysis is not required

This Best Practice includes
1 Excel Model

Matt Evans offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Outpus:
- Required investment
- Preliminary points
- Project value
- Rate of return
- Payback period
- Risk factor
- Relative risk
- Absolute risk

The solver feature of Excel must be installed


4.6 / 5 (17 votes)

please wait...