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
topmate.io/anu...
#career #mba #PGPX #EPGP #MBAEx #ISB
1yearmbaadmiss...
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
Негізгі бет Is it worth- 1 year MBA | IIMA PGPX | ISB PGP | 1 year MBA ROI Calculator | Financial Model for MBA
No video
Пікірлер: 210