NVFM231 Financial Modelling for Project Finance (Part 1)

Current Status

Not Enrolled

Price

268 MYR

Get Started

Duration 3 hours 16 mins

SIDC Approved 10 CPE Points

Trainer Helmi (click for profile)

Summary Project finance is a cornerstone of the monetary economy and it drives economic growth. Financial modelling is a foundational skill in project finance as it underpins every decision made throughout the lifecycle of a project. From initial feasibility assessment to structuring, credit evaluation, risk allocation and long-term monitoring, the ability to build a robust and dynamic financial model is essential for professionals engaged in banking, investment and financial advisory. In Part 1, you will be guided on the process of building a financial model comprising the assumptions page and the cash flow page using Microsoft Excel. There will be an in-depth discussion on the computations for revenues, capex, opex, income tax, facility size, reserve accounts, finance service coverage ratios and dividends. We will wrap up this tutorial with the steps to automate the financing repayment schedule using Microsoft Visual Basic for Applications (VBA).

Starting the Course The course outline is listed below. Click on the first lesson – Section 1.1 – to start. The video will automatically start playing. When the video ends, you will be able to click the “Mark Complete” button. The page then moves on to the next lesson and plays the relevant video. Alternatively you can replay the previous lessons. Upon completing the Summary, you will be able to take the Quiz. Click the “Start Quiz” button to begin. At any point in time you can click the course item on the top menu to see your percentage progress in this course.

Registration If you have already been registered for this course but the “Take this Course” button is visible, please contact us. Otherwise, click the “Take this Course” button to purchase this course. At the shopping cart, click “Proceed to Checkout.” You fill in your contact details at the checkout page. Your payment information bypasses 20CPE.com’s servers and is processed directly by Stripe / Billplz. After payment has been made, you can return to this page to begin the course.

Contact Details We know how frustrating it can be to run into issues. We are available to help you 24/7. You can contact us at +60193539093 or send an email to mail@neurover.com


Expiry Date
 Thirty (30) days from enrolment or upon completion of the course, whichever is later

Course Content

Section 1: Identify the appropriate procedure to extract the required data from their respective sources
1.1.1 Introduction
1.1.2 Financial model set up
Section 2: Determine the factors to be used as input into the financial model
2.1.1 Other initial computations, and size of sukuk (bonds) and equity
2.4.2 Effect of circular reference (Part 2)
2.4.3 Effect of circular reference (Part 3)
2.4.4 Effect of circular reference (Part 4)
Section 3: Assessment
3.1 Summary
3.2 Quiz [NVFM231] 1 Quiz
Lesson Content