Markdown Editor

MBA Budget During the Programme Template

Monthly MBA cash budget: term tuition, rent, recruiting, treks, social, internship months, buffer flags, rent, currency and social stress tests

MBA dan sekolah bisnisLengkapCash-flow budgeting; US federal loan facts from 1 July 2026budgetduringprogram

Cara menggunakan: Use it before you accept your loans and at the start of every term. Fill the disbursement dates and fixed costs first, then the recruiting, trek and social lines from the school calendar. The main pitfall is budgeting by year, which hides the months where the balance turns negative.

Pratinjau

MBA Programme Budget: [Your name], [Programme and intake]

A month-by-month cash budget for the MBA years: term-by-term tuition, rent, living costs, the costs most students underestimate (recruiting travel, club treks, global immersion trips, social events), the summer internship months, and the funding disbursements that pay for them. It shows the running cash balance, flags the months that fall below your safety buffer, and tests the plan against higher rent, an exchange-rate shock and higher social spending. Source basis: standard cash-flow budgeting and the funding facts in mba/mba-funding-scholarship-plan, with US federal loan facts checked in October 2026. Replace every [bracketed] value and every row marked Example. This is a planning aid, not financial, tax or legal advice.

Document control

FieldValue
Document ID[BUD-001]
Version[0.1]
Status[Draft / Funding confirmed / In use]
Owner[Your name]
Reviewed by[Partner, mentor or financial aid officer]
Last updatedYYYY-MM-DD
ClassificationPersonal, confidential
Programme dates[YYYY-MM to YYYY-MM]
Budget currency and home currency[USD; home currency]
Safety buffer (minimum balance)[USD 3,000]

Contents

  1. Purpose and principles
  2. The budgeting routine
  3. Cost categories, including hidden costs
  4. Monthly cash budget
  5. Stress tests
  6. Revising the plan
  7. Spending rules for the social side of the MBA
  8. Currency, insurance and emergencies
  9. Dated facts and timeline
  10. Quality checklist and common mistakes

1. Purpose and principles

An annual budget hides the problem that hurts MBA students most: running out of cash in a particular month even though the year adds up. Tuition is due in a lump at the start of each term, loan money and scholarships arrive on disbursement dates, and the expensive months (autumn recruiting, spring treks) do not line up with the cash. A monthly cash budget fixes this by tracking the running balance.

Principles:

  1. Plan the balance, not the total. The question is "what is my lowest balance and when?", not "do inflows cover outflows over two years?".
  2. Hold a buffer. Set a minimum balance (one month of essential costs is a common floor) and treat any month below it as a shortfall.
  3. Fix the essentials first. Tuition, rent, food, health insurance and transport are fixed; social and travel spending are choices that adjust to what is left.
  4. Budget the MBA-specific costs explicitly. Recruiting, treks, immersion trips and club events are part of the programme for most students. Leaving them out is the most common reason budgets fail.
  5. Review monthly. Ten minutes at the start of each month comparing plan and actual keeps small overruns from compounding.

2. The budgeting routine

The loop has two exits back to revision: a month below the buffer in the base case, and a month below the buffer under stress. Only a plan that clears both is ready to use. After that, the monthly review keeps the forecast honest: replace each past month's plan with the actual figures and let the running balance for the remaining months update.

3. Cost categories, including hidden costs

CategoryWhat to includeHow to estimateTiming
Tuition and feesNet of scholarship, per termAward letter, school billing calendarStart of each term
HousingRent, deposit, utilities, renter's insuranceListings near campus, lease termsMonthly, deposit up front
LivingFood, transport, phone, personal careCurrent spending adjusted for the cityMonthly
Health insuranceSchool plan or waiver if covered elsewhereSchool fee scheduleUsually per term or per year
Books and materialsCase packs, software, laptopCourse syllabi, current studentsStart of each term
RecruitingTravel to employer events, clothing, coaching resourcesNumber of target employers and citiesAutumn of year 1 for most functions
Treks and immersionClub treks, global immersion courses, exchange travelTrip prices from last year's club pagesUsually winter and spring breaks
Clubs and conferencesClub dues, conference ticketsClub fairs, conference pagesStart of each year
SocialDinners, events, celebrations, sportsA weekly allowance you setEvery week, highest in the first term
Internship monthsSecond rent or temporary housing, travel to the internship cityOffer letter, housing listingsSummer between years
Relocation and visaMoving, flights, visa and immigration feesQuotes, official fee schedulesBefore and at start
FamilyPartner, children, childcareCurrent spendingMonthly

4. Monthly cash budget

4.1 Spreadsheet layout

ColumnContentFormula (row 3 onwards)
AMonthAug Y1 to May Y2
BFunding in (loans, savings transfers, sponsor)from the funding plan
CEarnings (internship, assistantships)from the offer letter
D to IOutflows by categoryfrom section 3
JTotal out=SUM(D3:I3)
KBalance=K2+B3+C3-J3 (K2 holds the opening balance)
LBelow buffer=IF(K3<$N$1,"LOW","") with the buffer in N1

Summary cells: lowest balance =MIN(K3:K24); month of the lowest balance =INDEX(A3:A24,MATCH(MIN(K3:K24),K3:K24,0)); months below buffer =COUNTIF(K3:K24,"<"&N1); total outflows =SUM(J3:J24).

4.2 Worked example A: Kofi's first draft (fully solved)

Inputs (Example): opening balance USD 15,000; buffer USD 3,000; tuition net of scholarship USD 26,000 per term (four terms); funding disbursements of USD 40,000 at the start of each term; rent USD 2,400 a month; food USD 750 and transport and phone USD 200 a month; social allowance USD 400 a month in term; relocation USD 2,500; books USD 600 per term; recruiting travel USD 1,500 in three autumn and winter months; club dues and conferences USD 1,200 at the start of each year; a trek of USD 3,500 in year 1 and an immersion trip of USD 4,000 in year 2; internship pay USD 7,000 a month (net) for three summer months, with USD 1,500 a month of temporary housing on top of the home rent. Programme costs below are books, recruiting, treks, clubs and relocation.

Month (Example)Funding inInternship payTuitionRent and housingLivingProgramme costsSocialTotal outBalance
Aug Y140,000026,0002,4009503,10040032,85022,150
Sep Y10002,4009501,2004004,95017,200
Oct Y10002,4009501,5004005,25011,950
Nov Y10002,4009501,5004005,2506,700
Dec Y10002,40095004003,7502,950 LOW
Jan Y140,000026,0002,4009502,10040031,85011,100
Feb Y10002,40095004003,7507,350
Mar Y10002,4009503,5004007,250100 LOW
Apr Y10002,40095004003,750-3,650 LOW
May Y10002,40095004003,750-7,400 LOW
Jun (internship)07,00003,900950004,850-5,250 LOW
Jul (internship)07,00003,900950004,850-3,100 LOW
Aug (internship)07,00003,900950004,850-950 LOW
Sep Y240,000026,0002,4009501,80040031,5507,500
Oct Y20002,40095004003,7503,750
Nov Y20002,40095004003,7500 LOW
Dec Y20002,40095004003,750-3,750 LOW
Jan Y240,000026,0002,40095060040030,3505,900
Feb Y20002,40095004003,7502,150 LOW
Mar Y20002,4009504,0004007,750-5,600 LOW
Apr Y20002,40095004003,750-9,350 LOW
May Y20002,40095004003,750-13,100 LOW

Totals (Example): inflows USD 181,000 (funding 160,000, internship 21,000); outflows USD 209,100; closing balance USD -13,100 (=15000+181000-209100). Thirteen of 22 months are below the buffer and nine are negative.

Category (Example)Two-year totalShare of outflows
Tuition (net of scholarship)104,00049.7%
Rent52,80025.3%
Food16,5007.9%
Social7,6003.6%
Treks and immersion7,5003.6%
Internship housing4,5002.2%
Recruiting4,5002.2%
Transport and phone4,4002.1%
Relocation2,5001.2%
Books2,4001.1%
Club dues and conferences2,4001.1%
Total209,100100.0%

Average non-tuition spending is USD 4,777 a month (=(209100-104000)/22). Reading the draft: the plan does not fail because of one extravagant item. It fails because each term's disbursement covers tuition plus about three months of average non-tuition spending (USD 14,000 against USD 4,777 a month), while each term lasts four to five months, and the spring trek lands in the thinnest month. The internship pays more than it costs, but not enough to repair the year 1 deficit.

5. Stress tests

Test on the first draft (Example)Closing balanceLowest balance
Base draft-13,100-13,100 (May Y2)
Rent 10% higher (USD 2,640)-18,380-18,380 (May Y2)
Home currency falls 10% against USD, half of the funding is in home currency-21,100-21,100 (May Y2)
Home currency falls 20%-29,100-29,100 (May Y2)
Social allowance USD 600 a month-16,900-16,900 (May Y2)
All three: rent +10%, currency -10%, social USD 600-30,180-30,180 (May Y2)

The currency shock is the largest single risk for an international student whose savings or family support is in another currency: a 10% fall on half of USD 160,000 of funding removes USD 8,000. In Excel, set the funding cells to =40000*(1-$N$2*$N$3) with the shock in N2 and the home-currency share in N3, then use a Data Table on N2.

6. Revising the plan

6.1 Worked example A continued: Kofi's revised plan (fully solved)

Kofi makes three changes: social allowance USD 300 a month (saves USD 1,900 over 19 term months), a cheaper second-year immersion option at USD 2,500 (saves USD 1,500), and a request to raise each term's disbursement from USD 40,000 to USD 45,000 (USD 20,000 more in total). USD 45,000 is the smallest disbursement, in steps of USD 500, that keeps every month at or above the USD 3,000 buffer.

Measure (Example)First draftRevised
Funding per term40,00045,000
Total outflows209,100205,700
Total inflows181,000201,000
Lowest balance-13,100 (May Y2)3,600 (May Y1)
Closing balance-13,10010,300
Months below buffer130
Revised plan with a 10% currency fallclosing 1,300, lowest -900

The revised plan still dips close to the buffer in May Y1 and fails the 10% currency test (lowest balance USD -900). Kofi records two triggers: if the home currency falls more than 5% before January, he moves the trek budget to zero; and he converts half of the year 2 home-currency funding at the start of year 1 to lock in the rate.

6.2 Worked example B: test the revised plan (half solved)

Test on the revised planClosing balanceLowest balancePasses the buffer?
Base revised10,3003,600Yes
Home currency falls 10%1,300-900[ ]
Rent 10% higher[ ][ ][ ]
Social allowance back to USD 400[ ][ ][ ]

6.3 Exercise C: your budget (unsolved)

Build the table in 4.1 with your own months and record: the lowest balance and its month, the number of months below your buffer, the closing balance, and the result of the currency and rent tests. Then write the two changes that would fix your thinnest month.

7. Spending rules for the social side of the MBA

The social side of the programme (dinners, trips, celebrations, sports) builds the network many graduates value most, and it is also where budgets break. Rules you set in advance protect both.

RuleYour setting
Weekly social allowance, carried over or not[USD 75 a week, unused amount carries over within the month]
Trips per term you will join[One trek per year, decided at the start of each term]
What you say when you skip[A short, honest line; most classmates are on a budget too]
Lower-cost ways to join[Host a potluck, join the free club events, organise a hike]
Review point[Check social spending every Sunday]
Example KofiUSD 300 a month in term, one trek in year 1, immersion in year 2 chosen by price

8. Currency, insurance and emergencies

  • Currency. If funding is in a different currency, decide how and when you convert: all at once, per term, or a mix. Converting early removes the exchange-rate risk but gives up any favourable move. Record the rate you used in the budget and the rate at which your plan breaks the buffer.
  • Health insurance. Most schools require coverage; waivers usually need proof of an equivalent plan. Check the school's requirement and what the plan excludes.
  • Emergency fund. Keep a buffer that does not depend on the next disbursement. A family emergency, a laptop failure or a medical bill should not force an expensive short-term loan.
  • Income rules. Student visas often restrict paid work during term and set conditions for internships. Check the official rules of the country where you study (mba/mba-international-applicant-plan) before you budget any earnings.
  • Hardship options. Many schools have emergency grants or short-term loans for students. Find out where they are before you need them.

9. Dated facts and timeline

Dated facts (checked 2026-10-28):

  • As of October 2026, new US federal borrowers in an MBA programme can take Direct Unsubsidized Loans of up to USD 20,500 a year (USD 100,000 in total); Grad PLUS is closed to new borrowers from 1 July 2026, and the fixed rate for loans first disbursed from 1 July 2026 to 30 June 2027 is 8.07%. Federal loans are normally disbursed in at least two instalments per academic year, which is why the budget works per term. Check studentaid.gov and the ETS summary of the July 2026 changes before you rely on it; details are in mba/mba-funding-scholarship-plan.
  • Outside the US, disbursement schedules, caps and permitted uses depend on the lender or country scheme. Check your country's official schemes and your loan agreement.

Timeline relative to programme start (T):

WhenStep
T-4 monthsFirst full draft from the school's cost of attendance and the programme calendar
T-3 monthsStress tests, revise, and set the loan amount from the shortfall
T-2 monthsConfirm disbursement dates, health insurance and housing deposit
T-1 monthWrite the social spending rules and currency conversion plan
Each month from TTen-minute review: plan against actual, update the forecast
Start of each termRe-run the full budget with actual tuition bills and disbursements
Internship offerAdd internship pay, housing and travel; re-run
T+18 monthsPlan the transition to repayment (mba/mba-loan-repayment-plan)

10. Quality checklist and common mistakes

Checklist:

  • Every month from the first tuition payment to graduation has a row.
  • Tuition and disbursements are placed in the months they actually occur.
  • Recruiting, treks, immersion, clubs and the internship housing are in the budget.
  • The buffer is set and every month below it is flagged.
  • Rent, currency and social stress tests are recorded.
  • The loan request equals the shortfall plus the buffer, not the maximum offered.
  • Monthly reviews are in the calendar.

Common mistakes:

  1. Budgeting by year. Annual totals hide the months where the balance turns negative.
  2. Leaving out recruiting and trek costs. They are optional in name only for many career switchers.
  3. Assuming the internship repairs everything. In the example it added USD 21,000 against USD 14,550 of costs over three months: helpful, not a rescue.
  4. Ignoring the second rent. An internship in another city often means paying two rents for three months.
  5. No currency plan. A 10% fall on half the funding cost the example student USD 8,000.
  6. No buffer. A plan that ends at zero has no room for a single surprise.
  7. Spending the disbursement in the first month. The term's money must last four to five months.
  8. Not tracking actual spending. The budget is a forecast; without monthly actuals you find the problem in the last month of term.
  9. Counting on part-time work without checking visa rules. Many student visas limit paid work.
  10. Treating social spending as fixed. It is the easiest category to adjust; decide the rule early.

My notes and next steps

Next stepOwnerDue
[Get the school's billing calendar and disbursement dates][Your name]YYYY-MM-DD
[Ask current students for trek and recruiting costs][Your name]YYYY-MM-DD
[Decide the currency conversion plan][Your name]YYYY-MM-DD

Sources and further reading

Official and dated sources (checked 2026-10-28): ETS, New Federal Student Loan Rules Took Effect (updated 1 July 2026); Federal Student Aid, interest rates for Direct Loans first disbursed between 1 July 2026 and 30 June 2027 (fsapartners.ed.gov, June 2026); studentaid.gov.

Further reading: Brealey, Myers and Allen, Principles of Corporate Finance (chapters on short-term financial planning and cash budgets); Berk and DeMarzo, Corporate Finance. Open resource: OpenStax, Principles of Finance (CC BY-NC-SA 4.0).

Answer key

Worked example B: the revised plan with a 10% currency fall closes at USD 1,300 with a lowest balance of USD -900, so it does not pass the buffer. Rent 10% higher (USD 240 more for 22 months, USD 5,280 in total): closing USD 5,020, lowest USD 1,200 in May Y1, fails. Social allowance back to USD 400 (USD 1,900 more over 19 term months): closing USD 8,400, lowest USD 2,600 in May Y1, fails narrowly. The revised plan survives the base case only, so Kofi's two triggers in section 6.1 are needed.

Revision history

VersionDateAuthorChange
0.1YYYY-MM-DD[Your name]First draft from template
[0.2]YYYY-MM-DD[Your name][Revised after stress tests]

Standard and licence note

Based on standard cash-flow budgeting practice and dated public facts from US Federal Student Aid and ETS checked on 2026-10-28. The text, examples and numbers are original and fictional; they are not affiliated with or endorsed by any business school, lender or government body. Check the current official pages and your school's billing information before you rely on any fact. Template licence: MIT.

Templat terkait