Capital Budgeting Calculator
  Cash Flow Frequency
0  
1
2
3
4
5
6
7
8
9
10
Cost of Capital:
%

NPV: $

IRR: %

Payback:

EAA(not used):

The Capital Budgeting Calculator can be used to calculate the Net Present Value, Internal Rate of Return, Payback Period, and Equivalent Annual Annuity of a Capital Budgeting project. The calculator works similarly to the Cash Flow functions of the Texas Instruments BA II Plus calculator.

1.     Cash Flow at Time 0 - Enter the cash flow which occurs at time 0 in this field.

2.     Cash Flow at Time 1 - Enter the cash flow which occurs at time 1 in this field. Enter the number of time periods in which the cash flow occurs in succession in the field directly to the right. If the cash flow only occurs once, enter 1 in the field directly to the right. The next distinct cash flow and its frequency are entered in the following row.

3.     Cost of Capital Field - Enter the Cost of Capital in this field.

4.     NPV Field - The Net Present Value of the Capital Budgeting project is displayed in this field.

5.     IRR Field - The Internal Rate of Return of the Capital Budgeting project is displayed in this field.

6.     Payback Field - The Payback Period of the Capital Budgeting project is displayed in this field.

7.     EAA Field (not used in class) - The Equivalent Annual Annuity of the Capital Budgeting project is displayed in this field.

8.     Buttons - Press the Calculate button to calculate the NPV, IRR, etc. for the Capital Budgeting project. Press the Clear button to clear the calculator.

 
copy right 2002 - 2019 by Mark A. Lane, Ph.D
http://www.zenwealth.com/BusinessFinanceOnline/CB/CBCalcExercise.html.