NVFM211 Financial Modelling for Project Finance Using Microsoft Excel

Current Status
Not Enrolled
Price
298 MYR
Get Started

Duration 3 hours 20 mins


SIDC Approved
 10 CPE Points


Trainer
Helmi (click for profile)


Summary
This is part one of the hands-on tutorial on financial modelling for project finance using Microsoft Excel. We build the cashflows statement starting from the assumptions page followed by the computations for revenues, capital expenditure, operating expenses, income tax and financing. The focus point of this course is the automated 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 [email protected]


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


Course Content

Section 1: Financial Model Set Up [Hands-on step-by-step tutorial on Microsoft Excel]
Section 2: Fundamental Computations [Hands-on step-by-step tutorial on Microsoft Excel]
Section 3: Bankability Analysis [Hands-on step-by-step tutorial on Microsoft Excel]
Section 4: Financing Repayment Profile [Hands-on step-by-step tutorial on Microsoft Excel]
Section 5: Stress Testing [Hands-on step-by-step tutorial on Microsoft Excel]
Section 6: Assessment