Course curriculum

  • 1

    Introduction

    • Welcome

    • Course introduction

    • Solar case study overview

    • Case study details

    • Downloadable files

  • 2

    Renewable Energy Overview

    • Learning objectives

    • Renewable energy

    • Key renewable energy terms

    • Other key renewable energy terms

    • Key financing terms

    • Corporate vs project finance

    • Financial model goals

  • 3

    Return Metrics

    • Determining the IRR

    • Return metrics

  • 4

    Financial Model – Layout and Structure

    • Model structure and formatting

  • 5

    Financial Model – Assumptions Section

    • Assumptions section

    • Date periods

    • Energy production and capex assumptions

    • PPA assumptions

    • Tax rates financing assumptions and PPA term pricing

    • Operating costs assumptions

  • 6

    Financial Model – Financial Section

    • Financial section

    • Year periods

    • Revenue

    • Expenses and EBITDA

  • 7

    Financial Model – Returns Section

    • Returns section

    • Discounting year for debt

    • Debt covenants

    • Maximum debt sizing

    • Interest and target principal amount

    • Debt schedule

    • Debt service coverage ratios

    • Depreciation schedule

    • Tax shelter and taxes payable

    • Tax shelter section audit

    • EBITDA and adjustments

    • FCFE and project IRR

    • Running IRR, cash-on-cash, running cash-on-cash

    • Payback

    • Acquisition cost

  • 8

    Financial Model – Sensitivity Analysis

    • Sensitivity analysis overview

    • Sensitivity analysis on IRR and payback

  • 9

    Charts and Graphs

    • Charts and graphs overview

    • Linking the data

    • Pie chart - construction costs and capital stack

    • Bar chart - return data

    • Download completed model

    • Thank you

  • 10

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion