Financial Model for 1 year MBA
Originally published: 07/06/2021 07:16
Last version published: 07/06/2021 07:19
Publication number: ELQ-86982-2
View all versions & Certificate
certified

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'

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

This Best Practice includes
1 MS Excel File

Acquire business license for $10.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


Any questions on Financial Model For 1 Year MBA?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...