#### Go to GreenTreks Home

Note: Going home clears all of these panels.

Get
CTAP M and E RI

#### Capital Budget NPV Calculator

Introduction
This tool calculates net present value totals for operating and capital budget uris. The discounted totals include operating, allocated overhead, capital, and incentive-adjusted totals. Annual totals reflect the cost for operations or components that have an effective life different than 1 period.

Calculation View Description
v202a

Version: 1.7.0

#### Relations

Use In Childs?
Overwrite Childs?

#### Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.

#### Step 1

• Step 1. Real and Nominal Rates: The nominal rate includes inflation while the real rate does not. In the USA, DevTreks recommends using Office of Management and Budget rates for the same year as the date of the input.

#### Step 2

• Step 2. Use Same Calculator Pack In Descendants?: True to insert or update this same calculator in children.
• Step 3. Overwrite Descendants?: True to insert or update all of the attributes of this same calculator in all children. False only updates children attributes that are controlled by the developer of this calculator (i.e. version, stylehsheet name, relatedcalculatorstype ...)
• Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
• Step 2. Related Calculators Type: When the Use Same Calculator Pack in Descendant is true, uses this value to determine which descendant calculator to update. Inserts a new descendant when no descendant has this same name. Updates the descendant that has this same name.
• Step 2. Alternative Type: This property is used to analyze differences between Alternatives.
• Step 2. Target Type: This property is used to analyze progress being achieved with budget goals.
• Step 2. Calculated Results: Please refer to the references below.

#### References

• Hallam, Eidman, Morehart and Klonsky (editors) Commodity Cost and Returns Estimation Handbook, Staff General Research Papers, Iowa State University, Department of Economics, 1999

Current view of document
CTAP M and E RI
Investment Group : CTAP M and E RI
Document Status : underreview
Description : This data is used in a CTAP tutorial.
Label : RI Investment Type : 0
Date : 12/05/2015 Last Changed : 12/5/2015 12:00:00 AM
Investment :A CTAP BM M and E RI
Label 1 Label 2 Last Modif. Init. Value Salv. Value Interest Rates Nom. Rate Real Rate
RIA none 12/5/2015 12:00:00 AM 0.0000 0.0000 0.0300 0.0100
Description
This data is used in a CTAP tutorial.
Time Period : 2016 BM CTAP
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2016 True True 1 none 0 0
Time Period 2016 BM CTAP Last Changed 12/31/2016 12:00:00 AM
Description
This data is used in a CTAP tutorial.
Label Y1 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : CTAP RI BMQ2
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2016 Q2 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E BM RI Q2 Label : B2016Q2
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest 0.02
6/30/2016 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 1.02
Benefit Interest - Outcome 0.02 0.02
Total Benefit - Outcome 1.02 1.02
Total Incentive-Adjusted Benefits - Outcome 1.02 1.02
Outcome : CTAP RI BMQ4
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2016 Q4 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E BM RI Q4 Label : B2016Q4
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest 0.00
12/30/2016 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 1.00
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 1.00 1.00
Total Incentive-Adjusted Benefits - Outcome 1.00 1.00
Totals Annual Totals
Total Benefit -Time Period 2.02 2.02
Total Incentive Ben -Time Period 2.02 2.02
Costs
Component : CTAP RI BMQ2
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2016 Q2 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP BM RI Q2 Label : A2016Q2
06/30/2016 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 1.02
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.02 0.02
Total Capital Costs - Component 1.02 1.02
Total Incentive-Adjusted Costs - Component 1.02 1.02
Component : CTAP RI BMQ4
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2016 Q4 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP BM RI Q4 Label : A2016Q4
12/30/2016 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 1.00
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 1.00 1.00
Total Incentive-Adjusted Costs - Component 1.00 1.00
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 2.02 2.02
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 2.02 2.02
Capital Costs (CAP)
Total Capital Costs -Time Period 2.02 2.02
Net Returns -Time Period 0.00 0.00
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 2.02 2.02
Net Incentive Returns -Time Period 0.00 0.00
Time Period : 2017 BM CTAP
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2017 False True 1 none 0 0
Time Period 2017 BM CTAP Last Changed 12/31/2017 12:00:00 AM
Description
This data is used in a CTAP tutorial.
Label Y2 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : CTAP RI BMQ6
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2017 Q6 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E BM RI Q6 Label : B2017Q6
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest -0.01
6/30/2017 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.99
Benefit Interest - Outcome -0.01 -0.01
Total Benefit - Outcome 0.99 0.99
Total Incentive-Adjusted Benefits - Outcome 0.99 0.99
Outcome : CTAP RI BMQ8
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2017 Q8 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E BM RI Q8 Label : B2017Q8
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest -0.01
12/30/2017 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.99
Benefit Interest - Outcome -0.01 -0.01
Total Benefit - Outcome 0.99 0.99
Total Incentive-Adjusted Benefits - Outcome 0.99 0.99
Totals Annual Totals
Total Benefit -Time Period 1.98 1.98
Total Incentive Ben -Time Period 1.98 1.98
Costs
Component : CTAP RI BMQ6
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2017 Q6 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP BM RI Q6 Label : A2017Q6
06/30/2017 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 0.99
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest -0.01 -0.01
Total Capital Costs - Component 0.99 0.99
Total Incentive-Adjusted Costs - Component 0.99 0.99
Component : CTAP RI BMQ8
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2017 Q8 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP BM RI Q8 Label : A2017Q8
12/30/2017 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 0.99
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest -0.01 -0.01
Total Capital Costs - Component 0.99 0.99
Total Incentive-Adjusted Costs - Component 0.99 0.99
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 1.98 1.98
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 1.98 1.98
Capital Costs (CAP)
Total Capital Costs -Time Period 1.98 1.98
Net Returns -Time Period 0.00 0.00
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 1.98 1.98
Net Incentive Returns -Time Period 0.00 0.00
Investment Totals and Nets Totals Annual Totals
Total Benefit -Investment 4.00 4.00
Total Operating Costs -Investment 0.00 0.00
Net Operating Returns -Investment 4.00 4.00
Total Allocated Overhead Costs -Investment 0.00 0.00
Net Operating and Overhead Returns -Investment 4.00 4.00
Total Capital Expenditure Costs -Investment 4.00 4.00
Net Returns -Investment 0.00 0.00
Equivalent Annual Annuity -Investment 0.00
Total Incentive Ben -Investment 4.00 4.00
Total Incentive Costs -Investment 4.00 4.00
Net Incentive Returns -Investment 0.00 0.00
Investment :B CTAP Actual M and E RI
Label 1 Label 2 Last Modif. Init. Value Salv. Value Interest Rates Nom. Rate Real Rate
RIA none 12/5/2015 12:00:00 AM 0.0000 0.0000 0.0300 0.0100
Description
This data is used in a CTAP tutorial.
Time Period : 2016 Actual CTAP
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2016 True True 1 none 0 0
Time Period 2016 Actual CTAP Last Changed 12/31/2016 12:00:00 AM
Description
This data is used in a CTAP tutorial.
Label Y1 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : CTAP RI ACTQ2
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2016 Q2 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E Actual RI Q2 Label : B2016Q2
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest 0.02
6/30/2016 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 1.02
Benefit Interest - Outcome 0.02 0.02
Total Benefit - Outcome 1.02 1.02
Total Incentive-Adjusted Benefits - Outcome 1.02 1.02
Outcome : CTAP RI ACTQ4
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2016 Q4 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E Actual RI Q4 Label : B2016Q4
1 1 each 1 each 1.0000 1.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest 0.00
12/30/2016 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 1.00
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 1.00 1.00
Total Incentive-Adjusted Benefits - Outcome 1.00 1.00
Totals Annual Totals
Total Benefit -Time Period 2.02 2.02
Total Incentive Ben -Time Period 2.02 2.02
Costs
Component : CTAP RI ACTQ2
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2016 Q2 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP Actual RI Q2 Label : A2016Q2
06/30/2016 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 1.02
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.02 0.02
Total Capital Costs - Component 1.02 1.02
Total Incentive-Adjusted Costs - Component 1.02 1.02
Component : CTAP RI ACTQ4
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2016 Q4 1 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP Actual RI Q4 Label : A2016Q4
12/30/2016 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 1.00
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 1.00 1.00
Total Incentive-Adjusted Costs - Component 1.00 1.00
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 2.02 2.02
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 2.02 2.02
Capital Costs (CAP)
Total Capital Costs -Time Period 2.02 2.02
Net Returns -Time Period 0.00 0.00
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 2.02 2.02
Net Incentive Returns -Time Period 0.00 0.00
Time Period : 2017 Actual CTAP
Ending Date Common Ref.? Discount? Practice Amt. Enter. Unit Growth Type Growth Periods
12/31/2017 False True 1 none 0 0
Time Period 2017 Actual CTAP Last Changed 12/31/2017 12:00:00 AM
Description
This data is used in a CTAP tutorial.
Label Y2 Incentive Amount 0.0000 Incentive Rate 0 Overhead Factor 0
Benefits
Outcome : CTAP RI ACTQ6
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2017 Q6 0 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : CTAP- Actual RI Q6 Label : B2017Q6
1 1 each 0 each 2.0000 0.00
Description
This output is used in a Resource Stock Progress Analysis of a Resiliency Index.
Interest 0.00
6/30/2017 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.00
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 0.00 0.00
Total Incentive-Adjusted Benefits - Outcome 0.00 0.00
Outcome : CTAP RI ACTQ8
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2017 Q8 0 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Times Compos Amount Compos Unit Output Amount Output Unit Output Price Total Benefit Annual Total
Date Received Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Output : M and E Actual RI Q8 Label : B2016Q8
1 1 each 0 each 1.0000 0.00
Description
This output is used in an M and E Analysis of a Resiliency Index.
Interest 0.00
12/30/2017 12:00:00 AM Incentive Amount 0.0000 Incentive Rate 0
Total Output Benefit 0.00
Benefit Interest - Outcome 0.00 0.00
Total Benefit - Outcome 0.00 0.00
Total Incentive-Adjusted Benefits - Outcome 0.00 0.00
Totals Annual Totals
Total Benefit -Time Period 0.00 0.00
Total Incentive Ben -Time Period 0.00 0.00
Costs
Component : CTAP RI ACTQ6
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
06/30/2017 Q6 0 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP Actual RI Q6 Label : A2017Q6
06/30/2017 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 0 each 1.0000 0.00
Incentive 0.0000 0 0.00
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 0.00 0.00
Total Incentive-Adjusted Costs - Component 0.00 0.00
Component : CTAP RI ACTQ8
Ending Date Label Amount Unit Life SalvageValue Incent Amount Incent Rate
12/30/2017 Q8 0 each 1 0.0000 0.0000 0
Description
This data is used in a CTAP tutorial.
Date Applied Times OH Used? Amount Unit Price Total Annual Total
Incentive Incent. Amount Incent. Rate INCENT Total Annual Total
Input : CTAP Actual RI Q8 Label : A2016Q8
12/30/2017 1 False 0 none 0.0000 0.00
Allocated OH 0 none 0.0000 0.00
Capital 1 each 1.0000 1.00
Incentive 0.0000 0 0.99
Description
This data is used in a CTAP tutorial.
Operating Cost Interest 0.00 0.00
Total Operating Costs - Component 0.00 0.00
Allocated Overhead Cost Interest 0.00 0.00
Total Allocated Overhead Costs - Component 0.00 0.00
Capital Cost Interest 0.00 0.00
Total Capital Costs - Component 0.00 0.00
Total Incentive-Adjusted Costs - Component 0.00 0.00
Operating Costs (OC)
Total Operating Costs -Time Period 0.00 0.00
Net Operating Returns -Time Period 0.00 0.00
Total Allocated Overhead Costs -Time Period 0.00 0.00
Net Operating and Overhead Returns -Time Period 0.00 0.00
Capital Costs (CAP)
Total Capital Costs -Time Period 0.00 0.00
Net Returns -Time Period 0.00 0.00
Incentive Costs (INCENT)
Total Incentive Costs -Time Period 0.00 0.00
Net Incentive Returns -Time Period 0.00 0.00
Investment Totals and Nets Totals Annual Totals
Total Benefit -Investment 2.02 2.02
Total Operating Costs -Investment 0.00 0.00
Net Operating Returns -Investment 2.02 2.02
Total Allocated Overhead Costs -Investment 0.00 0.00
Net Operating and Overhead Returns -Investment 2.02 2.02
Total Capital Expenditure Costs -Investment 2.02 2.02
Net Returns -Investment 0.00 0.00
Equivalent Annual Annuity -Investment 0.00
Total Incentive Ben -Investment 2.02 2.02
Total Incentive Costs -Investment 2.02 2.02
Net Incentive Returns -Investment 0.00 0.00
Investment Group Totals and Nets Totals Annual Totals
Total Benefit - Investment Group 6.01 6.01
Total Operating Costs - Investment Group 0.00 0.00
Total Overhead Costs - Investment Group 0.00 0.00
Total Capital Costs - Investment Group 6.01 6.01
Net Returns - Investment Group 0.00 0.00
Total Incentives Ben -Investment Group 6.01 6.01
Total Incentive Costs - Investment Group 6.01 6.01
Net Incentive Returns - Investment Group 0.00 0.00
Dataset: CTAP M and E RI IRI This data is used in a CTAP tutorial.