Bean Counter
    https://www.dwmbeancounter.com
   
   
   
Capital Investment Model
 
Project Summary
 
NPV Rate 10.00% 15.00% 20.00% 10.00% 15.00% 20.00%      
Calculations   NPV     PI   IRR Payback ARR
Project 1 $0 $0 $0 0.00 0.00 0.00 na 0 Years 0.00%
Project 2 $0 $0 $0 0.00 0.00 0.00 na 0 Years 0.00%
Project 3 $0 $0 $0 0.00 0.00 0.00 na 0 Years 0.00%
Project 4 $0 $0 $0 0.00 0.00 0.00 na 0 Years 0.00%
Project 5 $0 $0 $0 0.00 0.00 0.00 na 0 Years 0.00%
Periods 0 1 2 3 4 5 6 7 8 9 10
                       
Number Of Periods   Only Needed For ARR Calculation                  
Project 1                      
Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expense 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Capital Investment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Annual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Cumulative) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
                       
Number Of Periods   Only Needed For ARR Calculation                  
Project 2                      
Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expense 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Capital Investment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Annual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Cumulative) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
                       
Number Of Periods   Only Needed For ARR Calculation                  
Project 3                      
Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expense 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Capital Investment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Annual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Cumulative) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
                       
Number Of Periods   Only Needed For ARR Calculation                  
Project 4                      
Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expense 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Capital Investment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Annual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Cumulative) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
                       
Number Of Periods   Only Needed For ARR Calculation                  
Project 5                      
Revenues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expense 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Profit $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Capital Investment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Annual) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash Flow (Cumulative) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
   
Net Present Value (NPV)            
Net Present Value (NPV) is a way to figure out if an investment will make a profit, considering that money today is  
 worth more than money in the future.           
It compares the current value of expected future cash flows (like revenue or savings) with the initial investment cost.  
Decision Criteria: According the NPV technique, for accept-reject type of decision, if the 
 
       
project has a positive NPV, the project is acceptable. If a project(s) NPV is less than ‘Zero’. It     
gives negative NPV. Hence, it must be rejected. For mutually exclusive projects (i.e., only     
one project will be selected) the project with highest positive NPV should be selected.    
             
Internal Rate Of Return (IRR)          
This is another important discounted cash flow technique used in capital budgeting decisions    
 IRR can be defined as that rate which equates the present value of cash inflows       
with the present value of cash outflows of an investment proposal. It is the rate at which the     
net present value of the investment proposal is zero.         
If the internal rate of return exceeds the required rate of return, then the project is accepted. If     
the project’s IRR is lower that the required rate of return, it will be rejected. In case of     
ranking the proposals, the technique of IRR is significantly used. The projects with higher     
rate of return will be ranked as first compared to the lowest rate of return projects.      
Thus, the             
IRR acceptance rules are:             
Accept if r>k             
Reject if r<k             
May accept or reject if r=k             
Where; r = internal rate of return           
k=cost of capital            
             
Payback Method            
The payback method is a capital budgeting technique that determines how long it takes for an investment to recoup its initial cost.   
It's a simple and quick way to assess the profitability of an investment by calculating the time it takes for the cash flow  
from the investment to equal its original cost.          
 A shorter payback period generally indicates a more attractive investment, as it signifies a quicker return on investment. 
             
Profitability Index (PI)             
The profitability index (PI) is a financial metric that assesses the attractiveness of an investment by comparing the present
value of future cash flows to the initial investment.  It essentially measures how much value is created per dollar invested.
 A PI greater than 1 suggests the project is likely profitable, while a PI less than 1 indicates it might not be a good investment. 
             
Average Rate Of Return (ARR)          
The average rate of return (ARR) is a capital budgeting method that calculates the average annual percentage return
 on an investment.             
It's a simple metric that helps businesses assess the profitability of a project by comparing the average annual profit 
to the initial investment.          
Projects that exceed the target ARR are considered acceptable, while those falling below it are typically rejected.