• PGP in New Age Banking
Co-created with Imarticus Learning
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

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, let's say, 1000 crackers sold in 2015. The result would be (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 the sale of fireworks from 2015 to 2016.

The 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 equal price into quantity. So instead of saying, arbitrarily, that the total sales of sparklers go up from Rs 300 to Rs 345 (a 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. (the 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 variability especially as it relates to stepping costs. So let’s say that for every extra Rs 200 I make in sales, I need to add one extra salesperson. That is not a variable cost. That is a steep cost. So when my sales go up 15% from Rs 1000 to Rs 1150, I don’t need an extra salesperson.

But what if I want to sell 1250. I need to add one more salesperson. A spin button does the job for you. Every time increment sales go 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.

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
Co-created with Imarticus Learning
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