Energy Technology Expert

How to develop your own project finance model

How to develop your own project finance model

In simplest terms, a project finance model is a business plan written in some sort of a spreadsheet implemented in software (e.g. MS Excel).

It is prepared primarily to assist a potential investor like you to assess numerous business alternatives that you might want to venture into — and decide which alternative would meet your investment objectives – capital requirement, payback, profitability or internal rate of return, cash flows and risks profile.

By preparing in advance a financial model and doing simple to complicated sensitivity tests, the potential investor is forewarned of any potential problems in advance so that mitigation measures are put in place to address such potential risks and problems.

It consists of the following worksheets (or tabs):

1) Assumption or Input worksheet

2) Capital Cost Estimation Worksheet

3) Project Schedule or Drawdown Worksheet

4) Total Project Cost Summary Worksheet (equipment, taxes, installation, land, working capital, capitalized expenses, capitalized interest during construction)

5) Loan Amortization Worksheet (interest, principal repayment)

6) Depreciation Worksheet (beginning balance, depreciation, ending balance)

7) Working Capital Worksheet (receivables, payables, stocks, training, mobilization)

8) Income & Expense Statement Worksheet

9) Balance Sheet Worksheet

More »

Energy Technology Expert is also Project Finance and Financial Modeling Expert

Energy Technology Expert is also a Project Finance Modeling Expert.

He will help you provide data to set up your own business model for power plants, manufacturing plants and direct lending or lending investor business.

Here is my resume. More »

Large-Scale Project Finance Models

Large-Scale Project Finance Models:

1. Oil Thermal Power Plant – 2,000 US$
   
   
   
2. Pulverized Thermal Power Plant – 4,000 US$
   
   
   
3. Advance Coal Thermal Power Plant – 6,000 US$
   
   
   
4. Geothermal Power Plant – 8,000 US$
   
   
   
5. Simple Gas Turbine Power Plant – 9,000 US$
   
   
   
6. Combined Cycle Gas Turbine Power Plant – 10,000 US$
   
   
   
7. Energy Storage Power Plant – 12,000 US$*
8. Solar Thermal Power Plant – 14,000 US$*
9. Fuel Cells Power Plant – 16,000 US$*
10. Ocean Thermal Power Plant – 18,000 US$*
11. Ocean Wave Power Plant – 20,000 US$*
12. Tidal Power Plant – 22,000 US$*
13. Nuclear Power Plant – 30,000 US$*

*Please inquire about payment options directly to me.

Contents:

1) Input (Assumption) Sheet

2) Report (Summary) Sheet

3) Project Cost Sheet (equipment cost, ocean freight, insurance, taxes & duties, brokerage & local shipping, erection & installation, land & right-of-way, project development & contract management, initial stocks & inventories, manpower mobilization & training, working capital, interest during construction, other capitalized expenses)

4) Construction Sheet (construction schedule, equity/loan drawdown, interest during construction)

5) Model Sheet (escalation of items, starting costs, capacity & degradation, heat rate & efficiency degradation, maintenance & overhaul scheduel, available hours, gross generation, plant use & net generation, transmission/distribution line constraints & losses, net electricity sales, revenue items, expense items, income statement, balance sheet, cash flow statement, project & equity IRR, project & equity payback, debt service cover ratio)

6) Depreciation Sheet (evolution of balance sheet accounts, working capital)

7) Loan Amortization Table (interest & principal repayment)

Small-Scale Project Finance Models

Small-Scale Project Finance Models:

1. Diesel Genset Power Plant – 100 US$
   
   
   
2. Biomass Power Plant – 200 US$
   
   
   
3. Cogen Power Plant – 300 US$
   
   
   
4. Hydro (Micro, Mini) Power Plant – 400 US$
   
   
   
5. Solar PV Power Plant – 600 US$
   
   
   
6. Wind Power Plant – 800 US$
   
   
   
7. Hybrid Power Plant (Diesel, Biomass, Solar, Wind, Micro-Hydro) – 1,000 US$
   
   
   

Hydro Power

The file (633 KB) will cover the following topics:

Hydro Power

Flowing water creates energy that can be stored, captured and turned into electricity. Hydropower is the world’s most important renewable energy source. It provides 7.2% of world’s primary energy and 18.5% of electric power generation.

Price: 13 USD