jagomart
digital resources
picture1_Budget Spreadsheet 40268 | Cost Methodology Fiji Nap Tool Pilot


 213x       Filetype XLSX       File size 0.34 MB       Source: www.iisd.org


File: Budget Spreadsheet 40268 | Cost Methodology Fiji Nap Tool Pilot
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 ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
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%




The words contained in this file might help you see if this file matches what you are looking for:

...Sheet welcome republic of fiji national adaptation plan nap costing methodology tool and instructions june description this is designed to provide a simple cost analysis for proposed measures in s using basic inputs user can enter data any three approaches calculated approach an aggregate hybrid additional guidance examples are provided the companion document by ministry economy ccicd iisd available at xxxxx allows input individual line items activity costs like buying truck cement build seawall while add agency budget updating land planning code or building project from case studies similar activities combine two relying mainly on allowing include approachresults relevant analyses be seen sheets ndash assessed each run keep it less cluttered as was performed pilot exercise if more then copy before starting name being key definitions initial onetime equipment materials expected last longer than year recurring operational that incurred discount rate which future discounted general guide...

no reviews yet
Please Login to review.