Subscribe

Coal Thermal and Clean-Coal Project Finance Model Template (Financials Tab) – free demo

April 17th, 2016 Posted in power generation

Coal Thermal and Clean-Coal Project Finance Model Template (Financials Tab) – free demo

This is the latest project finance model template (financials tab or worksheet) that your energy technology selection expert has developed for the geothermal power generation technology using energy stored on the earth’s crust. Familiarize with the template and if interested, get the full unlocked version for your immediate use. I can also provide data input service or customize further the model.

Solid fossil fuel such as coal (lignite, sub-bituminous, bituminous, etc.) are available in large quantities in many places around the world and will provide a cheap source of fuel to generated power in base-load coal-fired power plants using circulating fluidized bed (CFB) and the newer pulverized coal (PC) technologies such as super-critical and ultra-super-critical technologies.

The project finance model contains the following worksheets, including the Financials template for developing your own financial model:

1) Cover sheet

2) Inputs & Assumptions (model inputs and summary outputs)

3) Tariff Breakdown summary

4) Sensitivity Analysis (contains tax and incentives regime table and sensitivity run summary)

5) Construction Period calculations

6) Operating Period calculations

7) Financials summary

8) Asset Base FIT calculation

The complete template is found in the Financials worksheet and contains the step-by-step calculations done in a project finance model. It contains the following major sections:

a) Income statement

b) Retained Earnings and Capital

c) Base Construction Cost Breakdown (and projected cost breakdown if construction and commercial operation is delayed)

d) Funds Drawdown and Financing Cost during Construction

e) Sources and Uses of Funds During Construction in US$

f) Sources and Uses of Funds During Construction in Local Currency

g) Evolution of Balance Sheet Accounts (receivables, payables, inventory, input VAT, output VAT, acquisition of capital costs of depreciable and non-depreciable items, debt and equity drawdown, local debt and foreign debt amortization schedule, debt service reserve fund, recovery of VAT on imported equipment, monetization of initial working capital at end of life)

h) Cash Flow statement (from operations, investing and financing, net cash flow for period, beginning and ending balances)

i) Balance sheet (assets, liabilities, equity)

j) Equity returns (IRR, NPV, PAYBACK) – e.g. 30% equity and 70% debt

k) Project returns (IRR, NPV, PAYBACK) – e.g. 100% equity and 0% debt

l) Levelized Tariff and Generation Cost

m) Levelized Cost Breakdown of Electricity Price

n) Debt Service Cover Ratio (DSCR)

o) Benefits and Costs Analysis Ratio (B/C Ratio)

p) Financial Ratios (liquidity ratios, solvency ratios or leveraged ratios, efficiency ratios, profitability ratios, and market prospect ratios)

Download the sample model below to see and appreciate this complete template for building a project finance model from scratch.

adv-coal-fired-cfb-thermal-model3_50-mw-demo5 – subcritical circulating fluidized bed (CFB) technology 50 MW

adv-coal-fired-cfb-thermal-model3_135-mw-demo5– subcritical circulating fluidized bed (CFB) technology 135 MW

adv-coal-fired-pc-subcritical-thermal-model3-demo5– subcritical pulverized coal (PC) technology 400 MW

adv-coal-fired-pc-supercritical-thermal-model3-demo5 – supercritical pulverized coal (PC) technology 500 MW

adv-coal-fired-pc-ultrasupercritical-thermal-model3-demo5 – ultrasupercritical pulverized coal (PC) technology 650 MW

adv-petcoke-fired-pc-subcritical-thermal-model3-demo5– petroleum coke (petcoke) fired subcritical thermal 220 MW

A write-up on coal-fired  and other solid-fueled power generation technologies is also attached for further understanding on this technology.

Pulverized Coal

Advanced Coal

Better, email me if you are interested to obtain the full-version (unlocked):

energydataexpert@gmail.com

You can secure the basic template model and if you need further assistance, we can provide data input service, customization service, and sensitivity analysis and summary write-up.

Email me now with this Discount Voucher #1001 and get a 50% discount on the list price (USD 1,800 per model) for a net price of USD 900 per model.

Cheers,

Your energy technology selection expert and project finance modeling expert

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>