213x Filetype XLSX File size 0.34 MB Source: www.iisd.org
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 |
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% |
no reviews yet
Please Login to review.