Sheet 1: Welcome

	
	
	
	
	
	

		


		


		


		


		


		


		


		


		

 
		
		
	

		
Republic of Fiji National Adaptation Plan
		


		


		


		


		

 
		
		
	

		
NAP Costing Methodology Tool
		


		


		


		


		
	

		
Welcome and Instructions.   June 2020
		


		


		


		


		
	

		


		


		


		


		


		


		
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Description
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
This tool is designed to provide a simple cost analysis for proposed measures in Fiji's National Adaptation Plan.  Using basic inputs, a user can enter cost data using any of three costing approaches: a Calculated Cost Approach, an Aggregate Cost Approach, and a Hybrid Cost Approach. Additional guidance and examples are provided in the companion guidance document: Costing Methodology for Fiji's National Adaptation Plan, by Ministry of Economy / CCICD and IISD (available at XXXXX  [IISD -- ADD LINK HERE])

The Calculated Cost Approach allows a user to input individual line items for the activity costs (like buying a truck and cement to build a seawall), while the Aggregate Cost Approach allows a user to add agency budget line items (like updating a land planning code, or building a seawall) or project cost examples from case studies of similar activities. The Hybrid Cost Approach allows the user to combine the two approaches, relying mainly on the Aggregate Cost Approach, while allowing the user to include individual line items from the Calculated Cost Approach.

Results of the data and relevant analyses can be seen on Sheets 4–6.
		
	

		
Two measures can be assessed in each run of this tool, to keep it less cluttered, as was performed in the pilot exercise.  If more measures are to be run, then copy the tool before starting, and name each copy for the measures being run.
		
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Key Definitions
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Initial Costs
		


		
One-time costs for equipment or materials expected to last longer than a year
		


		


		


		


		


		


		


		


	
	

		
Recurring Costs
		


		
Operational costs that are expected to be incurred each year
		


		


		


		


		


		


		


		


	
	

		
Discount Rate
		


		
The rate at which future costs are discounted
		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
General User Guidelines
		


		


		


		


		
Initial Costs (in base year)
		
Recurring Costs / Operational Expenditures
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Cells with blue font and yellow background contain inputs which can be changed
		


		
Input
		


		


		


	
	

		
Cells with black font contain formulas and should not be changed
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Table of Contents
		


		


		


		
Description
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sheet 1 Key Inputs
		


		
Contains basic inputs regarding cost approach and discount/inflation rates
		
	

		
Sheet 2 Data Collection - Calculated Cost Approach
		
Contains all data entry for the Calculated or Hybrid Cost Approaches for measures being assessed
		
	

		
Sheet 3a Data Collection - Aggregate Cost Approach - agriculture pilot measure (in Pilot version of Excel tool)
		
Contains all data entry for the Aggregate or Hybrid Cost Approaches for the agriculture measure in pilot case
		
	

		
Sheet 3b Data Collection – Aggregate Cost Approach – Coastal pilot measure (in Pilot version of Excel tool)
		
Contains all data entry for the Aggregate or Hybrid Cost Approaches for the coastal measure in the pilot case
		
	

		
Sheet 4 Costs Subtotal
		


		
Aggregates data from Sheets 2–3; and contains inputs for users to subtract Shared Costs (other sources of funding) or add Other Operational Costs
		
	

		
Sheet 5 Sensitivity, Risk, Uncertainty
		


		
Calculates sensitivity analysis; and contains inputs for users to conduct risk and uncertainty assessments
		
	

		
Sheet 6 Reporting Results
		


		
Aggregates all inputs and calculations; and contains basic summary sheet and a reporting template for user to complete.
		
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
NAP-CM Tool was developed by AltaVerde Consulting LLC for IISD and Ministry of Economy
		

 


Sheet 2: Sheet1 Key Inputs

	
	
	
	
	

		


		

 
		
		


		

 
		
		


		


	
	

		
Republic of Fiji National Adaptation Plan
		


		


	
	

		
NAP Costing Methodology Tool
		


		


	
	

		
Sheet1 - Key Inputs
		


		


	
	

		


		


		


		


		


	
	

		
GUIDANCE NOTES:   1) Select one of the three cost calculation approaches. Hybrid Cost Approach simply allows some selected costs to be entered from the Calculated Cost Approach Sheet 2 to supplement the majority of the data entered in the Aggregate Cost Approach in Sheet 3. These are added together later in Sheet 4.
		
	

		
2) Base case discount and inflation rates: these values are the defaults.  If you want to vary those rates, please do so as Sensitivity cases for Sheet 5 (achieved by changing the default values here in this sheet to other values, however).
		
	

		
3) Default currency is Fiji dollar, FJD. Results in Sheet 6 can be expressed in USD if desired.
		
	

		
Cost Approach
		
Unit
		
Value
		


		


		


		


	
	

		
Calculated, Aggregate, or Hybrid
		
Menu
		
Hybrid
		


		


		


		
	

		


		


		


		


		


		


		


	
	

		
Timing
		
Unit
		
Value
		


		


		


		


	
	

		
Base Year
		
Year
		
2021
		


		


		


		


	
	

		
Analysis Duration
		
Years
		
5
		


		


		


		


	
	

		
End Year
		
Year
		
2025
		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Base Case Discount, Inflation Rates
		
Unit
		
Value
		


		


		
Initial Costs (in base year)
		
Recurring Costs / Operational Expenditures
	
	

		
Base case discount rate
		
%
		
5.75%
		


		


		


		


	
	

		
Base case inflation rate
		
%
		
3.00%
		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Currency
		
Unit
		
Value
		


		


		


		


	
	

		
Enter Fiji dollar to US dollar exchange rate (in base year)
		
(FJD / 1 USD)
		
2.18
		


		


		


		


	
	

		
Exchange rate inflator
		
% per year
		
1%