The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and flexible project finance models used in financial planning, structuring and fundraising purposes. 


 The participants will gain insights into the step-by-step process of creating financial models using Microsoft Excel, putting checks and audits and finally analyzing the same.


 Overview


This course will equip all participants with various tools to aid in complex business decision making by incorporating multiple factors operating in the dynamic business environment. At the end of the course, each participant will be able to create a project finance model independently and carry out analysis to take the best decision for their company.


 Who should attend         
                  


All individuals who want to improve their financial modeling skills should attend this course




Middle to senior managers in the project finance and fundraising department of the company 


All professionals who want to deal or currently deal with financial modeling in their company


Consultants, advisors and other professionals who wish to improve their modeling skills


Middle to senior managers from investment banking, banks, financial institution,  




Methodology      
                                            


The non-theoretical methodology which includes interactive discussions, case studies, and assignments to understand the concepts and their applicability. As a policy, we limit the class size to 12 participants so that we can provide attention to each participant and ensure their objective is achieved. 


 We request you to please bring your laptop with Microsoft Excel installed to the class.


Trainer


All our trainers are carefully chosen by us and possess a rich and vast experience in the financial sector. This course conducted by an experienced training consultant having more than 16 years of industry experience with some of the world’s leading business institutions, specializing in project finance, investment banking, and private equity.


Course Content


Module – 1


Setting up a project finance model and building projections




Overview of best industry practices for financial modeling and layout


Structure of Project finance and its stakeholders


Analysis of project information


Steps for creating financial models


Proper presentation of various sheets and setting up the model input dashboard




 


Module – 2


Preparation of Layout and timing related information




Discussion on the model development process and flow


Discussion on the best industry practices and standard  for layouts and structure


Preparation of the standard model template to ensure consistency between worksheets


Preparation of quarterly and annual flags 


Other key flags like construction period, operational period, debt period, etc 




 


Module – 3


Preparation, Assumption sheet 




Preparation of the assumption sheet 


Analysis of project assumptions and their rationale for construction timelines, revenues & costs, assets and liabilities’ assumptions - operating cost, capex, leverage, etc 


Shortlisting assumptions and applying adjustments


Applying various forecasting tools, etc




 


Module – 4


Importance of Capex and depreciation 




Different ways to model the Fixed assets and depreciation 


Schedule of amortization of intangible assets


Special concessions requirement for fixed assets and depreciation benefits


Tax and accounting depreciation, if any 




 


Module – 5


Preparation of debt and equity schedule  




Calculation of fund requirement and various sources of funding and source to service the same 


Calculation of Interest During Construction (IDC)


Waterfall mechanism to calculate the  debt requirement and cash flow available for debt service


Calculation of cost of various types of debt including arranger fees, interest, annual fees, etc


Various types of repayment structure like annuity, sculpted, bullet, etc 


Preparation of DSRA and other cash reserves 


Management of covenants of the banks 


Calculation of the cash flow available to equity shareholders 


Dividend calculation with its limitations including lender restriction etc 




 


Module – 6


Calculation of Net Taxable Income and final tax   




Calculation of net taxable income including adjustment of tax and concession benefits 


Adjustments for capital allowances, disallowable costs, and loss carry-forwards 




 


Module – 7


Importance of key schedule and their application




Working capital schedule  


Fixed assets and depreciation 


Schedule of amortization of intangible assets


Preparation of debt and interest 


Taxation


Equity fundraising


Equity gap and funding




 


Module – 8


How to create working capital schedule




Components of cash and non-cash working capital


Forecasting working capital requirements




 Module – 9


Integration of income statement, balance sheet, and cash flow statement




Industry practices on handling exceptions


Integration of Cash Flows, Income Statement and Balance Sheet as per best industry practices




  


Module – 10


Establish scenario and sensitivity analysis




Use of data for sensitivity analysis


Identifying suitable scenarios and sensitivities and their impact on financial analysis 


Stress testing on a model


Managing critical pitfalls in the analysis




 Module – 11


How to do model review and control




How to insert various test and checks in the model 


Identify common model errors and fix them 


Best industry practices 






Module – 12


How to apply different financial analysis techniques on the model




Importance of PV, NPV, and IRR and their link with company valuation


How to analysis various capital budgeting decisions 


Calculation of multiple ratios- Payback period, Equity IRR, Project IRR, DSCR, Debt/Equity etc 




 Module – 13


How to manage the circularity and apply macros in the model 




How to handle Circular References in financial modeling


Effect of circular references on the model 


Various types of  circularities 


How to apply macros on the model and break the circularity






If you need further information, please visit www.riverstonetraining.com.sg or send mail at info@riverstonetraining.com.sg


Riverstone – Corporate Training https://www.riverstonetraining.com.sg


  


Information Source: Riverstone Training Pte Ltd | eventbrite

Singapore

Searching for information and tickets regarding Project Finance Modeling | One Raffles Place taking place in Singapore on Jul 22, 2025 (UTC+8)? Trip.com has you covered. Check the dates, itineraries, and other information about Project Finance Modeling | One Raffles Place now! Trip.com has also prepared more similar exciting activities and discounted flight and hotel packages.

Project Finance Modeling | One Raffles Place: Tickets, Dates & Itineraries | Trip.com

Project Finance Modeling | One Raffles Place

Project Finance Modeling | Trip.com

Khám Phá Thêm Liên Quan Đến Singapore

null | Trip.com

Bạn muốn biết ý kiến của bạn bè? Hãy chia sẻ câu trả lời của bạn để bắt đầu trò chuyện nhé!

Raffles Singapore

Gần Công viên Sư tử biển|Vịnh Marina, Singapore

Khách sạn sang trọng

Resorts World Sentosa - Equarius Villas

Công viên giải trí cho gia đình

Universal Studios Singapore

Có thể dùng ngay

Đặt ngay, dùng hôm nay

Trải nghiệm nổi bật

Công viên giải trí

与神同行abc

Universal Studios Singapore tuy kh&ocirc;ng lớn nhưng c&aacute;c dự &aacute;n nhỏ gọn v&agrave; vui vẻ, &quot;Vi&ecirc;n tử&quot;, &quot;Mumie&quot;, &quot;Gruly&quot; rất th&uacute; vị, v&agrave; thời gian xếp h&agrave;ng hơi l&acirc;u. Khu vườn sạch sẽ, ngăn nắp, kh&ocirc;ng kh&iacute; cũng tốt, c&oacute; thể đi mua sắm trong một ng&agrave;y, th&iacute;ch hợp để đư

Gardens by the Bay

Cảnh đêm

Vườn Vịnh Marina được kết hợp với thi&ecirc;n nhi&ecirc;n v&agrave; c&ocirc;ng nghệ, chương tr&igrave;nh &aacute;nh s&aacute;ng của c&acirc;y gần trời thật tuyệt vời, nh&agrave; vệ sinh hoa v&agrave; rừng m&acirc;y m&ugrave; tạo chỉnh c&aacute;c loại c&acirc;y xanh, ph&ugrave; hợp cho bố mẹ v&agrave; c&aacute;c bạn nhiếp ảnh, kh&ocirc;ng kh&iacute; buổi tối đặc biệt tuyệt vời. Khu

Capella Singapore

Ẩm thực địa phương

Marina Bay Sands Singapore

Địa điểm chụp hình ấn tượng

The Fullerton Bay Hotel Singapore

Vườn thú Night Safari - Singapore

Anonymous User

T&ocirc;i thực sự rất th&iacute;ch chuyến đi n&agrave;y. N&oacute; đ&aacute;ng gi&aacute; với gi&aacute; cả. T&ocirc;i khuy&ecirc;n bạn n&ecirc;n đi v&agrave; tham quan đ&oacute;.

Skyline Luge Singapore

Đặt ngay cho ngày mai

Cáp treo

Akter Tania

Skyline Luge Singapore l&agrave; một cuộc trải nghiệm đầy adrenaline rất vui cho mọi lứa tuổi! Nằm tr&ecirc;n Đảo Sentosa, nơi tham quan độc đ&aacute;o n&agrave;y kết hợp với một c&aacute;i gỗ rất sắc với một chuyến đi lượn th&uacute; vị xuống c&aacute;c tuyến đường d&agrave;i, tr&agrave;n c&acirc;y. Chọn từ bốn tuyến đường th&uacute; vị -- mỗi lần cung cấp c&aacute;c lượt s&aacute;ng sợ, đường hầm, v&agrave; nhiều sự th&uacute; vị xuống dốc. Khung cảnh từ sắp xếp rất tuyệt vời, đặc biệt l&agrave; l&uacute;c ho&agrave;ng h&ocirc;n, v&agrave; Night Luge th&ecirc;m một c&aacute;i s&aacute;ng s&aacute;ng với c&aacute;c đường s&aacute;ng.

Sentosa

Phong cảnh thiên nhiên

205***26

Đảo Sentosa kh&aacute; tốt, c&oacute; nhiều c&ocirc;ng tr&igrave;nh trong c&ocirc;ng vi&ecirc;n chơi chơi, như C&ocirc;ng vi&ecirc;n 侏儒, người v&agrave;ng nhỏ, v.v. tr&ecirc;n đảo chủ yếu l&agrave; sinh th&aacute;i tốt, c&oacute; rất nhiều chim, v&agrave; t&ocirc;i cũng thấy c&aacute; biển, chim v&agrave; con rừng, nhưng chỗ ở đắt hơn, kh&aacute;ch sạn kh&ocirc;ng cung cấp

Liên quan đến Project Finance Modeling | One Raffles Place