• PGP in New Age Banking
    4.8 out of 5 by 669 learners
    4x Industry Demand
  • POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    4.8 out of 6071 learners
    2x industry demand
  • MBA in Investment Banking
    Co-created with Jain University
    4.5 out of 5 by467 learners
    2x industry demand
  • MBA in Fintech
    Co-created with Jain University
    4.4 out of 5 by 349 learners
    2x industry demand
  • MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    4.7 out of 5 by 669 learners
    4x Industry Demand
  • Post Graduate Program in Banking and Credit Underwriting
    4.7 out of 5 by 1376 learners
    12 X industry demand
  • 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 1421 learners
    6X industry demand
  • Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    4.6 out of 5 by 1139 learners
    4X industry demand
  • PGP in Banking and Wealth Management
    4.6 out of 5 by 1429 learners
    3X industry 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
  • Placement Program
    PGP in New Age Banking
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Finance
    POST GRADUATE DIPLOMA IN MANAGEMENT
    Co-created with BIMTECH
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.8 out of 6071 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    Live Instructor - Led Training Online
    Date Location Schedule
  • Recent Graduates
    MBA in Investment Banking
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.5 out of 5 by467 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Recent Graduates
    MBA in Fintech
    Co-created with Jain University
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.4 out of 5 by 349 learners
    2x industry demand
    Upcoming Batches
    Date Location Schedule
    31st July ONLINE Online
    Date Location Schedule
  • Placement Program
    MBA (Distance) in Banking and Finance with NGASCE
    Co-created with NMIMS
    Course duration(Months)
    24
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 669 learners
    4x Industry Demand
    Upcoming Batches
    Date Location Schedule
    8th Jan 2022 Live Instructor - Led Training Online
    Date Location Schedule
  • Post Graduate
    Post Graduate Program in Banking and Credit Underwriting
    Course duration(6)
    Upcoming batches
    1
    Organizations enrolled
    20
    4.7 out of 5 by 1376 learners
    12 X industry demand
    Upcoming Batches
    Date Location Schedule
    Not Available MUMBAI Online
    Date Location Schedule
  • 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
  • Certification
    Professional Certification in FinTech
    Co-created with SP Jain School of Global Management
    Course duration(Months)
    3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1421 learners
    6X industry demand
    Upcoming Batches
    Date Location Schedule
    27th November Live Instructor - Led Training Online
    Date Location Schedule
  • PRODEGREE
    Credit Risk and Underwriting Prodegree
    Co-created with Moody’s Analytics
    Course duration(Months)
    3
    Upcoming batches
    2
    Organizations enrolled
    20
    4.6 out of 5 by 1139 learners
    4X industry demand
    Upcoming Batches
    Date Location Schedule
    13th February ONLINE Weekend
    Date Location Schedule
    29th May ONLINE Weekend
  • Post Graduation
    PGP in Banking and Wealth Management
    Course duration(Months)
    2-3
    Upcoming batches
    1
    Organizations enrolled
    20
    4.6 out of 5 by 1429 learners
    3X industry demand
    Upcoming Batches
    Date Location Schedule
    21st October CHENNAI Weekday
    Date Location Schedule