Walnut DataTech
Create account

Financial modelling and IFRS reporting

Build three-statement models, apply key IFRS standards and turn forecasts into valuation and decisions.

No reviews yetTaught by Walnut Jobs course team
Level
Intermediate
Language
English
Duration
26 hours
Lessons
13

Last updated 22 Oct 2026

What you'll learn.

  • Structure a financial model with separate inputs, calculations and outputs that others can audit.
  • Use XLOOKUP, SUMIFS, INDEX, EOMONTH, XNPV and XIRR confidently in models.
  • Build a linked income statement, balance sheet and cash flow statement that balances.
  • Apply IFRS 15, IFRS 16 and IFRS 9 to forecast figures correctly.
  • Value a business with a discounted cash flow model, WACC and terminal value.
  • Prepare budgets, rolling forecasts and scenario analysis for management.

How this course is taught.

Every module comes to you in four parts, so you can watch, read, discuss and check what you have learned.

  1. Quadrant I

    e-Tutorial

    Watch a short video lecture for each module, with full text notes beside it so you can review or translate at your own pace.

  2. Quadrant II

    e-Content

    Download or print the reading material for each module, with key terms, case studies and links to further resources.

  3. Quadrant III

    Discussion forum

    Ask questions and clear your doubts with other learners. The course team guides the discussion and answers questions.

  4. Quadrant IV

    Assessment

    Check your understanding with quizzes, short and long-answer practice and FAQs, then take the final test.

Curriculum.

4 modules · 13 lessons
1Model design and Excel essentials3 lessons · 46 mine-Content (notes)2Assessment1
  • Note: Model structure and best practice16 min
  • Note: Excel functions modellers use18 min
  • Quiz: Check your understanding: model design12 min
2The three-statement model3 lessons · 48 mine-Content (notes)2Assessment1
  • Note: Building the income statement and balance sheet18 min
  • Note: The cash flow statement and balancing the model18 min
  • Quiz: Check your understanding: three statements12 min
3IFRS essentials for modellers4 lessons · 1 h 3 mine-Content (notes)3Assessment1
  • Note: IFRS 15: revenue from contracts with customers18 min
  • Note: IFRS 16 leases16 min
  • Note: IFRS 9 expected credit losses14 min
  • Quiz: Check your understanding: IFRS15 min
4Valuation, budgeting and scenarios3 lessons · 56 mine-Content (notes)2Final test1
  • Note: DCF valuation: free cash flow, WACC and terminal value20 min
  • Note: Budgeting, forecasting and scenario analysis16 min
  • Final test: Final assessment20 min

Your certificate.

This is the certificate you receive when you complete the course and pass its final test.

Certificate No.

WDT-WJFMI-2026-000000

Certificate of completion

Financial Modelling and IFRS Reporting

This is to certify that

Learner Name

has successfully completed the course and passed its assessment, and is recognised as a

Financial modelling and IFRS reporting

4 modules13 lessons26 hours of learningOnline, on Walnut LMS

DD Month YYYY

Date of issue

Noida, India

Authorised Signatory

Walnut DataTech Private Limited

Verify this certificate at walnutdatatech.com/verify-certificate with certificate number WDT-WJFMI-2026-000000. Issued on Walnut LMS.

Specimen — not a valid certificate
Financial modelling and IFRS reportingView full size

What you need to receive it.

Complete every lesson and pass the final assessment with at least 70%.

Every certificate carries its own number that anyone can check on the verification page.

About this course.

Financial modelling and IFRS are the two languages of corporate finance in most of the world. This course teaches both together: how to build a clean, auditable three-statement model in Excel, and how the main IFRS standards change the numbers that go into it.

You will apply modelling standards used by banks and Big Four firms, practise the Excel functions that analysts rely on, and work through IFRS 15 revenue, IFRS 16 leases and IFRS 9 expected credit losses with numerical examples. The course closes with discounted cash flow valuation, budgeting and scenario analysis.

Who this is for

  • Finance analysts, FP&A professionals and accountants preparing for international roles
  • ACCA, CIMA and CFA candidates who want applied practice
  • Consultants and founders who build business cases

Skills this certificate proves: Financial modelling (Advanced), IFRS (Proficient), Excel (Advanced), Budgeting and forecasting (Proficient).

Linked to Walnut Jobs: complete this course to earn the certificate employers ask for.

Your instructor.

Walnut Jobs course teamJob-ready courses designed with hiring companies

Learner reviews.

No reviews yet

No reviews yet. Learners can review a course after completing half of it.

Questions about enrolling.

Is this course really free?

Yes. Create an account and enrol with one click. There's no payment step.

How long can I access this course?

You keep access for as long as the course is offered on Walnut LMS.

Do I get a certificate?

Yes. The certificate section above shows the certificate and sets out what you need to receive it.

Business and product