Is it worth- 1 year MBA | IIMA PGPX | ISB PGP | 1 year MBA ROI Calculator | Financial Model for MBA

Is it worth- 1 year MBA | IIMA PGPX | ISB PGP | 1 year MBA ROI Calculator | Financial Model for MBA'

Financial Model for 1 year MBA | Is it worth going for 1 year MBA | IIM Ahmedabad PGPX | ISB PGP'

Link to Download Model

https://topmate.io/anuragsingal/513542

#career #mba #PGPX #EPGP #MBAEx #ISB

https://1yearmbaadmissions.blogspot.com/

Financial Model for 1 year MBA

Financial Model for 1 year MBA | Is it worth going for 1 year MBA | IIM Ahmedabad PGPX | ISB PGP'

This model will help you calculate the ROi

Input Metrics
Loan Taken
Cost of Program Fee (INR lacs)
Incoming CTC Pre 1 year MBA
Increase in CTC in Campus Placement
Annual Salary Increment
Interest Rate on SBI Loan
Tenure of Loan
Marginal Rate of Tax for Section 80E Deduction
Average Tax Rate on Salary

Output metrics
Average CTC Post 1 year MBA
Monthly payment
Number of payments
Total interest
Total cost of loan
IRR (excluding Terminal Value)

Loan Taken
Yes
No

Financial Feasibility of 1 year MBA as you make this huge decision


Fees paid for 1 year MBA
Opportunity Cost : Post Tax Salary for 1 year ( 20 lacs * (1-Tax Rate))
Living Expenses for 1 Year
Loan Related Calculations:
Collateral Free Loan from SBI
EMI Paid
Tax Saving on Interest u/s 80E
Salary Related Calculations:
Incremental Salary Post One Year MBA
Less Taxes on Incremental Salary

IRR excluding Terminal Value ( i.e. beyond 10 years post 1 year MBA)

Loan Summary
Monthly payment
Number of payments
Total interest
Total cost of loan