Online Excel Based Solar Power Financial Modelling Course

Learn all important concepts and technical terms about solar irradiation, solar plant types, and how to develop a complete solar plant.
00:00
00:00

Online Excel Based Solar Power Financial Modelling Course

Learn all important concepts and technical terms about solar irradiation, solar plant types, and how to develop a complete solar plant.
175
views
1
Save
Share the link to this page
Copied

About the Class

What will you learn in your course?

You will learn how to do financial modeling of solar power plants/projects and decide about the profitability in investing solar power plant by covering the topics as follows:

  • Inputs: solar insolation kWh/m2/day, various component specs, and efficiencies, units produced (kWh/ year), generation derating factor %, tracker efficiency %, tariff discount %.
  • Carbon credits rate Euro/CER, project cost, loan interest rates %, moratorium period years, capital structuring equity ratio
  • Optimization levers to key project costs accelerated depreciation selection, tax incentives, tax, and MAT rates %.
  • Outputs: levelised cost of energy (LCOE), project IRR, project payback, equity IRR, equity payback, average DSCR, return on equity (ROE)
  • Return on capital employed (ROCE), return on investment (ROI), gains from tax savings due to depreciation, net estimated expenses and revenues in 25 years, net gain over the project life cycle, cash flows for the project life cycle
  • Modeling analysis: project costs details, electricity generation estimates, depreciation including accelerated depreciation, loan interest, working capital for preoperative phase, projected balance sheet
  • Profit and loss statement, income tax both under the companies act and income tax act, minimum alternative tax (MAT), cash flows, debt service charge ratio (DSCR), internal rate of return (IRR)
  • Breakeven point, payback ratios, summary various ratios, form II to form VI various standard forms required for bankable detailed, project report, carbon credit modeling
  • Bid related results: scenario analysis to arrive at optimum bid tariff rate, bank.

Author

Nitish Sengar

Developing Solar Consciousness...
Teaching faculty: - B.E. ( Electrical ) from University of Pune ( India ). - Core experienced in Solar Power Design, Installatation, Maintenance, Safety, Troubleshooting & Finance modelling Projects in India. - SCGJ ( Govt. in India ) certifed in Solar Power Assessment Projects in India. - Owner- Proprietorship firm named Solar-Complete in...

School

Nitish Sengar's School

Requirements

  • You should have an electrical or electronics engineering degree or an accountant degree 
  • You should have knowledge of solar power
One-time Fee
$10
List Price:  $68
You save:  $58
€8.55
List Price:  €58.15
You save:  €49.60
£7.39
List Price:  £50.26
You save:  £42.86
CA$13.69
List Price:  CA$93.10
You save:  CA$79.41
A$15.18
List Price:  A$103.23
You save:  A$88.05
S$12.79
List Price:  S$87
You save:  S$74.21
HK$78.49
List Price:  HK$533.79
You save:  HK$455.29
CHF 7.95
List Price:  CHF 54.11
You save:  CHF 46.15
NOK kr101.04
List Price:  NOK kr687.08
You save:  NOK kr586.04
DKK kr63.81
List Price:  DKK kr433.92
You save:  DKK kr370.10
NZ$16.61
List Price:  NZ$112.94
You save:  NZ$96.33
د.إ36.73
List Price:  د.إ249.76
You save:  د.إ213.03
৳1,216.79
List Price:  ৳8,274.20
You save:  ৳7,057.41
₹857.73
List Price:  ₹5,832.58
You save:  ₹4,974.85
RM42.52
List Price:  RM289.17
You save:  RM246.64
₦15,309.90
List Price:  ₦104,107.32
You save:  ₦88,797.42
₨2,846.08
List Price:  ₨19,353.35
You save:  ₨16,507.27
฿324.21
List Price:  ฿2,204.62
You save:  ฿1,880.41
₺401.73
List Price:  ₺2,731.81
You save:  ₺2,330.07
B$55.35
List Price:  B$376.43
You save:  B$321.07
R178.37
List Price:  R1,212.96
You save:  R1,034.59
Лв16.72
List Price:  Лв113.75
You save:  Лв97.02
₩13,743.86
List Price:  ₩93,458.25
You save:  ₩79,714.39
₪33.34
List Price:  ₪226.77
You save:  ₪193.42
₱565.02
List Price:  ₱3,842.16
You save:  ₱3,277.14
¥1,468.16
List Price:  ¥9,983.48
You save:  ¥8,515.32
MX$186.81
List Price:  MX$1,270.33
You save:  MX$1,083.52
QR36.42
List Price:  QR247.66
You save:  QR211.24
P133.33
List Price:  P906.67
You save:  P773.33
KSh1,292
List Price:  KSh8,785.60
You save:  KSh7,493.60
E£495.05
List Price:  E£3,366.34
You save:  E£2,871.29
ብር1,353.75
List Price:  ብር9,205.50
You save:  ብር7,851.75
Kz9,119.55
List Price:  Kz62,012.94
You save:  Kz52,893.39
CLP$9,500.60
List Price:  CLP$64,604.08
You save:  CLP$55,103.48
CN¥71.68
List Price:  CN¥487.42
You save:  CN¥415.74
RD$601.64
List Price:  RD$4,091.15
You save:  RD$3,489.51
DA1,297.71
List Price:  DA8,824.44
You save:  DA7,526.73
FJ$22.41
List Price:  FJ$152.40
You save:  FJ$129.99
Q76.87
List Price:  Q522.72
You save:  Q445.85
GY$2,093.51
List Price:  GY$14,235.90
You save:  GY$12,142.39
ISK kr1,217.80
List Price:  ISK kr8,281.04
You save:  ISK kr7,063.24
DH89.97
List Price:  DH611.81
You save:  DH521.84
L169.57
List Price:  L1,153.08
You save:  L983.51
ден526.40
List Price:  ден3,579.52
You save:  ден3,053.12
MOP$80.90
List Price:  MOP$550.18
You save:  MOP$469.27
N$177.64
List Price:  N$1,208.01
You save:  N$1,030.36
C$367.93
List Price:  C$2,501.97
You save:  C$2,134.03
रु1,371.04
List Price:  रु9,323.07
You save:  रु7,952.03
S/35.46
List Price:  S/241.12
You save:  S/205.66
K41.24
List Price:  K280.48
You save:  K239.23
SAR37.50
List Price:  SAR255.03
You save:  SAR217.52
ZK242.40
List Price:  ZK1,648.37
You save:  ZK1,405.96
L43.44
List Price:  L295.39
You save:  L251.95
Kč210.89
List Price:  Kč1,434.05
You save:  Kč1,223.16
Ft3,416.47
List Price:  Ft23,232.01
You save:  Ft19,815.54
SEK kr95.31
List Price:  SEK kr648.15
You save:  SEK kr552.83
ARS$12,557.44
List Price:  ARS$85,390.63
You save:  ARS$72,833.18
Bs68.85
List Price:  Bs468.23
You save:  Bs399.37
COP$40,196.66
List Price:  COP$273,337.29
You save:  COP$233,140.63
₡5,046.51
List Price:  ₡34,316.32
You save:  ₡29,269.80
L263.15
List Price:  L1,789.43
You save:  L1,526.28
₲77,553.31
List Price:  ₲527,362.57
You save:  ₲449,809.25
$U404.34
List Price:  $U2,749.55
You save:  $U2,345.21
zł36.38
List Price:  zł247.43
You save:  zł211.05

What's Included

Language: English
Level: All levels
Skills: Electricity Generation, Balance Sheet, Financial Modelling, Solar Plants, Cash Flows, Life Cycle, Accelerated Depreciation, Solar Projects, Project Costs, Modelling Analysis, Revenues, Tax Savings, Solar Power
Age groups: 18-65 years
Certificate: On completion
Duration: 7 hours 17 minutes
19 Videos
10 Documents
1
Save
175
Views
This class has not been saved

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.