The Project Financier includes

Project Finance

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Access one of the most extensive project finance online courses available. Learn risk management, the accounting specifics, how to structure the finance behind a project, and build both a simple and advanced project finance model.

Completion time

10 Hours

Level

Skills Certificate

About

Access one of the most extensive project finance online courses available. Learn risk management, the accounting specifics, how to structure the finance behind a project, and build both a simple and advanced project finance model.

Completion time

10 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Introduction to Project Finance

24

0

Accordion Arrow Icon

Video minutes24

Excel Exercises0

  • Project finance introduction
  • How project finance is different
  • Project finance mechanics
  • Project finance process
  • Project finance contract summary
  • Project finance contracts detail
  • Eurotunnel case study
  • Information memorandum

Risk Management in Project Finance

16

0

Accordion Arrow Icon

Video minutes16

Excel Exercises0

  • Risk taxonomy
  • Risk management
  • Pre-completion risks
  • Post-completion risks
  • Risks common to both parties
  • Risk reduction summary

Financing the Project

45

6

Accordion Arrow Icon

Video minutes45

Excel Exercises6

  • Financing and insurance package
  • Understanding debt capacity
  • How much can the project borrow
  • How much equity does the project need
  • Syndicated loan financing
  • How many banks in the syndicate
  • Syndication strategy
  • Financial crisis and the development of club deals
  • Fee structures in loan syndication
  • Mandated lead arranger
  • What has changed in the syndication market
  • Return on equity of loan
  • Return on equity of two bank loans
  • Other financing options

Accounting for Project Finance

20

5

Accordion Arrow Icon

Video minutes20

Excel Exercises5

  • Project finance accounting
  • Cost capitalization

Project Finance Returns

26

6

Accordion Arrow Icon

Video minutes26

Excel Exercises6

  • Profitability to shareholders
  • Calculating the IRR
  • Calculating the IRR with an exit multiple
  • Returns to creditors and problems with the IRR
  • Model out a loan
  • Model out a bond
  • Dividend trap
  • Subordinated loan dividend trap

Modeling the Project

21

2

Accordion Arrow Icon

Video minutes21

Excel Exercises2

  • Cost terminology
  • Financing the construction costs
  • Sources and uses of funds
  • Operational phase
  • Unlevered free cash flows

Debt, Coverage Ratios and Covenants

29

3

Accordion Arrow Icon

Video minutes29

Excel Exercises3

  • Amortization methods
  • DSCR
  • Average life calculation for loan repayments
  • Average life
  • Coverage ratios
  • DSCR and LLCR
  • Security
  • Covenants
  • Covenant breach
  • Debt service coverage ratio covenant breach

Building a Simple Project Finance Model

27

9

Accordion Arrow Icon

Video minutes27

Excel Exercises9

  • Sources and uses of funds
  • PP&E
  • Soft assets and income statement
  • Calculations
  • Initial balance sheet
  • Cash flow statement
  • Debt schedule
  • Interest expense
  • Returns to equity holders

Building a Full Project Finance Model

81

24

Accordion Arrow Icon

Video minutes81

Excel Exercises24

  • Uses of funds
  • Sources of funds
  • Other assumptions
  • Revenues and variable costs
  • Depletion of soft costs and PP&E
  • Asset retirement obligation – asset
  •  Asset retirement obligation – liability
  • Income statement
  • Calcs – operating working capital
  • Calcs – Equity
  • Balance sheet
  • Cash flow preparation
  • Cash flow from operations
  • Cash flow from investing and financing activities
  • Cash flow available for debt service
  • Revolving credit facility
  • Syndicated loan
  • Debt service reserve account
  • Non-cash interest
  • Wiring up the debt lines
  • Interest during the construction phase
  • Interest during the operational period
  • Returns to equity holders
  • Loan life coverage ratio
  • Structuring the debt

The Accountant

4.4 STARS

Star Rating
Accordion White Arrow Icon

About

Quickly and confidently interpret financial data and statements, evaluate them and use the calculated information to build high-quality reports. Real company data and the latest rules are covered to ensure the methods used and skills developed are immediately applicable in the workplace.

Completion time

13 Hours

Level

Skills Certificate

About

Quickly and confidently interpret financial data and statements, evaluate them and use the calculated information to build high-quality reports. Real company data and the latest rules are covered to ensure the methods used and skills developed are immediately applicable in the workplace.

Completion time

13 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Financial Accounting Review

33

3

Accordion Arrow Icon

Video minutes33

Excel Exercises3

  • Making entries and ensuring the balance sheet balances
  • Preparing a balance sheet
  • Preparing an income statement from the entries to retained earnings
  • Preparing a cash flow statement from the entries to the cash account
  • A review of the different categorizations on the income statement, balance sheet, and the cash flow statement

Income Statements

61

15

Accordion Arrow Icon

Video minutes61

Excel Exercises15

  • Revenue recognition issues
  • Cost recognition issues
  • Identifying non-recurring items from the income statement, the MD&A, the notes to the accounts and the financial statement press release
  • Calculating EBIT and EBITDA for the historical year, and on an LTM basis

Earnings Per Share

27

11

Accordion Arrow Icon

Video minutes27

Excel Exercises11

  • Basic EPS calculations including weighted average shares
  • Dilutive securities: options (treasury method) and convertibles (as if converted)
  • Calculating recurring EPS

Working Capital

56

12

Accordion Arrow Icon

Video minutes56

Excel Exercises12

  • Inventory accounting including the impact on EBIT of LIFO and FIFO accounting choices (where relevant)
  • Accounts receivable and bad debts (identifying when companies are manipulating sales)
  • Accounts payable and accruals and the difference between them from a due diligence perspective
  • Other items including taxes payable, deferred revenue, and pre-paid items
  • Working capital and operating working capital and the cash impact of changes in operating working capital
  • Credit implications of working capital movements
  • Day ratios

Non-Current Assets

39

11

Accordion Arrow Icon

Video minutes39

Excel Exercises11

  • Gross PP&E, accumulated depreciation, depreciation expense and net PP&E
  • Building a simple forecast of fixed assets
  • Establishing the age of a company’s fixed asset base
  • Finite, and infinite intangibles including goodwill
  • A review of key methods of accounting for financial investments
  • At fair value through the income statement
  • Available for sale
  • Associate (equity method) accounting

Capital Structure

50

14

Accordion Arrow Icon

Video minutes50

Excel Exercises14

  • Debt issues and repurchases
  • Simple yield to maturity and all in cost calculations and understanding Original Issuer Discounts
  • Calculating net debt
  • Equity issuance and repurchases
  • The difference between authorized, issued and outstanding shares and multiple share classes
  • Other capital items: preference shares and convertible bonds
  • Leverage ratios
  • Debt liability maturity analysis

Accounting Ratios

41

5

Accordion Arrow Icon

Video minutes41

Excel Exercises5

  • Profitability ratios, including margins
  • Liquidity ratios, including operating working capital
  • EBIT and EBITDA for the historical year, and on an LTM basis
  • Leverage ratios, including net debt and interest coverage
    Asset ratios

Cash Flow Statements

25

3

Accordion Arrow Icon

Video minutes25

Excel Exercises3

  • Understanding how to categorize cash flows between operating, investing, and financing
  • Deriving a cash flow statement from two balance sheets and an income statement
  • Deriving a balance sheet from a cash flow statement and an income statement
  • Different cash flow statement presentations

Equity Method Investments

9

5

Accordion Arrow Icon

Video minutes9

Excel Exercises5

  • What are equity method investments?
    • Equity affiliates/associates
    • Joint ventures
  • Equity method accounting
    • Income statement
    • Balance sheet
    • Cash flow statement
    • Financial statement integration

Intro to Full Consolidation

68

21

Accordion Arrow Icon

Video minutes68

Excel Exercises21

  • M&A accounting overview
  • Balance sheet consolidation
  • Sources and uses of funds
  • Goodwill calculation
  • Income statement consolidation
  • Non controlling interests – NCI

The Modeler

4.6 STARS

Star Rating
Accordion White Arrow Icon

About

Financial modeling is one of the most useful skills in the world of finance. Knowing how to build models quickly and error-free is critical for the decisions and recommendations that they underpin. Our online financial modeling course provides the perfect introduction to building models, developing multiple techniques for a comprehensive and practical understanding of the topic.

Completion time

12 Hours

Level

Skills Certificate

About

Financial modeling is one of the most useful skills in the world of finance. Knowing how to build models quickly and error-free is critical for the decisions and recommendations that they underpin. Our online financial modeling course provides the perfect introduction to building models, developing multiple techniques for a comprehensive and practical understanding of the topic.

Completion time

12 Hours

Level

Skills Certificate

Module

Video Minutes

Excel Exercises

Introduction to Modeling

55

13

Accordion Arrow Icon

Video minutes55

Excel Exercises13

  • Key settings
  • Formatting and layout standards
  • Building a simple income statement and balance sheet model, on one sheet, then across sheets
  • Balancing the balance sheet using the cash flow statement
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Three Statement Modeling with Iterations

77

10

Accordion Arrow Icon

Video minutes77

Excel Exercises10

  • Income statement construction and highlighting key numbers
  • Calculation schedules (PP&E, retained earnings, operating working capital, and debt)
  • Balancing the balance sheet with a cash sweep
  • Calculating interest using average balances
  • Circular references and iterations
  • Working with a circular reference switch
  • Preparing the model for handover
  • Key formatting and putting the output into a pitch book

Three Statement Model Editing

44

6

Accordion Arrow Icon

Video minutes44

Excel Exercises6

  • Steps before editing
  • Inserting a new item
  • Removing an old item
  • After editing
  • Relevant keyboard shortcut keys

Three Statement Model With Estimates

70

12

Accordion Arrow Icon

Video minutes70

Excel Exercises12

  • Cleaning up the income statement and balance sheet and simplifying the line items
  • Getting estimates for revenues and EBIT
  • Building multiple scenarios into a model’s assumption
  • Modeling a forecast debt repayment schedule from the notes
  • Key ratios
  • Checking the model for reasonableness
  • Formatting and putting the output into a pitch book

Building a Model with Cash Sweep

71

19

Accordion Arrow Icon

Video minutes71

Excel Exercises19

  • Why banks want to be repaid early
  • Cash sweep mechanisms
  • How to model cash sweeps
  • Building a three statement model with a cash sweep

Checking a Model for Integrity and Errors

36

11

Accordion Arrow Icon

Video minutes36

Excel Exercises11

  • Top ten errors
  • Auditing and error checking toolkit
  • Checking your own model
  • Checking someone else’s model

Get Certification Recognized on Wall Street

Upgrade your résumé with certification recognized by the top 4 investment banks.

Our exams are similar to assessments at the top firms. This means they are going to challenge you. Our online courses will teach you everything you need to know to succeed.
The Project Financier is made up of 3 skills certificates. Pass each one to unlock your micro-degree. Certification can easily be added to LinkedIn, demonstrating your achievement which will be recognized by the most prestigious firms on Wall Street.

THIS MICRO-DEGREE HAS BEEN REVIEWED BY

Colin Evans

Managing Director at J.P. Morgan

Colin Evans is a Managing Director at J.P. Morgan and leads the financial institutions coverage team globally for Corporate Banking

Dr. Bridget Lyons

Professor of Finance

Professor of Finance at the Jack Welch College of Business at Sacred Heart University and Associate Instructor

Chris Bishko

CFO

CFO with over 25 years experience as an operator, investor and investment banker in technology and financial services.

Our Alumni

DEMONSTRATE YOU'RE AS GOOD AS THE BEST

By completing this course, you will be able to join our prestigious alumni on LinkedIn alongside hires at the top 4 investment banks. After becoming a member of this elite community, you can unlock exclusive benefits such as course discounts and more.

testimonials

what our students say

Individuals

Tzu-Chieh Lin

The Modeler

This is the right practical training which you cannot learn from professors in the university.

Corporate clients

Michael Whalley

The Accountant

Great videos, good variety of workings / Excel files!

View more

Frequently Asked Questions

What tech do I need?

Accordion Arrow Icon

Access your course across desktop, laptop, tablet or phone; either via our web portal or the dedicated mobile app. While we have optimized our video quality and size, we recommend a broadband connection to enable uninterrupted video playback. A PDF reader and spreadsheet application are required to open the supporting resources.

Is it right for me?

Accordion Arrow Icon

The Project Financier is perfect for those looking to develop project finance skills that don’t have a strong background in finance. The supporting accounting and modeling topics are covered comprehensively, providing the recommended foundation before learning the intricacies of financing projects.

Are Financial Edge's courses credible?

Accordion Arrow Icon

The 4 leading investment banks, as rated by the FT, hire us to train their incoming analysts. If you are looking to join the best analysts in the world, why not challenge yourself with the same content and certification with the same Wall Street instructors ready to answer your questions.

Will this course help me get a job in project finance?

Accordion Arrow Icon

Absolutely. Develop practical skills your can use to impress at interviews, whether you’re looking to break into the industry or change roles. Take advantage of our recruiter service to boost your chances.

How long do I have to complete the courses?

Accordion Arrow Icon

We are delighted to announce that we now offer lifetime access on all online courses! Fit studying around your schedule. Learn at your own pace with on-demand video, practical examples to download and expert instructor support.

Are there any hidden costs?

Accordion Arrow Icon

No. Everything you need to earn your micro-degree is included, from instructor-led videos and Excel exercises to the exam.

What is CPD?

Accordion Arrow Icon

All Financial Edge online courses are CPD accredited. CPD stands for Continuing Professional Development and makes demonstrating your commitment to learning easy. Your institution or accrediting body may track CDP points through activities, units or hours. Check with the relevant party to find out how you should be monitoring your progress.