Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial PlanningCollege Financial Aid Comparison

SpreadsheetFinancial PlanningFree

College Financial Aid Comparison

Compare aid offers on what college will really cost: cost of attendance minus grants, loans kept separate, four-year totals and the payment after graduation.

Shown with sample data

Colour

College Financial Aid Comparison

Compare aid offers on what college will really cost: cost of attendance minus grants, loans kept separate, four-year totals and the payment after graduation.

Lowest 4-year net price
$46,650
Highest 4-year net price
$229,199
Difference
$182,549
Between cheapest and dearest
Lowest borrowing
$14,000
Lowest net price, year 1
$10,800
Largest grant offer
$46,000
4-year net price by college
  • Riverside University (out-of-state)$229,199
  • Lakeside College (private)$148,073
  • Bayview University (merit scholarship)$137,609
  • Northern Tech Institute$107,530
  • State University (in-state)$92,052
  • Community college, then transfer$46,650
Monthly loan payment after graduation
  • Riverside University (out-of-state)$931
  • Lakeside College (private)$613
  • Northern Tech Institute$431
  • State University (in-state)$250
  • Bayview University (merit scholarship)$250
  • Community college, then transfer$159

How to use it

  1. 1For each school, enter tuition and fees, housing and food, and books, transport and personal costs from the award letter or the school’s cost-of-attendance page.
  2. 2Enter grants and scholarships (money you do not repay) and whether they renew every year.
  3. 3Enter work-study, federal student loans and any parent PLUS or private loans separately.
  4. 4On Settings, set the yearly cost increase, loan interest rate and expected starting salary.
  5. 5Read Compare: lowest four-year net price first, then check the monthly payment is affordable.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Aid letters mix free money and loans in different layouts, so the “biggest offer” is often the most expensive school. Enter each offer’s costs, grants, work-study and loans; the sheet calculates cost of attendance and net price, keeps loans separate from gifts, projects the four-year cost (dropping grants that do not renew), estimates total borrowing and the monthly payment after graduation, and tests it against expected starting salary.

Who it’s for

  • Comparing award letters in March and April
  • Families appealing an aid offer with evidence
  • Deciding between in-state, private and community college routes

What’s included

  • Compare sheet: Four-year cost, borrowing and the payment after graduation for each school.
  • Offers sheet: Each school’s costs, gift aid and loans for the first year, as listed in the award letter.
  • Settings sheet: Assumptions for four-year costs and repayment.

How to use it

  1. 1For each school, enter tuition and fees, housing and food, and books, transport and personal costs from the award letter or the school’s cost-of-attendance page.
  2. 2Enter grants and scholarships (money you do not repay) and whether they renew every year.
  3. 3Enter work-study, federal student loans and any parent PLUS or private loans separately.
  4. 4On Settings, set the yearly cost increase, loan interest rate and expected starting salary.
  5. 5Read Compare: lowest four-year net price first, then check the monthly payment is affordable.

Tips

  • Net price (cost minus grants) is the real price of a school. Loans are not aid you keep; they are deferred cost.
  • Ask each school in writing whether grants renew and what GPA or credit load keeps them. A grant that disappears after year one can double the cost.
  • A common rule of thumb: total student debt should be less than your expected first-year salary.

Questions

What is the difference between cost of attendance and net price?

Cost of attendance is the school’s full estimated cost: tuition, fees, housing, food, books, transport and personal expenses. Net price is what remains after grants and scholarships. Loans and work-study help you pay the net price; they do not reduce it.

Can I appeal a financial aid offer?

Yes. Write to the aid office with a competing offer or a change in circumstances (job loss, medical costs). A clear comparison of net prices from this sheet makes the case concrete.

Are parent PLUS loans included?

Yes, in a separate column, so you can see the student’s and parents’ borrowing. Both count toward the four-year borrowing and the estimated payment.

Why is the four-year cost higher than four times the first year?

Costs usually rise each year (set the rate on Settings) and some grants are for the first year only.

Related searchesfinancial aid comparisoncompare financial aid offerscollege cost comparisonnet price calculatorfinancial aid award letter comparisonstudent loan payment calculator

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial PlanningFree

College Financial Aid Comparison

Compare aid offers on what college will really cost: cost of attendance minus grants, loans kept separate, four-year totals and the payment after graduation.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More financial planning templates

View all
FIRE Early Retirement Planner3 sheets

FI number

$1,250,000

Savings rate

43%

Years to FI

15

ABC
1ResultValueWhat it means
2Annual savings40,000Take-home income minus spending
3Savings rate0.43The single biggest driver of how fast you reach FI
4FI number1,250,000Retirement spending ÷ safe withdrawal rate
5Progress to FI0.15Invested assets as a share of your FI number
Results
SpreadsheetFinancial Planning

FIRE Early Retirement Planner

Your FI number, savings rate, years to financial independence, Coast FI and a year-by-year path to retiring early.

10 min setupPreview
Retirement Income and Withdrawal Planner2 sheets

Money lasts to

Age 93

First-year withdrawal rate

7%

Balance at the last age

$0

Portfolio balance by age
SpreadsheetFinancial Planning

Retirement Income and Withdrawal Planner

A year-by-year drawdown plan: spending with inflation, Social Security and pension, tax on withdrawals, growth and whether the money lasts.

10 min setupPreview
Personal Net Worth Statement3 sheets

Net worth

$223,150

Change since last review

$17,850

Liquid net worth

$15,900

Assets by type
74%
  • Property
  • Retirement
  • Investments
  • Cash
SpreadsheetFinancial Planning

Personal Net Worth Statement

Assets, debts and net worth with a quarterly history, allocation by type and debt-to-asset ratio.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ