3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
  • 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)
Originally published: 04/06/2019 14:27
Publication number: ELQ-33289-1
View all versions & Certificate
certified

3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)

This is our FMI Exam solution created by City-Research. The model constitutes a possible exam solution.

Description
The financial model is built based on the 2017 (Henderson Manufacturing) FMI case study data and the questions provided by FMI.

Go to https://fminstitute.com to get access to information about the exam and the case study.
FMI candidates are required to build a similar model in 4 hours as part of their practical assessment and accreditation to being a certified financial modeler under the FMI.

This particular exam solution is for the Advanced Financial Modeler (AFM) certification exam (1st level). AFM candidates are required to build a fully integrated financial model (Income Statement, Balance Sheet and Cash Flow Statement) of a company using Excel. The 3-statement model includes IS, BS and CFS but also includes some complex calculations and detailed schedules including dealing with circularity issues in interest calculations.

We choose to use a circular switch to control for circular references which uses iterations but it can also be switched off to avoid any issues in the model. It is suggested that candidates are familiar with all various approaches and practice solving circularity problems prior to taking the exam.
In this model we also use macros to copy and paste as values key items and ratios under the different scenarios. In addition we use a macro to save the file as a pdf document. This is not required by FMI for this exam.

The model has been designed to assist AFM candidates with learning the fastest way to complete the exam, but not necessarily the best way to present such a model to clients. For example models should contain charts and outputs, table of contents etc. We have not included those as they are not required for the exam and no additional marks are provided for creating these. Hence this model is very much a technical solution, not a client demonstration version.

This Best Practice includes
1 Excel file, 1 PDF output

Acquire business license for $20.00

Add to cart

Add to bookmarks

Discuss

Further information

To assist potential students and candidates in their preparation for the FMI level 1 exam which is the Advanced Financial Modeler (AFM).

Use the tool if you are preparing for AFM exam or you would like to see how a 3 statement model is structured.

Presentations to clients, dashboarding etc.
You need training on how to create the model. If you are interested in getting 1-2-1 or classroom/online training, please contact us as we offer training for financial modelling including using shortcut keys, consistent formula logic and similar techniques to build the model quickly and accurately.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Nikolaos Giannoulis, CFA, AFM, CFM, MSc

keyboard_arrow_leftkeyboard_arrow_right

Any questions on 3 Statement Financial Model For AFM Exam Solution, Financial Modeling Institute (FMI)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...