Financial Model for 1 year MBA

Description
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 wisely


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

X X X X X X X X X X X X X X X X X X X X X X X X X X