Cademy logoCademy Marketplace

Course Images

Project Finance Modelling

Project Finance Modelling

By F1F9 Academy

4.9(12)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 12 hours

  • All levels

Description

Project Finance Modelling will teach you how to build a financial model to evaluate equity returns and secure non-recourse debt. It focuses on applying general business and non-recourse finance theory to cash flows forecast to arise from greenfield projects and special purpose vehicles (“SPVs”). You will also build a model that evaluates equity returns and may be used to negotiate and secure non-recourse debt through a process of model optimisation. On completing the course, you will have constructed a fully-functional financial model covering the period from the beginning of construction through to the end of the project’s operating period. To get started, please work through Excel Proficiency Skills and then Model Construction Skills if you are new to F1F9 training. Then you'll be ready to start with the Project Finance Modelling modules. Do remember we're here to support you: simply email us at support@f1f9.com.

course Content

1 sections•52 lessons
Contents52 lessons
  1. 1Welcome to the course
  2. 2Overview: Introduction to Project Finance
  3. 3Perspectives: The importance of the financial model in Project Finance
  4. 4Module 1: Roadmap of the start model
  5. 5Perspectives: Simplicity in financial modelling
  6. 6Perspectives: What the project sponsor wants from the financial modeller
  7. 7Module 2: Review of construction costs
  8. 8Perspectives: Construction issues in Project Finance - part 1
  9. 9Perspectives: Construction issues in Project Finance - part 2
  10. 10Module 3: Construction period sources and uses of funds
  11. 11Perspectives: Project Finance issues in the power sector
  12. 12Module 4: Modelling sources of funds
  13. 13Perspectives: The future of infrastructure financing
  14. 14Module 5: Modelling finance costs during construction
  15. 15Perspectives: Understanding a term sheet
  16. 16Module 6: Modelling and testing interest during construction
  17. 17Perspectives: Role of the banks and Credit Committee process
  18. 18Module 7: Construction debt: pro rata vs. equity first
  19. 19Perspectives: The Due Diligence process
  20. 20Module 8a: Modelling opening balances - compare and contrast different approaches to timelines
  21. 21Module 8b: Modelling opening balances - building the air lock
  22. 22Module 8c: Modelling opening balances - what qualifies as a non-current asset?
  23. 23Module 8d: Modelling opening balances - understanding the opening balance sheet
  24. 24Module 8e: Modelling opening balances - track sheet
  25. 25Module 9a: Debt service cover ratios - current period DSCR and minimum DSCR
  26. 26Module 9b: Debt service cover ratios - backward looking
  27. 27Module 9c: Debt service cover ratios - forward looking
  28. 28Module 9d: Debt service cover ratios - average ratios
  29. 29Module 10a: Loan life cover ratios - Initial LLCR
  30. 30Module 10b: Loan life cover ratios - rolling LLCR
  31. 31Perspectives: Pension funds and infrastructure financing
  32. 32Module 11: Project life cover ratios
  33. 33Perspectives: Credit documents
  34. 34Module 12: Debt sculpture and converged ratios
  35. 35Perspectives: Security package
  36. 36Module 13a: Blended equity rate of return
  37. 37Module 13b: Blended equity rate of return - continued
  38. 38Module 14: Debt service reserve accounts
  39. 39Perspectives: Collaboration in Project Finance
  40. 40Module 15: Shareholder loans
  41. 41Perspectives: Background of a Project Finance banker
  42. 42Module 16: Revolving credit facility
  43. 43Module 17a: Model optimisation - part 1
  44. 44Module 17b: Model optimisation - part 2
  45. 45Module 17c: Model optimisation - part 3
  46. 46Module 18a: Major maintenance reserve account - relocating checks
  47. 47Module 18b: Major maintenance reserve account - assessing the impact of the MRA on the financial statements
  48. 48Module 18c: Major maintenance reserve account - modelling the MRA
  49. 49Module 18d: Major maintenance reserve account - assessing and modelling smoothed maintenance costs
  50. 50BID EXERCISE: Instructions - please read carefully
  51. 51Submit your bid information here
  52. 52PFM (online) course feedback

About The Provider

F1F9 Academy

Expert & Certified Financial Modelling courses for best-in-class modelling

Read more about F1F9 Academy

Reviews

+ Add Review