NVFM336 Solving Financial Modelling Problems in Microsoft Excel

Current Status

Not Enrolled

Price

MYR 268.00

Get Started

Duration 4 hours 44 mins

SIDC Approved 10 CPE Points

Trainer Helmi (click for profile)

Summary Problems are a fact of everyday life, and researchers have long grappled with how to identify, frame, and solve them. In modern times, computing technology offers us a range of tools to take on bigger and more complex issues. For example, finance professionals dealing with financial modelling can now create more realistic visualisations of the flow of funds, perform complicated asset valuations, and model capital market dynamics with greater accuracy. With complexity comes modelling problems that require a more comprehensive understanding of the problems and the tools and methods to effectively address them. This course highlights common financial modelling problems and how to frame and solve them.

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: Problem-solving psychology and decision frameworks
1.1 Introduction, and problem-solving theories (Part A)
1.3 Computer-assisted problem-solving
Section 2: Problem-solving in financial modelling
2.1 How financial modellers think under pressure
2.2 Cognitive biases that directly cause modelling errors
2.3 Problem-solving behaviour in modelling
2.4 Bounded rationality and incomplete models
2.5 Professionally structure modelling problems
2.6 Practical problem-solving workflow for modelling
Section 3: Common problems in financial modelling for sukuk and bonds
3.2 Sourcing primary and secondary market data (Part B)
3.3 Handling multiple sources of data (Part A)
3.4 Handling multiple sources of data (Part B)
3.5 Preparing data for input into financial model
Section 4: Common problems in financial modelling for corporate finance
4.2 Separating fixed and variable costs, and allocating overheads
4.3 Depreciation for multiple assets, and financing amortisation
4.4 Working capital
4.5 Reconciliation of EBITDA, EBIT and net profit
4.6 Linking profit and cash flow
Section 5: Common problems in financial modelling for SPV-based financing
5.2 Rolling forecasts
5.3 Linking drivers to outputs
5.4 Step changes in assumptions
5.5 Inflation and escalation
1 of 2