Financial Model for Ports with Alternative Scenarios for Biogas Project for Scenario and Sensitivity Analysis

Description
This tool allows for extensive financial analysis and projections for your Biogas projects and investments. It includes numerous functional tabs that allow you to input huge amounts of financial data to track the financial progress of your investments, and project future financial fluctuations. These tabs include:

Contents
Summary
Control Page
Inputs
Financial Model
Back Up Data
Data
Gannt

The inputs required to run the model are organized by type and are:

- Timing
- Production of Palm Oil and Efflent
- Production from Biogas Upgrading Unit
- Capacity and Production of Biogas Dispenser
- Truck Assumptions
- Revenues
- Operating Cost
- Capital Expenditures
- Generator
- Discount Rates

The sheet labeled "Financial model" contains the below calculation blocks:
- Truck Demand
- Production of CNG to Meet Demand
- Operating Expenses
- Capital Expenditure
- investor IRR Perspective
- Savings to Mill
- Replacement Capital Expenditure
- Tax
- Financing
- Mill Perspective

Within the Project Summary you can input various assumptions: Operating Assumptions, Financing Structure, Re-Financing, Returns, Credit, Uses of Funds etc. This means that you can create a simple and effective overview of your project finances.

The "Control Page" tab allows you to creating scenarios using many different factors:
- Mill Size
- Mill Availability
- Effluent Percent
- Percent CH4 in Effluent
- Capacity of Upgrader
- Availability of Upgrader
- Filling Flow Rate
- Truck Distance
- Number of Trucks
- Fuel Efficiency
- Real Diesel Price
- Discount to Diesel Price
- Diesel Price Inflation
- BOT Period
- Operating Period

This is a great tool for anyone interested in biogas investments to plan, track and project the finances of their investments.