Oil Pump Price Model – Excel Spreadsheet

September 14th, 2012 No Comments   Posted in Oil Pricing Formula

Oil Pump Price Model – Excel Spreadsheet

Calculation model for the following products:

  98 Octane – Super Premium
  95 Octane – Premium
  93 Octane – Unleaded
  87 Octane – Regular / Naphtha
  Avgas
  Kerosene
  Avturbo
  Low Sulfur Diesel
  Regular Diesel
  Low Sulfur Fuel Oil
  Bunker C Fuel Oil
  Lubricating Oils
  LPG – Cooking
  LPG – Power / Automotive

 

Click the link below to order, remit payment via PayPal, then download in one easy step. More »

De-Politicizing Public Transport Fare Adjustment – Incremental Cost Model

September 4th, 2012 No Comments   Posted in Transport Fare

De-Politicizing Public Transport Fare Adjustment – Incremental Cost Model

In an oil deregulated regime, wherein oil companies adjust prices on a weekly or monthly basis in response to rapid changes in the international prices of crude oil and finished petroleum products, the public transport sector normally bears the brunt of the price adjustments since the public fare structure is subject to public hearings at the Land Transport Franchising & Regulatory Board (LFTRB) before any upward or downward adjustments are approved and implemented. More »

Solar PV-Diesel Hybrid Project finance Model with Resource Assessment – now available

March 21st, 2012 2 Comments   Posted in financial models

Solar PV-Diesel Hybrid Project finance Model with Resource Assessment – now available

Analyzing the economics of a solar PV-diesel hybrid power plant
(as well as other RE-diesel hybrid systems such as wind-diesel, biomass-diesel,
mini-hydro-diesel) has now become simple with the new solar PV-diesel project
finance model that makes use of the PVSYST V5.4 solar energy model. Avoid the
time consuming hassle by purchasing this latest product offering from your
energy technology selection expert. More »

How to order your project finance models for power plants – get 50% discount via PayPal

December 18th, 2009 Comments Off on How to order your project finance models for power plants – get 50% discount via PayPal Posted in financial models

How to order your project finance models for power plants – get 50% discount (extended 28 Feb 2015) via PayPal

Due to numerous inquiries and tremendous interest, the deadline has been extend up to 28 Feb 2015.  Order now to get 50% discount on any project finance model of your choice.

This advanced model allows you to perform the following:

1) Determine the impact of electricity tariff (selling price) on NPV, IRR and payback given the capital cost, fuel cost and O&M cost.

2) Determine the maximum main fuel price (natural gas, gas oil) to meet IRR given electricity tariff, capital cost and O&M cost.

3) Determine the maximum capital cost (all-in) to meet IRR given electricity tariff, fuel price and O&M cost.

4) Perform sensitivity analysis (+/- 10% change) on variables such as electricity tariff, rated capacity, plant heat rate (efficiency), fuel cost, capital cost and O&M costs on IRR.

5) The IRR may be defined as DCF-ROI (project cost vs cash flow), DCF-ROE (equity portion of project cost vs cash flow), DCF-FC (equity portion vs free cashflow), and discounted DCF-FC (native currency is depreciating vs foreign currency).  The model provides for analysis with escalation (nominal IRR) and without escalation (real IRR).

6) Optimize type of CCGT engine/manufacturer, plant location and cooling system (once thru sea water, once thru lake water, river cooling tower, deep well cooling tower, radiator cooling) and transmission line system (type of conductor).  The optimal configuration is determined by the combination that provides the cheapest electricity tariff, cheapest fuel or highest IRR. More »