• Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    4.9 out of 5 by 238 learners
    14 X industry demand
  • Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    4.6 out of 5 by 1250 learners
    6X industry demand
  • Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    4.5 out of 5 by 526 learners
    4X industry demand
  • Banking And Wealth Management Bootcamp
    4.7 out of 5 by 460 learners
    3X industry demand
  • Post Graduate Program In Capital Markets
    4.7 out of 5 by 807 learners
    3X industry demand
  • Certified Investment Banking Operations Professional
    4.8 out of 5 by 7600 learners
    8X indsutry demand
  • Post Graduate In New Age Banking
    4.6 out of 5 by 1726 learners
    4X industry demand
  • Financial Analysis Prodegree
    Co-created with KPMG
    4.7 out of 5 by 3311 learners
    4X indsutry demand

By Reshma Krishnan
We are continuing to understand the Fundamentals of Forecasting. Please click here for Part 1 and Part 2.
Many aspiring candidates ask us what is so special about the FMVC program at Imarticus Learning. After all, shouldn’t an MBA suffice? The problem with MBA’s, regardless of which school you go to, is that they don’t teach you role specific issues. For instance, they don’t have specific modeling modules. They will have a forecasting module but they won’t teach you how to model or how to forecast step by step. In the Financial Modelling and Valuation Course (FMVC), India’s leading Forecasting and Financial Modeling program, we teach you the minutae and we go into specifics. One such specific is modeling and forecasting hygiene.
Hard Coding- the model users bane.
This is the first thing I teach in modeling class. Hard Coding is essentially a stand alone number in a cell, which has no back up. It says nothing about the number. You must never hard code a forecasted number because the forecast is always done on the back of an assumption, which has to be modeled in. Hard coded numbers are usually past data, actual data that has been verified and been the result of auditing. A forecasted number should always be a linked number from an assumption.
Colour Coding
Staying with hard coded numbers, it always helps to colour code. In fact, in my class, I mark an assignment zero if it is not colour coded. Red hardcoded number tells me that the forecaster had no option but to hard code. All actuals should be in a different colour to forecasts and all delta numbers, that is the variable you are using to arrive at a forecast needs to also be in a different number.
Give the delta its own cell
Let’s say you want to increase the sale of pencils in 2017 by 10% from 2016. You have two ways to do it.
=(2016 revenue cell) x 10% +(2016 revenue cell) = 2017 revenue.
Or
You create a special cell for 10%
= ((2016 revenue cell) x (10% cell) )+(2016 revenue cell) = 2017 revenue.
Here I am assuming that revenue is growing by 10% . This helps me change the delta as I see fit which then changes my model. The delta is the rational for my model. If you hide it within a formula, I have to constantly look at formulas to find my assumptions.
Learn more about Forecasting by joining our course, FMVC,Financial Modeling and Valuation Course, India’s leading program in Financial Modeling and Valuation and focused on improving your chances on having a career in Investment Banking or Equity Research.


 

Follow Us On Social Media

Twitter


Facebook


LinkedIn


YouTube
For Online Course Enquiries
About Imarticus
Imarticus Learning is India’s leading professional education institute that offers training in Financial Services, Data Analytics & Technology. We’ve successfully transformed careers of over 35,000+ individuals globally through our Certification, Prodegree, and Post Graduate programs offered in association with leading and renowned global organisations in the Financial Services, Data Analytics & Technology domain.
Related course
  • Post Graduate
    Post Graduate Program In Finance And Accounting
    Co-created with Grant Thornton
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.9 out of 5 by 238 learners
    14 X industry demand
    Upcoming Batches
    Date Location Schedule
    None DELHI Online
    Date Location Schedule
  • Prodegree
    Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    Course duration(Months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1250 learners
    6X industry demand
    Upcoming Batches
    Date Location Schedule
    none ONLINE Online
    Date Location Schedule
  • PRODEGREE
    Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    Course duration(Months)
    3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.5 out of 5 by 526 learners
    4X industry demand
    Upcoming Batches
    Date Location Schedule
    30th-May ONLINE Weekend
    Date Location Schedule
  • Certification
    Banking And Wealth Management Bootcamp
    Course duration(Months)
    2-3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 460 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    Not Available ONLINE Weekend
    Date Location Schedule
  • Post Graduation
    Post Graduate Program In Capital Markets
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 807 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    Not Available ONLINE Online
    Date Location Schedule
  • Certification
    Certified Investment Banking Operations Professional
    Course duration(Months)
    2-3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 5 by 7600 learners
    8X indsutry demand
    Upcoming Batches
    Date Location Schedule
    26th-May THANE Weekday
    Date Location Schedule
  • Post Graduation
    Post Graduate In New Age Banking
    Course duration(months)
    4
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1726 learners
    4X industry demand
    Upcoming Batches
    Date Location Schedule
    None ONLINE Online
    Date Location Schedule
  • Prodegree
    Financial Analysis Prodegree
    Co-created with KPMG
    Course duration(Months)
    3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 3311 learners
    4X indsutry demand
    Upcoming Batches
    Date Location Schedule
    23rd-May ONLINE Weekend
    Date Location Schedule