Capital Budgetting Workbook

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

budgetfinanceplanningvaluation

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 business tool includes
1 Excel Model

Matt Evans offers you this business tool for free!

Download for free

Ask a question

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

Reviews

  • No review yet!

Any questions on Capital Budgetting Workbook?

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

please wait...