Previous Price: ₦ 96,266.25
Here's what you'll learn...
Course Introduction
FREE PREVIEWHow to use this Platform
FREE PREVIEWCourse Brochure & Agenda
FREE PREVIEW50 Excel Keyboard Shortcuts for Windows
50 Excel Keyboard Shortcuts for Mac
Meet an Advanced Finanical Modeler
FREE PREVIEWIntroducing the Advanced Financial Modeler Designation
FREE PREVIEWDownload the Exercise Files
Your Expectations
AFM Exam Structure (from FMI)
AFM Study Guide (From FMI)
AFM Exam Planner Tool by dbrownconsulting
FREE PREVIEWThe AFM Exam Experience
FREE PREVIEWPlanning for the Exams
AFM Body of Knowledge (from FMI)
FREE PREVIEWSkills Required for the AFM Exams
AFM Skills Checklist (From FMI)
FREE PREVIEWExam Study time required
FREE PREVIEWSample Exams & Models (From FMI)
Read and Markup Your Exam Script
FREE PREVIEWCreating a Cover Sheet
Building the Template Sheet
Automating Printer Settings
FREE PREVIEWReplicating the Template Sheet
Creating useful Styles
Extracting Scenario Assumptions
Building the Scenario Structure
Replicating Scenario Blocks
Creating useful Styles
Extracting Revenue Assumptions
Extracting Cost Assumptions
Extracting Capex Assumptions
Building Working Capital Assumptions
Extracting Taxation Assumptions
Extracting Debt Assumptions
Building Equity Assumptions
Documenting Other Assumptions
FREE PREVIEWReviewing your Half Way Point, time check
Preparing for the Model Build
FREE PREVIEWLinking Historical Financials
Building the Revenue Schedule
Building Cost of Sales Schedule
Building the Capex & Depreciation Schedule
Updating P&L Line Items
Completing Tax Computations
Building the Working Capital Schedule
Building the Equity Schedule
Updating Financial Statements before Debt Calculations
Building Debt & Interest Schedules
Modelling Excess Cash
Modelling the Revolver Cash Sweep
Calculating Interest Expense
FREE PREVIEWDealing with Circularity in your Model
Selecting Summary Sheet Line Items
Building a Linked Summary Template
Replicating for All Scenarios
Carrying out Final Cross Checks
Download Solution Files for Exercises
Instructions
Evaluation & Digital Certificate
Financial Modeling and Analysis are highly respected skills in the business world and hugely sought after in the job marketplace
Learn how to build a Financial Model under Exam conditions using a past exam script for Level 1 of the Financial Modeling Institute towards your Advanced Financial Modeler (AFM) designation.
Design a modern model structure based on pre-determined model outputs & requirements
Build a clear revenue schedule to forecast company sales
Recall the techniques for model auditing tax and deferred tax treatment, depreciation calculations, integrity & error checking and more.
“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended.”
Sean Bhesania
“Dbrown's AFM step-by-step guide is a highly online participatory and inclusive guide just right for passing the rigorous AFM exams... Having mastered and practiced well this piece of knowledge, I was able to combine speed with financial modeling best practices in writing the exams and this earned me the AFM level 1 certification. It was a 4-hour exam but this guide gives you the edge to finish in a little bit over 3 hours and have enough time to check through. This guide demystified the AFM level 1 exam for me. it moves you from zero to hero just in a short while...Check out this guide if you ever want to seamlessly pass your AFM exam and get well equipped with financial modeling best practices.. Dapo Aloba AFM FCA ”
dapo aloba AFM FCA
“Amazingly Relevant and Tailored”
Rasheed Davis
$199.00
