• 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

Flexibility or rather, variability and simulation of a scenario under different conditions is the end goal of a model. Here are some of the various techniques you can use to make a model more adaptable.
Model assumptions clearly- the first step to creating a workable model is to always document the delta assumption. What does that mean? As discussed earlier, if you want to say that you forecast sales of firecrackers during Diwali to up by 15 percent from 2015, then you model in the assumption. The origin value is, lets say, 1000 crackers sold in 2015. The result would by (1000 *0.15) + 1000 which would equal 1150 crackers sold in 2016. But you have to document the 0.15 clearly so that if someone wanted to change that assumption to 20 %, then they would just need to key 20% in instead of 15 and the entire model would change.
Created more detailed assumptions – While complex models are generally less robust due to higher chances of linkage issues etc, there needs to be some amount of complexity for a model to be useful. For instance we want to forecast revenue from sale of fireworks from 2015 to 2016. First would be to break the Rs 1000 up into the various products like sparklers, (30% of 1000) flowerpots and the like. Once that happens you need to break sales into its component. Sales equals price into quantity. So instead of saying, arbitrarily, that the total sales of sparklers goes up from Rs 300 to Rs 345 (jump of 15%) in 2016 you would say that the number of sparklers would go from 100 sparklers to 115 (model in the 15%) sparklers while the price of the sparkler (Rs 3 per piece ) did not increase at all. (model in the 0%) The flexibility comes in when I change the cell that holes 0% to 10%. This would make the price of the sparkler go up from Rs 3 to Rs 3.30 which would lead to a total sales of Rs 379.5.
Use a spin button- A spinner helps model in variability especially as it relates to step costs. So let’s say that every extra Rs 200 I make in sales, I need to add one extra sales person. That is not a variable cost. That is a step cost. So when my sales goes up 15% from Rs 1000 to Rs 1150, I don’t need an extra sales person. But what if I want to sell 1250. I need to add one more sales person. A spin button does the job for you. Every time increment sales goes up by Rs 200, one extra person at a salary of Rs x a month will be added to that cell, thereby making your model more adaptable and robust.


 

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